Home Marketing & Ads Dashboards

Marketing & Ads Dashboards

By Vikas Bansal

• 7 articles

Hourly Performance dashboard (Pro)

What this dashboard shows The Hourly Performance dashboard gives you a real-time, hour-by-hour view of your store's performance. While the standard dashboards show daily aggregates, this dashboard breaks down revenue, orders, ad spend, and traffic by the hour — making it invaluable during high-stakes periods like product launches, flash sales, or Black Friday/Cyber Monday. This dashboard is available on the Pro plan and above. If you are on the Free or Starter plan, you will see an upgrade prompt when accessing this page. Dashboard sections The Hourly Performance dashboard includes several focused sections: 1. Hourly Summary — Top-level metrics (revenue, orders, spend, sessions) for the selected date with hour-by-hour trend lines. 2. Channel Performance — Break down hourly performance by ad channel (Meta Ads, Google Ads) to see when each platform drives the most results. 3. Revenue vs. Spend — A combined chart showing hourly revenue alongside hourly ad spend, so you can see the relationship between investment and returns in real time. 4. GA4 Sessions — Hourly website session data from Google Analytics, showing when your store gets the most traffic. 5. Blended ROAS — Hourly ROAS calculation so you can see how advertising efficiency fluctuates throughout the day. 6. Orders — Hourly order volume to identify peak purchasing hours. 7. Performance Table — A detailed hour-by-hour table with all key metrics for easy scanning and comparison. 8. Top Products — Products generating the most revenue during the selected period, with hourly detail. 9. Top Categories — Product categories driving the most sales, broken down by hour. Key metrics available | | | | --- | --- | | Metric | Definition | | Hourly Revenue | Shopify revenue for each hour of the selected date. | | Hourly Orders | Number of Shopify orders placed each hour. | | Hourly Ad Spend | Combined Meta + Google ad spend per hour. | | Hourly Sessions | Website sessions from GA4 per hour. | | Hourly ROAS | Revenue / Ad Spend calculated per hour. | | Revenue per Hour | Average revenue generated each hour during the period. | How to use this dashboard 1. During sales events: Monitor revenue, orders, and traffic in real time. See which hours generate the most sales and whether your ad spend is aligned with peak traffic times. 2. Ad scheduling optimization: Identify the hours when your ROAS is highest. Consider adjusting your ad delivery schedules to concentrate spend during peak conversion hours. 3. Staffing decisions: If customer support or order fulfillment needs vary by hour, use this data to plan team schedules around peak activity times. 4. Product launch monitoring: During a new product launch, track hour-by-hour performance to gauge initial reception and adjust marketing in real time. 5. Compare days: Use the date picker to compare a sale day against a normal day and see how performance patterns differ by hour. Top Products and Categories The bottom sections of the dashboard show which products and product categories are performing best during the selected period. This helps you: - Identify which products are driving revenue during peak hours. - Spot trending products in real time during sales events. - Understand category-level performance patterns throughout the day. Data freshness Hourly data is updated more frequently than daily dashboards. Shopify order data is available within a few hours of the order being placed. Ad platform data (Meta and Google) may have slightly longer delays, typically 3-6 hours, depending on the platform's reporting API. Requirements - Pro plan or above is required to access this dashboard. - Connect Shopify (automatic with app installation) for order and revenue data. - Connect Meta Ads and/or Google Ads for hourly ad spend and performance data. - Connect Google Analytics 4 for hourly session and traffic data. Tips and best practices - Use this dashboard most actively during high-traffic events — BFCM, flash sales, product launches, and seasonal promotions. The value of hourly data is highest when you can act on it quickly. - Combine hourly data with Drew AI. Ask questions like "What were my peak revenue hours yesterday?" or "Compare today's hourly performance to last Saturday." - Look for patterns across multiple days. If your store consistently sees peak orders between 7-9 PM, optimize your ad delivery and email send times accordingly. - If you see high sessions but low revenue during certain hours, investigate whether those hours bring lower-quality traffic or if there is a site performance issue during high-traffic periods. Need help? If you have questions about the Hourly Performance dashboard or need help upgrading to Pro, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Blended Ads Summary — unified ad performance - Campaign-level analysis and ROAS tracking - Feature comparison across plans - Store Performance dashboard overview

