What is the Creative Strategy Dashboard?

The Creative Strategy feature in Datadrew combines product-level ad performance data with creative analysis to help you understand how your ad creatives perform at the product level. By connecting your Meta Ads and Google Ads accounts, you can see which creatives drive the best ROAS and which are wasting budget.

Creative Strategy insights are surfaced through the Product Performance dashboard and through Drew AI, your AI analytics assistant. This is a Pro plan feature.

How It Works

When you connect Meta Ads and/or Google Ads to Datadrew, the platform automatically:

Pulls ad spend, impressions, clicks, CPC, CPM, and CTR data at the product level
Matches this data with your Shopify revenue by product
Calculates a Blended Catalog ROAS for each product — combining all ad platform spend against Shopify revenue
Categorizes products into Hero Products, Ad Spend Wasters, and Potential Products based on their ROAS relative to your store average

Key Metrics for Creative Analysis

Metric	Source	What It Tells You
Meta Ads Spend	Meta Ads	How much you spent on Meta ads for this product
Meta Ads CPC	Meta Ads	Cost per click — lower is generally better
Meta Ads CPM	Meta Ads	Cost per 1,000 impressions — indicates creative competitiveness
Meta Ads CTR	Meta Ads	Click-through rate — higher CTR suggests more engaging creative
Google Ads Spend	Google Ads	How much you spent on Google ads for this product
Google Ads CPC	Google Ads	Cost per click on Google
Google Ads CTR	Google Ads	Click-through rate on Google
Google Ads Conversions	Google Ads	Number of conversions attributed to this product
Blended Catalog ROAS	Calculated	Revenue / Total Ad Spend — the ultimate creative efficiency metric

Using the Product Performance Dashboard for Creative Strategy

Open the Product Performance dashboard and ensure your Meta Ads and/or Google Ads are connected. You will see ad metrics columns appear in the product table.

Identifying Creative Winners

Sort by Meta Ads CTR (descending) to find products with the most engaging Meta creatives
Sort by Blended Catalog ROAS (descending) to find your most efficient ad-to-revenue products
Use column filters to show only products with CTR above a threshold (e.g., greater than 2%)

Identifying Creative Losers

Filter for products with high ad spend but low ROAS — these are your budget wasters
Products with low CTR and high CPM need creative refreshes — the platform is charging more because the creative is not resonating

Using Drew AI for Creative Insights

Ask Drew AI questions like:

"Which products have the highest CTR on Meta Ads?"
"Show me products where we are spending the most on Google Ads but getting low ROAS"
"Compare Meta and Google Ads performance for my top 10 products"
"What products should I pause ads on based on ROAS?"

Drew AI can query your live ad platform data and provide instant, conversational answers with charts and tables.

Actions to Take

Double down on creatives for Hero Products — increase budgets where ROAS is strong
Refresh or pause creatives for products with declining CTR and rising CPM
Test new creatives for Potential Products (high ROAS but low spend) — these have room to scale
Use the product-type breakdown to see which product categories perform best on each ad platform
Compare Meta vs. Google Ads metrics side by side to determine which platform is more efficient for each product

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