Reporting export output
Preface
This page contains a comprehensive overview of the data in the reporting export files you can download in the export section of the partner UI. Please note you can export reports by day, by product category, by advertiser, by ad media, by referrer and by sub ID. For detailed information on individual conversions, make sure you export the conversions file.
Output reporting export file
The output of your reporting export file will obviously depend on the type of file you select:
If you select report by day, the first column header will be called day. The value will have the
dd.mm.yyyyformat. All other figures in the row are related to this date.If you select report by product category, the first column header will be called id, the second one title. In the column below these headers, you will find the product category ID and the product category name respectively. All other figures in the row are related to this product category. Please note you select the timeframe in the filter panel at the top of the export page.
If you select report by advertiser, the first column header will be called mid, the second one title. In the column below these headers, you will find the advertiser ID and the advertiser name respectively. All other figures in the row are related to this advertiser. Please note you select the timeframe in the filter panel at the top of the export page.
If you select report by ad media, the first column header will be called wmid, the second one title. In the column below these headers, you will find the ID of the ad media item and the ad media item name respectively. All other figures in the row are related to this ad media item. Please note you select the timeframe in the filter panel at the top of the export page.
If you select report by referrer, the first column header will be called refferer. In the column below this header, you will find the referrer. All other figures in the row are related to this referrer. Please note you select the timeframe in the filter panel at the top of the export page.
If you select report by subID, the first column header will be called subid. In the column below this header, you will find the subIDs you have added to your tracking URLs. All other figures in the row are related to the subIDs. If you export a report by subID, please make sure you use UTF-8 characters instead of ISO-formats. Otherwise, programs such as Excel might not properly display your report.
Please note that you select the timeframe in the filter panel at the top of the export page.
Apart from the first, the other column headers are the same for every report. Their content is discussed in the table below:
Column header | Explanation (all values mentioned relate to the selected denominator only). | Value format |
|---|---|---|
views | The number of views generated. | Numerical |
clicks | The number of clicks generated. | Numerical |
click_rate | The percentage of views that resulted in clicks. | Numerical |
views_paid | The number of views for which you received commission. | Numerical |
views_commission | The amount of commission you received for generating views. | Numerical |
clicks_paid | The number of clicks for which you received commission. | Numerical |
clicks_commission | The amount of commission you received for generating clicks. | Numerical |
traffic_commission | The total amount of commission you received for generating views and clicks. | Numerical |
conversion_rate | The percentage of clicks that resulted in transactions. | Numerical |
confirmation_rate | The percentage of transactions that was confirmed by the advertiser. | Numerical |
provision_group | The commission model applied to the transactions. | Numerical |
post_views | The number of post view transactions. | Numerical |
post_clicks | The number of post click transactions. | Numerical |
post_sum | The total number of transactions. | Numerical |
post_clicks_opened | The number of post click transactions not yet validated by the advertiser. | Numerical |
post_clicks_canceled | The number of post click transactions canceled by the advertiser. | Numerical |
post_clicks_confirmed | The number of post click transactions confirmed by the advertiser. | Numerical |
post_views_opened | The number of post view transactions not yet validated by the advertiser. | Numerical |
post_views_canceled | The number of post view transactions canceled by the advertiser. | Numerical |
post_views_confirmed | The number of post view transactions confirmed by the advertiser. | Numerical |
post_sum_opened | The total number of transactions not yet validated by the advertiser. | Numerical |
post_sum_cancelled | The total number of transactions canceled by the advertiser. | Numerical |
post_sum_confirmed | The total number of transactions confirmed by the advertiser. | Numerical |
post_views_value | The amount of commission generated via post view transactions. | Numerical |
post_clicks_value | The amount of commission generated via post click transactions. | Numerical |
post_sum_value | The total amount of commission generated via transactions. | Numerical |
post_clicks_opened_value | The amount of commission generated via post view transactions that was not yet validated by the advertiser. | Numerical |
post_clicks_canceled_value | The amount of commission generated via post click transactions that was canceled by the advertiser. | Numerical |
post_clicks_confirmed_value | The amount of commission generated via post click transactions that was confirmed by the advertiser. | Numerical |
post_views_opened_value | The amount of commission generated via post view transactions that was not yet validated by the advertiser. | Numerical |
post_views_canceled_value | The amount of commission generated via post view transactions that was canceled by the advertiser. | Numerical |
post_views_confirmed_value | The amount of commission generated via post view transactions that was confirmed by the advertiser. | Numerical |
post_sum_opened_value | The total amount of commission generated via transactions that was not yet validated by the advertiser. | Numerical |
post_sum_canceled_value | The total amount of commission generated via transactions that was canceled by the advertiser. | Numerical |
post_sum_confirmed_value | The total amount of commission generated via transactions that was confirmed by the advertiser. | Numerical |
revenue_post_views_value | The amount of order value generated via post view transactions. | Numerical |
revenue_post_clicks_value | The amount of order value generated via post click transactions. | Numerical |
revenue_post_sum_value | The total amount of order value generated via transactions. | Numerical |
revenue_post_views_opened_value | The amount of order value generated via post view transactions that was not yet validated by the advertiser. | Numerical |
revenue_post_views_canceled_value | The amount of order value generated via post view transactions that was canceled by the advertiser. | Numerical |
revenue_post_views_confirmed_value | The amount of order value generated via post view transactions that was confirmed by the advertiser. | Numerical |
revenue_post_clicks_opened_value | The amount of order value generated via post click transactions that was not yet validated by the advertiser. | Numerical |
revenue_post_clicks_canceled_value | The amount of order value generated via post click transactions that was canceled by the advertiser. | Numerical |
revenue_post_clicks_confirmed_value | The amount of order value generated via post click transactions that was confirmed by the advertiser. | Numerical |
revenue_post_sum_opened_value | The total amount of order value that was not yet validated by the advertiser. | Numerical |
revenue_post_sum_canceled_value | The total amount of order value that was canceled by the advertiser. | Numerical |
revenue_post_sum_confirmed_value | The total amount of order value that was confirmed by the advertiser. | Numerical |
total_commission | The total amount of commission. | Numerical |
currencycode | The ISO currency code for the currency in which transactions were generated. | ISO 4217 currency codes. |