Jump to Content

Home Data Dictionary API Reference

Data Dictionary

Home Data Dictionary API Reference

All

Pages

Start typing to search…

Triple Whale Data Schema

How Data Works in Triple Whale
Triple Whale Data Ontology (Conceptual Data Model)
- Table Classification by Business Object
Table Schemas

Triple Whale Metrics

Custom Metrics
Store Metrics
Amazon Sales Metrics
Ad Metrics
Email/SMS Metrics
- Klaviyo Metrics
Web Analytics Metrics
Subscription Metrics
Shipping Metrics
- Shipstation Metrics
  - Shipstation Shipping Costs
  - Shipstation Shipments
Customer Support Metrics
- Gorgias Metrics
  - Gorgias Tickets Created
  - Gorgias Tickets Replied
LTV Metrics
- Lifetime Value (LTV)
- Unique Customers
Expense Metrics

Using Triple Whale Data

SQL Example Library
Data Troubleshooting Guides
Moving from BigQuery to ClickHouse syntax in the SQL Editor
Mapping BigCommerce Fields to Triple Whale

Powered by

SQL Example: Weekly Performance Metrics (ROAS, CTR, CVR…)

Updated 7 months ago

SQL Example: Group Campaigns by Keyword (Top Match Terms)

SQL Example: Monthly Pixel ROAS for Selected Channels (Bing, Facebook, Google)