Client data export / import for client custom reporting and dashboards
Client who wish to receive raw data directly for their internal analysts/data teams to develop and build their own internal dashboards and reports have 2 main options.
- iBank export
- CTM Data Hub scheduled report
Frequency:
- iBank export
- Daily
- CTM Data Hub scheduled reports
- Daily
Delivery Method:
- iBank export
- SFTP
- CTM Data Hub scheduled reports
- email
Content:
- iBank export
- Invoiced data
- CTM Data Hub scheduled reports
- Invoiced data
- Booked/Pre-Trip data
File Format
- iBank export
- 9 x text files
- CTM Data Hub scheduled reports
- Client decision
- Many clients use only 2 reports to received the data they require to develop their reports
- Travel Activity Detail & Carbon Emissions
Technical Effort
- iBank export
- An overview of the technical specification are attached for client review
- Significant development work is required on the client side, with regular calls and consulting from CTM to assist in building a data model and creating model
- Average time for delivery from start of project 5-7 month
- CTM Data Hub scheduled reports
- 'Cleansed' and modelled reports are delivered as required
- Client imports and creates reduced database/model
- Average time for delivery 4-6 weeks
Cost:
- iBank export
- GBP600 for initial set-up of SFTP and export configuration (inc 3 hours of support calls)
- GBP3,000 for 10 days of support and consulting + ongoing support charged at GBP300 per day
- CTM Data Hub scheduled reports
- CTM Data Hub provided FOC
- Client can purchase consulting if required at GBP300 per day