Conversions export file

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.

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

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

Shopping.com

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.