Page Comparison

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

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

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_targetcategory_labelid

The label ID of the conversion target of tracking category applied to the conversion.

AlphabeticNumeric

n/a

Sport sales5678

conversion_

category_

name

The

name of the

tracking category applied to the conversion.

Alphabetic

n/a

default

externalconversion_advertiser_id

An internal advertiser ID used for tracking purposes.

Alphanumeric

n/a

i12345678

internal_conversion_id

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

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

1608010800207180980_auto

revenue

The

order value of the conversion.

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

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

Numeric: #.#

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

fashionblog.com

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.

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

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_

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

Alphanumeric: {"#":"#"}. Please note JSON format is higly recommended.

Bracket, double quotation marks and colon.

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

Europe/Berlin