# Ad providers

* [Facebook](#facebook)
* [Google](#google)
* [Display & Video 360](#digital-and-video-360)
* [Microsoft](#microsoft)
* [LinkedIn](#linkedin)
* [Snapchat](#snapchat)

## 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.

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-Mexufkc2kRVnelx35-w%2F-Mexyu4dtLENidNxk9Wq%2Fimage.png?alt=media\&token=c19069aa-03a4-4b9f-9308-a03d69d4f4ca)

The header row is 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 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

![Example file for January 2021](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-Mexufkc2kRVnelx35-w%2F-Mey3gkl6U0kk6M4BB1F%2Fimage.png?alt=media\&token=e14ee7d8-5112-4368-916a-c7fbd47749a0)

## Google

Files to be used for Google ads import must follow the format defined here.

![The file must contain three rows of text , all comma separated, prior to the data.](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-Mexufkc2kRVnelx35-w%2F-Mey-MnYuNMC45p0ZE3p%2Fimage.png?alt=media\&token=db428633-75a6-4192-8b74-bfdf6660fe53)

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

<table data-header-hidden><thead><tr><th width="305.1810699588478">Column title</th><th>Description</th></tr></thead><tbody><tr><td>Column title</td><td>Description</td></tr><tr><td>Customer ID</td><td>The ID used in Google for the customer</td></tr><tr><td>Budget name</td><td>Name of campaign</td></tr><tr><td>Currency</td><td>Currency for the specific record</td></tr><tr><td>Billed Cost</td><td>Total cost/amount</td></tr></tbody></table>

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

![Example file for January 2021](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-Mexufkc2kRVnelx35-w%2F-Mey2S0oUYp9-G84EKl4%2Fimage.png?alt=media\&token=2829460d-e035-46e7-9590-ce1e2d48321f)

## Digital & Video 360

Files to be used for DV360 import must follow the format defined here.

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LsGm2gYUXX6xCfrrWgU-887967055%2Fuploads%2FNuCtuAVhseGvSkbsncPE%2Fimage.png?alt=media\&token=5c6372ea-0c7e-4fdf-bfe4-4aaa5081e2fa)

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 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

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LsGm2gYUXX6xCfrrWgU-887967055%2Fuploads%2FAkd2H8dvQFfJwoMRSG3f%2Fimage.png?alt=media\&token=f5469ced-3588-414e-b055-bb9d0dc8c7cf)

## Microsoft

Files to be used for Microsoft ads import must follow the format defined here.

![The file must contain ten rows, prior to the data.](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LsGm2gYUXX6xCfrrWgU-887967055%2Fuploads%2FanuS1aQotVBizrrmlItJ%2Fimage.png?alt=media\&token=782b39e7-739a-48ba-b6c1-3c8784991fc5)

The header rows are not imported, exact names are not significant. The number of columns is important. The columns must be:

| Column title           | Description                                 |
| ---------------------- | ------------------------------------------- |
| 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

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LsGm2gYUXX6xCfrrWgU-887967055%2Fuploads%2FSjWMJl77VseXIYR0Mpyx%2Fimage.png?alt=media\&token=d34a502c-4127-414c-afcb-72c4ee9c8fde)

## LinkedIn

Files to be used for LinkedIn ads import must follow the format defined here.

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-Mexufkc2kRVnelx35-w%2F-MexzK45YSsQLpZdFkr4%2Fimage.png?alt=media\&token=e57a3188-30b8-474b-9db8-7849203f43d0)

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.

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-Mexufkc2kRVnelx35-w%2F-Mexzjjb5Ok2V5NhowO6%2Fimage.png?alt=media\&token=affb9e58-51c2-4b4b-8fec-6ea38f00c9a7)

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<br>