Preface
This page contains a comprehensive overview of the data in the conversions export file you can download in the export section of the partner UI.
Output
When you export the file marked conversions will contain the following output:
Column header | Explanation | Example |
---|---|---|
partner_id | Your ID as a partner. | 1234 |
partner_firstname | Your first name as registered in your partner UI. | Roger |
partner_lastname | Your last name as registered in your partner UI. | Moore |
partner_company | The name of your company as registered in your partner UI. | Maxtargeter |
conversion_target_type | The type of the conversion target related to the conversion. | Sale |
conversion_target_label | The label of the conversion target related to the conversion. | Spring collection sale |
internal_conversion_id | The internal ID of the conversion. | 1234567 |
conversion_product_category_id | The ID of the product category of the conversion. Please note that if basket tracking is implemented for the advertiser, the category of the conversion will always be basket. | basket |
adspace_id | The ID of your ad space. | 1234 |
conversion_status | The status of the conversion, related to the validation. 0 means the conversion is open, 1 means the conversion has been approved, 2 means the conversion has been rejected, 3 means the conversion has been confirmed. | 0 |
conversion_id | The ID of the conversion, corresponding with the order number of the advertiser. | 123456789 |
converion_tracking_time | The time and date (UTC) on which the conversion was registered by the platform. | 2015-09-01 00:00:31.002 |
click_id | The ID of the click that was appointed as winner for this conversion. | 123456789 |
click_time | The time and date (UTC) on which the winning click was registered by the platform. | 2015-09-01 00:00:24.92 |
click_referer | The domain of the ad space on which the winning click took place. Please note the referrer might not have been retraced. In this case, the value will be empty. | |
click_subid | If you have add a subID to a conversion, you will find it here. | ABC1234 |
conversion_commission_rate_id | The ID of the commission model that was applied to the conversion. | 123 |
conversion_commission_rate | The rate of the commission that was granted for generating the conversion. Please note that the figure in this field can represent both a percentage or a fixed amount. | 5 |
conversion_commission_type | The type of commission that was granted for generating the conversion. Possible values are fix and percent. | fix |
conversion_order_value | The total order value of you generated, in the currency of the advertiser. | 100 |
conversion_order_value_eur | The total order value of the conversion you generated, in the currency you have selected in your partner UI or in the currency you have selected in the currency parameter of your export link. | 80 |
conversion_order_value_rejected | The total value of order value rejected for the conversion due to partial cancellations. | 25 |
conversion_commission_total | The total commission value that was granted for generating the conversion in the currency of the advertiser. | 5 |
conversion_commission_total_eur | The total commission value that was granted for generating the conversion, in the currency you have selected in your partner UI or in the currency you have selected in the currency parameter of your export link. | 4 |
click_admedia_id | The ID of the ad media item via which the winning click was generated. | 1234 |