> For the complete documentation index, see [llms.txt](https://docs.milientsoftware.com/help/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.milientsoftware.com/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md).

# Ad providers

* [Facebook](/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md#facebook)
* [Google](/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md#google)
* [Display & Video 360](/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md#digital-and-video-360)
* [Microsoft](/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md#microsoft)
* [LinkedIn](/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md#linkedin)
* [Snapchat](/help/moment-by-topic/integrations/file-import/integration-file-import/some-ad-expenses/ad-providers.md#snapchat)

## General&#x20;

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.

![](/files/-Mexyu4dtLENidNxk9Wq)

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](/files/-Mey3gkl6U0kk6M4BB1F)

## 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.](/files/-Mey-MnYuNMC45p0ZE3p)

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](/files/-Mey2S0oUYp9-G84EKl4)

## Digital & Video 360

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

![](/files/BQciLKr80yhCvwzmKPlL)

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

![](/files/gbIdYtYi3qQFhV6gL8EU)

## 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.](/files/pjx8psHzvDo7sL7rvPRp)

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

![](/files/tNSOtCAfICin34Atbi2L)

## LinkedIn

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

![](/files/-MexzK45YSsQLpZdFkr4)

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.

![](/files/-Mexzjjb5Ok2V5NhowO6)

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>
