If you encounter an error when uploading a Geo-contextual dataset on the AMP or OOH Planner, please make sure that the file respect all of the requirements listed on the platform:
If you upload a CSV file, make sure that the values are separated with commas “,”
The file must not exceed 500MB
Make sure that the file must contain headers in order to recognise the columns containing the “latitude” and “longitude”.
If you are uploading geometries in Well Known Text format, the column should be named “wkt”. Furthermore, the columns headers should be in english and should not contain any typoThe latitude and longitude must follow the following format with points:
latitude | longitude |
48.85837 | 2.29448 |
The POIs should be located in the country selected in the dropdown. Any POIs outside this country won’t be correctly reflected when using our products. If you need to use our products in different countries, you will need to upload a file for each country
The file should not contain any special characters
Requirements
The file should contain the following columns (separator should be “,”):
| Header | Details |
RECOMMENDED | geo_id | Unique ID - This helps you to match the POI on the DSP or in reports |
MANDATORY | latitude |
|
MANDATORY | longitude |
|
MANDATORY FOR POLYGONS | wkt | If you are using geometries instead of latitude & longitude coordinates |
RECOMMENDED | address, zipcode, store_name… | Additional meta-data (address, zipcode, store_name, etc.) can be added, which especially useful for reports |
What happens if there is no <geo_id> column?
In case there is no column named <geo_id>, a random id will be generated and attributed to the POI. Once the POI list is setup and used in a measurement, we cannot change it as this the referential data used by the DSP to attribute conversions.
The file must not exceed 500MB
Make sure that the headers is in english and does not contain any typo
The POIs should be located in the country selected in the dropdown. Any POIs outside this country won’t be correctly reflected when using our products. If you need to use our products in different countries, you will need to upload a file for each country
The file should not contain any special characters such as
~ ` @ # $ % ^ & * ( ) + = { } [ ] | \ / : ; " ' < > , . ? § ° ¬ ± ¡ ¢ ¬ ® §ö ü ä ß é è ê, etc.
If you have checked all of the above and still encounter an error when uploading your Geo-contextual file, feel free to raise a ticket with the file attached.