Last updated on Jul 07, 2026

Understanding blended metrics

What are blended metrics? Blended metrics combine data from multiple advertising platforms and your Shopify store into unified calculations. Instead of viewing Meta Ads and Google Ads performance separately, blended metrics give you a single, cross-channel view of your total marketing efficiency. This is important because most Shopify merchants advertise on multiple platforms. Looking at each platform in isolation gives you an incomplete picture — and platforms tend to over-attribute conversions to themselves. Blended metrics use your actual Shopify data as the source of truth for revenue and customer acquisition. Blended metrics reference | | | | | --- | --- | --- | | Metric | Formula | What it tells you | | Blended Spend | Google Ads Cost + Meta Ads Spend | Your total investment in paid advertising across all connected platforms. | | Blended Impressions | Google Ads Impressions + Meta Ads Impressions | Total number of times your ads were shown across all platforms. | | Blended Clicks | Google Ads Clicks + Meta Ads Clicks | Total traffic driven by all your paid campaigns. | | Blended CTR | (Blended Clicks / Blended Impressions) x 100 | Overall ad engagement rate across platforms. Useful for tracking changes in ad effectiveness over time. | | Blended CPC | Blended Spend / Blended Clicks | Average cost per click across all platforms. Helps you understand your overall traffic acquisition cost. | | Blended CPM | (Blended Spend / Blended Impressions) x 1,000 | Cost per thousand impressions across all platforms. Reflects overall audience reach efficiency. | | Blended ROAS | Shopify Total Revenue / Blended Spend | The most important blended metric. Uses your actual Shopify revenue (not platform-reported conversions) divided by total ad spend. This gives you the true return on your advertising investment. | | Blended CAC | Blended Spend / Shopify New Customer Count | Customer Acquisition Cost calculated using total ad spend and actual new customers from Shopify. Tells you how much it costs to acquire each new customer through paid channels. | | Blended Conversions | Google Ads Conversions + Meta Ads Website Purchases | Total platform-reported conversions. Note: this uses platform attribution and may double-count some purchases. | | MER (Marketing Efficiency Ratio) | Shopify Total Revenue / Blended Spend | Same calculation as Blended ROAS, sometimes referred to as MER in industry terminology. A MER of 5 means you earn $5 in revenue for every $1 spent on ads. | Why blended metrics matter The attribution problem Each ad platform has its own attribution model and claims credit for conversions based on its own rules: - Meta Ads attributes a purchase if someone clicked an ad within 7 days or viewed an ad within 1 day before purchasing. - Google Ads attributes conversions based on its own conversion tracking and attribution settings. - Both platforms can claim the same purchase, meaning platform-reported ROAS totals are inflated. How blended metrics solve this Blended ROAS and Blended CAC use your Shopify store as the source of truth: - Revenue comes from Shopify — actual orders, actual revenue. No attribution guessing. - New customers come from Shopify — first-time buyers based on complete order history. - Spend comes from the ad platforms — your actual investment. This combination gives you the most honest picture of your marketing efficiency. How to interpret blended metrics - Blended ROAS of 3x-5x is generally healthy for DTC e-commerce brands, but this varies by margin structure. If your gross margins are 70%, a 2x ROAS may be profitable. If margins are 30%, you may need 5x or higher. - Blended CAC should be lower than your LTV. Compare your Blended CAC to the customer lifetime value shown in Datadrew's Cohort Analysis dashboard. A healthy LTV-to-CAC ratio is typically 3:1 or better. - Blended CPC trends tell you about market competition. Rising CPC across both platforms usually means more advertisers are competing for your audience. - Platform ROAS vs. Blended ROAS gap: If the sum of Meta ROAS and Google ROAS is much higher than your Blended ROAS, there is significant attribution overlap. This is normal and expected. Blended metrics vs. platform metrics: when to use each | | | | --- | --- | | Use case | Which metric to use | | Evaluating overall marketing efficiency | Blended ROAS, Blended CAC | | Deciding total marketing budget | Blended ROAS, MER | | Optimizing a specific Meta campaign | Meta platform ROAS, Meta CPC | | Optimizing Google Shopping bids | Google Ads ROAS, Google Cost per Conversion | | Reporting to stakeholders | Blended ROAS (most accurate for business-level reporting) | | Comparing channel efficiency | Platform-specific Cost per Conversion side by side | Need help? If you have questions about blended metrics or how they are calculated, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Blended Ads Summary — unified ad performance - Campaign-level analysis and ROAS tracking - Understanding metrics and KPI definitions - Cross-channel marketing analysis

