On this page
What a B2B Google Ads report needs to tell you
When you sell to other businesses, leads are few and each one can turn into a large order. That is why the report cannot stop at clicks and impressions. It has to show how many good leads came in, what each one cost and which searches they came from. Every other number is there to explain why those go up or down.
Before you build anything, write down what management will ask when they open the report. Usually they want to know how many leads we had, whether they were any good, whether spend is on track and what we will change next month. Each page of the report should answer one of those questions. If a chart answers none, take it out.
The four data sources and what each one adds
A useful report brings four sources together, and each one answers a different question. Google Ads tells you what you paid and for which searches. Google Analytics 4 tells you what people do once they reach the site. Search Console tells you how people find you on Google without ads. And the lead sheet tells you who actually got in touch.
The lead sheet is the source that counts. Google Ads and GA4 count submitted forms, but they cannot tell whether the person writing was a buyer, a student or someone trying to sell you something. In the sheet, someone on the team marks each lead as good or not, and the report only counts the good ones.
GA4 also misses some forms. Since the site added its cookie banner, some people decline measurement and GA4 loses part of them, while every lead still reaches the sheet. So when it comes to counting leads, the sheet always wins, and GA4 tells you where they came from.
| Source | What goes in | What it will not tell you |
|---|---|---|
| Google Ads | Clicks, impressions, cost, cost per click, searches and conversions for each campaign | Whether the lead was any good or whether it will become a sale |
| Google Analytics 4 | What people do on the landing page, where they come from and which forms they send | Visits from people who reject cookies, which are not measured the same way |
| Search Console | Unpaid searches that bring visits, with impressions and clicks | Every search, because Google hides some of them for privacy |
| Lead sheet | Every lead received, with the date, product line, source and whether it is good | Anything the team has not logged |
Are Looker Studio and Data Studio the same tool?
Yes. On 16 April 2026 Google renamed Looker Studio back to Data Studio. It is the same tool for building reports and dashboards from your own data. Many people still search for it as Looker Studio, which is why this guide uses both names.
The five pages your report should have
The Looker Studio report we built for a pharmaceutical equipment manufacturer has five pages, and that order works for almost any B2B company. Each page answers a single question, and the summary comes first because it is what management reads.
The tracking page is the one people open most. In B2B, leads trickle in and a month can bring very few, but clicks and cost per click move every day. If one product line gets more expensive or stops getting clicks, you see it within days rather than at the end of the month. Here are the five pages, in order.
- Monthly summary. Clicks, cost, good leads and cost per lead, next to the previous month.
- Week-by-week tracking. Clicks and cost per click for each day, split by product line.
- Searches that brought visits. The ones that triggered your ads and the ones from Search Console, to decide what to add and what to cut.
- Budget and pace. How much has been spent, how much is left and whether the month will end within the limit.
- Glossary. What each metric means, so everyone on the team reads the numbers the same way.
How to connect the sources in Looker Studio
You can start from scratch or from a template. The Data Studio gallery has Google’s own templates for Google Ads and Google Analytics. Open one, click “Edit and share” to make your own copy and use “Use my own data” to connect your account. Then cut it down to the five pages and remove what you do not need.
Think carefully about which account connects the sources. With owner’s credentials, anyone who opens the report sees the data without needing access to Google Ads. If the person who connected them leaves, or an agency used one of its own accounts, the report can lose its data. Use a company account.
Before connecting anything, put the product line at the start of every campaign name, always written the same way. A calculated field can then pull the line out of the name and split clicks and cost without any manual work. In the lead sheet, write each line with exactly the same name so you can join the two sources. Then connect the four sources like this.
- Google Ads. A data source with the Google Ads connector and your account. With a manager account, one source can cover up to 50 sub-accounts.
- Google Analytics 4. The website’s property and, in the report, only the key events that matter, such as the submitted form.
- Search Console. The URL table if you want to see each landing page, or the site table if you only need the total.
- Lead sheet. A Google Sheet with a single header row and one row per lead. Each data source reads a single tab.

Do you have to pay for Looker Studio?
Not for a report like this one. The Google Ads, Google Analytics, Search Console and Google Sheets connectors are made by Google and work in the standard version. There is a paid version, Data Studio Pro, which adds team workspaces and makes reports belong to the company rather than to whoever created them.
Want us to look at what your Google Ads account counts as a conversion today? Leave your details and we will tell you what we would change first.
Review my accountWhat not to count as a conversion
In Google Ads, your primary conversion should be the lead you received, and nothing else. Primary conversion actions appear in the “Conversions” column and Google uses them for automated bidding. Secondary ones only appear under “All conversions” and play no part in bidding. If you mark something that is not a lead as primary, Google will go looking for more people who do that.
Also switch the count to one conversion per click. For website conversions, Google Ads counts every conversion after a click by default, so someone who sends the form twice adds two leads. With the “One” option, each click counts at most one conversion, which is what you want when the lead is what matters. And none of the following should ever be a primary conversion.
- Visits to the contact or thank-you page when there is no form behind them.
- Time on page, scrolling or clicks on any button.
- Spec sheet downloads, which show interest but are not a lead.
- Clicks on the phone number or email address, which are worth tracking as secondary.
- The same form counted twice, once by the Google Ads tag and again by the event imported from GA4.
How often does the report data refresh?
It depends on the source. Google Ads and Search Console data refresh every 12 hours, and that cannot be changed. A Google Sheet refreshes every 15 minutes by default, and you can set it to every hour, every 4 hours or every 12 hours. That is why a lead from today can show up in the sheet before it appears in Google Ads.
How to read your budget pace
Google Ads does not spend the same amount every day. According to its help centre, on any given day a campaign can spend up to twice its average daily budget, but by the end of the month it will not have spent more than 30.4 times that budget. That is why the budget page compares what you have spent so far with what you would expect at that point in the month.
Take an average daily budget of €30. The monthly maximum is €912, and a single day can spend up to €60. Halfway through the month, a normal pace would be around €450. If you have spent €600, you are ahead and spending will have to slow down. If you have spent €300, there is budget left and it is worth checking whether search volume allows for more.
How often to review the report and what to look at
Every week, a short review so you can correct course in time. Check the tracking page, read the new searches that brought clicks and block the ones that are not from buyers with negative keywords. Check the pace of spend and go through the week’s leads one by one, marking in the sheet whether they were good.
Every month, a longer review to discuss with management. Compare the month with the previous one, look at the cost per good lead for each product line and decide where you put more budget and where less. Write down what you changed and why, because three months from now nobody will remember.
Every quarter, match the leads against what happened next. Look at how many turned into a quote and how many into an order. In B2B, sales take months to close, and a month with few leads can bring the biggest sale of the year. That is why big decisions need several months of data.
Why does Google Ads show fewer leads than my sheet?
Because Google Ads only counts leads that come after a click on an ad and that it was able to measure. The sheet also includes people who phone, send an email or arrive from unpaid search. If the gap is very large, check that the conversion tag is on the thank-you page or fires when the form is sent.
What you can do this week
You do not need everything on day one. With these steps you get a report that already answers the important questions, and you can improve it with whatever the team asks for. When we take on Google Ads management for a company, we follow this same order.
- Write down the three or four questions the report has to answer.
- Make the received lead your only primary conversion, counted once per click.
- Create the lead sheet with the date, product line, source and whether each lead is good.
- Put the product line at the start of every campaign name.
- Copy a Google template, connect the four sources and build the five pages.
- Book a weekly review and a monthly one in the calendar.