The Affluencer Hub table contains Triple-Whale-managed affluencer (influencer/affiliate) profiles with discount codes, expense configurations, and tracking links. One row per affluencer profile currently available in Affluencer Hub.

📋

Table Guide

What You Can Answer With This Table

• What is each affluencer costing me, and how is that trending over time? — use spend, event_date, name
• Which discount codes and tracking links belong to each affluencer? — use discount_codes.code, links.url, name
• What are my expense commitments by type and cadence? — use expenses.spend_type, expenses.amount, expenses.recurring_cadence

Before You Query

• Required field: event_date
• Selecting spend returns one row per affluencer profile per day.
• spend is calculated dynamically per row, not stored. Per-order expenses (expenses.spend_type = 'per_order') are computed from Triple Attribution-attributed pixel orders matched to the affluencer by name. Fixed/recurring expenses (expenses.spend_type = 'fixed') are prorated across each expense's active date range using expenses.recurring_cadence and expenses.recurring_interval_length.
• Each expenses line item has its own start_date / end_date. Only line items active on the row's event_date contribute to that day's spend.

When to Use a Different Table

• Use Affiliates table when you need performance from external affiliate platforms. The Affluencer Hub table is for profiles, codes, expenses, and links configured directly in Triple Whale.
• Use Pixel Orders table when you need order-level Pixel-attributed transactions from affluencer-driven traffic; filter by channel = 'influencers'. The Affluencer Hub table is for affluencer configuration and computed cost.
• Use Pixel Joined table when you need attributed performance from affluencer-driven traffic; filter by channel = 'influencers'. The Affluencer Hub table is for affluencer configuration and computed cost.

View the full Triple Whale Data Ontology →

Dimensions

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