What is the Product Performance Dashboard?

The Product Performance dashboard gives you a comprehensive view of how every product in your catalog is performing — combining Shopify sales data with ad spend data from Meta Ads and Google Ads. It helps you identify your hero products, spot budget wasters, and find untapped potential.

This dashboard is available under Product > Product Performance in the sidebar. Product Performance is a Pro plan feature.

How It Works

Datadrew blends data from multiple sources to give you a unified view:

Shopify — Orders, revenue, units sold, customers, and average selling price per product
Meta Ads — Ad spend, CPC, CPM, CTR, clicks, and impressions attributed to each product (when connected)
Google Ads — Ad spend, CPC, CPM, CTR, clicks, impressions, conversions, and conversion value per product (when connected)
Blended Catalog ROAS — A unified return on ad spend metric that combines revenue from Shopify with blended ad spend from all connected platforms

Dashboard Components

Scatter Plot

A visual chart plotting each product by Revenue (Y-axis) vs. Blended Catalog Ad Spend (X-axis). This makes it easy to spot products in different quadrants:

Top-right — High revenue and high ad spend (potential heroes or wasters depending on ROAS)
Top-left — High revenue with low ad spend (organic winners)
Bottom-right — Low revenue with high ad spend (budget wasters)
Bottom-left — Low revenue and low ad spend (potential products to test)

Product Table

A detailed table with every product, showing all available metrics. The table supports:

Search — Find products by name or product ID
Column visibility — Show or hide columns to focus on the metrics that matter to you
Column filters — Filter rows by metric thresholds (e.g., show only products with ROAS greater than 3x)
Sorting — Sort by any column to rank products
Pagination — Navigate through large catalogs

Catalog Summary

Below the table, a summary row shows aggregate totals for your entire catalog — total revenue, total ad spend, and blended ROAS across all products.

Dashboard Controls

Time Period — Set the date range for analysis.
Breakdown By — View data by Product Title, Product Type, or Vendor.
Filters — Refine results by product type, vendor, tags, and more.
Column Preferences — Your column visibility choices are saved automatically and persist across sessions.

Key Metrics Explained

Metric	Description
Blended Catalog ROAS	Product revenue divided by total ad spend (Meta + Google). Higher is better. "Non-ad-driven" means the product generated revenue without any attributed ad spend.
Blended Catalog Spend	Total combined ad spend from Meta and Google Ads for this product.
Net Revenue	Total revenue from Shopify orders for this product.
Orders	Total number of orders containing this product.
Units Sold	Total quantity of this product sold.
Avg Selling Price	Average price per unit of this product.

Product Insights (Requires Ad Connections)

When you have Meta Ads and/or Google Ads connected, Datadrew automatically categorizes your products into three groups:

Hero Products — High revenue and high ROAS. These are your best performers — scale ad spend on these.
Ad Spend Wasters — High ad spend but low ROAS. Review and optimize or pause campaigns for these products.
Potential Products — Low ad spend but high ROAS. These are underinvested — consider increasing budget allocation.

Exporting Data

Click the export button to download your product performance data as CSV or XLSX. The export respects your current column visibility and applied filters.

Need help? Contact us at support@datadrew.io or use the in-app chat.