Jump to Content
Triple Whale
HomeData DictionaryAPI Reference
Triple Whale
Data Dictionary
HomeData DictionaryAPI Reference
All
Pages
Start typing to search…

Triple Whale Data Schema

  • Blended Stats Table
  • Pixel Joined Table
  • Pixel Keywords Joined Table
  • Product Analytics Table (BETA)
  • Activities Table (BETA)
  • Ads Table
    • Using Ad Set Targeting Data
  • Affluencer Table (BETA)
  • Creatives Table (BETA)
  • CS Agg Metrics Table (BETA)
  • CS Messages Table
  • CS Tickets Table
  • Custom Spend Table
  • Customer Journey Table
  • Customers Table (BETA)
  • Email/SMS Settings Table
  • Email/SMS Table
  • GA4 Product Analytics Table (BETA)
  • GA4 Sessions Agg Table (BETA)
  • GA4 Web Analytics Table (BETA)
  • Keywords Table
  • Orders Table
  • Pixel Custom Conversions Table
  • Pixel Custom Events Table
  • Pixel Orders Table
  • Post-Purchase Survey Table
  • Products Table
  • Refunds Table
  • Reviews Table
  • Search Terms
  • Sessions Table
  • Shipping Table
  • Sonar Event Logs Table
  • Sonar Meta EMQ Table
  • Subscription Metrics Table
  • Subscription Monthly Metrics Table (BETA)
  • Subscriptions Table
  • Web Analytics Table

