Upload File Upload Data
Uploading data involves manually uploading a file within the Ambition interface.
Where do I upload File Upload data?
Can I see an example of File Upload data?
Important to Note
There is a 2MB file size limit.
Either CSV or JSON formatted files can be utilized, but a single integration cannot receive both formats.
- CVS file must be a flat file with headers
- JSON must be flat (unnested)
The file must contain the CSV headers or JSON keys that are included in the Data Format.
All data in Ambition must be attributable to a user. If your data exists at a Team or Organizational level, it must be broken down into User level Metrics.
Upload File Upload Data
1. Login to your Ambition instance.
2. Open the left navigation and click Administration > Data > Integrations.
3. Click the Settings button to enter the File Upload Integration.
4. Click the File Upload tab.
5. Ensure that the .csv OR .json file about to be uploaded contains all the Required Fields found under the Name column. Ensure the file matches the exact case sensitivity and spelling seen under the Name column.
It's important to note that either CSV or JSON formatted files can be utilized, but a single integration cannot receive both formats.
Click the Data Format tab if you need to verify the integration's file format.
6. Click the blue Choose File button. Select the CSV or JSON file to be uploaded.
7. Verify seeing the correct file name chosen to be uploaded, and click the green Upload button to upload your file to Ambition.
File Upload Examples
Example Daily Totals File Format
*Metric Names found by clicking Data Format tab from within File Upload integration.
| date | metric_name1* | metric_name2* | |
| joey@freshwater.com | 2020-06-01 | 23 | 32 |
| agnes@goodman.com | 2020-06-01 | 11 | 84 |
Example Daily Totals File Format.
Uploading Multiple Days for One Account
| date | metric_name1* | metric_name2* | |
| joey@freshwater.com | 2020-06-01 |
12 |
2 |
| joey@freshwater.com | 2020-06-02 | 1 |
3 |
| joey@freshwater.com | 2020-06-03 | 33 |
9 |
Example Records Based File Format
| created_date | record_id | type | status | appointment_date | |
| joey@freshwater.com | 2020-06-01 8:23:11 | abc123 | appointment | completed | 2020-06-01 12:30:00 |
| agnes@goodman.com | 2020-06-01 8:25:30 | abc456 | call | completed |
Comments
0 comments
Please sign in to leave a comment.