
Alex Black
Co-Founder / CEO
For one client’s Google Ads, you don’t need to pay for a reporting tool. Looker Studio is free, it comes with Google’s own Google Ads connector, and a client can open a report you share without a Google Ads login. Pay when you report on several clients or put Google Ads next to other sources, and want every report current each morning without touching it. Then a Google Sheets connector like SyncWith does the job from $24.99 a month.
When agencies switch to us from Supermetrics, I think the reason is mostly price. Free is the best price there is, so start there.
Google makes three of them, and all three are free. The fourth is ours: SyncWith, a connector that pulls your accounts into Google Sheets for you. One naming note: Google renamed Looker Studio to Data Studio in April 2026. This page still says Looker Studio, but Data Studio is the name you’ll see when you open it.
| Tool | What the client gets | Accounts per report | Updates on its own | Cost |
|---|---|---|---|---|
| Google Ads reports (Report Editor, dashboards, scheduled emails) | A file by email, or a login to the account | One account, or every account under a manager account | Scheduled emails | Free |
| Google’s Google Ads add-on for Google Sheets | A Google Sheet you share | One Google Ads account per spreadsheet | Yes, on a schedule | Free (English-language Sheets, US only) |
| Looker Studio with Google’s Google Ads connector | A live report link, no Google Ads login needed | One account, or a manager account with up to 50 sub-accounts | Yes | Free |
| SyncWith for Google Sheets | A Google Sheet per client, or one for all of them | Any number of accounts, from any number of logins | Every 5 minutes, hourly, daily, weekly or monthly | Free Hobby plan, then from $24.99 a month |
Google emails scheduled reports only to people with access to the account’s reports, and manager account reports can also go to people with email-only access. Either way, your client gets a file, not a report that updates in front of them.
We’ve compared Google’s add-on and SyncWith side by side on our Google Ads to Google Sheets page, and the setup is in our guide to exporting Google Ads to Google Sheets.
A report that refreshes once a day uses about 30 refreshes a month. A refresh is one run that pulls new data into your report. We count refreshes, not clients or ad accounts: a report that covers a whole manager account uses one refresh per run.
People refresh more than you’d guess. In Q3 2026, the 12,367 Google Ads reports that ran in SyncWith refreshed 2,084,549 times between them: about 169 each, close to two a day. That’s more per report than Facebook Ads (about 102) or Google Analytics (about 47). Daily is also the schedule people pick most: 55.8% of scheduled SyncWith reports, across all sources. So pick a tool that can refresh itself every day.
So the Business plan, $24.99 a month for 100 refreshes, covers three daily client reports, or one daily report for every client under your manager account. The free Hobby plan’s 35 refreshes run one daily client report for about a month, so you can try it on a real client first.
This is what a sheet that refreshes every morning is good for. Give each client one row and you can see, before your first call, who’s spending ahead of their budget and who’s behind.
| Column | What goes in it | Formula (row 2) |
|---|---|---|
| A | Client | Typed in |
| B | Monthly budget | Typed in |
| C | Spent this month, up to yesterday | The cost total from the client’s month-to-date report |
| D | Expected by now | =B2*(DAY(TODAY())-1)/DAY(EOMONTH(TODAY(),0)) |
| E | Pace | =IF(D2=0,"",C2/D2), formatted as a percent |
Column D is the budget times the days finished so far, divided by the days in the month.
Say a client’s budget is $3,000 and it’s October 15. Fourteen of 31 days are done, so they should have spent about $1,354.84. If they’ve spent $1,500, the pace is 111%: on track to go over unless you pull back. Don’t panic over a single day, though: Google lets a campaign spend up to twice its average daily budget on one day, but over a month it won’t spend more than 30.4 times the daily budget.
Pace on spend, not conversions. Google counts a conversion on the day of the click, so last week’s numbers can still go up this week. Google also says reporting lags can take up to 24 to 48 hours.
Keep it short enough that a client reads all of it:
If the same client also runs Meta ads, the report has the same shape. Our Meta Ads reporting guide covers the parts that work differently there.
Send every client’s Google Ads data to Google Sheets on a schedule
Start on the free Hobby plan, with 35 refreshes a month.
Set up Google Ads in Google Sheets