Affluencer Table (BETA)

affluencer_spend_table

The Affluencer table contains detailed information about each influencer or affiliate, including their traffic sources, discount codes, expenses, and associated tracking links. By querying this table, users can analyze affluencer performance, manage payouts, and attribute sales across campaigns and channels.

📘

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 order was placed. Based on the time zone of the shop at the moment the event occurred.

Event Day

event_date.day

date

The day on which 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.

Affluencer Source

affluencer_source

string

How the affluencer profile was created.

Example values: upload, client, auto_create, backfill

Discount Codes

discount_codes

record repeated

A list of the discount codes associated with the affluencer.

Discount Code

discount_codes.code

string

The actual code used to attribute orders to the affluencer.

Example values: JEN20, UMICH, ARKNUTRITION

Discount Code Start Date

discount_codes.start_date

date

The start date the discount code is valid.

Example value: 2024-08-02 00:00:00

Discount Code End Date

discount_codes.end_date

date

The end date the discount code is valid.

Example value: 2025-08-02 00:00:00

Expenses

expenses

record repeated

A list of expense records assigned to the affluencer.

Expense ID

expenses.id

string

A unique identifier for the expense.

Example value: 37f1ad60-2ce9-4733-b6d9-4b3d13307e42

Expense Type

expenses.spend_type

string

Indicates the category of the expense.

Example values: per_order, fixed

Expense Amount Type

expenses.amount_type

string

Indicates whether the expense is a percentage of sales or a fixed amount (currency).

Example values: percentage, currency

Expense Is Recurring

expenses.is_recurring

boolean

Indicates whether this expense recurs on a regular cadence (e.g. monthly) or is a one-time expense.

Possible values: true, false

Expense Recurring Cadence

expenses.recurring_cadence

string

Frequency of the recurring expense.

Example values: one_time, weekly, monthly

Expense Start Date

expenses.start_date

date

The date the expense starts.

Example value: 2023-07-22

Expense End Date

expenses.end_date

date

The date the expense ends (if applicable).

Example value: 2025-01-01

Expense Amount

expenses.amount

numeric

The value of the expense.

Expense Recurring Interval Length

expenses.recurring_interval_length

numeric

Number of intervals between each recurring payment.

For example, if recurring_cadence = week and recurring_interval_length = 2, the expense recurs every two weeks.

Affluencer Links

links

record repeated

A list of destination URLs tied to the affluencer, used for traffic and attribution.

Link ID

links.id

string

Unique identifier for the link, formatted: ${name}*${links.campaign}*${links.source}

Link Campaign

links.campaign

string

The name of the campaign the link is associated with (e.g. summer-launch, holiday-sale).

Link Source

links.source

string

The traffic source where this link is shared.

Example values: instagram, default

Link Storefront URL

links.storefront_url

string

The public-facing URL the affluencer is promoting

Example value: https://www.instagram.com/example

Link URL

links.url

string

The fully generated tracking URL that includes affluencer and link identifiers.

Example value: https://www.instagram.com/example?linkId=example_instagram&affluencerId=example

Affluencer Name

name

string

The name of the affluencer.

Example value: Jane Smith

Spend

spend

string

The total amount of expenses.