Conversions export output

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

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 means the conversion is open

  • 1 means the conversion has been approved

  • 2 means the conversion has been rejected

  • 3 means the conversion has been confirmed

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.

allthebestbrands.com/springcollection

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.

Shopping.com

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:

  • open

  • approved

  • confirmed

  • rejected

confirmed

currencycode

The ISO 4217 currency code in which the values of the conversion were originally tracked.

EUR