...
Make sure you are logged in to your admin UI, click on ‘finance’ in the main navigation menu and proceed to click on ‘account balances’. If you do so, you will see a page looking more or less like this:
...
...
As As you can see, the page contains two elements: a panel in which you can define the settings of the export file and a table containing an overview of all the export files generated on the platform, along with their main settings. Please note the panel will change somewhat depending on whether you choose to create an overview for advertisers or for partners.
...
The file you export will contain the data described in the table below. Please not some columns will only appear for the advertiser type, others only for the partner type.
...
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. |
...