Conversions export output
- Former user (Deleted)
- Siamak Haschemi (Deactivated)
- Martin Heymann
- Tobias Rast
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_id | The Id of the conversion target related to the conversion | 123 |
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 |
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 |
conversion_last_modified_time | The time and date of the last update of the conversion. This can coincide with the moment the conversion was originally tracked, but it can also represent the moment on which the conversion was validated. | 2015-09-15 00:00:31.002 |
conversion_currency_code | The ISO 4217 currency code of the currency you selected in your partner UI or the currency you selected in the paramter of your export link. | EUR |
conversion_reason_canceled | A brief note in which the person responsible for the validation of the conversion can explain the reason for rejecting the conversion. Please note this value is only relevant when the status of the conversion is set to rejected. | Order was canceled. |
conversion_uniqid | An internal ID via which the tracking of the conversion is identified. | 123456789 |
conversion_num_products | The number of basket positions related to the conversion. Please note this field will only be filled when the advertiser has implemented basket tracking. | 5 |
maturity_date | The number of days after which the conversion is confirmed automatically, starting from the day on which the conversion was registered. Please note that when the value is empty, the conversion will not be confirmed automatically. | 30 |
conversion_type | The type of tracking that was applied for the conversion. Possible values are postclick and post view. | postclick |
conversion_product_category_lable | The name of the product category of the conversion. | default |
advertiser_label | The name of the advertiser for which you generated the conversion. | |
advertiser_id | The ID of the advertiser for which you generated the conversion. | 123 |
partner_adspace_label | The name of the ad space via which you you generated the conversion. | All the best brands |
voucher_code | The voucher code that was used when the conversion was registered. When the value is empty, no voucher was used. | SV1 |
voucher_code_id | The ID of the voucher that was used when the conversion was registered. When the value is empty, no voucher was used. | 1234 |
voucher_currencycode | The ISO 4217 currency code of the voucher that was used when the conversion was registered. When the value is empty, no voucher was used. | EUR |
device_id | The device the customer was using when the conversion was registered. Possible values are 0 (unknown), 1 (mobile), 2 (tablet) and 4 (desktop). | 2 |
status | The status of the conversion, explained in words:
|
|
currencycode | The ISO 4217 currency code in which the values of the conversion were originally tracked. | EUR |