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.
Related articles
- Facebook/Meta Ads dashboard
- Google Ads dashboard
- Campaign-level analysis and ROAS tracking
- Product Performance dashboard
Need help?
If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.