Tradetracker: Most-used fields#
The table below gives information about most-used fields that you can import from Tradetracker. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
ID Dimension
A unique identifier for the record, such as a campaign ID, affiliate site ID, or transaction ID.
affiliate_assignment_date Dimension
The date when the affiliate site was assigned to a campaign.
affiliate_assignment_status Dimension
The status of the affiliate site's assignment to a campaign (e.g., pending, accepted, rejected, onhold, signedout).
affiliate_modification_date Dimension
The date when the affiliate site's information was last modified.
affiliate_site_category_id Dimension
A unique identifier for the category of the affiliate site.
affiliate_site_category_name Dimension
The name of the category the affiliate site belongs to.
affiliate_site_id Dimension
A unique identifier for the affiliate site.
affiliate_site_name Dimension
The name of the affiliate site.
affiliate_site_type_id Dimension
A unique identifier for the type of the affiliate site.
affiliate_site_type_name Dimension
The name of the type of affiliate site.
affiliate_site_url Dimension
The URL of the affiliate site.
affiliate_trade_rules_enabled Dimension
Indicates whether trade rules are enabled for the affiliate site.
assessment_date Dimension
The date when a conversion transaction was assessed.
campaign_category_id Dimension
A unique identifier for the category of the campaign.
campaign_category_name Dimension
The name of the category the campaign belongs to.
campaign_characteristics Dimension
Characteristics or attributes associated with the campaign.
campaign_click_to_conversion_duration Dimension
The duration between the initial click and the final conversion for a specific transaction, measured from the time of the click to the time the conversion was registered.
campaign_description Dimension
A detailed description of the campaign.
campaign_id Dimension
A unique identifier for the campaign.
campaign_name Dimension
The name of the campaign.
campaign_policy_cashback_status Dimension
The status of the campaign's cashback policy.
campaign_policy_discount_code_status Dimension
The status of the campaign's discount code policy.
campaign_policy_email_marketing_status Dimension
The status of the campaign's email marketing policy.
campaign_policy_search_engine_marketing_status Dimension
The status of the campaign's search engine marketing policy.
campaign_product_id Dimension
A unique identifier for the product associated with the campaign in a conversion transaction.
campaign_product_name Dimension
The name of the product associated with the campaign in a conversion transaction.
campaign_segment_id Dimension
A unique identifier for the campaign segment.
campaign_segment_name Dimension
The name of the campaign segment.
campaign_start_date Dimension
The start date of the campaign.
campaign_stop_date Dimension
The stop date of the campaign.
campaign_target_group Dimension
The target audience or group for the campaign.
campaign_time_zone Dimension
The time zone of the campaign.
campaign_url Dimension
The URL of the campaign.
characteristic Dimension
A characteristic or specific attribute of a conversion transaction.
click_commission Metric
The total commission generated from clicks for a campaign or affiliate site.
click_to_conversion Dimension
Indicates the nature of the click to conversion (e.g., direct, assisted).
clr Metric
Conversion-to-Lead Ratio, indicating the percentage of clicks that result in a lead.
commission Metric
The commission earned from a specific click or conversion transaction.
country_code Dimension
The country code associated with the conversion transaction.
cpo Metric
The Cost Per Order (CPO) represents the average cost incurred to generate a single sales order or conversion. It is a key performance metric available in the Affiliate Site Performance report.
csr Metric
Conversion-to-Sale Ratio, indicating the percentage of clicks that result in a sale.
ctr Metric
Click-Through Rate, representing the percentage of impressions that result in a click.
currency Dimension
The currency of the commission or order amount.
date Dimension
This field represents a specific date or a date range used for filtering and retrieving data in reports or transactions. It can be used as a 'From' or 'To' date for periods related to campaign reports or transaction registrations.
description Dimension
Provides additional textual details or notes pertaining to a specific lead or sale transaction.
ecpc Metric
The Effective Cost Per Click, representing the average cost of a click.
ecpm Metric
Effective Cost Per Mille (or Cost Per Thousand Impressions), indicating the effective revenue generated per thousand impressions.
fixed_commission Metric
The fixed commission earned.
impression_commission Metric
The total commission generated from impressions for a campaign or affiliate site.
ip Dimension
The IP address associated with the click or conversion transaction.
lead_commission Metric
The commission earned for a generated lead.
lead_count Metric
The number of leads generated for a campaign or affiliate site.
num_attributed_touch_points Metric
The number of touch points that were attributed to a conversion transaction.
num_touch_points Metric
The total number of touch points in the conversion path for a transaction.
order_amount Metric
The total amount of the order associated with a conversion transaction.
originating_click_date Dimension
The date of the initial click that led to a conversion.
overall_click_count Metric
The total number of clicks (including non-unique) for a campaign or affiliate site.
overall_impression_count Metric
The total number of impressions (including non-unique) for a campaign or affiliate site.
registration_date Dimension
The date when a click or conversion transaction was registered.
rejection_reason Dimension
The reason why a conversion transaction was rejected.
sale_commission Metric
The commission earned for a completed sale.
sale_count Metric
The number of sales generated for a campaign or affiliate site.
shop_description Dimension
A description of the shop or merchant associated with the campaign.
total_commission Metric
The total commission generated from all types of conversions (impressions, clicks, leads, sales).
transaction_status Dimension
The status of a transaction (e.g., pending, accepted, rejected).
transaction_type Dimension
The type of transaction (e.g., click, lead, sale).
unique_click_count Metric
The number of distinct clicks recorded.
unique_impression_count Metric
The number of distinct impressions recorded.