Reporting export file
Creating the URL
To create a URL for a reporting export file, you first need to decide what type of report you would like to create. For every different type, you will have to add a different report name to your reporting URL. The system supports the following types of reports:
Report type | Report name |
---|---|
per day | adm-statsdate |
per advertiser | adm-statsmerchant |
per product category | adm-statsprodukt |
per partner | adm-statsaffiliate |
per ad space | adm-statsadspace |
per sub ID | adm-statssubid |
per referrer | adm-statsreferrer |
per ad media | adm-statswm |
Suppose you want to create a reporting export file for report by day. In that case, your URL should look like this:
https://export.net.[domain]/[your_API_key]/adm-statsdate_[userID].[file_extension]?
Once you have filled in your domain, your API key, your user ID and the relevant file extension and you have applied your filters, your URL should look more or less like this:
https://export.net.yourdomain.com/f0d58188-5420-4856-84b2-0417a3a85225/adm-statsdate_123.csv?filter[currencycode]=EUR
By default your system-generated default API key is used in the export links.
Available filters
No matter what type of report you create, following filters can be applied to your reporting export file:
Filter description | Filter name | Compulsory | Format |
---|---|---|---|
This filter defines whether the time range you select relates to the moment on which conversions were updated or tracked. | timetype | No. If the filter is not used, the time range will relate to moment on which conversions were tracked. | Either use ‘tracking’ or ‘updated’. |
This filter allows you to define whether the time frame for which you want a report on your conversions or basket positions is absolute (exact dates) or dynamic (for example: last ten days, last month, etc). | timerange_type | Yes | Either use ‘absolute’ or use ‘dynamic’. |
If you are using a dynamic time range, you need to specify it here. | timerange | Only if you select a dynamic time frame. | Please read the article: 'Dynamic time range options' |
If you are using an absolute time range, you need to define a date on which the range starts. | from_date | Only if you select an absolute time frame. | dd.mm.yyyy |
If you are using an absolute time range, you need to define a date on which the range ends. | to_date | Only if you select an absolute time frame. | dd.mm.yyyy |
To limit the output to conversions with a specific status, use this filter. | a:status | No | 0 for open, 1 for approved, 2 for rejected and 3 for confirmed. You can use multiple values. |
This filter allows you to limit the conversions or basket positions you export to a specific currency. | currencycode | No | Use the ISO currency codes. |
This filter allows you to limit the conversions or basket positions you export by a specific advertiser program. | a:advertiser_program_id | No, but highly recommended | Use the MID you find on the overview page of all the advertisers on your platform. |
This filter allows you to limit the conversions or basket positions you export by a specific partner. | a:affiliate | No | Use the UID you find on the overview page of the partners on your plaform. |