...
Name | Explanation | Possible values |
---|---|---|
period | The period to which the data in the file relates. | yyyy-mm-dd |
advertiser_id | The ID of the advertiser (MID) used on the platform. The column only appears when you export the account balances of your advertisers. | Numeric |
partner_id | The ID of the partner (UID) used on the platform. The column only appears when you export the account balances of your partners. | Numeric |
external_reference | The external reference number of your advertiser or partner. For more information, please read this article. | Alphanumeric |
advertiser_name | The name of the advertiser. The column only appears when you export the account balances of your advertisers. | Alphanumeric |
name | The company name of the partner. The column only appears when you export the account balances of your partners. | Alphanumeric |
vat_id | The VAT ID of the advertiser or the partner. | Alphanumeric |
country_code | The ID of the country in which the advertiser is registered, according to the ISO 3166. | Alphabetic, three digits, for example FRA. |
start_balance | The account balance on the first day of a month within the selected period (in case you chose a monthly granularity) or the account balance at the beginning of a day within the selected period (in case you chose a daily granularity). | Numeric, seperated by a dot: nn.nn |
deposit_amount | The deposit amount of the advertiser. Please note this column only appears when you export the account balances of your advertisers and the advertiser uses prepayment as a billing method. | Numeric, seperated by a dot: nn.nn |
delta | The difference between the start and the end balance in the corresponding row. Please note, the amount can be negative. | Numeric, seperated by a dot: nn.nn |
end_balance | The account balance on the last day of a month within the selected period (in case you chose a monthly granularity) or the account balance at the end of a day within the selected period (in case you chose a daily granularity). | Numeric, seperated by a dot: nn.nn |
billed_amount | The amount already covered in existing invoices. | Numeric, seperated by a dot: nn.nn |
billed_amount | The amount already covered in existing payout entries. | Numeric, seperated by a dot: nn.nn |
currency_code | The code of the currency applied to the mentioned amounts, according to ISO 4217. | Alphabetic, for example EUR. |
labels | Labels applied to the advertiser or the partner. | Alphanumeric |
entity_name | The name of the entity to which the advertiser or partner has been allocated. | Alphanumeric |
currency_rate | The rate of the currency in which the values are converted. | Numeric, seperated by a dot: nn.nn |
end_balance_conv | The converted account balance. | Numeric, seperated by a dot: nn.nn |
reference_currency_code | The ISO 4217 code of the currency to which the values were converted. |
...