# Triple Whale Documentation > Documentation for Triple Whale ## Data Dictionary: Triple Whale Ontology - [Triple Whale Data Ontology (Conceptual Data Model)](https://triplewhale.readme.io/docs/triple-whale-data-ontology.md) - [Table Classification by Business Object](https://triplewhale.readme.io/docs/table-classification-by-business-object.md) - [Including Marketplace Data in Blended Metrics](https://triplewhale.readme.io/docs/including-marketplace-data-in-blended-metrics.md) ## Data Dictionary: Table Schemas - [How Data Works in Triple Whale](https://triplewhale.readme.io/docs/how-data-works-in-triple-whale.md) - [Summary Metrics Table](https://triplewhale.readme.io/docs/summary-metrics-table.md): summary_metrics_tvf - [Customer Segmentation Analytics Table](https://triplewhale.readme.io/docs/customer-segmentation-analytics-table.md): customer_segmentation_analytics_tvf - [Pixel Joined Table](https://triplewhale.readme.io/docs/pixel-joined-table.md): pixel_joined_tvf - [Pixel Keywords Joined Table](https://triplewhale.readme.io/docs/pixel-keywords-joined-table.md): pixel_keywords_joined_tvf - [Product Analytics Table](https://triplewhale.readme.io/docs/product-analytics-table.md): product_analytics_tvf - [Activities Table](https://triplewhale.readme.io/docs/activities-table.md): activities_table - [Ads Table](https://triplewhale.readme.io/docs/ads-table.md): ads_table - [Using Ad Set Targeting Data](https://triplewhale.readme.io/docs/using-adset-targeting-data.md) - [Ads – Standardized `channel` IDs](https://triplewhale.readme.io/docs/ads-standardized-channel-ids.md) - [Ads Experiments Geolift Table (BETA)](https://triplewhale.readme.io/docs/ads-experiments-geolift-table.md): ads_experiments_geolift_table - [Affiliates Table](https://triplewhale.readme.io/docs/affiliates-table.md) - [Affluencer Hub Table](https://triplewhale.readme.io/docs/affluencer-hub-table.md): affluencer_hub_table - [AI Visibility Table](https://triplewhale.readme.io/docs/ai-visibility-table.md): ai_visibility_table - [Creatives Table](https://triplewhale.readme.io/docs/creatives-table.md): creatives_table - [Customer Support Agg Metrics Table (BETA)](https://triplewhale.readme.io/docs/customer-support-agg-metrics-table.md): cs_agg_metrics_table - [CS Events Table](https://triplewhale.readme.io/docs/cs-events-table.md): cs_events_table - [CS Messages Table](https://triplewhale.readme.io/docs/cs-messages-table.md): cs_messages_table - [CS Tickets Table](https://triplewhale.readme.io/docs/cs-tickets-table.md): cs_tickets_table - [Custom Categories Table](https://triplewhale.readme.io/docs/custom-categories-table.md): custom_categories_table - [Custom Category Mappings Table](https://triplewhale.readme.io/docs/custom-category-mappings-table.md): custom_category_mappings_table - [Custom Spend Table](https://triplewhale.readme.io/docs/custom-spend-table.md): custom_spend_table - [Customer Journey Table](https://triplewhale.readme.io/docs/customer-journey-table.md): customer_journey_table - [Customer Segmentation Table](https://triplewhale.readme.io/docs/customer-segmentation-table.md): customer_segmentation_table - [Customers Table](https://triplewhale.readme.io/docs/customers-table.md): customers_table - [Email/SMS Settings Table](https://triplewhale.readme.io/docs/emailsms-settings-table.md): email_sms_settings_table - [Email/SMS Table](https://triplewhale.readme.io/docs/emailsms-table.md): email_sms_table - [External Revenue Table](https://triplewhale.readme.io/docs/external-revenue-table.md): external_revenue_table - [GA4 Product Analytics Table](https://triplewhale.readme.io/docs/ga4-product-analytics-table.md): ga4_product_analytics_table - [GA4 Sessions Agg Table](https://triplewhale.readme.io/docs/ga4-sessions-agg-table.md): ga4_sessions_agg_table - [GA4 Web Analytics Table](https://triplewhale.readme.io/docs/ga4-web-analytics-table.md): ga4_web_analytics_table - [ID Graph Table](https://triplewhale.readme.io/docs/id-graph-table.md): id_graph_table - [Keywords Table](https://triplewhale.readme.io/docs/keywords-table.md): keywords_table - [Orders Table](https://triplewhale.readme.io/docs/orders-table.md): orders_table - [Pixel Custom Conversions Table](https://triplewhale.readme.io/docs/pixel-custom-conversions-table.md): pixel_custom_conversions_table - [Pixel Custom Events Table](https://triplewhale.readme.io/docs/pixel-custom-events-table.md): pixel_custom_events_table - [Pixel Orders Table](https://triplewhale.readme.io/docs/pixel-orders-table.md): pixel_orders_table - [Post-Purchase Survey Table](https://triplewhale.readme.io/docs/post-purchase-survey-table.md): post_purchase_survey_table - [Post-Purchase Survey (PPS) – Standardized Source IDs](https://triplewhale.readme.io/docs/post-purchase-survey-pps-standardized-source-ids.md) - [Products Table](https://triplewhale.readme.io/docs/products-table.md): products_table - [Refunds Table](https://triplewhale.readme.io/docs/refunds-table.md): refunds_table - [Reviews Table](https://triplewhale.readme.io/docs/reviews-table.md): reviews_table - [Search Terms Table](https://triplewhale.readme.io/docs/search-terms-table.md): search_terms_table - [Sessions Table](https://triplewhale.readme.io/docs/sessions-table.md): sessions_table - [Shipping Table](https://triplewhale.readme.io/docs/shipping-table.md): shipping_table - [Social Media Brand Mentions Table](https://triplewhale.readme.io/docs/social-media-brand-mentions-table.md): social_media_brand_mentions_table - [Social Media Comments Table](https://triplewhale.readme.io/docs/social-media-comments-table.md): social_media_comments_table - [Social Media Pages Table](https://triplewhale.readme.io/docs/social-media-pages-table.md): social_media_pages_table - [Social Media Posts Table](https://triplewhale.readme.io/docs/social-media-posts-table.md): social_media_posts_table - [Subscription Metrics Table](https://triplewhale.readme.io/docs/subscription-metrics-table.md): subscription_metrics_table - [Subscriptions Table](https://triplewhale.readme.io/docs/subscriptions-table.md): subscriptions_table - [Web Analytics Table](https://triplewhale.readme.io/docs/web-analytics-table.md): web_analytics_table ## Data Dictionary: Triple Whale Metrics - Custom Metrics - [Net Profit](https://triplewhale.readme.io/docs/net-profit.md): net_profit - [Blended ROAS](https://triplewhale.readme.io/docs/blended-roas.md): roas - [MER](https://triplewhale.readme.io/docs/mer.md): mer - [Net Margin](https://triplewhale.readme.io/docs/net-margin.md): net_margin - [Blended Ad Spend](https://triplewhale.readme.io/docs/blended-ad-spend.md): spend - [NCPA](https://triplewhale.readme.io/docs/ncpa.md): ncpa - [NC ROAS](https://triplewhale.readme.io/docs/nc-roas.md): new_customer_roas - [Return Rate](https://triplewhale.readme.io/docs/return-rate.md): returns_percent - [Blended CPA](https://triplewhale.readme.io/docs/blended-cpa.md): blended_cpa - [POAS](https://triplewhale.readme.io/docs/poas.md): poas - [BA ROAS](https://triplewhale.readme.io/docs/ba-roas.md): ba_roas - Store Metrics - [Order Revenue](https://triplewhale.readme.io/docs/order-revenue.md): order_revenue - [Orders](https://triplewhale.readme.io/docs/orders.md): orders - [Refunded Sales (Returns)](https://triplewhale.readme.io/docs/refunded-sales-returns.md): total_refunded_price - [Net Taxes](https://triplewhale.readme.io/docs/net-taxes.md) - [True Average Order Value](https://triplewhale.readme.io/docs/true-average-order-value-true-aov.md): true_aov - [Average Order Value (AOV)](https://triplewhale.readme.io/docs/average-order-value-aov.md): aov - [New Customers %](https://triplewhale.readme.io/docs/new-customers-percent.md): new_customers_percent - [Gross Sales](https://triplewhale.readme.io/docs/gross-sales.md): gross_product_sales - [Returning Customers %](https://triplewhale.readme.io/docs/returning-customers-percent.md): returning_customers_percent - [Non-Zero Orders](https://triplewhale.readme.io/docs/non-zero-orders.md): orders_with_amount - [New Customer Orders](https://triplewhale.readme.io/docs/new-customer-orders.md): new_customer_orders - [Units Sold](https://triplewhale.readme.io/docs/units-sold.md): product_quantity_sold_in_order - [New Customer Revenue](https://triplewhale.readme.io/docs/new-customer-revenue.md): new_customer_revenue - [Returning Customer Revenue](https://triplewhale.readme.io/docs/returning-customer-revenue.md): returning_customer_revenue - [Discounts](https://triplewhale.readme.io/docs/discounts.md): discount_amount - [Total Sales](https://triplewhale.readme.io/docs/total-sales.md): total_sales - [Sale Taxes](https://triplewhale.readme.io/docs/sale-taxes.md): taxes - [Is New Customer](https://triplewhale.readme.io/docs/is-new-customer.md): is_new_customer - Amazon Sales Metrics - [Amazon Product Sales](https://triplewhale.readme.io/docs/amazon-product-sales.md): gross_product_sales - [Amazon Orders](https://triplewhale.readme.io/docs/amazon-orders.md): orders - [Amazon Taxes](https://triplewhale.readme.io/docs/amazon-taxes.md): taxes - [Amazon Items Sold](https://triplewhale.readme.io/docs/amazon-items-sold.md): product_quantity_sold_in_order - [Amazon Estimated Fees](https://triplewhale.readme.io/docs/amazon-estimated-fees.md): amazon_estimated_fees - [Amazon Sales (Order Revenue)](https://triplewhale.readme.io/docs/amazon-sales-order-revenue.md): order_revenue - [Amazon Cost of Goods Sold (COGS)](https://triplewhale.readme.io/docs/amazon-cost-of-goods-sold-cogs.md): cost_of_goods - [Amazon Handling Fees](https://triplewhale.readme.io/docs/amazon-handling-fees.md): handling_fees - Ad Metrics - Facebook Ads Metrics - [Facebook Ad Spend](https://triplewhale.readme.io/docs/facebook-ad-spend.md): spend - [Facebook ROAS](https://triplewhale.readme.io/docs/facebook-roas.md): roas - [Facebook CPC](https://triplewhale.readme.io/docs/facebook-cpc.md): cpc - [Facebook CPM](https://triplewhale.readme.io/docs/facebook-cpm.md): cpm - [Facebook CV](https://triplewhale.readme.io/docs/facebook-cv.md): conversion_value - [Facebook CPOC](https://triplewhale.readme.io/docs/facebook-cpoc.md): cpoc - [Facebook CTR](https://triplewhale.readme.io/docs/facebook-ctr.md): ctr - [Facebook Revenue Per Link Click](https://triplewhale.readme.io/docs/facebook-revenue-per-link-click.md): revenue_per_link_click - [Facebook Conversions (Purchases)](https://triplewhale.readme.io/docs/facebook-conversions-purchases.md): conversions - [Facebook CPA](https://triplewhale.readme.io/docs/facebook-cpa.md): cpa - Google Ads Metrics - [Google Ad Spend](https://triplewhale.readme.io/docs/google-ad-spend.md): spend - [Google CV](https://triplewhale.readme.io/docs/google-cv.md): conversion_value - [Google ROAS](https://triplewhale.readme.io/docs/google-roas.md): roas - [Google Conversions (Purchases)](https://triplewhale.readme.io/docs/google-conversions-purchases.md): conversions - [Google CTR](https://triplewhale.readme.io/docs/google-ctr.md): ctr - [Google CPA](https://triplewhale.readme.io/docs/google-cpa.md): cpa - [Google CPM](https://triplewhale.readme.io/docs/google-cpm.md): cpm - [Google Clicks](https://triplewhale.readme.io/docs/google-clicks.md): clicks - [Google Impressions](https://triplewhale.readme.io/docs/google-impressions.md): impressions - [Google All CV](https://triplewhale.readme.io/docs/google-all-cv.md): all_conversion_value - [Google All Conversions](https://triplewhale.readme.io/docs/google-all-conversions.md): all_conversions - TikTok Ads Metrics - [TikTok Ad Spend](https://triplewhale.readme.io/docs/tiktok-ad-spend.md): spend - [TikTok ROAS](https://triplewhale.readme.io/docs/tiktok-roas.md): roas - [TikTok Impressions](https://triplewhale.readme.io/docs/tiktok-impressions.md): impressions - [TikTok CPM](https://triplewhale.readme.io/docs/tiktok-cpm.md): cpm - [TikTok CPC](https://triplewhale.readme.io/docs/tiktok-cpc.md): cpc - [TikTok CTR](https://triplewhale.readme.io/docs/tiktok-ctr.md): ctr - [TikTok CPA](https://triplewhale.readme.io/docs/tiktok-cpa.md): cpa - [TikTok CV](https://triplewhale.readme.io/docs/tiktok-cv.md): conversion_value - [TikTok Conversions (Purchases)](https://triplewhale.readme.io/docs/tiktok-conversions-purchases.md): conversions - Microsoft Ads Metrics - [Microsoft Ad Spend](https://triplewhale.readme.io/docs/microsoft-ad-spend.md): spend - [Microsoft Conversions (Purchases)](https://triplewhale.readme.io/docs/microsoft-conversions-purchases.md): conversions - [Microsoft CV](https://triplewhale.readme.io/docs/microsoft-cv.md): conversion_value - [Microsoft Clicks](https://triplewhale.readme.io/docs/microsoft-clicks.md): clicks - [Microsoft Impressions](https://triplewhale.readme.io/docs/microsoft-impressions.md): impressions - [Microsoft ROAS](https://triplewhale.readme.io/docs/microsoft-roas.md): roas - [Microsoft CTR](https://triplewhale.readme.io/docs/microsoft-ctr.md): ctr - [Microsoft CPA](https://triplewhale.readme.io/docs/microsoft-cpa.md): cpa - [Microsoft CPM](https://triplewhale.readme.io/docs/microsoft-cpm.md): cpm - Amazon Ads Metrics - [Amazon Ad Spend](https://triplewhale.readme.io/docs/amazon-ad-spend.md): spend - [Amazon ROAS](https://triplewhale.readme.io/docs/amazon-roas.md): roas - [Amazon CPC](https://triplewhale.readme.io/docs/amazon-cpc.md): cpc - [Amazon Clicks](https://triplewhale.readme.io/docs/amazon-clicks.md): clicks - [Amazon Conversions (Purchases)](https://triplewhale.readme.io/docs/amazon-conversions-purchases.md): conversions - [Amazon CV](https://triplewhale.readme.io/docs/amazon-cv.md): conversion_value - Pinterest Ads Metrics - [Pinterest Ad Spend](https://triplewhale.readme.io/docs/pinterest-ad-spend.md): spend - [Pinterest ROAS](https://triplewhale.readme.io/docs/pinterest-roas.md): roas - [Pinterest CPC](https://triplewhale.readme.io/docs/pinterest-cpc.md): cpc - [Pinterest CPM](https://triplewhale.readme.io/docs/pinterest-cpm.md): cpm - [Pinterest CV](https://triplewhale.readme.io/docs/pinterest-cv.md): conversion_value - [Pinterest Conversions (Purchases)](https://triplewhale.readme.io/docs/pinterest-conversions-purchases.md): conversions - [Pinterest Impressions](https://triplewhale.readme.io/docs/pinterest-impressions.md): impressions - [Pinterest CTR](https://triplewhale.readme.io/docs/pinterest-ctr.md): ctr - Snapchat Ads Metrics - [Snapchat Ad Spend](https://triplewhale.readme.io/docs/snapchat-ad-spend.md): spend - [Snapchat ROAS](https://triplewhale.readme.io/docs/snapchat-roas.md): roas - [Snapchat Impressions](https://triplewhale.readme.io/docs/snapchat-impressions.md): impressions - [Snapchat Swipes](https://triplewhale.readme.io/docs/snapchat-swipes.md): clicks - [Snapchat CPM](https://triplewhale.readme.io/docs/snapchat-cpm.md): cpm - [Snapchat CPA](https://triplewhale.readme.io/docs/snapchat-cpa.md): cpa - [Snapchat CV](https://triplewhale.readme.io/docs/snapchat-cv.md): conversion_value - Twitter Ads Metrics - [Twitter Ad Spend](https://triplewhale.readme.io/docs/twitter-ad-spend.md): spend - [Twitter ROAS](https://triplewhale.readme.io/docs/twitter-roas.md): roas - [Twitter Impressions](https://triplewhale.readme.io/docs/twitter-impressions.md): impressions - [Twitter CPM](https://triplewhale.readme.io/docs/twitter-cpm.md): cpm - [Twitter CPA](https://triplewhale.readme.io/docs/twitter-cpa.md): cpa - [Twitter CV](https://triplewhale.readme.io/docs/twitter-cv.md): conversion_value - [Twitter Conversions (Purchases)](https://triplewhale.readme.io/docs/twitter-conversions-purchases.md): conversions - [Twitter Clicks](https://triplewhale.readme.io/docs/twitter-clicks.md): clicks - Outbrain Ads Metrics - [Outbrain Ad Spend](https://triplewhale.readme.io/docs/outbrain-ad-spend.md): spend - [Outbrain Impressions (Displays)](https://triplewhale.readme.io/docs/outbrain-impressions-displays.md): impressions - [Outbrain Clicks](https://triplewhale.readme.io/docs/outbrain-clicks.md): clicks - [Outbrain CTR (vCTR)](https://triplewhale.readme.io/docs/outbrain-ctr-vctr.md): ctr - [Outbrain Conversions (Purchases)](https://triplewhale.readme.io/docs/outbrain-conversions-purchases.md): conversions - [Outbrain All Conversions](https://triplewhale.readme.io/docs/outbrain-all-conversions.md): all_conversions - [Outbrain CPA](https://triplewhale.readme.io/docs/outbrain-cpa.md): cpa - [Outbrain CPM (vCPM)](https://triplewhale.readme.io/docs/outbrain-cpm-vcpm.md): cpm - [Outbrain CV](https://triplewhale.readme.io/docs/outbrain-cv.md): conversion_value - [Outbrain ROAS](https://triplewhale.readme.io/docs/outbrain-roas.md): roas - [Outbrain AOV](https://triplewhale.readme.io/docs/outbrain-aov.md): aov - Criteo Ads Metrics - [Criteo Ad Spend](https://triplewhale.readme.io/docs/criteo-ad-spend.md): spend - [Criteo ROAS](https://triplewhale.readme.io/docs/criteo-roas.md): roas - [Criteo Impressions (Displays)](https://triplewhale.readme.io/docs/criteo-impressions-displays.md): impressions - [Criteo Conversions (Purchases)](https://triplewhale.readme.io/docs/criteo-conversions-purchases.md): conversions - [Criteo Visits](https://triplewhale.readme.io/docs/criteo-visits.md): visits - [Criteo Clicks](https://triplewhale.readme.io/docs/criteo-clicks.md): clicks - [Criteo AOV](https://triplewhale.readme.io/docs/criteo-aov.md): aov - [Criteo CPA](https://triplewhale.readme.io/docs/criteo-cpa.md): cpa - [Criteo CPV](https://triplewhale.readme.io/docs/criteo-cpv.md) - [Criteo CV](https://triplewhale.readme.io/docs/criteo-cv.md): conversion_value - Taboola Ads Metrics - [Taboola Ad Spend](https://triplewhale.readme.io/docs/taboola-ad-spend.md): spend - [Taboola Impressions (Displays)](https://triplewhale.readme.io/docs/taboola-impressions-displays.md): impressions - [Taboola Clicks](https://triplewhale.readme.io/docs/taboola-clicks.md): clicks - [Taboola CTR (vCTR)](https://triplewhale.readme.io/docs/taboola-ctr-vctr.md): ctr - [Taboola CPC](https://triplewhale.readme.io/docs/taboola-cpc.md): cpc - [Taboola CPA](https://triplewhale.readme.io/docs/taboola-cpa.md): cpa - [Taboola CPM (vCPM)](https://triplewhale.readme.io/docs/taboola-cpm-vcpm.md): cpm - [Taboola CV](https://triplewhale.readme.io/docs/taboola-cv.md): conversion_value - [Taboola ROAS](https://triplewhale.readme.io/docs/taboola-roas.md): roas - [Taboola AOV](https://triplewhale.readme.io/docs/taboola-aov.md): aov - [Taboola CPV](https://triplewhale.readme.io/docs/taboola-cpv.md) - MNTN Ads Metrics - [MNTN Ad Spend](https://triplewhale.readme.io/docs/mntn-ad-spend.md): spend - [MNTN ROAS](https://triplewhale.readme.io/docs/mntn-roas.md): roas - [MNTN Impressions](https://triplewhale.readme.io/docs/mntn-impressions.md): impressions - [MNTN Conversions (Purchases)](https://triplewhale.readme.io/docs/mntn-conversions-purchases.md): conversions - [MNTN CV](https://triplewhale.readme.io/docs/mntn-cv.md): conversion_value - [MNTN AOV](https://triplewhale.readme.io/docs/mntn-aov.md): aov - [MNTN CPA](https://triplewhale.readme.io/docs/mntn-cpa.md): cpa - [MNTN CPV](https://triplewhale.readme.io/docs/mntn-cpv.md) - LinkedIn Ads Metrics - [LinkedIn Ad Spend](https://triplewhale.readme.io/docs/linkedin-ad-spend.md): spend - [LinkedIn Impressions](https://triplewhale.readme.io/docs/linkedin-impressions.md): impressions - [LinkedIn Clicks](https://triplewhale.readme.io/docs/linkedin-clicks.md): clicks - [LinkedIn CTR (vCTR)](https://triplewhale.readme.io/docs/linkedin-ctr-vctr.md): ctr - [LinkedIn CPA](https://triplewhale.readme.io/docs/linkedin-cpa.md): cpa - [LinkedIn CPM (vCPM)](https://triplewhale.readme.io/docs/linkedin-cpm-vcpm.md): cpm - [LinkedIn CV (Revenue on Conversions)](https://triplewhale.readme.io/docs/linkedin-cv-revenue-on-conversions.md): conversion_value - [LinkedIn ROAS](https://triplewhale.readme.io/docs/linkedin-roas.md): roas - [LinkedIn AOV](https://triplewhale.readme.io/docs/linkedin-aov.md): aov - Axon by Applovin Ads Metrics - [Axon by Applovin Ad Spend](https://triplewhale.readme.io/docs/applovin-ad-spend.md): spend - [Axon by Applovin Impressions](https://triplewhale.readme.io/docs/applovin-impressions.md): impressions - [Axon by Applovin Clicks](https://triplewhale.readme.io/docs/applovin-clicks.md): clicks - [Axon by Applovin CTR](https://triplewhale.readme.io/docs/applovin-ctr.md): ctr - [Axon by Applovin Conversions (Purchases)](https://triplewhale.readme.io/docs/applovin-conversions-purchases.md): conversions - [Axon by Applovin CPA](https://triplewhale.readme.io/docs/applovin-cpa.md): cpa - [Axon by Applovin CPM](https://triplewhale.readme.io/docs/applovin-cpm.md): cpm - [Axon by Applovin CV (Revenue on Conversions)](https://triplewhale.readme.io/docs/applovin-cv-revenue-on-conversions.md): conversion_value - [Axon by Applovin ROAS ](https://triplewhale.readme.io/docs/applovin-roas.md): roas - [Axon by Applovin AOV ](https://triplewhale.readme.io/docs/applovin-aov.md): aov - Email/SMS Metrics - Klaviyo Metrics - [Klaviyo CV (Revenue)](https://triplewhale.readme.io/docs/klaviyo-order-revenue.md): conversion_value - [Klaviyo Flows CV (Revenue)](https://triplewhale.readme.io/docs/klaviyo-flows-cv-revenue.md): conversion_value - [Klaviyo Campaigns CV (Revenue)](https://triplewhale.readme.io/docs/klaviyo-campaigns-cv-revenue.md): conversion_value - [Klaviyo Percent of Revenue](https://triplewhale.readme.io/docs/klaviyo-sales-percentage.md) - [Klaviyo Flows Percent of Revenue](https://triplewhale.readme.io/docs/klaviyo-flows-percent-of-revenue.md) - [Klaviyo Campaigns Percent of Revenue](https://triplewhale.readme.io/docs/klaviyo-campaigns-percent-of-revenue.md) - [Klaviyo Unsubscribed](https://triplewhale.readme.io/docs/klaviyo-unsubscribed.md): unsubscribed - [Klaviyo Subscribed](https://triplewhale.readme.io/docs/klaviyo-subscribed.md): subscribed_to_list - [Klaviyo Net New Subscribers](https://triplewhale.readme.io/docs/klaviyo-net-new-subscribers.md) - Web Analytics Metrics - [Conversion Rate (CR)](https://triplewhale.readme.io/docs/conversion-rate-cr.md): conversion_rate - [Sessions](https://triplewhale.readme.io/docs/sessions.md): sessions - [New Users (New Visitors)](https://triplewhale.readme.io/docs/new-users-new-visitors.md): new_users - [Add to Cart Sessions](https://triplewhale.readme.io/docs/add-to-carts.md): add_to_carts - Subscription Metrics - [First Order Revenue](https://triplewhale.readme.io/docs/first-order-revenue.md): total_revenue_first_order - [Recurring Order Revenue](https://triplewhale.readme.io/docs/recurring-order-revenue.md): total_revenue_recurring - [Subscription Order Revenue](https://triplewhale.readme.io/docs/subscription-order-revenue.md): total_revenue - [Reactivated Subscribers](https://triplewhale.readme.io/docs/reactivated-subscribers.md): reactivated_subscribers - [New Subscriptions](https://triplewhale.readme.io/docs/new-subscriptions.md): total_new_subscriptions - [Cancelled Subscriptions](https://triplewhale.readme.io/docs/cancelled-subscriptions.md): total_cancelled_subscriptions - [Churned Subscribers](https://triplewhale.readme.io/docs/churned-subscribers.md): total_churned_subscribers - [Active Subscriptions](https://triplewhale.readme.io/docs/active-subscriptions.md): active_subscriptions - [Active Subscribers](https://triplewhale.readme.io/docs/active-subscribers.md): active_subscribers - Shipping Metrics - Shipstation Metrics - [Shipstation Shipping Costs](https://triplewhale.readme.io/docs/shipstation-shipping-costs.md): shop_shipment_cost - [Shipstation Shipments](https://triplewhale.readme.io/docs/shipstation-shipments.md) - Customer Support Metrics - Gorgias Metrics - [Gorgias Tickets Created](https://triplewhale.readme.io/docs/gorgias-tickets-created.md) - [Gorgias Tickets Replied](https://triplewhale.readme.io/docs/gorgias-tickets-replied.md) - LTV Metrics - [Lifetime Value (LTV)](https://triplewhale.readme.io/docs/lifetime-value-ltv.md): ltv - [Unique Customers](https://triplewhale.readme.io/docs/unique-customers.md): customer_id - Expense Metrics - [Payment Gateway Costs](https://triplewhale.readme.io/docs/payment-gateway-costs.md): payment_gateway_costs - [Cost of Goods Sold (COGS)](https://triplewhale.readme.io/docs/cost-of-goods-sold-cogs.md): cost_of_goods - [Handling Fees](https://triplewhale.readme.io/docs/handling-fees.md): handling_fees - [Shipping Costs](https://triplewhale.readme.io/docs/shipping-costs.md): shipping_costs - [Custom Spend (Custom Expenses)](https://triplewhale.readme.io/docs/custom-spend-custom-expenses.md): amount ## Data Dictionary: Using Triple Whale Data - SQL Example Library - [SQL Example Library Overview and Best Practices](https://triplewhale.readme.io/docs/sql-example-library-overview-and-best-practices.md) - Customer and Order Insights (orders_table) - [SQL Example: Top 200 Customers by Total Order Revenue](https://triplewhale.readme.io/docs/sql-example-top-200-customers-by-total-order-revenue.md) - [SQL Example: Single vs. Multi-Item Orders](https://triplewhale.readme.io/docs/sql-example-single-vs-multi-item-orders.md) - [SQL Example: Purchase Frequency Distribution (Orders per Customer)](https://triplewhale.readme.io/docs/sql-example-purchase-frequency-distribution-orders-per-customer.md) - [SQL Example: Retention & Churn Signals (Time Between Last Two Orders)](https://triplewhale.readme.io/docs/sql-example-retention-churn-signals-time-between-last-two-orders.md) - [SQL Example: Revenue Split (First vs. Second Half of Date Range)](https://triplewhale.readme.io/docs/sql-example-revenue-split-first-vs-second-half-of-date-range.md) - [SQL Example: Hourly Revenue Indexed by Day](https://triplewhale.readme.io/docs/sql-example-hourly-revenue-indexed-by-day.md) - [SQL Example: Lifetime Value by Day Range (60, 90, 180, 365)](https://triplewhale.readme.io/docs/sql-example-lifetime-value-by-day-range-60-90-180-365.md) - Product Purchase Patterns (orders_table + products_info) - [SQL Example: Top First Purchased Products (Count, AOV, LTV…)](https://triplewhale.readme.io/docs/sql-example-top-first-purchased-products-count-aov-ltv.md) - [SQL Example: Most Common Next Product Bought (Sequential Product Purchases)](https://triplewhale.readme.io/docs/sql-example-most-common-next-product-bought-sequential-product-purchases.md) - [SQL Example: Most Common Second Product Bought](https://triplewhale.readme.io/docs/sql-example-most-common-second-product-bought.md) - Ad & Funnel Performance (ads_table, pixel_joined_tvf, web_analytics_table) - [SQL Example: Group Campaigns by Keyword (Top Match Terms)](https://triplewhale.readme.io/docs/sql-example-group-campaigns-by-keyword-top-match-terms.md) - [SQL Example: Weekly Performance Metrics (ROAS, CTR, CVR…)](https://triplewhale.readme.io/docs/sql-example-weekly-performance-metrics-roas-ctr-cvr.md) - [SQL Example: Monthly Pixel ROAS for Selected Channels (Bing, Facebook, Google)](https://triplewhale.readme.io/docs/sql-example-monthly-pixel-roas-for-selected-channels-bing-facebook-google.md) - [SQL Example: Website Performance by Device and Country](https://triplewhale.readme.io/docs/sql-example-website-performance-by-device-and-country.md) - [SQL Example: Multi-Touch Landing Page Paths (Conversion & Bounce Metrics)](https://triplewhale.readme.io/docs/sql-example-multi-touch-landing-page-paths-conversion-bounce-metrics.md) - Data Troubleshooting Guides - [Why Does My Total Revenue Across Channels Look Higher Than My Store Revenue?](https://triplewhale.readme.io/docs/why-does-my-total-revenue-across-channels-look-higher-than-my-store-revenue.md) - [Why Do My Order-Based Sales Metrics Not Match Between Shopify and Triple Whale?](https://triplewhale.readme.io/docs/why-do-my-order-based-sales-metrics-not-match-between-shopify-and-triple-whale.md) - [Why Are My Amazon Product Sales in Triple Whale Different From Amazon’s Official Dashboard?](https://triplewhale.readme.io/docs/why-are-my-amazon-product-sales-in-triple-whale-different-from-amazons-official-dashboard.md) - [Why Is My New vs. Returning Customer Count Different in Triple Whale vs. Shopify?](https://triplewhale.readme.io/docs/why-is-my-new-vs-returning-customer-count-different-in-triple-whale-vs-shopify.md) - [Why Is My Klaviyo (or Email/SMS) Revenue in Triple Whale Different from the Klaviyo Dashboard?](https://triplewhale.readme.io/docs/why-is-my-klaviyo-or-emailsms-revenue-in-triple-whale-different-from-the-klaviyo-dashboard.md) - [Why Do TikTok Shop Purchases Show a Different Number in the Pixel Report (Pixel > All) Compared to the Ads Breakdown (Pixel > Ads > TikTok)?](https://triplewhale.readme.io/docs/why-do-tiktok-shop-purchases-show-a-different-number-in-the-pixel-report-pixel-all-compared-to-the-ads-breakdown-pixel-ads-tiktok.md) - [Why Does Triple Whale Show a Lower Fairing/Kno Post-Purchase Survey Response Rate Than Fairing/Kno’s Own Dashboard?](https://triplewhale.readme.io/docs/why-does-triple-whale-show-a-lower-fairingkno-post-purchase-survey-response-rate-than-fairingknos-own-dashboard.md) - [Why Do Shopify Sessions Not Match Triple Whale Web Analytics?](https://triplewhale.readme.io/docs/why-do-shopify-sessions-not-match-triple-whale-web-analytics.md) - [Why Does My Conversion Rate Not Match Between Triple Whale and Shopify?](https://triplewhale.readme.io/docs/why-does-my-conversion-rate-not-match-between-triple-whale-and-shopify.md) - [Why Does the Inventory Metric on the Summary Page Not Match Shopify Inventory Reports?](https://triplewhale.readme.io/docs/why-does-the-inventory-metric-on-the-summary-page-not-match-shopify-inventory-reports.md) - [Why Does Brand Search Lose Credit in Total Impact (TI), or Why Might Another Channel Get More Credit Than Expected?](https://triplewhale.readme.io/docs/why-does-brand-search-lose-credit-in-total-impact-ti-or-why-might-another-channel-get-more-credit-than-expected.md) - [Why Am I Seeing Negative Profit for a Channel in Total Impact?](https://triplewhale.readme.io/docs/why-am-i-seeing-negative-profit-for-a-channel-in-total-impact.md) - [Why Do My Campaigns Have Spend but No Sessions?](https://triplewhale.readme.io/docs/why-do-my-campaigns-have-spend-but-no-sessions.md) - [Why Are Some Orders Missing or Marked as “Excluded” in the Pixel?](https://triplewhale.readme.io/docs/why-are-some-orders-missing-or-marked-as-excluded-in-the-pixel.md) - [Why Is My Ad Spend on the Summary Page Different From the Pixel Report or Blended Stats?](https://triplewhale.readme.io/docs/why-is-my-ad-spend-on-the-summary-page-different-from-the-pixel-report-or-blended-stats.md) - [Why Are My Orders and Revenue on the Summary Page Different From the Pixel Page?](https://triplewhale.readme.io/docs/why-are-my-orders-and-revenue-on-the-summary-page-different-from-the-pixel-page.md) - [Why Do Conversions in Web Analytics Not Match the Pixel Report?](https://triplewhale.readme.io/docs/why-do-conversions-in-web-analytics-not-match-the-pixel-report.md) - [Why Is My COGS in Triple Whale Different From My Shopify COGS?](https://triplewhale.readme.io/docs/why-is-my-cogs-in-triple-whale-different-from-my-shopify-cogs.md) - [Why Does My Lifetime Value (LTV) Metric Keep Changing Over Time?](https://triplewhale.readme.io/docs/why-does-my-lifetime-value-ltv-metric-keep-changing-over-time.md) - [Why Is My NCPA on the Summary Page Different From the NCPA in the Cohort Page?](https://triplewhale.readme.io/docs/why-is-my-ncpa-on-the-summary-page-different-from-the-ncpa-in-the-cohort-page.md) - [Why Do the PPS ‘Views’ in the Retention Tab Not Match the Actual Number of Post-Purchase Survey Responses?](https://triplewhale.readme.io/docs/why-do-the-pps-views-in-the-retention-tab-not-match-the-actual-number-of-post-purchase-survey-responses.md) - [Why Are My Meta (Facebook) Organic Sessions Inflated Compared to Triple Whale Sessions?](https://triplewhale.readme.io/docs/why-are-my-meta-facebook-organic-sessions-inflated-compared-to-triple-whale-sessions.md) - [Why Is My Triple Whale Web Analytics Pageview Count Lower Than My Google Analytics Pageview Count?](https://triplewhale.readme.io/docs/why-is-my-triple-whale-web-analytics-pageview-count-lower-than-my-google-analytics-pageview-count.md) - [Why Are My TikTok or Meta/Facebook Purchases Falling Under 'Not Set' or Non-Attributed in the Attribution Page?](https://triplewhale.readme.io/docs/why-are-my-tiktok-or-metafacebook-purchases-falling-under-not-set-or-non-attributed-in-the-attribution-page.md) - [Why Does My New Customer Count in LTV Cohorts Not Match Shopify?](https://triplewhale.readme.io/docs/why-does-my-new-customer-count-in-ltv-cohorts-not-match-shopify.md) - [Why Do Pixel Unique Metrics Look Higher at the Channel, Campaign, or Ad Set Level Than at the Ads Level?](https://triplewhale.readme.io/docs/why-do-pixel-unique-metrics-look-higher-at-the-channel-campaign-or-ad-set-level-than-at-the-ads-level.md) - [Moving from BigQuery to ClickHouse syntax in the SQL Editor](https://triplewhale.readme.io/docs/moving-from-bigquery-to-clickhouse-in-the-sql-editor.md) - [Mapping Shopify Fields to Triple Whale](https://triplewhale.readme.io/docs/mapping-shopify-fields-to-triple-whale.md) - [Mapping BigCommerce Fields to Triple Whale](https://triplewhale.readme.io/docs/mapping-bigcommerce-metrics-to-triple-whale.md) ## Developers: Triple Whale API - [Introduction to the Triple Whale API](https://triplewhale.readme.io/reference/introduction-to-the-triple-whale-api.md) - API Keys - [Creating and Managing Triple Whale API Keys](https://triplewhale.readme.io/reference/creating-and-managing-triple-whale-api-keys.md) - [Validate Your Triple Whale API Key](https://triplewhale.readme.io/reference/validate-your-triple-whale-api-key.md): Enter your API key in Credentials > Header to the right and click "Try it!" to test its validity. - Data In - [Data-In API Use Cases](https://triplewhale.readme.io/reference/data-in-api-use-cases.md) - [Managing Data-In Connections](https://triplewhale.readme.io/reference/managing-data-in-connections.md) - [Google Sheets Data-In Template](https://triplewhale.readme.io/reference/google-sheets-data-in-template.md) - Custom Sales Platform - [Custom Sales Platform Setup Overview](https://triplewhale.readme.io/reference/custom-sales-platform-setup-overview.md): Set up your custom sales platform using Data-In API and Triple Pixel - [API Setup Guide for Custom Sales Platform ](https://triplewhale.readme.io/reference/api-setup-guide-for-custom-sales-platform.md) - [Pixel Setup Guide for Custom Sales Platform](https://triplewhale.readme.io/reference/pixel-setup-guide-for-custom-sales-platform.md) - [Create Order Record](https://triplewhale.readme.io/reference/create-order-record.md): Ingest order data into Triple Whale for Custom Sales Platforms. This endpoint allows users to upload detailed order information, including customer details, product information, transaction… - [Bulk Create Order Records](https://triplewhale.readme.io/reference/bulk-create-order-records.md): Ingest multiple order records into Triple Whale for Custom Sales Platforms. This endpoint allows users to upload batches of order information, including customer details, product information,… - [Create Product Record](https://triplewhale.readme.io/reference/create-product-record.md): Ingest product data into Triple Whale. This endpoint allows users to upload detailed product information, including variants, tags, collections, and images. - [Create Subscription Record](https://triplewhale.readme.io/reference/create-subscription-record.md): Ingest subscription data into Triple Whale. This endpoint allows users to upload detailed subscription information, including customer details, items, status, and metadata. - [Create Customer Record](https://triplewhale.readme.io/reference/create-customer-record.md): Ingest customer data into Triple Whale. This endpoint allows users to upload detailed customer information — including contact details, address, consent status, and purchase history metadata. - Custom 3rd-Party Integrations - [Create Ad Record](https://triplewhale.readme.io/reference/create-ad-record.md): Ingest ad data into Triple Whale. This endpoint allows users to upload detailed ad information, including campaign, adset, ad details, and performance metrics. - [Create Email/SMS Record](https://triplewhale.readme.io/reference/create-email-sms-record.md): Ingest email, SMS, and direct mail marketing data into Triple Whale. This endpoint accepts campaign, flow, and message attributes along with performance metrics. - [Create Post-Purchase Survey (PPS) Record](https://triplewhale.readme.io/reference/create-pps-record.md): Ingest PPS data into Triple Whale. This endpoint allows users to upload detailed post-purchase survey information, including order-related data, questions, and responses. - Data Enrichment for Native Sales Platforms - [Enrich Orders Data](https://triplewhale.readme.io/reference/enrich-orders-data.md): Use this endpoint to enrich existing orders—such as adding shipping costs or custom tags. Note: Supported for data from platforms with a native Triple Whale integration (e.g., Shopify, BigCommerce,… - [Enrich Products Data](https://triplewhale.readme.io/reference/enrich-products-data.md): Use this endpoint to enrich existing products—such as adding cost data from external systems. Supported for data from platforms with a native Triple Whale integration (e.g., Shopify, BigCommerce,… - Data Enrichment for Pixel Attribution - [Enrich Pixel With Offline Events](https://triplewhale.readme.io/reference/enrich-pixel-with-offline-events.md): Send offline or server-side Pixel events—such as leads, MQLs, SQLs, opportunities, book-a-demo events, or fully custom events—into Triple Whale. Rate limit is 1,000 events/min. Max payload is 3 KB.… - Compliance - [Create Compliance Data Deletion Request](https://triplewhale.readme.io/reference/create-compliance-request.md): Create a compliance request to delete/mask customer PII for a shop using one or more identifiers (emails and/or phone numbers). - [Sample Automation: Submit Deletion Requests from a CSV (Python)](https://triplewhale.readme.io/reference/sample-automation-submit-deletion-requests-from-a-csv-python.md) - Data Out - [Data-Out API Use Cases](https://triplewhale.readme.io/reference/data-out-api-use-cases.md) - [Get Summary Page Data](https://triplewhale.readme.io/reference/get-summary-page-data.md): Retrieve data from the Summary Page for a specified time period. - [Get Customer Journey Attribution Data](https://triplewhale.readme.io/reference/get-customer-journey-attribution-data.md): Export full customer journey data, with Triple Pixel attribution, for all customers who placed an order in the specified period. - [Execute Custom SQL Query](https://triplewhale.readme.io/reference/data-out-execute-custom-sql-query.md): Run custom SQL queries for structured data retrieval. The response returns the query results in a JSON format. - [Troubleshooting Common Triple Whale API Errors](https://triplewhale.readme.io/reference/troubleshooting-common-triple-whale-api-errors.md) ## Developers: Developer Portal - [Introduction to the Developer Portal](https://triplewhale.readme.io/reference/introduction-to-the-developer-portal.md) - Getting Started - [Creating a Developer Account](https://triplewhale.readme.io/reference/creating-a-developer-account.md) - Apps - [Submitting an App for Review](https://triplewhale.readme.io/reference/submitting-an-app-for-review.md) - [App Review and Statuses](https://triplewhale.readme.io/reference/app-review-and-statuses.md) - [OAuth Scopes](https://triplewhale.readme.io/reference/oauth-scopes.md) - [Managing Your Client Secret](https://triplewhale.readme.io/reference/managing-your-client-secret.md) - [Quick Start: The OAuth Flow](https://triplewhale.readme.io/reference/quick-start-oauth-flow.md) - [Testing with the Playground](https://triplewhale.readme.io/reference/testing-with-the-playground.md) - [Editing an Approved App](https://triplewhale.readme.io/reference/editing-an-approved-app.md) - [Managing App Members](https://triplewhale.readme.io/reference/managing-app-members.md) - [Activity Log](https://triplewhale.readme.io/reference/activity-log.md) - Merchants and API - [Merchant Consent and Disconnecting an App](https://triplewhale.readme.io/reference/merchant-consent-and-disconnecting.md) - [API Endpoints for OAuth Apps](https://triplewhale.readme.io/reference/api-endpoints-for-oauth-apps.md) - [API Keys vs OAuth Apps](https://triplewhale.readme.io/reference/api-keys-vs-oauth-apps.md) ## Developers: Triple Pixel Mobile SDK - [Intro to the Triple Pixel Mobile SDK](https://triplewhale.readme.io/reference/intro-to-the-triple-pixel-mobile-sdk.md) - [Mobile SDK Installation](https://triplewhale.readme.io/reference/mobile-sdk-installation.md) - [Mobile SDK Quick Start](https://triplewhale.readme.io/reference/mobile-sdk-quick-start.md) - [Mobile SDK Methods](https://triplewhale.readme.io/reference/mobile-sdk-methods.md) - [Mobile SDK Consent and Privacy](https://triplewhale.readme.io/reference/mobile-sdk-consent-and-privacy.md) - [Troubleshooting Mobile SDK Errors](https://triplewhale.readme.io/reference/troubleshooting-mobile-sdk-errors.md) ## Developers: Data Warehouse Export - [Introduction to Data Warehouse Export](https://triplewhale.readme.io/reference/introduction-to-data-warehouse-export.md) - Setup and Configuration - [BigQuery Setup and Configuration](https://triplewhale.readme.io/reference/bigquery-setup-and-configuration.md) - [Snowflake Setup and Configuration](https://triplewhale.readme.io/reference/snowflake-setup-and-configuration.md) - [AWS S3 Setup and Configuration](https://triplewhale.readme.io/reference/aws-s3-setup-and-configuration.md) - [Google Cloud Storage Setup and Configuration](https://triplewhale.readme.io/reference/google-cloud-storage-setup-and-configuration.md) - [De-duplication for Data Warehouse Export](https://triplewhale.readme.io/reference/de-duplication-for-data-warehouse-export.md)