Trackonomics: Most-used fields

The table below gives information about most-used fields that you can import from Trackonomics. 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
SKU (Product)	sku	The Stock Keeping Unit (SKU) identifier for a specific product.	dimension
account_id	account_id	A unique identifier for the affiliate account or publisher account associated with the recorded activity.	dimension
account_name	account_name	The name of the affiliate account or publisher account.	dimension
asset_id	asset_id	A unique identifier for an asset, which could refer to a piece of content, an advertisement, or a product.	dimension
asset_name	asset_name	The name or title of the asset.	dimension
campaign_id	campaign_id	The unique identifier for a marketing campaign.	dimension
click_date	click_date	The specific date and time when a user clicked on an affiliate link.	dimension
commissions_gross	commissions_gross	The total commission earned from a transaction or product sale before any deductions or adjustments.	metric
commissions_net	commissions_net	The net commission earned from a transaction or product sale after all deductions and adjustments.	metric
commissions_net_raw	commissions_net_raw	The original net commission earned from a transaction or product sale, prior to any adjustments.	metric
coupon	coupon	The coupon or promotional code used in the transaction, if applicable.	dimension
currency	currency	The currency in which the transaction amounts (sales, commissions) are denominated.	dimension
date	date	The date of a transaction or event. This can be used for filtering data by a specific date range, such as transaction date or update date.	dimension
external_merchant_id	external_merchant_id	A unique identifier for the merchant associated with a product or transaction. The ‘merchant’ is also available as a dimension for SKU data.	dimension
merchant	merchant	The name of the merchant or advertiser associated with the transaction or product.	dimension
merchant_id	merchant_id	The unique identifier for the merchant.	dimension
merchant_name	merchant_name	The name of the merchant.	dimension
network	network	The name of the affiliate network through which the transaction was tracked.	dimension
network_id	network_id	The unique identifier for the affiliate network.	dimension
network_name	network_name	The name of the affiliate network.	dimension
order_id	order_id	The unique identifier for the order or transaction.	dimension
order_type	order_type	The classification of the order or transaction, such as a new sale, lead, or adjusted order.	dimension
original_commissions_gross	original_commissions_gross	The total commission earned on a transaction before any deductions or adjustments. This corresponds to ‘statistics[commissions_gross]’ in the SKU report.	metric
original_commissions_net	original_commissions_net	The commission earned on a transaction after any deductions or adjustments have been applied.	metric
original_currency	original_currency	The original currency in which the transaction was recorded by the affiliate network.	dimension
original_sales_gross	original_sales_gross	The total sales amount before any deductions or adjustments.	metric
original_sales_net	original_sales_net	The sales amount after any deductions or adjustments have been applied.	metric
parent_id	parent_id		dimension
payment_status	payment_status	The current status of the payment for the transaction (e.g., pending, approved, paid).	dimension
product_id	product_id	A unique identifier for the product involved in a transaction. This corresponds to ‘static_dimensions[sku]’ in the SKU report.	dimension
product_name	product_name	The name of the product.	dimension
record_date	record_date	The date when the record was created or last updated in the system. This can correspond to the ‘Update date’ within the date_filter parameter.	dimension
referral_url	referral_url	The URL from which the user was referred to the merchant’s site, indicating the source of the click or transaction.	dimension
sales_gross	sales_gross	The total sales amount from a transaction or product sale before any deductions or adjustments.	metric
sales_gross_raw	sales_gross_raw	The original gross sales amount from a transaction or product sale, prior to any adjustments or deductions.	metric
sales_net	sales_net	The net sales amount from a transaction or product sale after all deductions and adjustments.	metric
sales_net_raw	sales_net_raw	The original net sales amount from a transaction or product sale, prior to any adjustments or deductions.	metric
sku_product_name	sku_product_name	The name of the product associated with the SKU.	dimension
status	status	The general status of the transaction or record.	dimension
status_name	status_name	A descriptive name corresponding to the numerical or categorical status of a transaction or record.	dimension
store_id	store_id	A unique identifier for the online store or merchant where the transaction originated.	dimension
store_name	store_name	The name of the online store or merchant.	dimension
sub_id	sub_id	An optional identifier used by publishers to track specific traffic sources, campaigns, or individual links. Trackonomics supports up to three SubIDs for detailed tracking.	dimension
transaction_date	transaction_date	The date when the transaction occurred.	dimension
transaction_type	transaction_type	The specific type of affiliate transaction, such as a sale, lead, or click.	dimension
update_date	update_date	The date when the transaction record was last updated.	dimension