Last updated on Jul 07, 2026

Campaign-level analysis and ROAS tracking

What this dashboard shows The Campaign-level Analysis view lets you drill into the performance of individual advertising campaigns across Meta (Facebook) Ads and Google Ads. While the Blended Ads Summary gives you the big picture, campaign-level analysis helps you identify which specific campaigns are driving results and which ones need optimization. Campaign-level metrics Each campaign row in the performance table shows: | | | | --- | --- | | Metric | What to look for | | Campaign Name | The name of the campaign as it appears in Meta Ads Manager or Google Ads. | | Spend | Total budget consumed by this campaign. Are you allocating spend to your best performers? | | Impressions | How many times ads in this campaign were shown. Low impressions may mean budget constraints or narrow targeting. | | Clicks | Total traffic driven by this campaign. | | CTR | Click-through rate. Compare across campaigns to identify which creative and targeting combinations resonate most. | | CPC | Cost per click. Higher CPC campaigns need stronger conversion rates to remain profitable. | | Conversions | Purchases or conversion events attributed to this campaign by the platform. | | ROAS | Return on ad spend for this specific campaign. Your primary efficiency metric at the campaign level. | | Cost per Conversion | How much each purchase costs through this campaign. Compare to your AOV. | Understanding ROAS at the campaign level ROAS (Return on Ad Spend) is the ratio of revenue generated to money spent on advertising. At the campaign level: - ROAS above your target (e.g., above 3x): The campaign is performing well. Consider increasing its budget. - ROAS near your target (e.g., 2-3x): The campaign is marginal. Look at the trend — is it improving or declining? - ROAS below your target (e.g., below 2x): The campaign may need creative refresh, audience adjustment, or budget reduction. Keep in mind that platform-reported ROAS uses the platform's attribution model. The actual ROAS based on Shopify revenue may be different. Use the Blended Ads dashboard for the most accurate cross-platform ROAS. Comparing campaigns across platforms Datadrew lets you view Meta and Google campaigns in the same dashboard. When comparing: - Different attribution windows: Meta defaults to 7-day click / 1-day view. Google Ads uses its own conversion window settings. These differences mean the same customer purchase might be counted by both platforms. - Different campaign types: A Meta prospecting campaign targets awareness, while a Google Shopping campaign targets high-intent buyers. Their metrics will naturally differ. - Focus on cost efficiency: Compare Cost per Conversion across campaigns regardless of platform. This normalizes the comparison and tells you where each dollar of ad spend is most effective. How to use campaign analysis for optimization 1. Rank by ROAS: Sort campaigns by ROAS to find your top performers. Consider shifting budget from low-ROAS to high-ROAS campaigns. 2. Identify fatigue: If a campaign's CTR is declining week over week while spend is constant, the audience may be experiencing ad fatigue. Time for new creative. 3. Check scale vs. efficiency: Sometimes your highest-ROAS campaign has very low spend. Before scaling it up, test whether increasing budget maintains ROAS or causes it to drop. 4. Review by campaign objective: Prospecting campaigns will naturally have higher cost per conversion than retargeting campaigns. Evaluate each against its purpose, not against each other. 5. Use with Drew AI: Ask Drew AI questions like "Which campaigns should I pause?" or "Where should I shift budget for better ROAS?" to get AI-powered recommendations based on your actual campaign data. Tips and best practices - Review campaign performance at least weekly. Daily fluctuations are normal, but weekly trends reveal meaningful patterns. - Do not just look at the last 7 days. Set a 30-day window to evaluate campaign performance over a full cycle. - When a campaign has high clicks but low conversions, the issue is likely on your landing page rather than in the ad itself. - Export the campaign table to CSV for deeper analysis or to share with your media buying team. Need help? If you have questions about campaign-level analysis or ROAS tracking, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Blended Ads Summary — unified ad performance - Facebook/Meta Ads dashboard - Google Ads dashboard - Understanding blended metrics

