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 |
| date | The date the order was placed. Based on the time zone of the shop at the moment the event occurred. |
Event Day |
| date | The day on which the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
Affluencer Source |
| string | How the affluencer profile was created. Example values: |
Discount Codes |
| record repeated | A list of the discount codes associated with the affluencer. |
Discount Code |
| string | The actual code used to attribute orders to the affluencer. Example values: |
Discount Code Start Date |
| date | The start date the discount code is valid. Example value: |
Discount Code End Date |
| date | The end date the discount code is valid. Example value: |
Expenses |
| record repeated | A list of expense records assigned to the affluencer. |
Expense ID |
| string | A unique identifier for the expense. Example value: |
Expense Type |
| string | Indicates the category of the expense. Example values: |
Expense Amount Type |
| string | Indicates whether the expense is a percentage of sales or a fixed amount (currency). Example values: |
Expense Is Recurring |
| boolean | Indicates whether this expense recurs on a regular cadence (e.g. monthly) or is a one-time expense. Possible values: |
Expense Recurring Cadence |
| string | Frequency of the recurring expense. Example values: |
Expense Start Date |
| date | The date the expense starts. Example value: |
Expense End Date |
| date | The date the expense ends (if applicable). Example value: |
Expense Amount |
| numeric | The value of the expense. |
Expense Recurring Interval Length |
| numeric | Number of intervals between each recurring payment. For example, if |
Affluencer Links |
| record repeated | A list of destination URLs tied to the affluencer, used for traffic and attribution. |
Link ID |
| string | Unique identifier for the link, formatted: |
Link Campaign |
| string | The name of the campaign the link is associated with (e.g. |
Link Source |
| string | The traffic source where this link is shared. Example values: |
Link Storefront URL |
| string | The public-facing URL the affluencer is promoting Example value: |
Link URL |
| string | The fully generated tracking URL that includes affluencer and link identifiers. Example value: |
Affluencer Name |
| string | The name of the affluencer. Example value: |
Spend |
| string | The total amount of expenses. |
Updated about 15 hours ago