affluencer_spend_table
The Affluencer table tracks influencer- and affiliate-related events, including discount codes, expenses, and campaign links. Querying this table helps users analyze the effectiveness and cost of influencer marketing campaigns by organizing data across different events and influencer interactions.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| ID | Type | Description | Source |
|---|---|---|---|
event_date | date | The date the affluencer event occurred. Based on the time zone of the shop at the moment of the affluencer event. | Gorgias |
event_date.day | date | The day the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.week | date | The Sunday of the week during which the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.month | date | The month during which the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.quarter | date | The first month of the quarter during which the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.year | date | The year during which the affluencer event occurred. Derived from event_date. | Gorgias |
discount_codes | record repeated | Information about the discount codes associated with the affluencer event. | Gorgias |
discount_codes.code | string | Example values: BRIGHT29, ROCKLATIMER, CORALRANCHNUTRITION | Gorgias |
discount_codes.start_date | date | The start date for the discount code. | Gorgias |
discount_codes.end_date | date | The end date for the discount code. | Gorgias |
expenses | record repeated | Information about the expenses associated with the affluencer event. | Gorgias |
expenses.id | string | Example value: pecc2c1c-07ae-423d-a35d | Gorgias |
expenses.spend_type | string | Example value: per_order | Gorgias |
expenses.amount_type | string | Example value: percentage | Gorgias |
expenses.is_recurring | boolean | Indicates if the expense is recurring. | Gorgias |
expenses.recurring_cadence | string | The recurrence pattern of the expense (e.g., monthly, weekly). | Gorgias |
expenses.start_date | date | The start date for the expense. | Gorgias |
expenses.end_date | date | The end date for the expense. | Gorgias |
expenses.amount | numeric | The amount of the expense. | Gorgias |
expenses.recurring_interval_length | numeric | The interval length for the recurrence of the expense. | Gorgias |
id | string | The unique identifier for the affluencer event. | Gorgias |
links | record repeated | Information about the links associated with the affluencer event. | Gorgias |
links.id | string | Example value: iam_kdh | Gorgias |
links.campaign | string | Example value: kdh | Gorgias |
links.source | string | Example values: instagram, default | Gorgias |
links.storefront_url | string | Example value: https://www.instagram.com/p/Ck9bPlVjKFr | Gorgias |
links.url | string | Example value: https://www.instagram.com/p/Ck9bPlVjKFr/?linkId=iam_kdh&affluencerId=kdh | Gorgias |
name | string | The name of the influencer involved in the event. Example value: Kelly Daniel Hall | Gorgias |
source | string | The source platform of the affluencer event. Example values: instagram, youtube | Gorgias |
spend | string | The total spend associated with the affluencer event. | Gorgias |
The Affluencer Events table tracks influencer- and affiliate-related events, including discount codes, expenses, and campaign links. Querying this table helps users analyze the effectiveness and cost of influencer marketing campaigns by organizing data across different events and influencer interactions.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| ID | Type | Description | Source |
|---|---|---|---|
event_date | date | The date the affluencer event occurred. Based on the time zone of the shop at the moment of the affluencer event. | Gorgias |
event_date.day | date | The day the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.week | date | The Sunday of the week during which the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.month | date | The month during which the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.quarter | date | The first month of the quarter during which the affluencer event occurred. Derived from event_date. | Gorgias |
event_date.year | date | The year during which the affluencer event occurred. Derived from event_date. | Gorgias |
discount_codes | record repeated | Information about the discount codes associated with the affluencer event. | Gorgias |
discount_codes.code | string | The code for discounts offered in the affluencer event. Example values: BRIGHT29, ROCKLATIMER, CORALRANCHNUTRITION | Gorgias |
discount_codes.start_date | date | The start date for the discount code. | Gorgias |
discount_codes.end_date | date | The end date for the discount code. | Gorgias |
expenses | record repeated | Information about the expenses associated with the affluencer event. | Gorgias |
expenses.id | string | The unique identifier for expenses in the affluencer event. Example value: pecc2c1c-07ae-423d-a35d | Gorgias |
expenses.spend_type | string | Type of spending associated with the event, such as order-based or fixed. Example value: per_order | Gorgias |
expenses.amount_type | string | The type of amount specified, such as percentage-based or fixed. Example value: percentage | Gorgias |
expenses.is_recurring | boolean | Indicates if the expense is recurring. | Gorgias |
expenses.recurring_cadence | string | The recurrence pattern of the expense (e.g., monthly, weekly). | Gorgias |
expenses.start_date | date | The start date for the expense. | Gorgias |
expenses.end_date | date | The end date for the expense. | Gorgias |
expenses.amount | numeric | The amount of the expense. | Gorgias |
expenses.recurring_interval_length | numeric | The interval length for the recurrence of the expense. | Gorgias |
id | string | The unique identifier for the affluencer event. | Gorgias |
links | record repeated | Information about the links associated with the affluencer event. | Gorgias |
links.id | string | The identifier for links associated with the event. Example value: iam_kdh | Gorgias |
links.campaign | string | The campaign name tied to the affluencer link. Example value: kdh | Gorgias |
links.source | string | The platform from which the link originated. Example values: instagram, default | Gorgias |
links.storefront_url | string | The storefront URL associated with the influencer's campaign. Example value: https://www.instagram.com/p/Ck9bPlVjKFr | Gorgias |
links.url | string | The full URL link used in the campaign, including tracking parameters. Example value: https://www.instagram.com/p/Ck9bPlVjKFr/?linkId=iam_kdh&affluencerId=kdh | Gorgias |
name | string | The name of the influencer involved in the event. Example value: Kelly Daniel Hall | Gorgias |
source | string | The source platform of the affluencer event. Example values: instagram, youtube | Gorgias |
spend | string | The total spend associated with the affluencer event. | Gorgias |