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.

API name	Adverity UI name	Description	Use in Adverity
ID	ID	A unique identifier for the record, such as a campaign ID, affiliate site ID, or transaction ID.	dimension
affiliate_assignment_date	affiliate_assignment_date	The date when the affiliate site was assigned to a campaign.	dimension
affiliate_assignment_status	affiliate_assignment_status	The status of the affiliate site’s assignment to a campaign (e.g., pending, accepted, rejected, onhold, signedout).	dimension
affiliate_modification_date	affiliate_modification_date	The date when the affiliate site’s information was last modified.	dimension
affiliate_site_category_id	affiliate_site_category_id	A unique identifier for the category of the affiliate site.	dimension
affiliate_site_category_name	affiliate_site_category_name	The name of the category the affiliate site belongs to.	dimension
affiliate_site_id	affiliate_site_id	A unique identifier for the affiliate site.	dimension
affiliate_site_name	affiliate_site_name	The name of the affiliate site.	dimension
affiliate_site_type_id	affiliate_site_type_id	A unique identifier for the type of the affiliate site.	dimension
affiliate_site_type_name	affiliate_site_type_name	The name of the type of affiliate site.	dimension
affiliate_site_url	affiliate_site_url	The URL of the affiliate site.	dimension
affiliate_trade_rules_enabled	affiliate_trade_rules_enabled	Indicates whether trade rules are enabled for the affiliate site.	dimension
assessment_date	assessment_date	The date when a conversion transaction was assessed.	dimension
campaign_category_id	campaign_category_id	A unique identifier for the category of the campaign.	dimension
campaign_category_name	campaign_category_name	The name of the category the campaign belongs to.	dimension
campaign_characteristics	campaign_characteristics	Characteristics or attributes associated with the campaign.	dimension
campaign_click_to_conversion_duration	campaign_click_to_conversion_duration	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.	dimension
campaign_description	campaign_description	A detailed description of the campaign.	dimension
campaign_id	campaign_id	A unique identifier for the campaign.	dimension
campaign_name	campaign_name	The name of the campaign.	dimension
campaign_policy_cashback_status	campaign_policy_cashback_status	The status of the campaign’s cashback policy.	dimension
campaign_policy_discount_code_status	campaign_policy_discount_code_status	The status of the campaign’s discount code policy.	dimension
campaign_policy_email_marketing_status	campaign_policy_email_marketing_status	The status of the campaign’s email marketing policy.	dimension
campaign_policy_search_engine_marketing_status	campaign_policy_search_engine_marketing_status	The status of the campaign’s search engine marketing policy.	dimension
campaign_product_id	campaign_product_id	A unique identifier for the product associated with the campaign in a conversion transaction.	dimension
campaign_product_name	campaign_product_name	The name of the product associated with the campaign in a conversion transaction.	dimension
campaign_segment_id	campaign_segment_id	A unique identifier for the campaign segment.	dimension
campaign_segment_name	campaign_segment_name	The name of the campaign segment.	dimension
campaign_start_date	campaign_start_date	The start date of the campaign.	dimension
campaign_stop_date	campaign_stop_date	The stop date of the campaign.	dimension
campaign_target_group	campaign_target_group	The target audience or group for the campaign.	dimension
campaign_time_zone	campaign_time_zone	The time zone of the campaign.	dimension
campaign_url	campaign_url	The URL of the campaign.	dimension
characteristic	characteristic	A characteristic or specific attribute of a conversion transaction.	dimension
click_commission	click_commission	The total commission generated from clicks for a campaign or affiliate site.	metric
click_to_conversion	click_to_conversion	Indicates the nature of the click to conversion (e.g., direct, assisted).	dimension
clr		Conversion-to-Lead Ratio, indicating the percentage of clicks that result in a lead.	metric
commission	commission	The commission earned from a specific click or conversion transaction.	metric
country_code	country_code	The country code associated with the conversion transaction.	dimension
cpo			metric
csr		Conversion-to-Sale Ratio, indicating the percentage of clicks that result in a sale.	metric
ctr		Click-Through Rate, representing the percentage of impressions that result in a click.	metric
currency	currency	The currency of the commission or order amount.	dimension
date	date	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.	dimension
description	description	Provides additional textual details or notes pertaining to a specific lead or sale transaction.	dimension
ecpc	ecpc	The Effective Cost Per Click, representing the average cost of a click.	metric
ecpm		Effective Cost Per Mille (or Cost Per Thousand Impressions), indicating the effective revenue generated per thousand impressions.	metric
fixed_commission	fixed_commission	The fixed commission earned.	metric
impression_commission	impression_commission	The total commission generated from impressions for a campaign or affiliate site.	metric
ip	ip	The IP address associated with the click or conversion transaction.	dimension
lead_commission		The commission earned for a generated lead.	metric
lead_count	lead_count	The number of leads generated for a campaign or affiliate site.	metric
num_attributed_touch_points	num_attributed_touch_points	The number of touch points that were attributed to a conversion transaction.	metric
num_touch_points	num_touch_points	The total number of touch points in the conversion path for a transaction.	metric
order_amount	order_amount	The total amount of the order associated with a conversion transaction.	metric
originating_click_date	originating_click_date	The date of the initial click that led to a conversion.	dimension
overall_click_count	overall_click_count	The total number of clicks (including non-unique) for a campaign or affiliate site.	metric
overall_impression_count	overall_impression_count	The total number of impressions (including non-unique) for a campaign or affiliate site.	metric
registration_date	registration_date	The date when a click or conversion transaction was registered.	dimension
rejection_reason	rejection_reason	The reason why a conversion transaction was rejected.	dimension
sale_commission		The commission earned for a completed sale.	metric
sale_count	sale_count	The number of sales generated for a campaign or affiliate site.	metric
shop_description	shop_description	A description of the shop or merchant associated with the campaign.	dimension
total_commission		The total commission generated from all types of conversions (impressions, clicks, leads, sales).	metric
transaction_status	transaction_status	The status of a transaction (e.g., pending, accepted, rejected).	dimension
transaction_type	transaction_type	The type of transaction (e.g., click, lead, sale).	dimension
unique_click_count		The number of distinct clicks recorded.	metric
unique_impression_count		The number of distinct impressions recorded.	metric