How to build a marketing analytics dashboard for Meta, Google Ads and Shopify

Category

Growth

Published Date

ElarisLabs Engineering

Summary

Build a marketing analytics dashboard that pulls Meta, Google Ads and Shopify into one view: the metrics to show, why numbers differ, and the tools to use.

Share this article

In this article

  1. What should a marketing analytics dashboard show?

  2. Why don't Meta, Google Ads and Shopify numbers match?

  3. How do you build a marketing analytics dashboard step by step?

  4. Which tools build a marketing analytics dashboard?

  5. What about a B2B marketing analytics dashboard?

  6. Do you need multi-touch attribution?

  7. See every channel in one dashboard with ElarisLabs AI

  8. Frequently asked questions

A marketing analytics dashboard should answer three questions in under a minute: are we profitable, which channel is driving it, and is it getting better? Most dashboards fail because they try to show everything every platform reports. This guide covers what to show, why Meta, Google Ads and Shopify never agree, and how to build the dashboard with the tools you already have.

We build a reporting product at ElarisLabs AI, Ad Analytics, so we have spent a lot of time on the gaps between platforms. The method below works with any tool.

What should a marketing analytics dashboard show?

Start with money in and money out, then break it down. These are the metrics that earn a place, with where each one comes from.

Metric

How it's calculated

Where the data comes from

Spend

Cost of ads across every platform

Meta, Google Ads, TikTok, LinkedIn

Revenue

Orders, net of refunds

Shopify or your store, as the source of truth

MER

Total revenue divided by total marketing spend

Your store revenue and every platform's spend

ROAS by channel

Conversion value divided by cost (Google calls it "Conv. value / cost")

Each ad platform

CAC

Spend divided by new customers

Spend from platforms, new customers from the store

Cost per conversion

Cost divided by conversions

Each ad platform

Conversion rate and AOV

Orders divided by sessions; revenue divided by orders

Shopify or GA4

MER (marketing efficiency ratio) has no official platform definition; Shopify describes it as total revenue over total marketing spend. Put it at the top, because no platform can inflate it.

Layout sketch of a marketing analytics dashboard: four tiles for spend, revenue, MER and CAC, a channel breakdown of spend and ROAS, and a trend of revenue against spend

Top row: are we profitable? Left: which channel? Right: is it getting better?

Why don't Meta, Google Ads and Shopify numbers match?

Because each tool counts conversions by its own rules, and each one is right by those rules. The differences are predictable once you know the defaults.

Source

How it credits a sale by default

What that means

Google Ads

Data-driven attribution, the default for most conversion actions since 2023, across paid Google clicks only

Claims sales its ads helped, even if another channel closed them

GA4

Data-driven attribution across paid and organic channels

Shares credit across sources, so Google Ads looks smaller here than in Google Ads

Meta

Conversions within the ad set's attribution setting, which can include views as well as clicks

Can claim a sale from someone who saw an ad and later bought another way

Shopify

Last non-direct click for its channel report; last click for sales by marketing source

Gives the whole sale to the final traceable visit

Two more causes trip teams up. Google's own documentation notes that Analytics reports in the property's time zone while Google Ads uses the account's, so daily totals shift. And from 12 January 2026, Meta's Ads Insights API stopped returning 7-day and 28-day view windows, so older dashboards built on them changed overnight.

Diagram of one customer journey, seeing a Meta ad, clicking a Google ad and buying on Shopify, and how Meta, Google Ads, GA4 and Shopify each credit that single sale

One sale can appear as a conversion in two ad platforms at once. That's why the top-line number should come from your store.

How do you build a marketing analytics dashboard step by step?

  1. Write down the three questions your team actually asks each week. Everything on the dashboard must answer one of them.

  2. Pick one source of truth for revenue. For ecommerce that is the store, not the ad platforms.

  3. Connect the ad platforms. Looker Studio connects natively to Google Ads, Google Analytics, Sheets and BigQuery; Meta and Shopify need a partner connector.

  4. Line up dates, time zones and currency before you compare anything.

  5. Label each platform's attribution next to its numbers, so nobody adds them up as if they matched.

  6. Lay out the page top to bottom: totals, channels, trend. Leave out any chart nobody acts on.

  7. Automate the refresh and share a link, not a screenshot, so the numbers are never a week old.

Which tools build a marketing analytics dashboard?

Prices from each vendor's pricing page on 19 November 2026.

Tool

Entry price

Best for

ElarisLabs AI Ad Analytics

Basic $149 a month ($119 billed yearly)

Meta, Google Ads, TikTok and GA4 side by side, refreshed daily, with plain-English insights and share links; white-label client portals on Growth ($399)

Looker Studio

Free

Teams that can build and maintain reports themselves

Supermetrics

Starter $59 a month ($44 billed yearly), 2 data sources

Feeding ad data into Looker Studio, Sheets or Excel

Windsor.ai

Basic $23 a month ($19 billed yearly), 3 data sources

A low-cost connector, with a free plan for one source

Funnel

Starter $300 a month, billed yearly

Larger teams with many sources and destinations

Triple Whale

Priced by annual store revenue

Shopify-first attribution and reporting

Northbeam

Starter from $1,500 a month

Multi-touch attribution and incrementality for larger ecommerce brands

Shopify's own marketing reports show ROAS, CPA and CAC by channel, but in Shopify's words, "Spend-based metrics apply only to marketing channels that report cost data to Shopify."

What about a B2B marketing analytics dashboard?

Swap orders for pipeline. A B2B dashboard tracks leads, qualified opportunities, pipeline value and won revenue by source, plus cost per opportunity, because a sale can take months. CRM reports in HubSpot or Salesforce cover the basics; B2B attribution tools such as Dreamdata, which has a free plan, and HockeyStack connect ad and website touches to deals.

Do you need multi-touch attribution?

Not on day one. Start with MER and channel ROAS, read side by side with each platform's attribution labelled. Once spend is large enough that small shifts matter, add incrementality tests, where you pause a channel in some regions and measure the difference, or a marketing mix model. Google's open-source Meridian model is one free starting point.

See every channel in one dashboard with ElarisLabs AI

ElarisLabs AI Ad Analytics connects Meta, Google Ads, TikTok and GA4 in a few clicks, lines up spend, ROAS and conversions every morning, and lets you ask questions in plain words. See Ad Analytics or compare plans. To see how your business shows up in AI answers too, read our guide to AI visibility tools.