Trusted by 1,600+ marketing teams and agencies
What you can do with this marketing KPI dashboard
Click a job to see its view on demo data, then paste its prompt into the same Claude chat.
Track your KPIs week by week
Every KPI as a row and each week as a column, so you see which number moved before anyone asks.
- Which KPIs moved this week compared with last week?
- Is cost per conversion rising on Google Ads or on Meta Ads?
Show ad spend, conversions, cost per conversion, Sessions, Key events and Purchase revenue as rows and each of the last two weeks as a column, with the change.
Track progress against your targets
Each KPI next to the target you set and the gap, so you know which goal is behind while there is time to act.
- Are conversions and ROAS on pace for this period’s target?
- Which goal is furthest behind?
Show conversions, Key events, Purchase revenue and ROAS for the last 14 days against these targets: [your targets], with % of target.
Check ad spend against budget
Spend per platform and where the month lands at this week’s rate, so you move budget before a platform overspends.
- Will Google Ads or Meta Ads finish the month over budget?
- How much is each platform spending per day this week?
Project Google Ads and Meta Ads spend to month end at the last 7 days’ rate against these budgets: Google Ads [budget], Meta Ads [budget].
Spot campaigns going off track
Every campaign’s cost per conversion and ROAS against your target CPA, so the expensive ones come up first.
- Which campaigns cost more per conversion than the target?
- Which campaigns bring revenue at the best ROAS?
List my Google Ads and Meta Ads campaigns for the last 14 days with cost, conversions, cost per conversion and ROAS against a target CPA of [your target].
Catch rising and falling KPIs early
Daily spend, conversions and key events on one chart, so a dip shows up before the weekly report.
- Did spend rise on a day when conversions didn’t?
- Did key events dip on any day?
Chart daily ad spend, conversions and GA4 Key events for the last 14 days.
Find where the funnel drops
The rate at each step from add to cart to purchase, so you know whether to fix the product pages or the checkout.
- Which step loses the most visitors?
- Did the checkout rate change this period?
Show GA4 Sessions, Add to carts, Checkouts and Ecommerce purchases for the last 14 days, with the rate from each step to the next.How to set up the marketing KPI dashboard in Claude
You need Google Ads, Meta Ads and GA4, a free Porter account and Claude Pro, Max, Team or Enterprise for Claude Dashboards. Setup takes about 10 minutes.
Connect Google Ads, Meta Ads and GA4 in Porter
Sign up free at Porter, open Data sources and connect Google Ads, Meta Ads and Google Analytics 4, picking the ad accounts and the property for the same business. The Google Ads to Claude tutorial and the Meta Ads to Claude tutorial show each click.
Pick the GA4 property Claude can read, then add Google Ads and Meta Ads the same way. Add Porter to Claude
In Claude, go to Customize → Connectors → Add custom connector, paste https://mcp.portermetrics.com/mcp and name it Porter Metrics. Click Continue, then sign in to Porter and allow access.
In Claude: Customize, Connectors, Add custom connector, then paste Porter’s MCP URL Paste the install prompt
Open a new chat in Claude, paste this prompt and replace the brackets with your brand, targets and budgets.
Install promptDuplicate this Claude dashboard template and keep its layout, views and styling: https://claude.ai/artifact/Y2emDYTx2csMEeQCmBJzBz Then rebuild it with my own data through Porter: a marketing KPI dashboard for [brand] for the last 14 days from Google Ads, Meta Ads and GA4: KPI cards for ad spend, conversions, ROAS, cost per conversion, Purchase revenue and Key events against the previous 14 days; a KPI table by week; each KPI against these targets: [your targets]; spend against these monthly budgets: [Google Ads budget], [Meta Ads budget]; a campaign table with cost per conversion and ROAS; a daily trend; and the GA4 purchase funnel.
Open in Claude with this prompt 
The first thing Claude builds: KPI cards for your own accounts. Demo data shown.
How to connect Google Analytics 4 to Claude (no code)
Marketing KPI dashboard fields and data
The template reads spend, conversions and conversion value from Google Ads and Meta Ads, and sessions, key events, funnel steps and revenue from GA4, lined up by date.
Top 5 marketing KPIs to watch
Trailgear demo data · last 14 days vs the 14 before
- Ad spend$85,200+5.2%
A jump with flat conversions means money went to campaigns that don’t convert.
- Cost per conversion$48.77+0.3%
Rising on one platform only? The cause sits in that platform’s campaigns, not in demand.
- ROAS2.33+1.2%
Falling while spend rises means the extra budget went to weaker campaigns.
- Key events3,235+9.6%
Sessions up and key events flat? Check the landing pages before the bids.
- Purchase revenue$337,100+10.8%
Spend growing faster than revenue means each ad dollar earns less, whatever the platforms report.
How the numbers are calculated
- Ad spend
- Google Ads Cost + Meta Ads Amount spent.
- Cost per conversion
- Spend ÷ Google Ads Conversions or Meta Ads Results, per platform. The total divides all spend by both.
- ROAS
- (Google Ads Conversions value + Meta Ads Purchase conversion value) ÷ ad spend, as each platform reports it.
- Projected spend
- Spend so far + remaining days × the last 7 days’ average daily spend.
- Change
- (This period − previous period) ÷ previous period. Rates change in percentage points.
Data sources
Metrics
Cost- Clicks
- Conversions
- Conversions value
Amount spent- Results
- Purchase conversion value
Sessions- Engagement rate
- Key events
- Add to carts
- Checkouts
- Ecommerce purchases
- Purchase revenue
Dimensions
- Date
- Campaign
- Campaign name
See all fields:Google Analytics 4 · 285 fieldsGoogle Ads · 1,042 fieldsMeta Ads · 1,378 fields
What makes this marketing KPI dashboard different
What you get that Google Ads, Meta Ads Manager and GA4 can’t show on one screen.
Skip the Monday copy-paste
Google Ads, Meta Ads and GA4 fill one table, so nobody copies numbers from three tabs before the meeting.
Compare days that cover the same hours
Porter lines up each platform’s time zone, so Monday’s spend and Monday’s GA4 revenue count the same day.
Ask why a KPI moved
See cost per conversion jump, then ask Claude in the same chat which campaign caused it.
Track the metrics your team uses
Save total CPA or ROAS across platforms once in Porter and reuse them in every report.
Send the KPI table every Monday
Publish it in Porter and email it, with your logo, on the day you choose.
Share it without ad account access
Anyone with the Porter link sees the numbers, without a seat in Google Ads, Meta or GA4.
What the dashboard includes
- Ten KPI cards against the previous 14 days
- A weekly KPI table and your targets
- Spend per platform against budget
- Campaigns against your target CPA
- Daily trend and the GA4 funnel
- Share by link, PDF and scheduled email once published in Porter
Related dashboard templates
Claude
Executive dashboard template
Show leadership revenue, ad spend, MER and pipeline on one page
Claude
Cross-channel marketing dashboard template
Compare spend, CPA and ROAS across your ad platforms next to GA4
Claude
GA4 SEO dashboard template
See which landing pages bring organic sessions and key events.
ClaudeMonthly SEO dashboard template
Show month-on-month SEO results and the pages that moved them.Browse more Claude dashboard templates
By data source
GA4Google Analytics dashboardROAS dashboardSEO marketing dashboardGA4 SEO dashboardSEO dashboard
Google AdsGoogle Ads dashboardPPC dashboardSEM dashboard
Meta AdsMeta Ads dashboard
By use case: Marketing overview
Marketing dashboardExecutive dashboardCross-channel marketing dashboard
Data Studio
ChatGPTGet your free marketing KPI dashboard
Sign up free, connect Google Ads, Meta Ads and GA4 and paste the prompt. Your own data fills the same layout as the demo.
Free plan · 14-day trial · No card needed