Trusted by 1,600+ marketing teams and agencies
What you can do with this Google Ads dashboard
Eight jobs this dashboard does. Click one to see its view on demo data, then paste its prompt into the same Claude chat.
Spot campaigns going off track
Each campaign’s cost, conversions and cost per conversion against the 14 days before, so you catch the one that slipped.
- Which campaigns spend more for fewer conversions?
- Which ones went over my target cost per conversion?
Compare cost, conversions and cost / conv. by campaign for the last 14 days with the 14 days before, biggest conversion drop first.
Find search terms that waste spend
Search terms with clicks and no conversions, so you know which negative keywords to add.
- Which search terms got clicks and no conversions?
- Which ones should become negative keywords?
List search terms with clicks and 0 conversions in the last 14 days, by cost, with campaign and match type.
Track spend against the monthly budget
Cost this month against your budget per campaign, so you move money before one overspends.
- Are we on pace for the month?
- Which campaigns will end over or under budget?
My monthly budgets are [campaign: budget]. Show cost month to date and projected month-end cost per campaign.
See which campaigns are limited by budget or rank
Searches each campaign missed on budget or ad rank, so you know whether to add budget or fix bids.
- Which campaigns run out of budget?
- Where do we lose the auction on ad rank?
Show Search Impr. share and Search Lost IS (budget) and (rank) by Search campaign for the last 14 days.
Check Performance Max against Search
Cost and return for Search, Shopping and Performance Max, so you see which type earns its budget.
- Does Performance Max convert cheaper than Search?
- How much of the budget goes to each type?
Show cost, conversions, cost / conv. and conv. value / cost by advertising channel type for the last 14 days.
Find the hours that convert
Average conversions per hour, weekdays against weekends, so you can set an ad schedule.
- Which hours bring the most conversions?
- Do weekends follow a different pattern?
Chart average conversions per hour of day for the last 14 days, weekdays vs weekends.
Compare ads and keep the winners
Responsive search ads ranked by conversions, so you know which ads to copy and which to rewrite.
- Which ads bring the most conversions?
- Which weak ads should I rewrite first?
Rank responsive search ads by conversions for the last 14 days with ad strength, CTR and cost / conv.
See which conversions your ads drive
Conversions and value per conversion action, so you know what your Conversions column counts.
- Which actions count in Conversions?
- How much value does each action bring?
Show conversions, value, view-through conv. and all conv. by conversion name for the last 14 days.How to set up the Google Ads dashboard in Claude
You need a Google Ads account your Google login can open, a free Porter account and Claude Pro, Max, Team or Enterprise for Claude Dashboards. The whole setup takes about 8 minutes.
Connect Google Ads in Porter
Sign up free at Porter, open Data sources, pick Google Ads, sign in with Google and select your ad accounts. The Google Ads to Claude tutorial shows each click.
Pick the Google Ads accounts Claude can read, then save. 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 account in brackets with your own. Claude queries Google Ads through Porter and builds the dashboard.
Install promptDuplicate this Claude dashboard template and keep its layout, views and styling: https://claude.ai/artifact/HFMDtZZMujcwfFdQ19D7mW Then rebuild it with my own data through Porter: a Google Ads dashboard for [account] for the last 14 days: KPI cards for cost, conversions, cost / conv., conv. value / cost, impressions, clicks, CTR and avg. CPC; then by campaign, by advertising channel type and by hour of day; search terms with clicks and no conversions; impression share lost to budget and rank; top responsive search ads; and conversions by conversion name.
Open in Claude with this prompt 
The first thing Claude builds: KPI cards for your own account. Demo data shown.
How to use the Google Ads MCP in Claude (no code)
Google Ads fields and data
The template reads 14 metrics and 11 dimensions from four Google Ads reports. Porter reads 1,042 Google Ads fields if you need more.
Top 5 Google Ads KPIs to watch
Trailgear demo data · last 14 days vs the 14 before
- Cost$46,800+6.1%
Spend rising faster than conversions means something is leaking money.
- Conversions1,005+6.0%
If it drops while cost holds, open the campaigns table to find why.
- Cost / conv.$46.57+0.1%
A campaign far above your target is the first place to cut or fix.
- Conv. value / cost2.53+1.8%
Your ROAS. Below 1, a campaign earns less than it costs.
- Search Lost IS (budget)29%Search · Tents
High on a profitable campaign means more budget should pay back.
How the numbers are calculated
- Cost / conv.
- Cost ÷ conversions.
- Conv. value / cost
- Conversions value ÷ cost (ROAS).
- Lost IS (budget)
- Share of eligible Search impressions missed because the budget ran out.
- Budget pacing
- Cost so far ÷ days passed × days in the month.
- Change
- (This period − previous) ÷ previous.
Data sources
Metrics
Cost- Impressions
- Clicks
- CTR
- Avg. CPC
- Conversions
- Cost / conv.
- Conversions value
- Conv. value / cost
- Search Impr. share
- Search Lost IS (budget)
- Search Lost IS (rank)
- View-through conv.
- All conv.
Dimensions
- Date
- Campaign
- Advertising channel type
- Search term
- Query match type
- Hour of day
- Day of Week
- Ad group
- Responsive Search Ad Headlines
- Ad strength
- Conversion Name
See all fields:Google Ads · 1,042 fields
What makes this Google Ads dashboard different
What you get that the Google Ads interface or an exported report can’t give you.
Ask the next question in the same chat
Spot a jump in cost per conversion, then ask Claude which terms caused it.
Act on it after you approve
Ask Claude to add a negative keyword or change a budget. Porter asks first.
Pace against your own budget
Give Claude monthly budgets and see month-end spend per campaign.
See what happens after the click
Add GA4 to see the sessions and key events each campaign brings.
Send clients a report on your logo
Publish it in Porter and email it on the day you choose.
Share it without Google Ads access
Anyone with the Porter link sees the numbers.
What the dashboard includes
- KPI cards against the previous period
- Campaign, search term, budget and impression share tables
- Search, Shopping and Performance Max side by side
- Conversions by hour, ad and conversion action
Related dashboard templates
Claude
PPC dashboard template
Compare Google Ads and Microsoft Ads spend and cost per conversion side by side
Claude
SEM dashboard template
Find search terms you pay for but already rank for, and queries worth bidding on
Claude
Meta Ads dashboard template
Track Meta Ads spend, ROAS and cost per purchase by campaign, ad and placement, and catch ad fatigue early
ClaudeGoogle Search Console dashboard template
Find queries close to page one and fix low CTR by page and device.Browse more Claude dashboard templates
Data Studio
Google Sheets
ChatGPTGet your free Google Ads dashboard
Sign up free, connect Google Ads and paste the prompt. Your own data fills the same layout as the demo.
Free plan · 14-day trial · No card needed