Triple Whale Metrics

  • Custom Metrics
    • Net Profit
    • Blended ROAS
    • MER
    • Net Margin
    • Blended Ad Spend
    • NCPA
    • NC ROAS
    • Return Rate (Returns %)
    • Blended CPA
    • POAS
    • BA ROAS
  • Store Metrics
    • Order Revenue
    • Orders
    • Total Refunds
    • Net Taxes
    • True Average Order Value
    • Average Order Value (AOV)
    • New Customers Percent
    • Gross Sales
    • Returning Customers Percent
    • Non-Zero Orders
    • New Customer Orders
    • Units Sold
    • New Customer Revenue
    • Returning Customer Revenue
    • Discounts
    • Total Sales
    • Sale Taxes
  • Ad Metrics
    • Facebook Ads Metrics
      • Facebook Ad Spend
      • Facebook ROAS
      • Facebook CPC
      • Facebook CPM
      • Facebook CV
      • Facebook CPOC
      • Facebook CTR
      • Facebook Revenue per Link Click
      • Facebook Conversions (Purchases)
      • Facebook CPA
    • Google Ads Metrics
      • Google Ad Spend
      • Google CV
      • Google ROAS
      • Google Conversions (Purchases)
      • Google CTR
      • Google CPA
      • Google CPM
      • Google Clicks
      • Google Impressions
      • Google All CV
      • Google All Conversions
    • TikTok Ads Metrics
      • TikTok Ad Spend
      • TikTok ROAS
      • TikTok Impressions
      • TikTok CPM
      • TikTok CPC
      • TikTok CTR
      • TikTok CPA
      • TikTok CV
      • TikTok Conversions (Purchases)
    • Microsoft Ads Metrics
      • Microsoft Ad Spend
      • Microsoft Conversions (Purchases)
      • Microsoft CV
      • Microsoft Clicks
      • Microsoft Impressions
      • Microsoft ROAS
      • Microsoft CTR
      • Microsoft CPA
      • Microsoft CPM
    • Amazon Ads Metrics
      • Amazon Ad Spend
      • Amazon ROAS
      • Amazon CPC
      • Amazon Clicks
      • Amazon Conversions (Purchases)
      • Amazon CV
    • Pinterest Ads Metrics
      • Pinterest Ad Spend
      • Pinterest ROAS
      • Pinterest CPC
      • Pinterest CPM
      • Pinterest CV
      • Pinterest Conversions (Purchases)
      • Pinterest Impressions
      • Pinterest CTR
    • Snapchat Ads Metrics
      • Snapchat Ad Spend
      • Snapchat ROAS
      • Snapchat Impressions
      • Snapchat Swipes
      • Snapchat CPM
      • Snapchat CPA
      • Snapchat CV
    • Twitter Ads Metrics
      • Twitter Ad Spend
      • Twitter ROAS
      • Twitter Impressions
      • Twitter CPM
      • Twitter CPA
      • Twitter CV
      • Twitter Conversions (Purchases)
      • Twitter Clicks
    • Outbrain Ads Metrics
      • Outbrain Ad Spend
      • Outbrain Impressions (Displays)
      • Outbrain Clicks
      • Outbrain CTR (vCTR)
      • Outbrain Conversions (Purchases)
      • Outbrain All Conversions
      • Outbrain CPA
      • Outbrain CPM (vCPM)
      • Outbrain CV
      • Outbrain ROAS
      • Outbrain AOV
    • Criteo Ads Metrics
      • Criteo Ad Spend
      • Criteo ROAS
      • Criteo Impressions (Displays)
      • Criteo Conversions (Purchases)
      • Criteo Visits
      • Criteo Clicks
      • Criteo AOV
      • Criteo CPA
      • Criteo CPV
      • Criteo CV
    • Taboola Ads Metrics
      • Taboola Ad Spend
      • Taboola Impressions (Displays)
      • Taboola Clicks
      • Taboola CTR (vCTR)
      • Taboola CPC
      • Taboola CPA
      • Taboola CPM (vCPM)
      • Taboola CV
      • Taboola ROAS
      • Taboola AOV
      • Taboola CPV
    • MNTN Ads Metrics
      • MNTN Ad Spend
      • MNTN ROAS
      • MNTN Impressions
      • MNTN Conversions (Purchases)
      • MNTN CV
      • MNTN AOV
      • MNTN CPA
      • MNTN CPV
    • LinkedIn Ads Metrics
      • LinkedIn Ad Spend
      • LinkedIn Impressions
      • LinkedIn Clicks
      • LinkedIn CTR (vCTR)
      • LinkedIn CPA
      • LinkedIn CPM (vCPM)
      • LinkedIn CV (Revenue on Conversions)
      • LinkedIn ROAS
      • LinkedIn AOV
    • AppLovin Ads Metrics
      • AppLovin Ad Spend
      • AppLovin Impressions
      • AppLovin Clicks
      • AppLovin CTR
      • AppLovin Conversions (Purchases)
      • AppLovin CPA
      • AppLovin CPM
      • AppLovin CV (Revenue on Conversions)
      • AppLovin ROAS
      • AppLovin AOV
  • Expense Metrics
    • Payment Gateway Costs
    • Cost of Goods Sold (COGS)
    • Handling Fees
    • Shipping Costs
    • Custom Spend (Custom Expenses)
  • Email/SMS Metrics
    • Klavyio Metrics
      • Klaviyo CV (Revenue)
      • Klaviyo Flows CV (Revenue)
      • Klaviyo Campaigns CV (Revenue)
      • Klaviyo Percent of Revenue
      • Klaviyo Flows Percent of Revenue
      • Klaviyo Campaigns Percent of Revenue
      • Klaviyo Unsubscribed
      • Klaviyo Subscribed
      • Klaviyo Net New Subscribers
    • Yotpo Metrics
      • Yotpo Spend
      • Yotpo CV (Revenue)
      • Yotpo Conversions (Purchases)
      • Yotpo Sent Messages
      • Yotpo Unsubscribed
      • Yotpo Clicks
      • Yotpo Delivered Messages
  • Web Analytics Metrics
    • Conversion Rate (CR)
    • Sessions
    • New Users (New Visitors)
    • Add to Carts
  • Customer Support Metrics
    • Gorgias Metrics
      • Gorgias Tickets Created
      • Gorgias Tickets Replied
  • Pixel Metrics
    • Pixel Conversion Rate
  • LTV Metrics
    • Lifetime Value (LTV)

