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

For Triple-Whale-managed affluencer/influencer programs with discount codes and tracking links → use Affluencer Hub. Affiliates covers third-party affiliate platforms; Affluencer Hub covers profiles, codes, expenses, and links configured directly in Triple Whale.

For revenue from affiliate-sourced traffic with a Triple Whale attribution model applied → use Pixel Joined. Affiliates carries the affiliate platform's own conversion reporting; Pixel Joined applies a Triple Whale attribution model on top of pixel-tracked sessions.

View the full Triple Whale Data Ontology →

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 24 hours ago