Last updated on Jul 07, 2026

Website Traffic (Google Analytics) dashboard

What this dashboard shows The Website Traffic dashboard connects your Google Analytics 4 (GA4) property to Datadrew, giving you a clear picture of how visitors interact with your online store. While Shopify tells you about orders and revenue, GA4 tells you about the journey visitors take before (and instead of) purchasing — sessions, engagement, bounce rates, cart behavior, and more. Access it from Acquisition > Ads Overview and selecting the Google Analytics tab, or from the dedicated analytics section in the sidebar. Key metrics explained | | | | | --- | --- | --- | | Metric | Definition | Why it matters | | Total Users | The number of unique users who visited your site during the selected period. | Your total audience reach. Compare to Customer Count from Shopify to see what percentage of visitors convert to buyers. | | New Users | Users who visited your site for the first time during the selected period. | Measures the effectiveness of your top-of-funnel marketing at driving new traffic. | | Sessions | The total number of visits to your site. A single user can have multiple sessions. | Sessions indicate overall site activity. More sessions per user suggests repeat interest. | | Engaged Sessions | Sessions that lasted longer than 10 seconds, had a conversion event, or had 2+ page views. | Filters out bounce traffic. Engaged sessions represent visitors who actually interacted with your store. | | Bounce Rate | Percentage of sessions that were not engaged: ((Sessions - Engaged Sessions) / Sessions) x 100. | High bounce rate (over 60%) may indicate issues with page load speed, irrelevant traffic, or poor landing page experience. | | Engagement Rate | (Engaged Sessions / Sessions) x 100. The inverse of Bounce Rate. | A more positive way to measure session quality. Higher is better. Aim for 40%+ for e-commerce. | | Page Views per Session | Total Page Views / Sessions. | Indicates browsing depth. More page views per session often correlates with higher purchase likelihood. | | Average Engagement Time | Total engagement duration / Engaged Sessions (in seconds). | How long engaged visitors actively spend on your site. Longer times suggest deeper product research. | | Total Revenue | E-commerce revenue as tracked by GA4. | GA4's view of revenue. May differ from Shopify due to tracking gaps (ad blockers, consent banners). | | Transactions | The number of completed purchases tracked by GA4. | Compare to Shopify order count. A large gap may indicate a GA4 tracking implementation issue. | | Conversion Rate | (Conversions / Sessions) x 100. | The percentage of sessions that result in a conversion event. Typical e-commerce conversion rates are 1-3%. | | Revenue per User (RPU) | Total Revenue / Total Users. | Similar to Shopify's ARPU but includes all site visitors, not just buyers. Low RPU with high traffic means your conversion funnel needs work. | | Revenue per Session | Total Revenue / Sessions. | Revenue efficiency per visit. Useful for evaluating traffic quality from different sources. | | Add to Cart Rate | (Items Added to Cart / Sessions) x 100. | Measures purchase intent. A healthy add-to-cart rate for e-commerce is typically 5-10%. | | Cart Abandonment Rate | ((Items Added to Cart - Transactions) / Items Added to Cart) x 100. | Shows how many potential purchases are lost after cart additions. Industry average is around 70%. Reducing this directly increases revenue. | | Purchase Frequency | Transactions / Total Users. | Average number of purchases per user. Values above 1.0 indicate repeat purchasing behavior within the period. | How to use this dashboard 1. Monitor traffic quality: Compare Total Users to Engaged Sessions. If engagement rate is low, your traffic sources may be sending irrelevant visitors. 2. Optimize the funnel: Track the path from Sessions to Add to Cart to Transactions. Identify where the biggest drop-off occurs and focus optimization there. 3. Evaluate traffic sources: Use GA4 data alongside your ad platform dashboards. If Meta Ads report high clicks but GA4 shows few sessions from those clicks, you may have a tracking or landing page issue. 4. Reduce cart abandonment: If cart abandonment rate exceeds 75%, consider implementing abandoned cart emails, simplifying checkout, or adding trust signals. Requirements To use this dashboard, connect your Google Analytics 4 property via Integrations > Google Analytics. You will need to select the GA4 property that tracks your Shopify store. Universal Analytics (UA) is not supported — only GA4 properties. Need help? If you have questions about the Website Traffic dashboard or GA4 data, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Connecting your GA4 property - Blended Ads Summary — unified ad performance - How to connect Google Analytics 4 - Understanding GA4 metrics in Datadrew

