Affiliates Table

The Affiliates table contains affiliate-platform-reported performance for tracking links, campaigns, and publishers. One row per tracking link per day.

📋
Table Guide
What You Can Answer With This Table

Which affiliate publishers or campaigns are driving revenue, purchases, and ROAS? — use conversion_value, spend, publisher_name

Which tracking links or partnerships are active and converting best? — use clicks, conversion_value, ad_status

Before You Query

Required field: event_date

When to Use a Different Table

Use Affluencer Hub table when you need Triple Whale-managed affluencer or influencer profiles with discount codes, expenses, and tracking links. The Affiliates table is for external affiliate-platform reporting.

Use Pixel Joined table when you need Triple Whale-attributed revenue from affiliate-sourced traffic. The Affiliates table carries the affiliate platform's own conversion reporting.

View the full Triple Whale Data Ontology →

Dimensions

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

Title	ID	Type	Description
Event Hour	`event_hour`	string	The hour of the day the affiliate event occurred, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: `07`, `16`, `21`
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`
Channel	`channel`	string	The affiliate platform that reported the data. Example values: `awin`, `impact`, `rakuten`
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`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`

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.
Conversions	`conversions`	numeric	The number of conversions attributed to the affiliate. Equivalent to `purchases` for this table.
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.