External Revenue Table
The External Revenue table stores uploaded revenue records from sources outside the main ecommerce sales platform. One row per external revenue record per event date.
Table GuideWhat You Can Answer With This Table
- How much revenue came from external source types or named sources? — use
amount_total,source_type,source_name- Which stores or regions generated external revenue? — use
amount_total,location,state_code- What product-level detail was included in uploaded external revenue records? — use
breakdownBefore You Query
- Required field:
event_date- If an uploaded revenue record covers a date range, External Revenue shows one row per day in that range.
amount_totaland any product-levelbreakdownrevenue are spread across those daily rows.When to Use a Different Table
- Use Orders table when you need order or customer detail for ecommerce sales. The External Revenue table is for uploaded revenue from outside sales-platform and marketplace order records.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| Title | ID | Type | Description |
|---|---|---|---|
| Event Date | event_date | date | The date the external revenue was generated. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Note: Each uploaded row can represent either a single date of revenue, or a start and end date. For rows containing a date range, Triple Whale will amortize the amount over the time range. |
| Event Day | event_date.day | date | The day 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. |
| Breakdown | breakdown | JSON | A JSON array containing product-level details for the revenue. Each element in the array is an object with the following properties:
|
| Channel | channel | string | The marketing or sales channel through which the revenue was generated. Example values: |
| City | city | string | The city where the revenue was generated. Example values: |
| Created At | created_at | timestamp | The timestamp when the revenue record was created in Triple Whale (when the CSV was uploaded and processed). Example value: |
| Source Currency | currency | string | The original currency in which the revenue was recorded, before conversion to the shop's currency. All monetary values are automatically converted to the shop's selected currency for display. Example values: Note: All revenue metrics are automatically converted to your shop's selected currency for display. |
| Location | location | string | The physical location or store where the revenue was generated. Example values: |
| Source Name | source_name | string | Free-text identifier to name the specific revenue source. Example values: |
| Source Type | source_type | string | The type of revenue source. Possible values:
|
| State | state | string | The full state name where the revenue was generated. Example values: |
| State Code | state_code | string | The two-letter state code where the revenue was generated. Example values: |
| ZIP Code | zip | string | The ZIP or postal code where the revenue was generated. Example values: |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Title | ID | Type | Description |
|---|---|---|---|
| Amount Total | amount_total | numeric | The total revenue amount for the record. |
Updated 6 days ago