Ad providers
General
For all providers these name standards are the same
Name of provider is the first part of the file name
Year and month is the second part of the name
Files can only be imported once, if the same period needs to be updated/appended the file must be updated with an appendix for iteration. No check on number used, only that it is unique.
Example:
Original file name: "facebook_202111.csv"
Second import of the file, eg: "facebook_202111_1.csv"
Third import of the file, eg: "facebook_202111_2.csv"
Facebook
Files to be used for Facebook ads import must follow the format defined here.
The header row is not imported, exact names are not significant. The number of columns is important. The columns must be:
Account ID
The ID used in Facebook for the account
Campaign name
Name of campaign
Currency
Currency for the specific record
Cost
Total cost/amount
The file type is CSV (Comma Separated Values), using "," (comma) as separator.
Provider name used as filename: facebook
Example
Google
Files to be used for Google ads import must follow the format defined here.
The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:
Column title
Description
Customer ID
The ID used in Google for the customer
Budget name
Name of campaign
Currency
Currency for the specific record
Billed Cost
Total cost/amount
The file type is CSV (Comma Separated Values), using "," (comma) as separator.
Provider name used as filename: google
Note! Google can deliver the various currencies in separate files, to accommodate this it's possible to add currency code before the file extension. eg "Google_YYYYMM_NOK.csv"
Example
Digital & Video 360
Files to be used for DV360 import must follow the format defined here.
The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:
Account ID
The ID used in DV360 for the customer
Campaign name
Name of campaign
Currency
Currency for the specific record
Cost
Total cost/amount
The file type is CSV (Comma Separated Values), using "," (comma) as separator.
Provider name used as filename: dv360
Example
Microsoft
Files to be used for Microsoft ads import must follow the format defined here.
The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:
Month
Not used in the import
Manager account name
Name of campaign
Account number
The ID used in Microsoft for the customer
Bill-to country/region
Determines currency for the specific record
Bill-to-name
Not used in the import
Document number
Not used in the import
Document type
Not used in the import
Billing type
Not used in the import
Net due
Total cost/amount
The file type is XLSX (Microsoft Excel).
Provider name used as filename: microsoft
Example
LinkedIn
Files to be used for LinkedIn ads import must follow the format defined here.
The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:
Column title
Description
Account ID
The ID used in LinkedIn for the account
Campaign name
Name of campaign
Currency
Currency for the specific record
Cost
Total cost/amount
The file type is CSV (Comma Separated Values), using "," (comma) as separator.
Provider name used as filename: linkedin
Snapchat
Files to be used for Snapchat ads import must follow the format defined here.
The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:
Column title
Description
Account ID
The ID used in Snapchat for the account
Campaign name
Name of campaign
Currency
Currency for the specific record
Cost
Total cost/amount
The file type is CSV (Comma Separated Values), using "," (comma) as separator.
Provider name used as filename: snapchat
Last updated
