The Custom Spend table aggregates expenses from various categories not otherwise accounted for, including advertising, operational costs, and other expenditures related to your store's operations. Querying this table enables you to analyze your spending patterns across different platforms and campaigns, helping you optimize your budget allocation for better financial management.
Note
event_dateis a required field for queries on this table.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| Name | Type | Description |
|---|---|---|
event_date | date | The date the expense was incurred. |
event_date.day | date | The day the expense was incurred. Derived from event_date. |
event_date.week | date | The Sunday of the week during which the expense was incurred. Derived from event_date. |
event_date.month | date | The month during which the expense was incurred. Derived from event_date. |
event_date.quarter | date | The first month of the quarter during which the expense was incurred. Derived from event_date. |
event_date.year | date | The year during which the expense was incurred. Derived from event_date. |
event_hour | string | The hour of the day the expense was incurred, according to a 24-hour clock. Based on the time zone of the shop at the moment the expense was incurred. Example values: 07, 16, 21 |
title | string | The title of the expense. Set by the seller in Triple Whale admin. Example value: Podcast US |
category | string | The category of the expense. Set by the seller in Triple Whale admin. Example values: Ad Spend, Cashback Booked, Returns Estimate |
is_ad_spend | boolean | True if the expense is associated with advertising. Set by the seller in Triple Whale admin. |
is_recurring | boolean | True if the expense is recurring. Set by the seller in Triple Whale admin. Note: Only relevant for fixed expenses. NULL for variable expenses. |
metric | string | The specific metric related to the expense. Set by the seller in Triple Whale admin. Note: Only relevant for variable expenses. NULL for fixed expenses. Example values: sales, ads, revenue |
rate | string | The rate applied to the expense. Set by the seller in Triple Whale admin in the percent field. Note: Only relevant for variable expenses. NULL for fixed expenses. Example value: 0.02 |
channel | string | The platform related to the expense (e.g. Shopify, Facebook, Podcast, Point of Sale). Note: This may match an existing integrated channel, or may be added manually by the seller in Triple Whale admin. Example values: facebook, social, microsoft |
campaign_id | string | The name or ID of the campaign the custom expense is associated with. Note: This may match an existing campaign ID in an integrated publisher platform, or may be added manually by the seller in Triple Whale admin. Example values: 23852438666180053, 531011533, 20620285829 |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Name | Type | Description |
|---|---|---|
amount | numeric | The amount of the expense. By default shown in the shop's currency. Note: For fixed expenses, the amount is set by the seller in Triple Whale admin. For variable expenses, the amount is calculated based on the rate set by the seller in Triple Whale admin and shop prices from the sales, ad, or email/SMS platform (e.g. Shopify, Facebook, Klaviyo). |