...
Header name | Explanation | Format | Delimeter | Example |
---|---|---|---|---|
conversion_tracking_time | The time and date on which the conversion was originally tracked. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2016-08-20 15:00:00 |
conversion_id | The ID of the conversion. Usually, this ID will correspond with the order ID generated by the advertiser, but in some cases it is replaced with an internal ID. If this is the case, the ID will contain the word 'auto'. | Alphanumeric | n/a | 1608010800207180980_auto |
conversion_target_id | The id of the conversion target of the conversion. | Alphabetic | n/a | 4711 |
conversion_target_name | The ma,e of the conversion target of the conversion. | Alphabetic | n/a | Sport sales |
conversion_category_id | The ID of the tracking category applied to the conversion. | Numeric | n/a | 5678 |
conversion_category_name | The name of the tracking category applied to the conversion. | Alphabetic | n/a | default |
conversion_status | The status of the conversion. Possible values are 0 (open), 1 (approved), 2 (rejected) and 4 (confirmed). | Numeric | n/a | 0 |
conversion_id | The ID of the conversion. Usually, this ID will correspond with the order ID generated by the advertiser, but in some cases it is replaced with an internal ID. If this is the case, the ID will contain the word 'auto'. | Alphanumeric | n/a | 1608010800207180980_auto |
revenue | The order value of the conversion. Please note this amount does not include shipping costs and VAT. | Numeric: #.# | Period | 142.45 |
revenue_ejected | The rejected amount of order value. Please note you will only see a value here in case of partial cancelations. | Numeric: #.# | Period | 35.75 |
total_commission | The total commission value applied to the conversion. | Numeric: #.# | Period | 3.56 |
invoice_value | The total value of the order, including shipping costs and VAT. Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Numeric: #.# | Period | 144.56 |
discount_value | The discount applied to revenue. This will also affect the calculation of commission and fee | Numeric: #.# | Period | 42.43 |
conversion_update_time | The time and date on which the conversion was last modified, i.e. edited or validated. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2016-08-20 15:00:00 |
conversion_currency_code | The ISO 4217 currency code in which the values of the conversion were defined. | Alphabetic | n/a | EUR |
conversion_reason_canceled | The reason the conversion was rejected during the validation process. Please note this field is not mandatory and will be empty in most cases. | Alphabetic | n/a | Order was canceled. |
conversion_uniqid | The unique ID is used to identify conversions during the validation process. | Alphanumeric | n/a | 1650cd4d-9d57-34b4-80b4-34579d4dcd50 |
total_fee | The total amount of fee applied to the conversion. Please note you will only see a value here when you charge your advertisers. | Numeric: #.# | Period | 45.65 |
advertiser_name | The name of the advertiser for which the conversion was generated. | Alphanumeric | n/a | Fashion shop |
advertiser_id | The ID of the advertiser (MID) used on the platform | Numeric | n/a | 7485 |
voucher_code | The code of the voucher applied to the conversion. You will only see a value here when the customer placing the order used a voucher. | Alphanumeric | n/a | SV258569 |
voucher_code_id | The ID of the voucher applied to the conversion. You will only see a value here when the customer placing the order used a voucher registered on the platform. | Numeric | n/a | 1234 |
customer_new | Whether the customer was new to the advertiser. Possible values are true (new) and false (recurring). Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Alphabetic | n/a | True |
user_value_1 | Contains the values of the first custom tracking parameter. Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Alphanumeric | n/a | ab12345 |
user_value_2 | Contains the values of the second custom tracking parameter. Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Alphanumeric | n/a | cd67891 |
user_value_3 | Contains the values of the third custom tracking parameter. Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Alphanumeric | n/a | ef23456 |
user_value_4 | Contains the values of the fourth custom tracking parameter. Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Alphanumeric | n/a | gh78901 |
additional_data | Contains the values of the additional data tracking parameter, mostly used for CRM related information. Please note you will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter. | Alphanumeric: {"#":"#"}. Please note JSON format is highly recommended. | Bracket, double quotation marks and colon. | {"number_prev_cancellations":"12","recommended_by":"user_id: 15"} |
payment_method | The payment methode the customer chose when placing an order, for example 'creditcard' or 'paypal'. | Alphanumeric | n/a | paypal |
time_zone | Indicates the time zone for all date time values | Alphanumeric | n/a | Europe/Berlin |
...