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	clr	The Click-to-Lead Ratio, indicating the percentage of clicks that resulted in leads.	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	cpo	The Cost Per Order, representing the cost incurred to generate an order.	metric
csr	csr	The Click-to-Sale Ratio, indicating the percentage of clicks that resulted in sales.	metric
ctr	ctr	The Click-Through Rate, representing the percentage of impressions that resulted in a click.	dimension
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	This field provides descriptive text for various entities within the TradeTracker platform, such as campaigns, affiliate sites, conversion transactions, or promotional materials like vouchers and offers. The specific content depends on the context of the data being retrieved.	dimension
ecpc	ecpc	The Effective Cost Per Click, representing the average cost of a click.	metric
ecpm	ecpm	The Effective Cost Per Mille (thousand impressions), representing the average cost for one 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	lead_commission	The total commission generated from leads for a campaign or affiliate site.	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	sale_commission	The total commission generated from sales for a campaign or affiliate site.	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	total_commission	The total commission generated for a campaign or affiliate site, encompassing various commission types.	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	unique_click_count	The number of unique clicks for a campaign or affiliate site.	metric
unique_impression_count	unique_impression_count	The number of unique impressions for a campaign or affiliate site.	metric