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.
IDDimension
A unique identifier for the record, such as a campaign ID, affiliate site ID, or transaction ID.
affiliate_assignment_dateDimension
The date when the affiliate site was assigned to a campaign.
affiliate_assignment_statusDimension
The status of the affiliate site's assignment to a campaign (e.g., pending, accepted, rejected, onhold, signedout).
affiliate_modification_dateDimension
The date when the affiliate site's information was last modified.
affiliate_site_category_idDimension
A unique identifier for the category of the affiliate site.
affiliate_site_category_nameDimension
The name of the category the affiliate site belongs to.
affiliate_site_idDimension
A unique identifier for the affiliate site.
affiliate_site_nameDimension
The name of the affiliate site.
affiliate_site_type_idDimension
A unique identifier for the type of the affiliate site.
affiliate_site_type_nameDimension
The name of the type of affiliate site.
affiliate_site_urlDimension
The URL of the affiliate site.
affiliate_trade_rules_enabledDimension
Indicates whether trade rules are enabled for the affiliate site.
assessment_dateDimension
The date when a conversion transaction was assessed.
campaign_category_idDimension
A unique identifier for the category of the campaign.
campaign_category_nameDimension
The name of the category the campaign belongs to.
campaign_characteristicsDimension
Characteristics or attributes associated with the campaign.
campaign_click_to_conversion_durationDimension
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_descriptionDimension
A detailed description of the campaign.
campaign_idDimension
A unique identifier for the campaign.
campaign_nameDimension
The name of the campaign.
campaign_policy_cashback_statusDimension
The status of the campaign's cashback policy.
campaign_policy_discount_code_statusDimension
The status of the campaign's discount code policy.
campaign_policy_email_marketing_statusDimension
The status of the campaign's email marketing policy.
campaign_policy_search_engine_marketing_statusDimension
The status of the campaign's search engine marketing policy.
campaign_product_idDimension
A unique identifier for the product associated with the campaign in a conversion transaction.
campaign_product_nameDimension
The name of the product associated with the campaign in a conversion transaction.
campaign_segment_idDimension
A unique identifier for the campaign segment.
campaign_segment_nameDimension
The name of the campaign segment.
campaign_start_dateDimension
The start date of the campaign.
campaign_stop_dateDimension
The stop date of the campaign.
campaign_target_groupDimension
The target audience or group for the campaign.
campaign_time_zoneDimension
The time zone of the campaign.
campaign_urlDimension
The URL of the campaign.
characteristicDimension
A characteristic or specific attribute of a conversion transaction.
click_commissionMetric
The total commission generated from clicks for a campaign or affiliate site.
click_to_conversionDimension
Indicates the nature of the click to conversion (e.g., direct, assisted).
clrMetric
Conversion-to-Lead Ratio, indicating the percentage of clicks that result in a lead.
commissionMetric
The commission earned from a specific click or conversion transaction.
country_codeDimension
The country code associated with the conversion transaction.
cpoMetric
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.
csrMetric
Conversion-to-Sale Ratio, indicating the percentage of clicks that result in a sale.
ctrMetric
Click-Through Rate, representing the percentage of impressions that result in a click.
currencyDimension
The currency of the commission or order amount.
dateDimension
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.
descriptionDimension
Provides additional textual details or notes pertaining to a specific lead or sale transaction.
ecpcMetric
The Effective Cost Per Click, representing the average cost of a click.
ecpmMetric
Effective Cost Per Mille (or Cost Per Thousand Impressions), indicating the effective revenue generated per thousand impressions.
fixed_commissionMetric
The fixed commission earned.
impression_commissionMetric
The total commission generated from impressions for a campaign or affiliate site.
ipDimension
The IP address associated with the click or conversion transaction.
lead_commissionMetric
The commission earned for a generated lead.
lead_countMetric
The number of leads generated for a campaign or affiliate site.
num_attributed_touch_pointsMetric
The number of touch points that were attributed to a conversion transaction.
num_touch_pointsMetric
The total number of touch points in the conversion path for a transaction.
order_amountMetric
The total amount of the order associated with a conversion transaction.
originating_click_dateDimension
The date of the initial click that led to a conversion.
overall_click_countMetric
The total number of clicks (including non-unique) for a campaign or affiliate site.
overall_impression_countMetric
The total number of impressions (including non-unique) for a campaign or affiliate site.
registration_dateDimension
The date when a click or conversion transaction was registered.
rejection_reasonDimension
The reason why a conversion transaction was rejected.
sale_commissionMetric
The commission earned for a completed sale.
sale_countMetric
The number of sales generated for a campaign or affiliate site.
shop_descriptionDimension
A description of the shop or merchant associated with the campaign.
total_commissionMetric
The total commission generated from all types of conversions (impressions, clicks, leads, sales).
transaction_statusDimension
The status of a transaction (e.g., pending, accepted, rejected).
transaction_typeDimension
The type of transaction (e.g., click, lead, sale).
unique_click_countMetric
The number of distinct clicks recorded.
unique_impression_countMetric
The number of distinct impressions recorded.