Last updated on Jul 07, 2026

Google Ads dashboard

What this dashboard shows The Google Ads dashboard provides a complete view of your Google Ads performance across Search, Shopping, Display, Video, and Performance Max campaigns. Data is pulled directly from the Google Ads API and presented alongside calculated efficiency metrics. Access it from Acquisition > Ads Overview and selecting the Google Ads tab, or navigate to the campaign-level view for detailed analysis. Key metrics explained | | | | | --- | --- | --- | | Metric | Definition | Why it matters | | Cost | Total amount spent on Google Ads during the selected period. | Your Google Ads investment. Track alongside conversions and revenue to evaluate spending efficiency. | | Impressions | The number of times your ads were shown in Google search results, Shopping listings, Display network, or YouTube. | Indicates your visibility and reach across Google's advertising surfaces. | | Clicks | The number of times users clicked on your ads. | Direct measure of the traffic your Google Ads are driving to your store. | | CTR | (Clicks / Impressions) x 100. | Measures ad relevance. Higher CTR usually means your ads match search intent well. Search campaigns typically see 3-5% CTR; Display campaigns are much lower (0.5-1%). | | CPC | Cost / Clicks. | Average cost per click. Varies significantly by campaign type — Shopping and brand search tend to have lower CPC than generic search terms. | | CPM | (Cost / Impressions) x 1,000. | Cost per thousand impressions. More relevant for Display and Video campaigns focused on awareness. | | Conversions | The number of conversion actions recorded by Google Ads (typically purchases tracked via the Google Ads conversion tag). | Primary performance metric. Note: Google Ads conversions may differ from Shopify orders due to attribution and tracking differences. | | Conversions Value | Total revenue value of all conversions, as reported by Google Ads. | Used to calculate Google Ads ROAS. Compare to Shopify revenue for accuracy. | | ROAS | Conversions Value / Cost. | Return on ad spend for Google Ads. A ROAS of 5.0 means you earned $5 in reported revenue for every $1 spent. | | Cost per Conversion | Cost / Conversions. | How much each conversion (typically a purchase) costs. Compare to your AOV to ensure profitability. | | Order Rate | (Conversions / Clicks) x 100. | The percentage of ad clicks that result in a purchase. Reflects landing page effectiveness and product-market fit. | | Revenue per Click | Conversions Value / Clicks. | The average revenue generated per ad click. Helps compare efficiency across campaigns and ad groups. | | Value per Conversion | Conversions Value / Conversions. | The average revenue from each conversion. Similar to AOV but specific to Google Ads-attributed purchases. | | Video Views | Number of video views from Video and YouTube campaigns. | Relevant for brands running YouTube or video awareness campaigns. | Campaign breakdown The campaign table lets you compare performance across all your Google Ads campaigns. Key columns include campaign name, status, channel type (Search, Shopping, Display, Video, Performance Max), spend, conversions, ROAS, and more. You can sort by any column to identify your best and worst performing campaigns. Use this to make informed budget allocation decisions. Understanding campaign types - Search: Text ads in Google search results. Typically highest intent and best conversion rates. - Shopping: Product listing ads with images and prices. Essential for e-commerce product visibility. - Performance Max: Google's AI-driven campaign type that runs across all Google surfaces. Provides broad reach but less granular control. - Display: Banner ads across Google's Display Network. Lower conversion rates but useful for retargeting and awareness. - Video: YouTube and video partner ads. Primarily used for brand awareness and top-of-funnel marketing. Tips and best practices - Focus on ROAS and Cost per Conversion for performance evaluation. High impressions and clicks mean nothing if they do not convert. - Compare Google Ads ROAS to your Blended ROAS. Google's attribution tends to be more conservative than Meta's, so these may be closer in value. - Use the Order Rate metric to evaluate landing page effectiveness. Low order rate with good CTR suggests your landing page needs optimization. - Track CPC trends over time. Rising CPCs may indicate increased competition for your keywords or declining quality scores. Need help? If you have questions about your Google Ads data in Datadrew, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Connecting your Google Ads account - Blended Ads Summary — unified ad performance - Campaign-level analysis and ROAS tracking - How to connect Google Ads

