Description: This article describes how to format and upload client and partner-level impression mappings data.
Formatting your file
You can upload the data in a flat CSV file. Ensure your file is cumulative, i.e., inclusive of all historical mappings.
Your file must be formatted correctly and according to our guidelines:
| How should I format my impression data mappings file? | |
|
✓ Include all required columns ✓ Ensure all columns have a header ✓ Ensure headers and field values match those in the examples exactly, including case ✓ Include only a header row and data within the file ✓ Avoid ambiguous dates. Use the format yyyy-mm-dd ✓ Mapping file must be cumulative |
✕ Use special characters in the field value, e.g., !,@,% ✕ Mix data formats in a column ✕ No overlapping dates with mappings in file For example: Date: 1/4 - 1/10 |
To view an example file in the platform, go to Data > Impressions > Upload Impression Mappings File.
Example file
1. Complete the fields in your data file according to the table below:
| Title | Column name | Description | Format | Accepted values |
| Impression Type | impression_type | Only a value of "vod" is accepted. | Text | vod |
| Impression Field | impression_field | Values as shown in your impression pixel. | Text | placementgroup, publisher, creative, campaign, network |
| Mapped Value | mapped_value | Value to replace field value. | Text | Value that should appear in the InnovidXP platform. |
| Discard Flag | discard_flag | Leave this blank. | None | Leave this blank. |
| Delete Flag | delete_flag | To discard the impressions associated with the field_value, enter TRUE. Leave blank if you are not discarding impressions. | Boolean | If discarding enter TRUE. If leaving values as they are, leave this blank. |
| Date From | date_from | Start date of the creative. | Date | YYYY-mm-dd |
| Date To | date_to | End date of the creative. | Date | YYYY-mm-dd |
| Ordinal To Rename From | ordinal_to_rename_from | Leave this blank. | None | Leave this blank. |
2. Create a file that contains your current creative IDs (what you want to view in the platform) mapped to the publisher creative IDs so that we can upload the impression mapping with that information included.
Uploading your file
Note: If your file is formatted incorrectly, it will fail to upload. An error message will be displayed listing the reasons for the upload failure. Make the necessary changes to the file and try again. You can upload a client-level or partner-level file.
-
Select Data > Impressions > Upload Impression Mappings File (for client-level data) or Upload Partner Impression Mappings File (for partner-level data). The Upload Impression Mappings File screen is displayed, for example:
-
Click into the file types field to browse for the file.
- Select the file you want to upload, or drag and drop and select Upload File. If your file is formatted correctly, the file will upload, and an "Upload Complete" message will be displayed.