Event Date

event_date

date

The date the external revenue was earned/recorded, provided in the CSV upload (or derived from start_date/end_date for date ranges). Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).

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:

• sku (string): The SKU (Stock Keeping Unit) for the product.
• product_id (string): The unique product ID.
• amount (number): The quantity of the product sold.
• revenue (number): The revenue amount for this specific product. This value is automatically converted to your shop's selected currency for display.

Channel

channel

string

The marketing or sales channel through which the revenue was generated.

Example values: online, retail, wholesale, in-store

City

city

string

The city where the revenue was generated.

Example values: New York, Los Angeles, Chicago

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: 2025-01-15T10:30:00.000Z

Currency

currency

string

The original currency in which the revenue was recorded.

Example values: USD, EUR

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: Downtown Store, Mall Location, Warehouse A

Source Name

source_name

string

The name of the revenue source.

Example values: Target, Walmart, Store Location 1

Source Type

source_type

string

The type of revenue source.

Possible values: retail, wholesale, pos, offline.

State

state

string

The full state name where the revenue was generated.

Example values: California, New York, Texas

State Code

state_code

string

The two-letter state code where the revenue was generated.

Example values: CA, NY, TX

ZIP Code

zip

string

The ZIP or postal code where the revenue was generated.

Example values: 10001, 90210, 60601