...
Filter description | Filter name | Application | Value format |
---|---|---|---|
This filter defines whether the time frame you select relates to the moment on which conversions were updated or tracked. | timetype | If the filter is not used, the time frame 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 | This filter is compulsory. | Either use ‘absolute’ or use ‘dynamic’. |
If you are using a dynamic time frame, you need to specify it here. | timerange | This filter is compulsory when you use a dynamic time frame. | Please read this article for a full overview. |
If you are using an absolute time frame, you need to define a date on which the range starts. | from_date | This filter is compulsory when you use an absolute time frame. | dd.mm.yyyy |
If you are using an absolute time frame, you need to define a date on which the range ends. | to_date | This filter is compulsory when you use an absolute time frame. | dd.mm.yyyy |
To limit the output to conversions or basket positions with a specific status, use this filter. | a:status | This filter should be applied when you are creating a report used for validation purposes. | 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 | Use the ISO 4217 currency codes. Please note you cannot use only one currency code at a time. | |
This filter allows you to limit the conversions or basket positions you export by a specific advertiser program. | a:advertiser_program_id | This filter allows you to create export files per advertiser, which is 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 | Use the UID you find on the overview page of the partners on your plaform. | |
This filter allows you to include the brand and the shopping categories the advertiser applied in the basket export. | fullBasket | This filter is only available for the basket export. | Use ‘true’ to include the additional data. |
This filter allows you to include any sub IDs related to the conversion in your export file. | allsmcs | This filter is only available for the comprehensive conversion report. | Use ‘true’ if you want to export the sub IDs. |
This filter allows you to include all additional parameters (customer age and gender, new customer, custom values, etc.) related to the conversion in your export file. | trackingParams | This filter is only available for the comprehensive conversion report. | Use ‘true’ if you want to export the additional parameters. |
...
Header name | Explanation | Format | Delimeter | Example | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
conversion_tracking_ | idtime | The | ID of the partner who generated the conversion.Numeric | n/a | 1234 | |||||||
partner_firstname | The first name of the partner who generated the conversion. | Alphabetic | n/a | Mary | ||||||||
partner_lastname | The last name of the partner who generated the conversion. | Alphabetic | n/a | Poppins | ||||||||
partner_company | The company name of the partner who generated 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 | Walt Disney Productions4711 | ||||||||
conversion_target_ | typename | The | type ma,e of the conversion target of the conversion. | Alphabetic | n/a | SaleSport sales | ||||||
conversion_targetcategory_labelid | The label ID of the conversion target of tracking category applied to the conversion. | AlphabeticNumeric | n/a | Sport sales5678 | ||||||||
conversion_ | hiddencategory_ | statusname | The | visibility name of the | conversion target of the conversion for the partners. Possible values are false (visible) and true (hidden)tracking category applied to the conversion. | Alphabetic | n/a | falesdefault | ||||
externalconversion_advertiser_id | An internal advertiser ID used for tracking purposes. | Alphanumeric | n/a | i12345678 | internal_conversion_id | An internal advertiser ID used for rating purposesstatus | The status of the conversion. Possible values are 0 (open), 1 (approved), 2 (rejected) and 4 (confirmed). | Numeric | n/a | 1234567890 | ||
conversion_ | product_category_id | The ID of | the tracking category applied to the conversion.Numeric | n/a | 5678 | adspace_id | The ID (PID) of the ad space via which the conversion was generated. | Numericthe 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 | 142536 | conversion_status1608010800207180980_auto |
revenue | The | status order value 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 | ||||||||
conversion_commission_model | The name of the rating model 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. | Alphanumeric | n/a | Premium commissionNumeric: #.# | Period | 3.56 | ||||||
conversion_trackingupdate_time | The time and date on which the conversion was originally trackedlast modified, i.e. edited or validated. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2016-08-20 15:00:00 | ||||||||
click_id | The ID of the click via which the conversion was generated. | Numeric | n/a | 987654321 | ||||||||
click_time | The time and date on which the click was tracked via which the conversion was generated. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2016-08-20 15:00:00 | ||||||||
click_referrer | The referrer, i.e. the URL of the website on which the click was generated. | URL | n/a | |||||||||
click_subid | The first sub ID of the click via which the conversion was generated. Please note you will only find a value here when a sub ID was attached to the click URL. | Alphanumeric | n/a | mp1234 | ||||||||
conversion_commission_rate_id | An internal ID used to identify the way in which the conversion was rated. | Numeric | n/a | 74859 | ||||||||
conversion_commission_rate | The rate of the commission applied to the conversion. | Numeric | Period | 2.5 | ||||||||
conversion_commission_type | The type of the commission applied to the conversion. Possible values are fix and percent. | Alphabetic | n/a | percent | ||||||||
conversion_order_value | The order value of the conversion. Please note this amount does not include shipping costs and VAT. | Numeric: #.# | Period | 142.45 | ||||||||
conversion_order_value_rejected | The rejected amount of order value. Please note you will only see a value here in case of partial cancelations. | Numeric: #.# | Period | 35.75 | ||||||||
conversion_commission_total | The total commission value applied to the conversion. | Numeric: #.# | Period | 3.56 | ||||||||
click_admedia_id | The ID of the ad media item used for the click via which the conversion was generated. | Numeric | n/a | 98745 | ||||||||
conversion_last_modified_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 | ||||||||
internal_tracking_id | An internal ID of the conversion, used for tracking purposes. | Numeric | n/a | 1608010800207180000 | ||||||||
internal_accounting_id | An internal ID of the conversion, used for rating purposes. | Numeric | n/a | 160801080300000000 | ||||||||
conversion_fee_total | 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 | ||||||||
conversion_num_products | The total numer of products ordered for this conversion | Numerical | n/a | 5 | ||||||||
maturity_date | The time and date on which the conversion will be approved automatically. Please note that if you do not see a value here, the conversion will never be approved automatically. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2016-08-20 15:00:00 | ||||||||
conversion_type | The type of conversion. Possible values are postclick and postview. | Alphabetic | n/a | postclick | ||||||||
conversion_product_category_label | The name of the tracking category applied to the conversion. | Alphabetic | n/a | default | ||||||||
advertiser_label | 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 | ||||||||
partner_adspace_label | The name of the ad space via which the conversion was generated. | Alphanumeric | n/a | Fashion blog | ||||||||
adspace_subcategory_label | The name of the subcategory of the ad space via which the conversion was generated. | Alphanumeric | n/a | Fashion blogs | ||||||||
adspace_subcategory_type | The type of the subcategory of the ad space via which the conversion was generated. | Alphanumeric | n/a | Consumer guides and bloggers | ||||||||
adspace_category_label | The name of the category of the ad space via which the conversion was generated. | Alphanumeric | n/a | Fashion content | ||||||||
adspace_category_type | The type of the category of the ad space via which the conversion was generated. | Alphanumeric | n/a | Content | ||||||||
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 | ||||||||
voucher_currencycode | The ISO 4217 currency code of the voucher applied to the conversion. You will only see a value here when the customer placing the order used a voucher. | Alphabetic | n/a | EUR | ||||||||
device_type | The type of device the customer used to place the order related to the conversion. | Alphabetic | n/a | Desktop | ||||||||
conversion_checksum | An internal code used to identify the conversion. | Alphanumeric | n/a | 27a2dccfb0362a10c0c82904c8dfd52d | ||||||||
click_subid_2 | The second sub ID of the click via which the conversion was generated. Please note you will only find a value here when a second sub ID was attached to the click URL and you have used the 'allsmcs' filter. | Alphanumeric | n/a | dc5678 | ||||||||
click_subid_3 | The third sub ID of the click via which the conversion was generated. Please note you will only find a value here when a third sub ID was attached to the click URL and you have used the 'allsmcs' filter. | Alphanumeric | n/a | ef9012 | ||||||||
click_subid_4 | The fourth sub ID of the click via which the conversion was generated. Please note you will only find a value here when a fourth sub ID was attached to the click URL and you have used the 'allsmcs' filter. | Alphanumeric | n/a | gh3456 | ||||||||
click_subid_5 | The fifth sub ID of the click via which the conversion was generated. Please note you will only find a value here when a fifth sub ID was attached to the click URL and you have used the 'allsmcs' filter. | Alphanumeric | n/a | ij7890 | ||||||||
click_subid_6 | The sixth sub ID of the click via which the conversion was generated. Please note you will only find a value here when a sixth sub ID was attached to the click URL and you have used the 'allsmcs' filter. | Alphanumeric | n/a | kl1234 | ||||||||
conversion_target_alias | The value transmitted to identify the conversion target of the conversion and you have used the 'allsmcs' filter. | Alphanumeric | n/a | sale | ||||||||
conversion_tracking_category_alias | The value transmitted to identify the tracking category of the conversion and you have used the 'allsmcs' filter. | Alphanumeric | n/a | default | ||||||||
invoice_value | The total value of the order, including shipping costs and VAT15: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 the corresponding tracking parameter was implemented and you have used the 'trackingParams' filteryou charge your advertisers. | Numeric: #.# | Period | 144.56 | 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. | AlphabeticPeriod | 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 | True7485 | ||||||||
customervoucher_gendercode | The gender code of the customer who placed the order. Possible values are f (female) and m (male). Please note you voucher applied to the conversion. You will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filter.Alphabeticcustomer placing the order used a voucher. | Alphanumeric | n/a | fSV258569 | ||||||||
customervoucher_code_ageid | The age of customer who placed the order. Please note you ID of the voucher applied to the conversion. You will only see a value here when the corresponding tracking parameter was implemented and you have used the 'trackingParams' filtercustomer placing the order used a voucher registered on the platform. | Numeric | n/a | 451234 | ||||||||
customer_ | surveynew | 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.Alphanumeric: {"#":"#"}. Please note JSON format is higly recommended. | Bracket, double quotation marks and colon. | {"Your favorite movie":"Moonraker","Your favorite actor":"Sean Connery"}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'., for example 'creditcard' or 'paypal'. | Alphanumeric | n/a | paypal | ||||||||
time_zone | Indicates the time zone for all date time values | Alphanumeric | n/a | paypalEurope/Berlin |
Touchpoint export file
Header name | Explanation | Format | Delimeter | Example |
---|---|---|---|---|
conversion_tracking_time | The time and date on which the transaction was originally tracked. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2019-04-20 15:00:00 |
conversion_id | The ID of the transaction. 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 transaction. | Numeric | n/a | 174 |
conversion_category_id | The ID of the category of the transaction. | Numeric | n/a | 19 |
advertiser_id | The ID of the advertiser for which the transaction was generated, corresponding with the MID in the UI. | Numeric | n/a | 1234 |
advertiser_name | The name of the advertiser for which the transaction was generated. | Alphanumeric | n/a | |
conversion_status | The status of the conversion. Possible values are 0 (open), 1 (approved), 2 (rejected) and 3 (confirmed). | Numeric | n/a | 0 |
partner_id | The ID of the partner who generated the touchpoint. | Numeric | n/a | 1234 |
partner_first_name | The first name of the partner who generated the touchpoint. | Alphanumeric | n/a | Mary |
partner_last_name | The last name of the partner who generated the touchpoint. | Alphanumeric | n/a | Poppins |
partner_company_name | The company name of the partner who generated the touchpoint. | Alphanumeric | n/a | Walt Disney Productions |
adspace_id | The ID (PID) of the ad space via which the touchpoint was generated. | Numeric | n/a | 142536 |
adspace_name | The name of the ad space via which the touchpoint was generated. | Alphanumeric | n/a | Special Offers |
adspace_category_name | The name of the category of the ad space via which the touchpoint was generated. | Alphanumeric | n/a | Content Publisher |
adspace_subcategory_name | The name of the sub category of the ad space via which the touchpoint was generated. | Alphanumeric | n/a | Blogger |
touchpoint_position | The chronological position of the touchpoint in the customer journey that led to the transaction. | Numeric | n/a | 2 |
touchpoint_credit | The share/contribution that was attributed to this touchpoint for generating the transaction. All touchpoint credits of a transaction add up to 100. | Numeric | Period | 20.00 |
touchpoint_type | The type of the touchpoint (click or view). | Alphanumeric | n/a | Click |
touchpoint_time | The time and date on which the touchpoint was tracked. | yyyy-mm-dd hh:mm:ss | Hyphen and colon | 2019-04-20 14:00:00 |
touchpoint_commission_model | The commission model of the ad space that is used for (proportionate) remuneration. If Multi Touch Attribution is used it is recommended to give all ad spaces the same commission model in order to enable a clear attribution of commission. | Alphanumeric | n/a | 10 percent + 2 EUR fix |
touchpoint_revenue | The share of the tracked revenue that was allocated to the touchpoint. All touchpoint revenues add up to the total revenue sum of the transaction. | Numeric | Period | 6.30 |
touchpoint_commission | The share of the transaction commission that was allocated to the touchpoint. All touchpoint commissions add up to the total commission sum of the transaction. | Numeric | Period | 0.70 |
conversion_currency_code | The ISO 4217 currency code in which the values of the transaction were defined. | Alphanumeric | n/a | EUR |
touchpoint_revenue_'ISO3' | The share of the tracked revenue that was allocated to the touchpoint in display currency of the user creating the export. All touchpoint revenues add up to the total revenue sum of the transaction. | Numeric | Period | 8.00 |
touchpoint_commission_'ISO3' | The share of the transaction commission that was allocated to the touchpoint in display currency of the user creating the export. All touchpoint commissions add up to the total commission sum of the transaction. | Numeric | Period | 0.90 |
admedia_id | The ID of the ad media item used for which the touchpoint was generated. | Numeric | n/a | 56789 |
admedia_name | The name of the ad media item used for which the touchpoint was generated. | Alphanumeric | n/a | Banner summer special 2019 |
device_type | The type of device the customer used during touchpoint. | Alphanumeric | n/a | Desktop |
original_adspace_id | The ID of the ad space for which the touchpoint was originally generated. Might differ from adspace_id in case of e.g. a voucher rule that changed the attribution of the touchpoint retroactively. | Numeric | n/a | 45780 |
smc_1 | The additional parameter of the touchpoint that was set by the partner. | Alphanumeric | n/a | Free text field |
smc_2 | The additional parameter of the touchpoint that was set by the partner. | Alphanumeric | n/a | Free text field |
smc_3 | The additional parameter of the touchpoint that was set by the partner. | Alphanumeric | n/a | Free text field |
smc_4 | The additional parameter of the touchpoint that was set by the partner. | Alphanumeric | n/a | Free text field |
smc_5 | The additional parameter of the touchpoint that was set by the partner. | Alphanumeric | n/a | Free text field |
smc_6 | The additional parameter of the touchpoint that was set by the partner. | Alphanumeric | n/a | Free text field |
request_id | unique identifier of the touchpoint | Numeric | n/a | 2001201520357490208 |
conversion_uniqid | unique identifier of the conversion | Alphanumeric (UUID) | n/a | ce7bcd17-1b7a-442d-96d4-bf0f88a4798e |
time_zone | Indicates the time zone for all date time values | Alphanumeric | n/a | Europe/Berlin |
Basket position export file
...