Last updated on Jul 07, 2026

Facebook/Meta Ads dashboard

What this dashboard shows The Facebook/Meta Ads dashboard gives you a complete view of your Meta advertising performance — covering Facebook, Instagram, Messenger, and Audience Network campaigns. It pulls data directly from the Meta Ads API so you can analyze campaign, ad set, and ad-level performance alongside your Shopify data. Access it from Acquisition > Ads Overview and selecting the Facebook Ads tab, or from the campaign-level reports in the sidebar. Key metrics explained | | | | | --- | --- | --- | | Metric | Definition | Why it matters | | Spend | The total amount spent on your Meta ads during the selected period. | Tracks your investment. Compare against revenue and conversions to evaluate efficiency. | | Impressions | The number of times your ads were displayed on screen. | Measures reach. High impressions with low clicks may indicate weak creative or targeting. | | Clicks | Total clicks on your ads (includes all click types: link clicks, reactions, comments, shares). | Overall engagement with your ads. For performance campaigns, focus on Link Clicks instead. | | Link Clicks | Clicks that navigate the user to your website or app. | More relevant than total clicks for measuring traffic quality. This is what drives potential purchases. | | Landing Page Views | The number of times someone clicked your ad and successfully loaded the destination page. | If landing page views are much lower than link clicks, you may have page speed issues or broken links. | | CTR (Link) | (Link Clicks / Impressions) x 100. | Measures how compelling your ad is at driving website visits. Industry average is typically 1-2% for e-commerce. | | CPC (Link) | Spend / Link Clicks. | The cost to get one visitor to your website from Meta ads. Lower is better, but balance against conversion quality. | | CPM | (Spend / Impressions) x 1,000. | Cost per thousand impressions. Reflects auction competitiveness and audience demand. | | Add to Cart | The number of add-to-cart events attributed to your Meta ads. | Key funnel metric. Tracks how well your ads are driving purchase intent. | | Purchases | The number of purchase conversion events reported by Meta. | Note: Meta-reported purchases use Meta's attribution model and may differ from your Shopify order count. | | Purchase Value | Total revenue from purchases attributed to your Meta ads, as reported by Meta. | Used to calculate platform ROAS. Compare to Shopify revenue for a reality check. | | ROAS | Website Purchase Value / Spend. | Return on ad spend as reported by Meta. This is based on Meta's attribution, which may overcount conversions. | | Cost per Purchase | Spend / Purchases. | How much you pay per sale through Meta. Compare to your AOV — if cost per purchase exceeds your AOV, you are losing money on each sale. | | Cost per Add to Cart | Spend / Add to Cart events. | Useful for evaluating upper-funnel campaign efficiency even when direct purchase conversions are low. | Campaign breakdown The dashboard includes a campaign-level table showing performance for each active campaign. You can sort by any metric to find your top and bottom performers. Each campaign row shows spend, impressions, clicks, conversions, ROAS, and other key metrics. Attribution considerations Meta Ads uses its own attribution model (typically 7-day click, 1-day view by default). This means: - Meta may attribute a purchase even if the customer clicked an ad 7 days before buying. - Platform-reported ROAS may be higher than your Blended ROAS because of these attribution differences. - For the most accurate view, use the Blended Ads dashboard to compare total ad spend against actual Shopify revenue. Tips and best practices - Monitor Landing Page Views vs. Link Clicks. If there is a large gap, your landing page may be loading too slowly on mobile devices. - Watch your CPM trends. Rising CPM can indicate increased competition for your target audience or ad fatigue. - Use the cost per add-to-cart metric for prospecting campaigns where direct purchases may take more time. - Compare Meta ROAS to your Blended ROAS regularly. A large gap indicates attribution inflation. Need help? If you have questions about your Facebook/Meta Ads data, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Connecting your Facebook/Meta Ads account - Blended Ads Summary — unified ad performance - Campaign-level analysis and ROAS tracking - How to connect Facebook/Meta Ads

