Affiliates Table

The Affiliates table contains performance and metadata for affiliate, influencer, and publisher campaigns, including tracking links, campaigns, and partners. Querying this table allows you to analyze affiliate-driven traffic, conversions, and spend over time, broken down by publisher, campaign, and tracking link.

📘
Note
event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Date	`event_date`	date	The date the affiliate event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Ad ID	`ad_id`	string	The unique identifier of the tracking link under the campaign. Example values: `link_abc123`, `tracking_xyz789`
Ad Name	`ad_name`	string	The name of the tracking link under the campaign. Example values: `homepage-banner`, `product-page-link`, `email-cta`
Ad Status	`ad_status`	string	Indicates whether this tracking link is active or inactive. Example values: `active`, `inactive`
Campaign ID	`campaign_id`	string	The unique identifier of the campaign or offer under the publisher. Example values: `camp_12345`, `offer_67890`
Campaign Name	`campaign_name`	string	The name of the campaign or offer under the publisher. Example values: `summer-promo-10%`, `holiday-sale-2024`, `winter-clearance`
Campaign Status	`campaign_status`	string	Indicates whether this campaign or offer is active or inactive. Example values: `active`, `inactive`
Publisher ID	`publisher_id`	string	The unique identifier of the affiliate partner or influencer. Example value: `208997`
Publisher Name	`publisher_name`	string	The name of the affiliate partner or influencer. Example values: `Karma Shopping LTD`, `NextGen Shopping, Inc.`, `tenere_team`
Publisher Status	`publisher_status`	string	Indicates whether the partnership with this affiliate is active or inactive. Example values: `active`, `inactive`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Clicks	`clicks`	numeric	Number of clicks on the affiliate tracking link.
Conversion Value	`conversion_value`	numeric	Total revenue generated from purchases attributed to the affiliate.
Impressions	`impressions`	numeric	Number of times the affiliate tracking link was displayed or viewed.
Purchases	`purchases`	numeric	Number of purchases attributed to the affiliate.
Spend	`spend`	numeric	Total amount spent on the affiliate partnership, including commissions, fees, or other costs.

Updated about 3 hours ago