The Metric Directory for the Polar MCP (Model Connection Protocol) serves as a reference guide for all the metrics you can query from your Polar workspace using MCP-connected tools — such as ChatGPT, Claude, or automation platforms like Make or n8n.
It ensures you understand exactly which metrics are available, how they’re defined, and how to use them correctly when building prompts or data queries.
By using this Metric Directory, you can:
Access consistent metric definitions aligned with your Polar workspace.
Write precise, natural-language prompts that return accurate data.
Understand the scope and logic behind key business metrics such as Revenue, ROAS, and Customer Acquisition Cost (CAC).
In this article, you’ll learn:
How the MCP Metric Directory works and why it matters.
The main metric categories available in Polar’s semantic layer.
Examples of how to reference these metrics in your MCP prompts.
Understanding the Metric Directory
What Is the MCP Metric Directory?
The Metric Directory is a comprehensive list of business metrics exposed through Polar’s semantic layer, accessible via the Model Connection Protocol (MCP).
When you connect an AI assistant (like ChatGPT or Claude) or an automation tool to Polar using the MCP endpoint, this directory becomes the foundation of your queryable dataset.
The directory ensures that AI tools interpret metrics consistently — so that when you ask for “revenue,” the assistant knows it means “total gross revenue from Shopify (or your connected source) excluding taxes, refunds, and discounts,” not just a generic figure.
Why It Matters
Consistency: All MCP-compatible tools use the same metric definitions as your Polar dashboards.
Accuracy: Removes ambiguity from natural language queries by mapping them directly to your workspace’s metric logic.
Transparency: Lets users understand how each metric is calculated and sourced.
Example:
When you query:
“Show me total ad spend and ROAS across all channels for the last 30 days,”
the MCP automatically pulls the values for:
Ad Spend→ Total advertising cost aggregated across connected ad platforms.ROAS→ (Revenue attributed to ads ÷ Ad Spend), standardized across data sources.
Core Metric Categories in the MCP Directory
The Metric Directory includes every key performance indicator available in your Polar workspace. Below are the main categories and common metrics you can query:
1. Revenue Metrics
Metrics related to sales and earnings across all channels.
Revenue: Total sales excluding taxes, refunds, and discounts.Gross Profit: Revenue minus COGS (Cost of Goods Sold).Net Profit: Gross Profit minus ad spend and other operational costs.AOV (Average Order Value): Total Revenue ÷ Number of Orders.
2. Marketing & Advertising Metrics
Metrics for measuring ad performance and spend efficiency.
Ad Spend: Total cost from ad platforms (Meta, Google Ads, TikTok, etc.).ROAS (Return on Ad Spend): Revenue generated ÷ Ad Spend.CTR (Click-Through Rate): Clicks ÷ Impressions.CPC (Cost Per Click): Ad Spend ÷ Clicks.CPM (Cost Per Mille): Ad Spend ÷ (Impressions ÷ 1000).CAC (Customer Acquisition Cost): Ad Spend ÷ Number of New Customers.
3. Customer Metrics
Metrics that track customer growth, retention, and engagement.
New Customers: Count of first-time purchasers.Returning Customers: Count of repeat purchasers.LTV (Customer Lifetime Value): Average revenue generated by a customer over time.Churn Rate: Percentage of customers who haven’t made a repeat purchase within a given timeframe.
4. Order & Conversion Metrics
Metrics focused on sales funnel performance.
Orders: Total number of completed transactions.Conversion Rate: Orders ÷ Sessions or Clicks.Add-to-Cart Rate: Add-to-cart events ÷ Sessions.Checkout Completion Rate: Completed purchases ÷ Checkouts started.
5. Product & Inventory Metrics
Metrics for product-level insights.
Top Products by Revenue: Highest-grossing SKUs in a given timeframe.Sell-Through Rate: Units sold ÷ Units available.Inventory Value: Total stock value based on COGS.
6. Email & Retention Metrics
Metrics that measure engagement and revenue from email marketing.
Email Revenue: Revenue attributed to email campaigns or flows.Open Rate: Opens ÷ Emails sent.Click Rate: Clicks ÷ Emails sent.Email-attributed Orders: Orders placed after receiving or interacting with an email.
How to Use Metrics in MCP Queries
Once your MCP is connected, you can reference these metrics directly in your prompts or automations.
Example 1: Natural Language Query
You can use conversational phrasing, and the MCP will interpret the correct metrics automatically.
Prompt:
“Compare my ROAS and Ad Spend for Meta and Google Ads in the last 30 days.”
MCP Output:
Meta Ads: $21,400 spend | 4.1x ROAS
Google Ads: $18,700 spend | 3.6x ROAS
Example 2: Profitability Analysis
Prompt:
“Show me total Revenue, Gross Profit, and Net Profit over the last quarter.”
MCP Output:
Revenue: $310,000
Gross Profit: $186,000
Net Profit: $142,000
Example 3: Funnel Health Check
Prompt:
“Analyze my conversion funnel — from sessions to checkouts to orders — for the last 7 days.”
MCP Output:
Sessions: 18,500 → Checkouts: 2,140 → Orders: 1,950 (Conversion Rate: 10.5%)
Tips for Writing Better Prompts
Be specific with timeframes (e.g., “last 7 days,” “this quarter,” “Q3 2024”).
Include dimensions like channel, product, or campaign to segment results.
Ask for comparisons (e.g., “Compare this week vs. last week”).
Combine multiple metrics for richer analysis (e.g., “Show ROAS, CAC, and LTV by channel”).
The Metric Directory for the MCP is your foundation for querying and understanding data through Polar’s Model Connection Protocol. By knowing which metrics are available — and how they’re defined — you can create smarter, more accurate prompts that deliver clear, actionable insights.
Key takeaways:
The Metric Directory standardizes all metrics across Polar’s semantic layer.
Use it to craft precise MCP prompts that match your business context.
Combine multiple metrics in your prompts to uncover deeper performance trends.
Comprehensive Metrics List
Cross-Platform / Blended Metrics
Metric Name | Metric Key |
% Email Revenue | percentage_email_revenue |
ACOS | acos |
Ad Platforms ACV | paid_avg_conversion_value |
Ad Platforms Clicks | total_clicks |
Ad Platforms Conversion Value | total_conversion_value_from_pixels |
Ad Platforms Conversions | total_conversions_from_pixels |
Ad Platforms CPC | cpc |
Ad Platforms CPM | cpm |
Ad Platforms CPO | paid_cpa |
Ad Platforms CTR | ctr |
Ad Platforms Impressions | total_impressions |
Ad Platforms Order Rate | order_rate |
Ad Platforms Revenue per Click | revenue_per_click |
Ad Platforms Revenue per Impression | revenue_per_impression |
Ad Platforms ROAS | paid_roas |
Ad Spend | total_marketing_spend |
Attributed Revenue | revenue_from_klaviyo |
Average Order Value | klaviyo_avg_order_value |
Blended Average Order Value | blended_avg_order_value |
Blended CAC | blended_cac |
Blended CAC:AOV Ratio | cac_aov_ratio |
Blended CPO | cost_per_order |
Blended Discounts | blended_discounts |
Blended Gross Sales | blended_gross_sales |
Blended ncROAS (MER) | acquisition_roas |
Blended Net Sales | blended_net_sales |
Blended POAS (Profit on Ad Spend) | poas |
Blended Product Quantity | blended_product_quantity |
Blended ROAS (MER) | blended_roas |
Blended Shipping | blended_shipping |
Blended Tax | blended_tax |
Blended Total Orders | blended_total_orders |
Blended Total Sales | blended_total_sales |
CM3 | contribution_margin_3 |
CM3 % | contribution_margin_3_ratio |
CM4 | contribution_margin_4 |
CM4 % | contribution_margin_4_ratio |
GA Paid ROAS | ga_paid_roas |
Klaviyo List Growth % | list_growth_perc |
LTV:CAC Ratio | ltv_blended_cac_ratio |
Placed Order Rate | placed_order_rate |
Polar Pixel CAC | pixel_cac |
Polar Pixel Conversion Rate | polar_pixel_conversion_rate |
Polar Pixel Paid ACV | pixel_paid_aov |
Polar Pixel Paid CAC | pixel_paid_cac |
Polar Pixel Paid CPO | pixel_paid_cost_per_order |
Polar Pixel Paid ncACV | pixel_paid_nc_aov |
Polar Pixel Paid ROAS | pixel_paid_roas |
Polar Pixel ROAS | pixel_roas |
Received Email | sends |
Revenue per Received Email | revenue_per_subscriber |
Shopify Conversion Rate from GA sessions | blended_conversion_rate |
Unique Bounced Email | unique_bounce |
Unique Bounced Rate | unique_bounce_rate |
Unique Clicked Email | unique_click |
Unique Clicked Email excluding Bots | unique_click_excl_bot |
Unique Clicked Rate | unique_click_rate |
Unique Clicked Rate excluding Bots | unique_click_rate_excl_bot |
Unique Marked Email as Spam | unique_spam |
Unique Opened Rate | open_rate |
Unique Received Email | unique_open |
Unique Unsubscribed | unique_unsubscribe |
Unique Unsubscribed Rate | unique_unsubscribe_rate |
Amazon Ads
Metric Name | Metric Key |
Clicks from Amazon Ads | amazonads_campaign.raw.clicks |
Conversions from Amazon Ads | amazonads_campaign.raw.attributed_conversions |
Conversions (1 Day) from Amazon Ads | amazonads_campaign.raw.attributed_conversions_1_d |
Conversions (7 Days) from Amazon Ads | amazonads_campaign.raw.attributed_conversions_7_d |
Conversions (14 Days) from Amazon Ads | amazonads_campaign.raw.attributed_conversions_14_d |
Conversions (30 Days) from Amazon Ads | amazonads_campaign.raw.attributed_conversions_30_d |
Cost from Amazon Ads | amazonads_campaign.raw.cost |
Impressions from Amazon Ads | amazonads_campaign.raw.impressions |
Sales from Amazon Ads | amazonads_campaign.raw.attributed_sales |
Sales (1 Day) from Amazon Ads | amazonads_campaign.raw.attributed_sales_1_d |
Sales (7 Days) from Amazon Ads | amazonads_campaign.raw.attributed_sales_7_d |
Sales (14 Days) from Amazon Ads | amazonads_campaign.raw.attributed_sales_14_d |
Sales (30 Days) from Amazon Ads | amazonads_campaign.raw.attributed_sales_30_d |
Units Ordered (1 Day) from Amazon Ads | amazonads_campaign.raw.attributed_units_ordered_1_d |
Units Ordered (7 Days) from Amazon Ads | amazonads_campaign.raw.attributed_units_ordered_7_d |
Units Ordered (14 Days) from Amazon Ads | amazonads_campaign.raw.attributed_units_ordered_14_d |
Units Ordered (30 Days) from Amazon Ads | amazonads_campaign.raw.attributed_units_ordered_30_d |
Amazon Seller
Metric Name | Metric Key |
Adjustments from Amazon Seller | amazonsp_order_items.raw.adjustments_amazon |
Cost of Products (COGs) from Amazon Seller | amazonsp_order_items.raw.cost_of_products_amazon |
Fees from Amazon Seller | amazonsp_order_items.raw.total_fees_amazon |
Gross Sales from Amazon Seller | amazonsp_order_items.raw.gross_sales_amazon |
Promotion Discounts from Amazon Seller | amazonsp_order_items.raw.promotion_discounts_amazon |
Quantity Ordered from Amazon Seller | amazonsp_order_items.raw.quantity_ordered |
Quantity Shipped from Amazon Seller | amazonsp_order_items.raw.quantity_shipped |
Returns from Amazon Seller | amazonsp_order_items.raw.returns_amazon |
Shipping from Amazon Seller | amazonsp_order_items.raw.shipping_amazon |
Shipping Discounts from Amazon Seller | amazonsp_order_items.raw.shipping_discounts_amazon |
Tax from Amazon Seller | amazonsp_order_items.raw.tax_amazon |
Total Costs from Amazon Seller | amazonsp_order_items.raw.total_costs_amazon |
Total Orders from Amazon Seller | amazonsp_order_items.raw.total_orders_amazon |
Total Refunds from Amazon Seller | amazonsp_order_items.raw.total_refunds_amazon |
Average Order Value from Amazon Seller | amazonsp_order_items.computed.avg_order_value_amazon |
Net Sales from Amazon Seller | amazonsp_order_items.computed.net_sales_amazon |
Total Discounts from Amazon Seller | amazonsp_order_items.computed.discounts_amazon |
Total Sales from Amazon Seller | amazonsp_order_items.computed.total_sales_amazon |
Attentive
Metric Name | Metric Key |
Total SMS Sent from Attentive | attentive_events.raw.total_sms_sent |
Total SMS Sent (Campaign) from Attentive | attentive_events.raw.total_sms_sent_campaign |
Total SMS Sent (Concierge) from Attentive | attentive_events.raw.total_sms_sent_concierge |
Total SMS Sent (Journey) from Attentive | attentive_events.raw.total_sms_sent_journey |
Total SMS Subscriptions from Attentive | attentive_events.raw.total_sms_subscriptions |
Total SMS Unsubscriptions from Attentive | attentive_events.raw.total_sms_unsubscriptions |
Benchmarks
Metric Name | Metric Key |
Ad Platforms Clicks (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_clicks_per_tenant |
Ad Platforms Impressions (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_impressions_per_tenant |
Ad Spend (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_spend_per_tenant |
Average Order Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_aov |
Blended CAC (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_cac |
Blended Conversion Rate (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_conversion_rate |
Blended ROAS (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_roas |
Facebook Adds to Cart (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_adds_to_cart_per_tenant |
Facebook Adds to Cart Conversion Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_adds_to_cart_value_per_tenant |
Facebook Clicks (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_clicks_per_tenant |
Facebook Cost per Purchase (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_cost_per_purchase |
Facebook CPM (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_cpm |
Facebook CTR (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_ctr |
Facebook Impressions (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_impressions_per_tenant |
Facebook Initiate Checkout (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_initiate_checkout_per_tenant |
Facebook Initiate Checkout Conversion Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_initiate_checkout_value_per_tenant |
Facebook Inline Link Clicks (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_inline_link_clicks_per_tenant |
Facebook Leads (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_leads_per_tenant |
Facebook Leads Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_leads_value_per_tenant |
Facebook Mobile App Purchases (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_mobile_app_purchases_per_tenant |
Facebook Mobile App Purchases Conversion Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_mobile_app_purchases_value_per_tenant |
Facebook Offline Purchases (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_offline_purchases_per_tenant |
Facebook Offline Purchases Conversion Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_offline_purchases_value_per_tenant |
Facebook Outbound Clicks (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_outbound_clicks_per_tenant |
Facebook Purchases (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_purchases_per_tenant |
Facebook Purchases Conversion Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_purchases_value_per_tenant |
Facebook ROAS (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_roas |
Facebook Spend (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_spend_per_tenant |
Facebook Website Purchases (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_website_purchases_per_tenant |
Facebook Website Purchases Conversion Value (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_fb_website_purchases_value_per_tenant |
Google Analytics Sessions (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_sessions_per_tenant |
Google Analytics Transactions (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_transactions_per_tenant |
New Customer Orders (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_new_orders_per_tenant |
Total Orders (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_orders_per_tenant |
Total Sales (Benchmark) from Benchmarks | benchmarks_master.computed.benchmarks_total_sales_per_tenant |
Bing Ads
Metric Name | Metric Key |
Clicks from Bing Ads | bingads_campaign_addistribution_network_and_device.raw.clicks |
Conversions from Bing Ads | bingads_campaign_addistribution_network_and_device.raw.conversions |
Conversions (All) from Bing Ads | bingads_campaign_addistribution_network_and_device.raw.all_conversions |
Impressions from Bing Ads | bingads_campaign_addistribution_network_and_device.raw.impressions |
Revenue from Bing Ads | bingads_campaign_addistribution_network_and_device.raw.revenue |
Spend from Bing Ads | bingads_campaign_addistribution_network_and_device.raw.spend |
Average Revenue from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.avg_revenue |
Cost per Conversion from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.cost_per_conversion |
Cost per Conversion (All) from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.cost_per_conversion_all |
CPC from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.cpc |
CPM from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.cpm |
CTR from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.ctr_rate |
Order Rate from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.order_rate |
Order Rate (All) from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.order_rate_all |
Revenue per Click from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.revenue_per_click |
Revenue per Impression from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.revenue_per_impression |
ROAS from Bing Ads | bingads_campaign_addistribution_network_and_device.computed.roas |
Criteo
Metric Name | Metric Key |
Audience from Criteo | criteo_adset_and_category.raw.audience |
Clicks from Criteo | criteo_adset_and_category.raw.clicks |
Conversion Value (1d PV) from Criteo | criteo_adset_and_category.raw.all_conversion_value_pv_24_h |
Conversion Value (30d PC + 1d PV) from Criteo | criteo_adset_and_category.raw.all_conversion_value_pc_30_d_pv_24_h |
Conversion Value (30d PC) from Criteo | criteo_adset_and_category.raw.all_conversion_value_pc_30_d |
Conversion Value (All) from Criteo | criteo_adset_and_category.raw.all_conversion_value |
Conversions (1d PV) from Criteo | criteo_adset_and_category.raw.all_conversions_pv_24_h |
Conversions (30d PC + 1d PV) from Criteo | criteo_adset_and_category.raw.all_conversions_pc_30_d_pv_24_h |
Conversions (30d PC) from Criteo | criteo_adset_and_category.raw.all_conversions_pc_30_d |
Conversions (All) from Criteo | criteo_adset_and_category.raw.all_conversions |
Cost from Criteo | criteo_adset_and_category.raw.cost |
Display Opportunities from Criteo | criteo_adset_and_category.raw.display_opportunities |
Displays from Criteo | criteo_adset_and_category.raw.displays |
Exposed Users (Non-Unique) from Criteo | criteo_adset_and_category.raw.exposed_users |
Reach from Criteo | criteo_adset_and_category.raw.reach |
Average Conversion Value from Criteo | criteo_adset_and_category.computed.avg_conversion_value |
Cost per Conversion from Criteo | criteo_adset_and_category.computed.cost_per_conversion |
CPC from Criteo | criteo_adset_and_category.computed.cpc |
CPM from Criteo | criteo_adset_and_category.computed.cpm |
CTR from Criteo | criteo_adset_and_category.computed.ctr_rate |
Order Rate from Criteo | criteo_adset_and_category.computed.order_rate |
Revenue per Click from Criteo | criteo_adset_and_category.computed.revenue_per_click |
Revenue per Impression from Criteo | criteo_adset_and_category.computed.revenue_per_impression |
ROAS from Criteo | criteo_adset_and_category.computed.roas |
Facebook Ads (Meta Ads)
Metric Name | Metric Key |
Adds to Cart from Facebook Ads | facebookads_ad_platform_and_device.raw.adds_to_cart |
Adds to Cart Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.raw.adds_to_cart_conversion_value |
Checkouts Initiated from Facebook Ads | facebookads_ad_platform_and_device.raw.initiate_checkout |
Checkouts Initiated Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.raw.initiate_checkout_value |
Clicks from Facebook Ads | facebookads_ad_platform_and_device.raw.clicks |
Creative Spend from Facebook Ads | facebookads_ad_platform_and_device.raw.creative_spend |
Impressions from Facebook Ads | facebookads_ad_platform_and_device.raw.impressions |
In-App Purchases from Facebook Ads | facebookads_ad_platform_and_device.raw.mobile_app_purchases |
In-App Purchases Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.raw.mobile_app_purchases_conversion_value |
Leads from Facebook Ads | facebookads_ad_platform_and_device.raw.leads |
Leads Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.raw.leads_value |
Link Clicks from Facebook Ads | facebookads_ad_platform_and_device.raw.link_clicks |
Outbound Clicks from Facebook Ads | facebookads_ad_platform_and_device.raw.outbound_clicks |
Purchases from Facebook Ads | facebookads_ad_platform_and_device.raw.purchases |
Purchases (for Click Attribution window) from Facebook Ads | facebookads_ad_platform_and_device.raw.purchases_click |
Purchases (for View Attribution window) from Facebook Ads | facebookads_ad_platform_and_device.raw.purchases_view |
Purchases Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.raw.purchases_conversion_value |
Spend from Facebook Ads | facebookads_ad_platform_and_device.raw.spend |
Website Purchases from Facebook Ads | facebookads_ad_platform_and_device.raw.website_purchases |
Website Purchases Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.raw.website_purchases_conversion_value |
Average Purchase Conversion Value from Facebook Ads | facebookads_ad_platform_and_device.computed.avg_purchase_value |
Cost per Add to Cart from Facebook Ads | facebookads_ad_platform_and_device.computed.cost_per_add_to_cart |
Cost per Checkout Initiated from Facebook Ads | facebookads_ad_platform_and_device.computed.cost_per_initiate_checkout |
Cost per Lead from Facebook Ads | facebookads_ad_platform_and_device.computed.cost_per_lead |
Cost per Purchase from Facebook Ads | facebookads_ad_platform_and_device.computed.cost_per_purchase |
CPC (All) from Facebook Ads | facebookads_ad_platform_and_device.computed.cpc_all |
CPC (Link) from Facebook Ads | facebookads_ad_platform_and_device.computed.cpc_link |
CPC (Outbound) from Facebook Ads | facebookads_ad_platform_and_device.computed.cpc_outbound |
CPM from Facebook Ads | facebookads_ad_platform_and_device.computed.cpm |
CTR (All) from Facebook Ads | facebookads_ad_platform_and_device.computed.ctr_all_rate |
CTR (Link) from Facebook Ads | facebookads_ad_platform_and_device.computed.ctr_click_rate |
CTR (Outbound) from Facebook Ads | facebookads_ad_platform_and_device.computed.outbound_ctr |
Order Rate (Link Clicks) from Facebook Ads | facebookads_ad_platform_and_device.computed.order_rate |
Revenue per Click from Facebook Ads | facebookads_ad_platform_and_device.computed.revenue_per_click |
Revenue per Impression from Facebook Ads | facebookads_ad_platform_and_device.computed.revenue_per_impression |
ROAS from Facebook Ads | facebookads_ad_platform_and_device.computed.roas |
Fairing
Metric Name | Metric Key |
Total Customers from Fairing | fairing_response.raw.fairing_total_customers |
Total Orders from Fairing | fairing_response.raw.fairing_total_orders |
Total Responses from Fairing | fairing_response.raw.total_responses |
Google Analytics
Metric Name | Metric Key |
Adds to Cart (GA4) from Google Analytics | ga_main.raw.ga4_adds_to_cart |
Brand Sessions from Google Analytics | ga_main.raw.brand_sessions |
Conversions (GA4) from Google Analytics | ga_main.raw.ga4_conversions |
Desktop Engaged Sessions (GA4) from Google Analytics | ga_main.raw.desktop_engaged_sessions |
Desktop Sessions from Google Analytics | ga_main.raw.desktop_sessions |
Ecommerce Purchases (GA4) from Google Analytics | ga_main.raw.ecommerce_purchases |
Engaged Sessions (GA4) from Google Analytics | ga_main.raw.engaged_sessions |
Mobile Engaged Sessions (GA4) from Google Analytics | ga_main.raw.mobile_engaged_sessions |
Mobile Sessions from Google Analytics | ga_main.raw.mobile_sessions |
New Sessions from Google Analytics | ga_main.raw.new_sessions |
New Transactions from Google Analytics | ga_main.raw.new_transactions |
Purchase Revenue (GA4) from Google Analytics | ga_main.raw.purchase_revenue |
Repeat Sessions from Google Analytics | ga_main.raw.repeat_sessions |
Repeat Transactions from Google Analytics | ga_main.raw.repeat_transactions |
Screen Pageviews (GA4) from Google Analytics | ga_main.raw.screen_page_views |
Sessions from Google Analytics | ga_main.raw.sessions |
Total Revenue from Google Analytics | ga_main.raw.total_revenue |
Transaction Revenue from Google Analytics | ga_main.raw.transaction_revenue |
Transactions from Google Analytics | ga_main.raw.transactions |
User Engagement Duration - mins (GA4) from Google Analytics | ga_main.raw.user_engagement_duration_mins |
User Engagement Duration - secs (GA4) from Google Analytics | ga_main.raw.user_engagement_duration_secs |
Users (GA UA / Non-Unique) from Google Analytics | ga_main.raw.users |
Adds to Cart Rate (GA4) from Google Analytics | ga_main.computed.adds_to_cart_rate |
Average Purchase Revenue (GA4) from Google Analytics | ga_main.computed.average_purchase_revenue |
Bounce Rate (GA4) from Google Analytics | ga_main.computed.bounce_rate |
Conversion Rate from Google Analytics | ga_main.computed.conversion_rate |
Engaged Sessions Rate (GA4) from Google Analytics | ga_main.computed.engaged_sessions_rate |
GA Paid Conversion Value from Google Analytics | ga_main.computed.paid_transaction_revenue |
New Conversion Rate from Google Analytics | ga_main.computed.new_conversion_rate |
Page Views per Session (GA4) from Google Analytics | ga_main.computed.screen_page_views_per_session |
Purchase Conversion Rate (GA4) from Google Analytics | ga_main.computed.session_conversion_rate |
Repeat Conversion Rate from Google Analytics | ga_main.computed.repeat_conversion_rate |
Time per Session in minutes (GA4) from Google Analytics | ga_main.computed.user_engagement_duration_mins_per_session |
Time per Session in seconds (GA4) from Google Analytics | ga_main.computed.user_engagement_duration_secs_per_session |
Google Ads
Metric Name | Metric Key |
Clicks from Google Ads | googleads_campaign_and_device.raw.clicks |
Conversion Value from Google Ads | googleads_campaign_and_device.raw.conversion_value |
Conversion Value (All) from Google Ads | googleads_campaign_and_device.raw.all_conversion_value |
Conversions from Google Ads | googleads_campaign_and_device.raw.conversions |
Conversions (All) from Google Ads | googleads_campaign_and_device.raw.all_conversions |
Cost from Google Ads | googleads_campaign_and_device.raw.cost |
Impressions from Google Ads | googleads_campaign_and_device.raw.impressions |
Average Conversion Value from Google Ads | googleads_campaign_and_device.computed.avg_conversion_value |
Average Conversion Value (All) from Google Ads | googleads_campaign_and_device.computed.avg_conversion_value_all |
Cost per Conversion from Google Ads | googleads_campaign_and_device.computed.cost_per_conversion |
Cost per Conversion (All) from Google Ads | googleads_campaign_and_device.computed.cost_per_conversion_all |
CPC from Google Ads | googleads_campaign_and_device.computed.cpc |
CPM from Google Ads | googleads_campaign_and_device.computed.cpm |
CTR from Google Ads | googleads_campaign_and_device.computed.ctr_rate |
Order Rate from Google Ads | googleads_campaign_and_device.computed.order_rate |
Order Rate (All Conversions) from Google Ads | googleads_campaign_and_device.computed.order_rate_all |
Revenue per Click from Google Ads | googleads_campaign_and_device.computed.revenue_per_click |
Revenue per Click (All) from Google Ads | googleads_campaign_and_device.computed.revenue_per_click_all |
Revenue per Impression from Google Ads | googleads_campaign_and_device.computed.revenue_per_impression |
Revenue per Impression (All) from Google Ads | googleads_campaign_and_device.computed.revenue_per_impression_all |
ROAS from Google Ads | googleads_campaign_and_device.computed.roas |
ROAS (All) from Google Ads | googleads_campaign_and_device.computed.roas_all |
Google Sheets (Spend)
Metric Name | Metric Key |
Clicks from Google Sheets (Spend) | gsheets_campaign_and_device.raw.clicks |
Conversion Value from Google Sheets (Spend) | gsheets_campaign_and_device.raw.conversion_value |
Conversions from Google Sheets (Spend) | gsheets_campaign_and_device.raw.conversions |
Impressions from Google Sheets (Spend) | gsheets_campaign_and_device.raw.impressions |
Spend from Google Sheets (Spend) | gsheets_campaign_and_device.raw.spend |
Average Conversion Value from Google Sheets (Spend) | gsheets_campaign_and_device.computed.avg_conversion_value |
Cost per Conversion from Google Sheets (Spend) | gsheets_campaign_and_device.computed.cost_per_conversion |
CPC from Google Sheets (Spend) | gsheets_campaign_and_device.computed.cpc |
CPM from Google Sheets (Spend) | gsheets_campaign_and_device.computed.cpm |
CTR from Google Sheets (Spend) | gsheets_campaign_and_device.computed.ctr_rate |
Order Rate from Google Sheets (Spend) | gsheets_campaign_and_device.computed.order_rate |
Revenue per Click from Google Sheets (Spend) | gsheets_campaign_and_device.computed.revenue_per_click |
Revenue per Impression from Google Sheets (Spend) | gsheets_campaign_and_device.computed.revenue_per_impression |
ROAS from Google Sheets (Spend) | gsheets_campaign_and_device.computed.roas |
Google Search Console
Metric Name | Metric Key |
Clicks from Google Search Console | generated_root_google_search_console.raw.clicks |
Impressions from Google Search Console | generated_root_google_search_console.raw.impressions |
CTR from Google Search Console | generated_root_google_search_console.computed.ctr |
Klaviyo
Metric Name | Metric Key |
Campaign Placed Orders from Klaviyo | klaviyo_sales_main.raw.campaign_orders |
Campaign Received Email from Klaviyo | klaviyo_sales_main.raw.campaign_send |
Campaign Revenue from Klaviyo | klaviyo_sales_main.raw.campaign_revenue |
Campaign Unique Bounced Email from Klaviyo | klaviyo_sales_main.raw.campaign_unique_bounce |
Campaign Unique Clicked Email from Klaviyo | klaviyo_sales_main.raw.campaign_unique_click |
Campaign Unique Clicked Email excluding Bots from Klaviyo | klaviyo_sales_main.raw.campaign_unique_click_excl_bot |
Campaign Unique Marked Email as Spam from Klaviyo | klaviyo_sales_main.raw.campaign_unique_spam |
Campaign Unique Opened Email from Klaviyo | klaviyo_sales_main.raw.campaign_unique_open |
Campaign Unique Received Email from Klaviyo | klaviyo_sales_main.raw.campaign_unique_send |
Campaign Unique Unsubscribed from Email Marketing from Klaviyo | klaviyo_sales_main.raw.campaign_unique_unsubscribe |
Discounts from Klaviyo | klaviyo_sales_main.raw.discounts |
Flow Placed Orders from Klaviyo | klaviyo_sales_main.raw.flow_orders |
Flow Received Email from Klaviyo | klaviyo_sales_main.raw.flow_send |
Flow Revenue from Klaviyo | klaviyo_sales_main.raw.flow_revenue |
Flow Unique Bounced Email from Klaviyo | klaviyo_sales_main.raw.flow_unique_bounce |
Flow Unique Clicked Email from Klaviyo | klaviyo_sales_main.raw.flow_unique_click |
Flow Unique Clicked Email excluding Bots from Klaviyo | klaviyo_sales_main.raw.flow_unique_click_excl_bot |
Flow Unique Marked Email as Spam from Klaviyo | klaviyo_sales_main.raw.flow_unique_spam |
Flow Unique Opened Email from Klaviyo | klaviyo_sales_main.raw.flow_unique_open |
Flow Unique Received Email from Klaviyo | klaviyo_sales_main.raw.flow_unique_send |
Flow Unique Unsubscribed from Email Marketing from Klaviyo | klaviyo_sales_main.raw.flow_unique_unsubscribe |
Subscribed to List from Klaviyo | klaviyo_sales_main.raw.new_subscribers |
Tax from Klaviyo | klaviyo_sales_main.raw.tax |
Tips from Klaviyo | klaviyo_sales_main.raw.tips |
Total Customers from Klaviyo | klaviyo_sales_main.raw.total_customers |
Total Placed Orders from Klaviyo | klaviyo_sales_main.raw.klaviyo_orders |
Total Revenue from Klaviyo | klaviyo_sales_main.raw.total_revenue |
Unsubscribed from List from Klaviyo | klaviyo_sales_main.raw.unsubscribes |
Campaign Placed Order Rate from Klaviyo | klaviyo_sales_main.computed.campaign_placed_order_rate |
Campaign Revenue per Received Email from Klaviyo | klaviyo_sales_main.computed.campaign_revenue_per_subscriber |
Campaign Unique Bounced Rate from Klaviyo | klaviyo_sales_main.computed.campaign_bounce_rate |
Campaign Unique Clicked Rate from Klaviyo | klaviyo_sales_main.computed.campaign_unique_click_rate |
Campaign Unique Clicked Rate excluding Bots from Klaviyo | klaviyo_sales_main.computed.campaign_unique_click_rate_excl_bot |
Campaign Unique Opened Rate from Klaviyo | klaviyo_sales_main.computed.campaign_unique_open_rate |
Campaign Unique Recipients from Klaviyo | klaviyo_sales_main.computed.campaign_unique_recipients |
Campaign Unique Spam Rate from Klaviyo | klaviyo_sales_main.computed.campaign_spam_rate |
Campaign Unique Unsubscribed Rate from Klaviyo | klaviyo_sales_main.computed.campaign_unsubscribe_rate |
Flow Placed Order Rate from Klaviyo | klaviyo_sales_main.computed.flow_placed_order_rate |
Flow Revenue per Received Email from Klaviyo | klaviyo_sales_main.computed.flow_revenue_per_subscriber |
Flow Unique Bounced Rate from Klaviyo | klaviyo_sales_main.computed.flow_bounce_rate |
Flow Unique Clicked Rate from Klaviyo | klaviyo_sales_main.computed.flow_unique_click_rate |
Flow Unique Clicked Rate excluding Bots from Klaviyo | klaviyo_sales_main.computed.flow_unique_click_rate_excl_bot |
Flow Unique Opened Rate from Klaviyo | klaviyo_sales_main.computed.flow_unique_open_rate |
Flow Unique Recipients from Klaviyo | klaviyo_sales_main.computed.flow_unique_recipients |
Flow Unique Spam Rate from Klaviyo | klaviyo_sales_main.computed.flow_spam_rate |
Flow Unique Unsubscribed Rate from Klaviyo | klaviyo_sales_main.computed.flow_unsubscribe_rate |
Live Pixel Data
Metric Name | Metric Key |
Live Polar Pixel Orders from Live Pixel Data | live_pixel_attribution.raw.polar_pixel_live_orders |
Live Polar Pixel Sessions from Live Pixel Data | live_pixel_attribution.raw.polar_pixel_live_sessions |
Live Polar Pixel Conversions Rate from Live Pixel Data | live_pixel_attribution.computed.polar_pixel_live_conversions_rate |
Omnisend
Metric Name | Metric Key |
Campaign Complained from Omnisend | omnisend_campaigns.raw.campaign_complained |
Campaign Received Email from Omnisend | omnisend_campaigns.raw.campaign_send |
Campaign Unique Bounced Email from Omnisend | omnisend_campaigns.raw.campaign_unique_bounce |
Campaign Unique Clicked Email from Omnisend | omnisend_campaigns.raw.campaign_unique_click |
Campaign Unique Opened Email from Omnisend | omnisend_campaigns.raw.campaign_unique_open |
Campaign Unique Unsubscribed from Email Marketing from Omnisend | omnisend_campaigns.raw.campaign_unique_unsubscribe |
Pinterest Ads
Metric Name | Metric Key |
Clicks from Pinterest Ads | pinterestads_campaign.raw.clicks |
Impressions from Pinterest Ads | pinterestads_campaign.raw.impressions |
Outbound Clicks from Pinterest Ads | pinterestads_campaign.raw.outbound_clicks |
Spend from Pinterest Ads | pinterestads_campaign.raw.spend |
Total Conversions Checkout from Pinterest Ads | pinterestads_campaign.raw.total_conversions_checkout |
Total Order Value Checkout from Pinterest Ads | pinterestads_campaign.raw.total_order_value_checkout |
Average Purchase Value from Pinterest Ads | pinterestads_campaign.computed.avg_purchase_value |
Cost per Checkout Conversion from Pinterest Ads | pinterestads_campaign.computed.cost_per_checkout_conversion |
CPC from Pinterest Ads | pinterestads_campaign.computed.cpc |
CPC (Outbound) from Pinterest Ads | pinterestads_campaign.computed.cpc_outbound |
CPM from Pinterest Ads | pinterestads_campaign.computed.cpm |
CTR from Pinterest Ads | pinterestads_campaign.computed.ctr_rate |
CTR (Outbound) from Pinterest Ads | pinterestads_campaign.computed.ctr_outbound_rate |
Order Rate from Pinterest Ads | pinterestads_campaign.computed.order_rate |
Revenue per Click from Pinterest Ads | pinterestads_campaign.computed.revenue_per_click |
Revenue per Impression from Pinterest Ads | pinterestads_campaign.computed.revenue_per_impression |
ROAS from Pinterest Ads | pinterestads_campaign.computed.roas |
Recharge
Metric Name | Metric Key |
Active Customers Snapshot from Recharge | recharge_sales_products.raw.active_customers |
Churned Customers from Recharge | recharge_sales_products.raw.churned_customers |
Cost of Products (COGs) from Recharge | recharge_sales_products.raw.cost_of_products |
Discounts from Recharge | recharge_sales_products.raw.discounts |
Gross Sales from Recharge | recharge_sales_products.raw.gross_sales |
Net Product Quantity from Recharge | recharge_sales_products.raw.product_quantity |
New Discounts from Recharge | recharge_sales_products.raw.new_sub_discounts |
New Gross Sales from Recharge | recharge_sales_products.raw.new_sub_gross_sales |
New Returns from Recharge | recharge_sales_products.raw.new_sub_returns |
New Shipping from Recharge | recharge_sales_products.raw.new_sub_shipping |
New Subscriptions from Recharge | recharge_sales_products.raw.new_subscriptions |
New Subscriptions Cost of Products from Recharge | recharge_sales_products.raw.new_sub_cost_of_products |
New Tax from Recharge | recharge_sales_products.raw.new_sub_tax |
Product Price from Recharge | recharge_sales_products.raw.product_price |
Returns from Recharge | recharge_sales_products.raw.returns |
Shipping from Recharge | recharge_sales_products.raw.shipping |
Shipping Pre Refunds from Recharge | recharge_sales_products.raw.shipping_pre_refunds |
Shipping Refunds from Recharge | recharge_sales_products.raw.shipping_refunds |
Tax from Recharge | recharge_sales_products.raw.tax |
Tax Pre Refunds from Recharge | recharge_sales_products.raw.tax_pre_refunds |
Tax Refunds from Recharge | recharge_sales_products.raw.tax_refunds |
Total Active Subscribers from Recharge | recharge_sales_products.raw.total_active_customers |
Total Active Subscriptions from Recharge | recharge_sales_products.raw.total_active_subscriptions |
Total Customers from Recharge | recharge_sales_products.raw.total_customers |
Total Subscriptions from Recharge | recharge_sales_products.raw.total_subscriptions |
Average Charge Value from Recharge | recharge_sales_products.computed.avg_order_value |
Churned Sales from Recharge | recharge_sales_products.computed.churned_sales |
Churned Subscriptions from Recharge | recharge_sales_products.computed.churned_subscriptions |
Gross Margin from Recharge | recharge_sales_products.computed.gross_margin |
Gross Profit from Recharge | recharge_sales_products.computed.gross_profit |
Net Sales from Recharge | recharge_sales_products.computed.net_sales |
New Sales from Recharge | recharge_sales_products.computed.new_sales |
Total Charges from Recharge | recharge_sales_products.computed.total_charges |
Total Sales from Recharge | recharge_sales_products.computed.total_sales |
Shopify
Metric Name | Metric Key |
Average time between orders (days) from Shopify | shopify_sales_main.raw.days_between_orders |
Average time between orders (hours) from Shopify | shopify_sales_main.raw.hours_between_orders |
Cart Sessions (Legacy Shopify Plus) from Shopify | shopify_sales_main.raw.cart_sessions |
Checkout Sessions (Legacy Shopify Plus) from Shopify | shopify_sales_main.raw.checkout_sessions |
Compare At Price from Shopify | shopify_sales_main.raw.compare_at_price |
Cost of Products (COGs) from Shopify | shopify_sales_main.raw.cost_of_products |
Cost of Products (GSheet Only) from Shopify | shopify_sales_main.raw.cost_of_products_custom |
Current Inventory Quantity (Snapshot) from Shopify | shopify_sales_main.raw.inventory_quantity |
Days in range from Shopify | shopify_sales_main.raw.days_in_range |
Discounts from Shopify | shopify_sales_main.raw.discounts |
Expenses from Shopify | shopify_sales_main.raw.expenses |
Gross Sales from Shopify | shopify_sales_main.raw.gross_sales |
Net Product Quantity from Shopify | shopify_sales_main.raw.product_quantity |
New Cost of Products from Shopify | shopify_sales_main.raw.new_cost_of_products |
New Customer Orders from Shopify | shopify_sales_main.raw.new_customer_orders |
New Customers from Shopify | shopify_sales_main.raw.new_customers |
New Discounts from Shopify | shopify_sales_main.raw.new_discounts |
New Gross Sales from Shopify | shopify_sales_main.raw.new_gross_sales |
New Returns from Shopify | shopify_sales_main.raw.new_returns |
New Shipping from Shopify | shopify_sales_main.raw.new_shipping |
New Shipping Pre Refunds from Shopify | shopify_sales_main.raw.new_shipping_pre_refunds |
New Tax from Shopify | shopify_sales_main.raw.new_tax |
New Tax Pre Refunds from Shopify | shopify_sales_main.raw.new_tax_pre_refunds |
New Tips from Shopify | shopify_sales_main.raw.new_tips |
New Total Costs from Shopify | shopify_sales_main.raw.new_total_costs |
Polar Pixel Add to Cart Sessions from Shopify | shopify_sales_main.raw.polar_pixel_funnel_product_added_to_cart_sessions |
Polar Pixel Average Converted Journey Duration (days) from Shopify | shopify_sales_main.raw.polar_pixel_converted_journey_duration |
Polar Pixel Bounces from Shopify | shopify_sales_main.raw.polar_pixel_bounces |
Polar Pixel Checkout Completed Sessions from Shopify | shopify_sales_main.raw.polar_pixel_funnel_checkout_completed_sessions |
Polar Pixel Checkout Started Sessions from Shopify | shopify_sales_main.raw.polar_pixel_funnel_checkout_started_sessions |
Polar Pixel Conversions from Shopify | shopify_sales_main.raw.polar_pixel_conversions |
Polar Pixel Journeys from Shopify | shopify_sales_main.raw.polar_pixel_journeys |
Polar Pixel Page Viewed Sessions from Shopify | shopify_sales_main.raw.polar_pixel_funnel_sessions |
Polar Pixel Page Views from Shopify | shopify_sales_main.raw.polar_pixel_pageviews |
Polar Pixel Product Viewed Sessions from Shopify | shopify_sales_main.raw.polar_pixel_funnel_product_viewed_sessions |
Polar Pixel Sessions from Shopify | shopify_sales_main.raw.polar_pixel_sessions |
Polar Pixel Sessions Converted from Shopify | shopify_sales_main.raw.polar_pixel_sessions_converted |
Polar Pixel Unique Users from Shopify | shopify_sales_main.raw.polar_pixel_traffic |
Product Quantity from Shopify | shopify_sales_main.raw.net_product_quantity |
Purchase Sessions (Legacy Shopify Plus) from Shopify | shopify_sales_main.raw.purchase_sessions |
Quantity Added To Cart (Legacy Shopify Plus) from Shopify | shopify_sales_main.raw.quantity_added_to_cart |
Repeat Cost of Products from Shopify | shopify_sales_main.raw.repeat_cost_of_products |
Repeat Customer Orders from Shopify | shopify_sales_main.raw.repeat_customer_orders |
Repeat Customers from Shopify | shopify_sales_main.raw.repeat_customers |
Repeat Discounts from Shopify | shopify_sales_main.raw.repeat_discounts |
Repeat Gross Sales from Shopify | shopify_sales_main.raw.repeat_gross_sales |
Repeat Returns from Shopify | shopify_sales_main.raw.repeat_returns |
Repeat Shipping from Shopify | shopify_sales_main.raw.repeat_shipping |
Repeat Shipping Pre Refunds from Shopify | shopify_sales_main.raw.repeat_shipping_pre_refunds |
Repeat Tax from Shopify | shopify_sales_main.raw.repeat_tax |
Repeat Tax Pre Refunds from Shopify | shopify_sales_main.raw.repeat_tax_pre_refunds |
Repeat Tips from Shopify | shopify_sales_main.raw.repeat_tips |
Repeat Total Costs from Shopify | shopify_sales_main.raw.repeat_total_costs |
Returned Orders from Shopify | shopify_sales_main.raw.returned_orders |
Returned Product Quantity from Shopify | shopify_sales_main.raw.returned_product_quantity |
Returns from Shopify | shopify_sales_main.raw.returns |
Sale Agreement Count from Shopify | shopify_sales_main.raw.sales_agreement_count |
Shipping from Shopify | shopify_sales_main.raw.shipping |
Shipping Pre Refunds from Shopify | shopify_sales_main.raw.shipping_pre_refunds |
Shipping Refunds from Shopify | shopify_sales_main.raw.shipping_refunds |
Tax from Shopify | shopify_sales_main.raw.tax |
Tax Pre Refunds from Shopify | shopify_sales_main.raw.tax_pre_refunds |
Tax Refunds from Shopify | shopify_sales_main.raw.tax_refunds |
Tips from Shopify | shopify_sales_main.raw.tips |
Total Compare at Price from Shopify | shopify_sales_main.raw.total_compare_at_price |
Total Costs from Shopify | shopify_sales_main.raw.total_costs |
Total Customers from Shopify | shopify_sales_main.raw.total_customers |
Total Duties from Shopify | shopify_sales_main.raw.total_duties |
Total Orders from Shopify | shopify_sales_main.raw.total_orders |
Total Purchase Price from Shopify | shopify_sales_main.raw.total_purchase_price |
Total Refunds from Shopify | shopify_sales_main.raw.total_refunds |
Transaction Fees from Shopify | shopify_sales_main.raw.transaction_fees |
View Sessions (Legacy Shopify Plus) from Shopify | shopify_sales_main.raw.view_sessions |
30 Day Cost of products from Shopify | shopify_sales_main.raw.cost_of_products_thirtyd |
30 Day Customers from Shopify | shopify_sales_main.raw.customers_thirtyd |
30 Day Discounts from Shopify | shopify_sales_main.raw.discounts_thirtyd |
30 Day Gross Sales from Shopify | shopify_sales_main.raw.gross_sales_thirtyd |
30 Day Orders from Shopify | shopify_sales_main.raw.orders_thirtyd |
30 Day Returns from Shopify | shopify_sales_main.raw.returns_thirtyd |
30 Day Shipping from Shopify | shopify_sales_main.raw.shipping_thirtyd |
30 Day Tax from Shopify | shopify_sales_main.raw.tax_thirtyd |
30 Day Tips from Shopify | shopify_sales_main.raw.tips_thirtyd |
30 Day Total Costs from Shopify | shopify_sales_main.raw.total_costs_thirtyd |
60 Day Cost of products from Shopify | shopify_sales_main.raw.cost_of_products_sixtyd |
60 Day Customers from Shopify | shopify_sales_main.raw.customers_sixtyd |
60 Day Discounts from Shopify | shopify_sales_main.raw.discounts_sixtyd |
60 Day Gross Sales from Shopify | shopify_sales_main.raw.gross_sales_sixtyd |
60 Day Orders from Shopify | shopify_sales_main.raw.orders_sixtyd |
60 Day Returns from Shopify | shopify_sales_main.raw.returns_sixtyd |
60 Day Shipping from Shopify | shopify_sales_main.raw.shipping_sixtyd |
60 Day Tax from Shopify | shopify_sales_main.raw.tax_sixtyd |
60 Day Tips from Shopify | shopify_sales_main.raw.tips_sixtyd |
60 Day Total Costs from Shopify | shopify_sales_main.raw.total_costs_sixtyd |
90 Day Cost of products from Shopify | shopify_sales_main.raw.cost_of_products_ninetyd |
90 Day Customers from Shopify | shopify_sales_main.raw.customers_ninetyd |
90 Day Discounts from Shopify | shopify_sales_main.raw.discounts_ninetyd |
90 Day Gross Sales from Shopify | shopify_sales_main.raw.gross_sales_ninetyd |
90 Day Orders from Shopify | shopify_sales_main.raw.orders_ninetyd |
90 Day Returns from Shopify | shopify_sales_main.raw.returns_ninetyd |
90 Day Shipping from Shopify | shopify_sales_main.raw.shipping_ninetyd |
90 Day Tax from Shopify | shopify_sales_main.raw.tax_ninetyd |
90 Day Tips from Shopify | shopify_sales_main.raw.tips_ninetyd |
90 Day Total Costs from Shopify | shopify_sales_main.raw.total_costs_ninetyd |
180 Day Cost of products from Shopify | shopify_sales_main.raw.cost_of_products_oneeightyd |
180 Day Customers from Shopify | shopify_sales_main.raw.customers_oneeightyd |
180 Day Discounts from Shopify | shopify_sales_main.raw.discounts_oneeightyd |
180 Day Gross Sales from Shopify | shopify_sales_main.raw.gross_sales_oneeightyd |
180 Day Orders from Shopify | shopify_sales_main.raw.orders_oneeightyd |
180 Day Returns from Shopify | shopify_sales_main.raw.returns_oneeightyd |
180 Day Shipping from Shopify | shopify_sales_main.raw.shipping_oneeightyd |
180 Day Tax from Shopify | shopify_sales_main.raw.tax_oneeightyd |
180 Day Tips from Shopify | shopify_sales_main.raw.tips_oneeightyd |
180 Day Total Costs from Shopify | shopify_sales_main.raw.total_costs_oneeightyd |
360 Day Cost of products from Shopify | shopify_sales_main.raw.cost_of_products_threesixtyd |
360 Day Customers from Shopify | shopify_sales_main.raw.customers_threesixtyd |
360 Day Discounts from Shopify | shopify_sales_main.raw.discounts_threesixtyd |
360 Day Gross Sales from Shopify | shopify_sales_main.raw.gross_sales_threesixtyd |
360 Day Orders from Shopify | shopify_sales_main.raw.orders_threesixtyd |
360 Day Returns from Shopify | shopify_sales_main.raw.returns_threesixtyd |
360 Day Shipping from Shopify | shopify_sales_main.raw.shipping_threesixtyd |
360 Day Tax from Shopify | shopify_sales_main.raw.tax_threesixtyd |
360 Day Tips from Shopify | shopify_sales_main.raw.tips_threesixtyd |
360 Day Total Costs from Shopify | shopify_sales_main.raw.total_costs_threesixtyd |
% Returns from Shopify | shopify_sales_main.computed.percentage_returns |
Average Order Value from Shopify | shopify_sales_main.computed.avg_order_value |
Average Product Quantity per Order from Shopify | shopify_sales_main.computed.quantity_per_order |
CM1 from Shopify | shopify_sales_main.computed.contribution_margin_1 |
CM1 % from Shopify | shopify_sales_main.computed.contribution_margin_1_ratio |
CM2 from Shopify | shopify_sales_main.computed.contribution_margin_2 |
CM2 % from Shopify | shopify_sales_main.computed.contribution_margin_2_ratio |
Gross Margin from Shopify | shopify_sales_main.computed.gross_margin |
Gross Margin (net of expenses) from Shopify | shopify_sales_main.computed.gross_margin_net_of_expenses |
Gross Profit from Shopify | shopify_sales_main.computed.gross_profit |
Gross Profit (net of expenses) from Shopify | shopify_sales_main.computed.gross_profit_net_of_expenses |
LTV from Shopify | shopify_sales_main.computed.ltv |
Net Profit from Shopify | shopify_sales_main.computed.net_profit |
Net Sales from Shopify | shopify_sales_main.computed.net_sales |
New Average Order Value from Shopify | shopify_sales_main.computed.new_avg_order_value |
New Customer % from Shopify | shopify_sales_main.computed.new_customer_rate |
New Sales from Shopify | shopify_sales_main.computed.new_sales |
New Sales % from Shopify | shopify_sales_main.computed.new_sales_rate |
Polar Pixel Add to Cart Sessions % from Shopify | shopify_sales_main.computed.polar_pixel_funnel_product_added_to_cart_sessions_rate |
Polar Pixel Average Journey Duration (days) from Shopify | shopify_sales_main.computed.polar_pixel_avg_journey_duration |
Polar Pixel Average Session Duration from Shopify | shopify_sales_main.computed.polar_pixel_avg_session_duration |
Polar Pixel Bounce Rate from Shopify | shopify_sales_main.computed.polar_pixel_bounce_rate |
Polar Pixel Checkout Completed Sessions % from Shopify | shopify_sales_main.computed.polar_pixel_funnel_checkout_completed_sessions_rate |
Polar Pixel Checkout Started Sessions % from Shopify | shopify_sales_main.computed.polar_pixel_funnel_checkout_started_sessions_rate |
Polar Pixel Conversion Value from Shopify | shopify_sales_main.computed.pixel_gross_sales |
Polar Pixel ncConversion Value from Shopify | shopify_sales_main.computed.pixel_nc_gross_sales |
Polar Pixel ncConversions from Shopify | shopify_sales_main.computed.pixel_nc_orders |
Polar Pixel Paid Conversion Value from Shopify | shopify_sales_main.computed.pixel_paid_gross_sales |
Polar Pixel Paid Conversions from Shopify | shopify_sales_main.computed.pixel_paid_total_orders |
Polar Pixel Paid ncConversion Value from Shopify | shopify_sales_main.computed.pixel_paid_nc_gross_sales |
Polar Pixel Paid ncConversions from Shopify | shopify_sales_main.computed.pixel_paid_nc_orders |
Polar Pixel Product Viewed Sessions % from Shopify | shopify_sales_main.computed.polar_pixel_funnel_product_viewed_sessions_rate |
Purchase Frequency from Shopify | shopify_sales_main.computed.purchase_frequency |
Repeat Average Order Value from Shopify | shopify_sales_main.computed.repeat_avg_order_value |
Repeat Customer % from Shopify | shopify_sales_main.computed.repeat_customer_rate |
Repeat Sales from Shopify | shopify_sales_main.computed.repeat_sales |
Repeat Sales % from Shopify | shopify_sales_main.computed.repeat_sales_rate |
Total Sales from Shopify | shopify_sales_main.computed.total_sales |
30 Day Gross Profit from Shopify | shopify_sales_main.computed.gross_profit_thirtyd |
30 Day LTV from Shopify | shopify_sales_main.computed.ltv_thirtyd |
30 Day Net Sales from Shopify | shopify_sales_main.computed.net_sales_thirtyd |
30 Day Total Sales from Shopify | shopify_sales_main.computed.total_sales_thirtyd |
60 Day Gross Profit from Shopify | shopify_sales_main.computed.gross_profit_sixtyd |
60 Day LTV from Shopify | shopify_sales_main.computed.ltv_sixtyd |
60 Day Net Sales from Shopify | shopify_sales_main.computed.net_sales_sixtyd |
60 Day Total Sales from Shopify | shopify_sales_main.computed.total_sales_sixtyd |
90 Day Gross Profit from Shopify | shopify_sales_main.computed.gross_profit_ninetyd |
90 Day LTV from Shopify | shopify_sales_main.computed.ltv_ninetyd |
90 Day Net Sales from Shopify | shopify_sales_main.computed.net_sales_ninetyd |
90 Day Total Sales from Shopify | shopify_sales_main.computed.total_sales_ninetyd |
180 Day Gross Profit from Shopify | shopify_sales_main.computed.gross_profit_oneeightyd |
180 Day LTV from Shopify | shopify_sales_main.computed.ltv_oneeightyd |
180 Day Net Sales from Shopify | shopify_sales_main.computed.net_sales_oneeightyd |
180 Day Total Sales from Shopify | shopify_sales_main.computed.total_sales_oneeightyd |
360 Day Gross Profit from Shopify | shopify_sales_main.computed.gross_profit_threesixtyd |
360 Day LTV from Shopify | shopify_sales_main.computed.ltv_threesixtyd |
360 Day Net Sales from Shopify | shopify_sales_main.computed.net_sales_threesixtyd |
360 Day Total Sales from Shopify | shopify_sales_main.computed.total_sales_threesixtyd |
Snapchat Ads
Metric Name | Metric Key |
Adds to Cart from Snapchat Ads | snapchatads_campaign_and_device.raw.adds_to_cart |
Android Installs from Snapchat Ads | snapchatads_campaign_and_device.raw.android_installs |
Checkouts Started from Snapchat Ads | snapchatads_campaign_and_device.raw.checkouts_started |
Impressions from Snapchat Ads | snapchatads_campaign_and_device.raw.impressions |
iOS Installs from Snapchat Ads | snapchatads_campaign_and_device.raw.ios_installs |
Purchases from Snapchat Ads | snapchatads_campaign_and_device.raw.purchases |
Purchases Conversion Value from Snapchat Ads | snapchatads_campaign_and_device.raw.purchases_conversion_value |
Searches from Snapchat Ads | snapchatads_campaign_and_device.raw.searches |
Shares from Snapchat Ads | snapchatads_campaign_and_device.raw.shares |
Spend from Snapchat Ads | snapchatads_campaign_and_device.raw.spend |
Story Completness from Snapchat Ads | snapchatads_campaign_and_device.raw.story_completes |
Story Opens from Snapchat Ads | snapchatads_campaign_and_device.raw.story_opens |
Swipes from Snapchat Ads | snapchatads_campaign_and_device.raw.swipes |
Total Installs from Snapchat Ads | snapchatads_campaign_and_device.raw.total_installs |
Video Views from Snapchat Ads | snapchatads_campaign_and_device.raw.video_views |
Average Purchase Value from Snapchat Ads | snapchatads_campaign_and_device.computed.avg_purchase_value |
Cost per Add to Cart from Snapchat Ads | snapchatads_campaign_and_device.computed.cost_per_add_to_cart |
Cost per Initiate Checkout from Snapchat Ads | snapchatads_campaign_and_device.computed.cost_per_initiate_checkout |
Cost per Purchase from Snapchat Ads | snapchatads_campaign_and_device.computed.cost_per_purchase |
CPM from Snapchat Ads | snapchatads_campaign_and_device.computed.cpm |
Revenue per Impression from Snapchat Ads | snapchatads_campaign_and_device.computed.revenue_per_impression |
ROAS from Snapchat Ads | snapchatads_campaign_and_device.computed.roas |
TikTok Ads
Metric Name | Metric Key |
Clicks from Tiktok Ads | tiktokads_campaign_and_platform.raw.clicks |
Conversions from Tiktok Ads | tiktokads_campaign_and_platform.raw.conversions |
Follows from Tiktok Ads | tiktokads_campaign_and_platform.raw.follows |
Impressions from Tiktok Ads | tiktokads_campaign_and_platform.raw.impressions |
Purchases from Tiktok Ads | tiktokads_campaign_and_platform.raw.purchases |
Purchases Conversion Value from Tiktok Ads | tiktokads_campaign_and_platform.raw.purchases_conversion_value |
Results from Tiktok Ads | tiktokads_campaign_and_platform.raw.results |
Spend from Tiktok Ads | tiktokads_campaign_and_platform.raw.spend |
Cost per Conversion from Tiktok Ads | tiktokads_campaign_and_platform.computed.cost_per_conversion |
Cost per Follow from Tiktok Ads | tiktokads_campaign_and_platform.computed.cost_per_follow |
Cost per Result from Tiktok Ads | tiktokads_campaign_and_platform.computed.cost_per_result |
CPC from Tiktok Ads | tiktokads_campaign_and_platform.computed.cpc |
CPM from Tiktok Ads | tiktokads_campaign_and_platform.computed.cpm |
CTR from Tiktok Ads | tiktokads_campaign_and_platform.computed.ctr_rate |
Order Rate from Tiktok Ads | tiktokads_campaign_and_platform.computed.order_rate |
ROAS from Tiktok Ads | tiktokads_campaign_and_platform.computed.roas |
Yotpo
Metric Name | Metric Key |
Average Star Rating from Yotpo | yotpo_reviews.raw.avg_star_rating |
Total Reviews from Yotpo | yotpo_reviews.raw.total_reviews |