Last updated on Jul 07, 2026

Blended Ads Summary — unified ad performance

What this dashboard shows The Blended Ads Summary brings together performance data from all your connected advertising platforms — Meta (Facebook) Ads and Google Ads — into a single unified view. Instead of switching between ad managers to understand your total advertising performance, the Blended Ads Summary calculates combined metrics across both platforms. This dashboard appears as the first section on the main Store Performance page, and is also available as a full report at Acquisition > Ads Overview in the sidebar. How blended metrics are calculated Blended metrics combine raw data from each ad platform and, where relevant, cross-reference it with your Shopify store data: - Additive metrics (Spend, Impressions, Clicks, Conversions) are summed across Meta Ads and Google Ads. - Ratio metrics (ROAS, CPC, CTR, CAC, CPM) are recalculated from the blended totals — not averaged across platforms. This gives you accurate cross-channel ratios. - Shopify-blended metrics (Blended ROAS, Blended CAC) use your Shopify revenue and new customer data combined with total ad spend, giving you a true picture of your marketing efficiency. Key metrics explained | | | | | --- | --- | --- | | Metric | Definition | Why it matters | | Total Ad Spend | Combined spend across Meta Ads and Google Ads. | Your total investment in paid acquisition. Track this against revenue to ensure you are spending efficiently. | | Blended ROAS | Shopify Total Revenue / Total Ad Spend. Uses your actual Shopify revenue, not platform-reported conversions. | The single most important metric for evaluating overall ad efficiency. Unlike platform ROAS, this is based on real revenue from your store. | | Blended CAC | Total Ad Spend / Shopify New Customer Count. | Shows the true cost to acquire each new customer across all channels. Compare this to your customer lifetime value to ensure sustainable growth. | | Blended CPC | Total Ad Spend / Total Clicks (across both platforms). | Tells you the average cost per click across all paid channels. Useful for budgeting and comparing efficiency between periods. | | Blended CTR | (Total Clicks / Total Impressions) x 100. | Measures overall ad engagement. A declining CTR may indicate ad fatigue or poor targeting across your campaigns. | | Blended CPM | (Total Ad Spend / Total Impressions) x 1,000. | The cost to reach 1,000 people across all platforms. Helps you understand audience reach efficiency. | | Total Conversions | Google Ads conversions + Meta Ads website purchases, as reported by each platform. | Note: this uses platform-reported conversions, which may differ from Shopify orders due to attribution differences. | Connected ad accounts The dashboard shows which ad accounts are contributing to the blended view. You can see the connected accounts listed at the bottom of the section. If you have multiple Meta or Google Ads accounts connected, all of them are included in the blended calculations. How to use this dashboard 1. Monitor Blended ROAS daily: This is your north star for ad efficiency. If Blended ROAS drops below your target (commonly 3x-5x for DTC brands), investigate which platform is underperforming. 2. Track CAC trends: Rising CAC over time may indicate market saturation, increased competition, or declining ad quality. Compare it to your average customer LTV from the Cohort Analysis dashboard. 3. Compare blended vs. platform metrics: If platform ROAS is much higher than your Blended ROAS, it likely means the platforms are over-attributing conversions. Use Blended ROAS for true performance measurement. Requirements To see the Blended Ads Summary, you need at least one advertising platform connected: - Connect Meta (Facebook) Ads via Integrations > Facebook Ads - Connect Google Ads via Integrations > Google Ads Connecting both platforms gives you the most accurate blended view. If only one platform is connected, the blended metrics will reflect that single platform's data. Need help? If you have questions about the Blended Ads Summary or how blended metrics are calculated, reach out to us at support@datadrew.io or use the in-app chat widget. Related articles - Facebook/Meta Ads dashboard - Google Ads dashboard - Understanding blended metrics - Campaign-level analysis and ROAS tracking

Last updated on Jul 07, 2026