Google Ads ROI Dashboard Setup Guide

By Corey Frankosky · Last Updated August 6, 2026

A Google Ads ROI dashboard turns raw spend and revenue numbers into one clear view of which campaigns actually make you money. In this guide you will build a real-time dashboard using Google Ads, GA4, and Looker Studio, all of which are free. You will link your accounts, import conversion and revenue data, and build the scorecards, charts, and filters that let you see profit at a glance. By the end you will have a dashboard that saves you time and helps you shift budget toward the campaigns that deliver.

---

1Why an ROI dashboard matters

Return on investment tells you whether your ad spend is producing profit, not just clicks and impressions. The core formula is simple: ROI equals revenue minus ad spend, divided by ad spend. When you express it as a percentage inside a dashboard, you can rank every campaign by profitability and stop guessing which ones deserve more budget.

Most advertisers never get this clarity. A HubSpot study from 2024 found that 67% of marketers do not track the metrics that actually influence business outcomes. On top of that, many businesses overestimate their ROAS by 20% to 40% because they leave management costs and overhead out of the math. A dedicated dashboard fixes both problems by putting spend, revenue, ROAS, and true ROI side by side, refreshed automatically.

If you want a deeper breakdown of what drives your numbers up or down, our guide on Google Ads cost pairs well with this dashboard, and our Google Ads management services can handle the tracking and optimization for you.

Question to Answer:

Do you currently know which of your Google Ads campaigns is your most profitable, or only which one spends the most?

2Watch: track your Google Ads ROI in GA4

Before you build anything in Looker Studio, it helps to see how Google Ads ROI data flows into Google Analytics 4. This video walks through tracking your ad performance directly inside GA4 so the numbers you pull into your dashboard are the right ones.

Question to Answer:

Are your Google Ads conversions and revenue already showing up correctly in GA4 before you try to visualize them?

3What you need before you start

You need three tools, and the Google ones are all free. Google Ads supplies your spend, clicks, impressions, and CPC. GA4 supplies your conversion events, revenue, and user behavior. Looker Studio blends the two into a dashboard using its built-in connectors. If you also pull data from non-Google platforms, you will need a third-party connector such as Supermetrics or Porter Metrics.

You also need the right access. You want Admin access in Google Ads and at least a Marketer role in GA4 so you can link the accounts and import conversion data. If you run a Manager Account (MCC), you can connect up to 50 sub-accounts per Looker Studio data source.

Two setup details matter before you go further. First, auto-tagging must be enabled in Google Ads, and your website must preserve the GCLID (Google Click Identifier) through any redirects, or your click data will not match. Second, expect a wait: it can take up to 48 hours for data to appear in GA4 after you link the accounts.

For accurate ROI, you also need conversion tracking in place. In GA4, mark your key events such as purchases, form submissions, or phone calls as conversions before importing them into Google Ads. Only new conversion data imports after you enable tracking, and it can take up to 24 hours for GA4 key event data to appear in Google Ads after the first import. For actions without a direct dollar value, such as email sign-ups, assign a value so they still count in your reports. Google Ads converts GA4 revenue into your billing currency using average daily exchange rates.

Question to Answer:

Is auto-tagging on in your account, and are your most important actions marked as key events in GA4?

4Link Google Ads and GA4

Log into GA4 and go to Admin, then Product Linking, then Google Ads Linking. Select your Google Ads account and complete the link. Make sure at least one event is marked as a key event in GA4 so performance data flows correctly.

Once the accounts are linked, open the Advertising tab in GA4 and confirm that metrics like ad cost and ROAS are showing up. That check tells you the connection is working. Auto-tagging has to stay enabled in Google Ads for the integration to keep functioning. When you see the data, you are ready to build the report.

Question to Answer:

When you open the Advertising tab in GA4, do you see ad cost and ROAS populated for your campaigns?

5Build the dashboard in Looker Studio

Open Looker Studio and start with a blank report. Add Google Ads as your primary data source and use Overall Account Fields so dimensions and metrics integrate cleanly. Then add GA4 as a secondary source with Read & Analyze permissions. If you plan to share the dashboard with people who do not have direct access to Google Ads or GA4, set the data source credentials to Owner's Credentials so viewers can see the data without their own permissions.

At the top of the dashboard, add scorecards for your headline KPIs: Total Spend, Total Revenue, ROAS, ROI, and Conversions. ROI is not always available as a ready-made metric, so build it as a calculated field with this formula:

• ROI calculated field: [(Revenue - Cost) / Cost] * 100 gives you ROI as a percentage.

Below the scorecards, add a time series chart showing spend and revenue over time so you can spot seasonal swings and performance shifts. Add a table that ranks campaigns by ROI, and apply conditional formatting to flag weak performers. For example, you can turn any campaign with ROI below 150% red so it stands out.

Finally, make the dashboard interactive. Add a date range control so viewers can change the reporting period, and add dropdown filters for Campaign Name, Device, and Ad Group so stakeholders can drill into specific segments. If you manage several accounts, a Data Control component lets viewers switch between Google Ads accounts without a separate report for each one. Format all currency fields in USD with comma separators, for example $1,500.00. Keep in mind that campaigns or ad groups with zero impressions will not appear in your filter lists or data sources.

Question to Answer:

Does your dashboard let a viewer sort campaigns by ROI and change the date range without editing the report?

6Verify your data is accurate

Before you share anything, check your dashboard numbers against Google Ads. Compare total spend, conversions, and revenue from the Insights view in Google Ads with the same figures in Looker Studio. Comparison periods like the previous month or the same period last year help you catch problems fast. If your dashboard shows a 200% jump in conversions that Google Ads does not, you likely have a data connection issue.

Look at 90-day trend lines rather than daily snapshots so you can see real patterns instead of noise, and break performance out by campaign type. Search, Shopping, and Performance Max behave differently, and a blended average can hide a problem inside one of them. If you run Performance Max, our guide on Google Ads Performance Max explains how to read its reporting.

Question to Answer:

Do your dashboard totals for spend and conversions match what Google Ads reports for the same date range?

7Share and automate reports

When you share the dashboard, use the Invite people option in Looker Studio instead of Anyone with the link. Inviting people requires Google authentication, so only specific individuals or a Google Group can open the data. Assign Viewer to people who only need to read the dashboard and Editor to team members who maintain it. Keep in mind that anyone with email-only access in Google Ads cannot view the dashboard directly and will need a report sent to them.

To automate delivery, click the schedule email icon on your saved dashboard, enter recipient addresses, choose a frequency of daily, weekly, or monthly, and select PDF. Reports for individual accounts send at 1:00 AM in the account time zone, and manager account (MCC) reports send at 5:00 AM. Use dynamic date ranges like Last 7 days or Last 30 days so every report reflects current data, and add a short note such as "Weekly ROI performance for Q1 campaigns" so recipients know the focus at a glance.

For heavier automation, use the Google Ads add-on for Google Sheets. It schedules automatic data updates and can email a notification when the sheet refreshes, which is useful when you need custom calculations or pivot tables before the data reaches your team.

Question to Answer:

Who on your team or client side needs an automated PDF, and who should get direct dashboard access instead?

8Advanced ROI tracking techniques

Once the core dashboard runs, you can add blended ROI and attribution comparisons for a deeper picture of performance across platforms and models.

If you advertise on Google and Facebook, a blended ROI gives you a fuller view of overall efficiency. To build it, standardize your channel names with a lookup table, combine cost data from every advertising platform, and join that cost to GA4 revenue. Use Total Revenue / Total Cost to display a blended ROAS. For cleaner numbers, calculate net revenue by subtracting refunds from purchase value instead of using gross sales, and normalize all currencies to USD with daily exchange rates.

Attribution comparisons refine your ROI further. Google Ads offers two main models. Last Click gives full credit to the final interaction before the conversion, and Data-Driven distributes credit across all touchpoints based on their contribution. To compare them, go to Goals, then Measurements, then Attribution, then Model comparison, and add columns showing conversion value per cost for each model. This helps you find undervalued keywords that assist conversions but rarely get the final click.

1. Last Click: easy to understand and set up, but it ignores earlier touchpoints in the path to conversion.
2. Data-Driven: more precise because it accounts for every interaction, but it needs a significant amount of data to work.

Data-Driven attribution requires at least 200 conversions and 2,000 ad interactions within a 30-day period to produce accurate results. Use the assisted conversions report to find campaigns with high assist counts but low last-click conversions, since those often deserve more investment than a last-click view suggests. If you want to tighten the models feeding this data, our guide to Google Ads bidding strategies is a good next step.

Question to Answer:

If you switched from Last Click to Data-Driven attribution, would your best campaigns still look like your best campaigns?