Order Count
Orders represented by the order-level ecommerce fact
Order Gross Revenue
Gross revenue at order grain
Order Net Revenue
Net revenue at order grain
Outstanding Order Revenue
Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.
Order Refunds
Refund amount at order grain
Order Shipping
Shipping amount charged on order-level ecommerce rows.
Order Tax
Tax amount collected on order-level ecommerce rows.
Order Units
Units sold at order grain
Platform Discount
Platform-funded discounts on TikTok Shop orders
Seller Discount
Seller-funded discounts on TikTok Shop orders
Shopify Current Order Value
Shopify order value after returns, sourced from currentTotalPriceSet.
SKU Count
Distinct SKU counts reported on TikTok Shop orders
Subtotal Price
Order subtotal before tax shipping discounts and refunds
TikTok Shop Items
Items represented on TikTok Shop orders
TikTok Shop Revenue
Gross revenue on TikTok Shop orders
Total Line Items
Line items represented across canonical orders
Units Sold (Ecommerce)
Units sold from orders
Current Order Value
Order value after post-purchase edits and returns (Shopify currentTotalPriceSet). Only Shopify reports this value, so the formula is limited to Shopify orders; other platforms' order totals are in ecommerce_gross_revenue
Collected Order Revenue
Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.
Ecommerce Orders
Orders represented by the order-level ecommerce fact
Outstanding Order Revenue
Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.
Ecommerce Units Sold
Units sold at order grain
Ecommerce Product Discounts
Line-level product discounts.
Ecommerce Product Net Revenue
Net product revenue after line-level discounts.
Ecommerce Product Net Revenue After Refunds
Product revenue after discounts and line-linked refunds; group or filter by currency
Ecommerce Product Orders
Distinct orders containing this product.
Ecommerce Product Revenue
Gross product revenue across commerce and shopping product rows
Ecommerce Product Units Sold
Units sold for the product at daily grain.
Shopping Clicks
Product-listing clicks reported by Google Merchant Center
Shopping Conversions
Product-listing conversions reported by Google Merchant Center
Shopping Impressions
Product-listing impressions reported by Google Merchant Center
Shopping Revenue
Product-listing conversion revenue reported by Google Merchant Center
Cohort Active Customers
Distinct cohort customers who placed an order at this month offset. Summing across offsets yields customer-months, not distinct customers.
Cohort Cumulative Active Customers
Running sum of active_customers for the cohort from month 0 through this offset (customer-months; can exceed cohort_size). Level, not a flow — do not sum across offsets.
Cohort Cumulative Revenue
Running gross revenue for the cohort from month 0 through this offset. Level, not a flow — do not sum across offsets.
Cohort Gross Revenue
Gross revenue (order total price) from the cohort at this month offset.
Cohort Net Revenue
Net revenue (gross revenue minus refunds) from the cohort at this month offset.
Cohort Orders
Orders placed by the cohort at this month offset.
Cohort Size
Distinct customers acquired in the cohort month. Repeated on every offset row of the cohort — only valid within a single months_since_first_order slice.
Geo Ad Conversions
Platform-reported conversions from the region. For Facebook this is Meta Results for each ad set's optimization event under its attribution setting, not purchases.
Geo Ad Revenue
Platform-reported conversion value from regional paid-media rows. For Facebook this is the primary set's conversion_value, not purchase_value.
Regional Ad Spend
Paid media spend attributed to a geo region by the ad platform
Geo Clicks
Ad clicks from the region.
Geo Impressions
Ad impressions served in the region.
Regional Orders
Orders shipped to a geo region (Shopify)
Regional Revenue
Business revenue by geo region from one KPI source per workspace (Shopify when connected, else GA4)
Regional Sessions
Web sessions from a geo region (GA4)
Geo Users
Web users from the region (GA4 rows; null for Shopify).
Regional Weekly Attributed Conversions
Weekly platform-attributed conversions by region from the geo spend-response panel
Regional Weekly Orders
Weekly total business orders by region from the geo spend-response panel (single KPI source platform per workspace)
Regional Outcome Delta
Baseline-relative, cross-region demeaned weekly unattributed-orders difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation
Regional Weekly Spend
Weekly ad spend by region from the geo spend-response panel (summed across platforms and campaigns)
Regional Spend Delta
Baseline-relative, cross-region demeaned weekly spend difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation
Regional Spend Delta Prior Week
Prior week's spend delta for the same region (1-week lag). Analysis aid for lagged region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation
Regional Weekly Unattributed Orders
Weekly orders not attributed by ad platforms (total orders minus platform-attributed conversions) — descriptive correlation input; not a causal measure
Demeaned Spend Delta
Baseline-relative, cross-region demeaned weekly spend difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation
Demeaned Spend Delta (Prior Week)
Prior week's spend delta for the same region (1-week lag). Analysis aid for lagged region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation
Demeaned Unattributed Orders Delta
Baseline-relative, cross-region demeaned weekly unattributed-orders difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation
Conversion Weight (First Touch)
Fractional conversion credit under the first-touch model by conversion touchpoint
Conversion Weight (Last Touch)
Fractional conversion credit under the last-touch model by conversion touchpoint
Conversion Weight (Linear)
Fractional conversion credit under the linear model by conversion touchpoint
Conversion Weight (Markov)
Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint
Conversion Weight (Position Based)
Fractional conversion credit under the position-based model by conversion touchpoint
Conversion Weight (Shapley)
Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint
Conversion Weight (Time Decay)
Fractional conversion credit under the time-decay model by conversion touchpoint
Conversion Events
Canonical conversion/lead events counted through normalized last-touch weights
GA4 Site Conversions by Geo
GA4 key events (site conversions) by geography and channel; GA4 rows only, never added to platform conversions
GA4 Key Event Days Covered
GA4 day-rows whose key events were fully reported; compare with geo_channel_ga4_days_expected
GA4 Key Event Days Expected
GA4 day-rows expected for key-event coverage
GA4 Revenue by Geo
GA4 revenue by geography and channel
GA4 Sessions by Geo
GA4 sessions by geography and channel
Platform Clicks by Geo
Ad platform clicks by geography and channel
Platform Conversions by Geo
Platform-reported conversions (each platform's own attribution) by geography and channel; NULL where the platform does not report them, never added to GA4 conversions
Platform Impressions by Geo
Ad platform impressions by geography and channel
Platform Conversion Value by Geo
Platform-reported conversion value by geography and channel; NULL where not reported
Platform Spend by Geo
Ad platform spend by geography and channel, including spend a geo level does not account for (__not_reported__ rows)
Platform Spend with Reported Conversions
Ad platform spend on rows whose conversions the platform reports at that geo level; the CPA numerator
GA4 Conversion Rate by Geo
GA4 site conversions divided by GA4 sessions
GA4 Conversion Share of Total
Each grouped row's share of all GA4 site conversions in the result
GA4 Conversion Share within Geo
Each grouped row's share of GA4 site conversions within its geography
Platform Conversion Share of Total
Each grouped row's share of all platform conversions in the result (for example a state's share of the total)
Platform Conversion Share within Geo
Each grouped row's share of platform conversions within its geography (for example a channel's share of a state)
Platform CPA by Geo
Spend with reported conversions divided by platform-reported conversions
Return Count
Returns at return grain across connected returns platforms
Return Exchange Value
Value of items exchanged rather than refunded.
Return Refund Amount
Amount refunded for the return.
Return Store Credit
Store credit issued for the return.
Returned Quantity
Quantity of returned items across connected return sources.
Returned Value
Total value of returned items.