Using Triple Whale Data

  • Overview of Data in Triple Whale
    • Moving from BigQuery to ClickHouse syntax in the SQL Editor
    • Mapping BigCommerce Fields to Triple Whale
  • SQL Example Library
    • Customer & Order Insights
      • SQL Example: Lifetime Value by Day Range (60, 90, 180, 365)
      • SQL Example: Monthly Repeat Purchase Rate (Returning Customers / Total Customers)
      • SQL Example: Top 200 Customers by Total Order Revenue
      • SQL Example: Single vs. Multi-Item Orders
    • Product Purchase Patterns
      • SQL Example: Top First Purchased Products (Count, AOV, LTV…)
      • SQL Example: Most Common Next Product Bought (Sequential Product Purchases)
    • Ad & Creative Performance
      • SQL Example: Weekly Performance Metrics (ROAS, CTR, CVR…)
      • SQL Example: Group Campaigns by Keyword (Top Match Terms)
      • SQL Example: Monthly Pixel ROAS for Selected Channels (Bing, Facebook, Google)
    • Traffic & Funnel Performance
    • Time-Based Revenue Comparisons
      • SQL Example: Hourly Revenue Indexed by Day
  • Data Troubleshooting Guides
    • Why Does My Total Revenue Across Channels Look Higher Than My Store Revenue?
    • Why Does My Total Sales in Shopify Not Match My Total Sales in Triple Whale?
    • Why Are My Amazon Product Sales in Triple Whale Different From Amazon’s Official Dashboard?
    • Why Is My New vs. Returning Customer Count Different in Triple Whale vs. Shopify?
    • Why Is My Klaviyo (or Email/SMS) Revenue in Triple Whale Different from the Klaviyo Dashboard?
    • Why Do TikTok Shop Purchases Show a Different Number in the Pixel Report (Pixel > All) Compared to the Ads Breakdown (Pixel > Ads > TikTok)?
    • Why Does Triple Whale Show a Lower Fairing/Kno Post-Purchase Survey Response Rate Than Fairing/Kno’s Own Dashboard?
    • Why Do Shopify Sessions Not Match Triple Whale Web Analytics?
    • Why Does My Conversion Rate Not Match Between Triple Whale and Shopify?
    • Why Does the Inventory Metric on the Summary Page Not Match Shopify Inventory Reports?
    • Why Does Brand Search Lose Credit in Total Impact (TI), or Why Might Another Channel Get More Credit Than Expected?
    • Why Am I Seeing Negative Profit for a Channel in Total Impact?
    • Why Do My Campaigns Have Spend but No Sessions?
    • Why Are Some Orders Missing or Marked as “Excluded” in the Pixel?
    • Why Is My Ad Spend on the Summary Page Different From the Pixel Report or Blended Stats?
    • Why Do Conversions in Web Analytics Not Match the Pixel Report?
    • Why Is My COGS in Triple Whale Different From My Shopify COGS?
    • Why Does My Lifetime Value (LTV) Metric Keep Changing Over Time?
    • Why Is My NCPA on the Summary Page Different From the NCPA in the Cohort Page?
    • Why Do the PPS ‘Views’ in the Retention Tab Not Match the Actual Number of Post-Purchase Survey Responses?
    • Why Are My Meta (Facebook) Organic Sessions Inflated Compared to Triple Whale Sessions?
    • Why Is My Triple Whale Web Analytics Pageview Count Lower Than My Google Analytics Pageview Count?
    • Why Are My TikTok or Meta/Facebook Purchases Falling Under 'Not Set' or Non-Attributed in the Attribution Page?
Powered by 

Traffic & Funnel Performance

Updated 2 days ago


SQL Example: Monthly Pixel ROAS for Selected Channels (Bing, Facebook, Google)
Time-Based Revenue Comparisons