For AI agents: the docs index is at https://triplewhale.readme.io/llms.txt. Append .md to any documentation page URL to get its markdown version.
Jump to Content
Home
Data Dictionary
Developers
Data Dictionary
Jump to Content
Home
Data Dictionary
Developers
Store Metrics
Triple Whale Ontology
Triple Whale Data Ontology (Conceptual Data Model)
Table Classification by Business Object
Including Marketplace Data in Blended Metrics
Table Schemas
How Data Works in Triple Whale
Summary Metrics Table
Customer Segmentation Analytics Table
Pixel Joined Table
Pixel Keywords Joined Table
Product Analytics Table
Activities Table
Ads Table
Using Ad Set Targeting Data
Ads – Standardized `channel` IDs
Ads Experiments Geolift Table (BETA)
Affiliates Table
Affluencer Hub Table
AI Visibility Table
Creatives Table
Customer Support Agg Metrics Table (BETA)
CS Events Table
CS Messages Table
CS Tickets Table
Custom Categories Table
Custom Category Mappings Table
Custom Spend Table
Customer Journey Table
Customer Segmentation Table
Customers Table
Email/SMS Settings Table
Email/SMS Table
External Revenue Table
GA4 Product Analytics Table
GA4 Sessions Agg Table
GA4 Web Analytics Table
ID Graph Table
Keywords Table
Orders Table
Is New Customer
Pixel Custom Conversions Table
Pixel Custom Events Table
Pixel Orders Table
Post-Purchase Survey Table
Post-Purchase Survey (PPS) – Standardized Source IDs
Products Table
Refunds Table
Reviews Table
Search Terms Table
Sessions Table
Shipping Table
Social Media Brand Mentions Table
Social Media Comments Table
Social Media Pages Table
Social Media Posts Table
Subscription Metrics Table
Subscriptions Table
Web Analytics Table
Using Triple Whale Data
SQL Example Library
SQL Example Library Overview and Best Practices
Customer and Order Insights (orders_table)
SQL Example: Top 200 Customers by Total Order Revenue
SQL Example: Single vs. Multi-Item Orders
SQL Example: Purchase Frequency Distribution (Orders per Customer)
SQL Example: Retention & Churn Signals (Time Between Last Two Orders)
SQL Example: Revenue Split (First vs. Second Half of Date Range)
SQL Example: Hourly Revenue Indexed by Day
SQL Example: Lifetime Value by Day Range (60, 90, 180, 365)
Product Purchase Patterns (orders_table + products_info)
SQL Example: Top First Purchased Products (Count, AOV, LTV…)
SQL Example: Most Common Next Product Bought (Sequential Product Purchases)
SQL Example: Most Common Second Product Bought
Ad & Funnel Performance (ads_table, pixel_joined_tvf, web_analytics_table)
SQL Example: Group Campaigns by Keyword (Top Match Terms)
SQL Example: Weekly Performance Metrics (ROAS, CTR, CVR…)
SQL Example: Monthly Pixel ROAS for Selected Channels (Bing, Facebook, Google)
SQL Example: Website Performance by Device and Country
SQL Example: Multi-Touch Landing Page Paths (Conversion & Bounce Metrics)
Data Troubleshooting Guides
Why Does My Total Revenue Across Channels Look Higher Than My Store Revenue?
Why Do My Order-Based Sales Metrics Not Match Between Shopify and 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 Are My Orders and Revenue on the Summary Page Different From the Pixel Page?
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?
Why Does My New Customer Count in LTV Cohorts Not Match Shopify?
Why Do Pixel Unique Metrics Look Higher at the Channel, Campaign, or Ad Set Level Than at the Ads Level?
Moving from BigQuery to ClickHouse syntax in the SQL Editor
Mapping Shopify Fields to Triple Whale
Mapping BigCommerce Fields to Triple Whale
Powered by
Store Metrics
Copy Page