Digital Marketing Agency in Pune: How to Set Up a Looker Studio Dashboard You Actually Own (Ads, SEO and Leads in One View)

Digital Marketing Agency in Pune: How to Set Up a Looker Studio Dashboard You Actually Own (Ads, SEO and Leads in One View)

A Looker Studio dashboard is a free report builder from Google that reads live data from your ad accounts, analytics and spreadsheets and lays it out on one page. To set one up properly, create the report and every data source under a Google account that belongs to your business, connect Google Analytics 4, Google Ads and Search Console through Google's own connectors, bring Meta Ads and CRM data in through a partner connector or a Google Sheet, and show each channel's own numbers side by side with a single leads and enquiries figure from your own records. If you are comparing a digital marketing agency in Pune, ask early who will own that report. A dashboard living in the agency's login is a rented dashboard, and it can vanish the day the contract ends.

This guide is for business owners and marketing managers who pay for ads or SEO and want one honest view of results without learning to build reports. It covers which sources connect natively and which need partner tools, what to show per channel, why platform numbers and your own lead count rarely match, how data freshness works, how to keep ownership and permissions in your hands, a simple page layout, a worked example, and questions to ask an agency. Product facts come from Google's Looker Studio documentation, read in October 2026. Google reorganises these pages often, so check the live page before you act. The worked example uses illustrative numbers only. This guide does not cover payments, shipping or tax.

What a Looker Studio dashboard is, and what it is not

Looker Studio does not store your marketing data. It is a viewing layer. Each chart asks a data source, a saved connection to a Google Ads account, a GA4 property, a Search Console site or a Google Sheet, for numbers, and the data stays where it was.

Three consequences follow. The dashboard is only as good as the tracking behind it, so if a form submission is not recorded in GA4, no chart will invent it (our guide to GA4 conversion tracking setup in India covers that groundwork). The dashboard is not the system of record; your CRM or a disciplined spreadsheet is. And two things have owners, the report and each data source, which are separate objects.

Which data sources connect natively and which need a partner

Google divides connectors into those it builds and those built by others. Google's available-connectors page lists the Google connectors, and for marketing the relevant group is Google Marketing Platform, which includes Google Analytics, Google Ads, Search Console and YouTube Analytics, alongside others such as Campaign Manager 360 and Display & Video 360. The same list includes Google Sheets, CSV upload, BigQuery and several database connectors. These need no extra subscription from Looker Studio's side, though the underlying ad accounts and data are yours, with their own costs.

What to settle before buying a partner connector

Ask who holds the subscription (if it sits in the agency's workspace, the dashboard dies when they leave), whose credentials it authorises against (a Meta admin on your own business account, so you can revoke it) and the monthly cost, in writing. Vendors such as Supermetrics, Funnel.io, Windsor.ai and Power My Analytics sell these, per the comparison pages I read; I have not verified any price. For a cheap fallback, have your CRM or form tool write one row per lead into a Google Sheet you own and connect it with the Sheets connector; keep raw rows on one tab.

What to show for each channel

A dashboard fails when it tries to show everything. Pick a few numbers per channel that answer a decision you actually make.

Google Ads

• Spend, clicks, impressions for the period, so you can see volume.
• Conversions and cost per conversion, using the conversion actions you have agreed count as a lead. Check which actions are marked as primary, because an agency can make the headline number look better by counting soft actions such as page views.
• Search impression share, if the account is mainly search campaigns, to show whether you are missing demand you are already paying for.
• Top campaigns by spend with their conversions, in a table.

Meta Ads

• Spend, reach or impressions, link clicks.
• Leads or results as Meta reports them, labelled clearly as Meta's number.
• Cost per lead as Meta reports it.
• Creative-level results, in a small table, if the agency tests ads.

SEO: Search Console and GA4 organic

• Clicks and impressions from Search Console, with the average position treated as a rough trend rather than a promise.
• Top queries and top pages, so you can see whether visibility is on the pages that sell.
• Organic sessions and organic conversions from GA4, which show what search visitors did after they arrived.

Search Console counts appearances and clicks in Google Search; GA4 counts sessions its tag recorded. They will not match, and the gap is not necessarily an error.

Leads and sales (CRM or Sheet)

This is the section most agency dashboards leave out, and it is the one an owner cares about most.

• Total leads received, by source as the CRM records it.
• Leads by stage: new, contacted, qualified, site visit or demo booked, won.
• Speed to first contact, if you record timestamps.
• Lost reasons, as a short list.

If you do not yet record stages, start with two: "qualified" and "won".

Blended numbers versus platform numbers

Platform numbers are what each system reports about itself: Google Ads says 40 conversions, Meta says 55 leads, GA4 says 70 key events. Each uses its own attribution rules and look-back windows and tends to credit itself, so adding them up usually overcounts. Your own numbers are what your CRM or enquiry sheet records, counted once per person. Treat that as ground truth for volume.

The honest layout shows platform numbers labelled as platform numbers, shows your CRM count as the single total, and puts them side by side. The gap is information: overlap between channels, tracking loss, or leads that arrived by phone or walk-in.

What "blending" means in Looker Studio

Looker Studio also has a feature called blending, which joins several sources in one chart. Google's documentation says a blend can use up to five data sources, supports inner, left outer, right outer, full outer and cross joins, and only equality in join conditions. A blend lives inside the report that created it and cannot be reused elsewhere. It has no freshness or credential settings of its own, inheriting them from its sources, and uses the shortest refresh time among them. Data is aggregated per table before joining, so without a unique key identical rows can merge and counts come out lower than expected.

Blending suits joining Google Ads campaign names to a sheet that maps campaigns to products. It does not remove double counting: two platforms that both claim a lead will both still claim it. Keep CRM leads as the total.

Data freshness, caching and sampling

Owners often ask why the dashboard does not match the live ad platform. Usually the answer is freshness.

Google's data freshness page explains that Looker Studio keeps recent query results in memory and reuses them until a freshness threshold passes, then fetches new data. The documented thresholds differ by connector:

• Google Ads, Search Console and some other Google ad and measurement connectors: refreshed every 12 hours, and the page says this cannot be changed.
• Google Analytics: the table lists options of 1, 4 or 12 hours with 12 hours as the default, although the page's own introduction describes Google marketing products as fixed at 12 hours. Check the setting on your own data source, since the documentation is not fully consistent here.
• Google Sheets: options of 15 minutes, 1, 4 or 12 hours, with 15 minutes as the default.
• Partner and community connectors: vary by connector, so ask the vendor.

Editors can refresh manually; viewers can only if the viewer-refresh option is on. A report's auto-refresh does not change a data source's freshness setting, so a report refreshing every minute can still show cached data. With owner's credentials all viewers share one freshness setting.

Sampling, thresholds and processing delay

GA4 reports can also be affected by sampling, privacy thresholds and a processing delay; I did not re-verify the exact rules for the connector in October 2026, so treat the latest day or two as provisional. Ad platforms also revise conversions after the fact, as late conversions are credited back to earlier clicks. Report on completed periods, note the data cut-off on the page, and use one date range on every chart.

Ownership and permissions: the part owners skip

This is the section that decides whether you own your dashboard.

Two objects, two owners

In Looker Studio there are two things to check:

1. The report, which has an owner who can share, delete or transfer it.
2. Each data source, which carries a credential type and a credential owner.

A report you own, built on data sources whose credentials belong to an agency employee, is only half yours. If that person leaves, your charts can turn blank.

Owner's credentials versus viewer's credentials

Google's documentation describes two credential types for a data source:

• Owner's credentials. The data source uses the credential owner's authorisation, so viewers do not need their own access to the underlying data. Google's example is a viewer who cannot access a Google Analytics view but can still see the report. This is the usual choice for sharing a dashboard with a director or a client.
• Viewer's credentials. Each viewer must authorise with their own access. People without access to the underlying data see no data.

Google adds that editors can change the credential type and can make themselves the credential owner with the "Make me the owner" option, and that a data source using your credentials keeps retrieving data after you lose edit access unless you revoke the credentials. Switching credential types can also cause errors for people without access to the underlying dataset.

So the credential owner should be someone on your side, using a business Google account that is a listed user on GA4, Google Ads and Search Console.

• The report owner is a business-domain Google account, at least two people on your side can edit, and the agency is an editor rather than the owner. Our onboarding, access and tracking checklist covers the access handovers.
• Sharing is restricted to named people, not "anyone with the link", for a report that shows revenue or lead details.
• Prefer totals over names, phone numbers or emails; ask a qualified lawyer about your duties under India's data protection law.

If the answer to "who owns the report?" is "we do, you have view access", ask for a copy under your account and a written list of each data source's credential owner.

A simple page layout

Three pages are enough for most small and mid-size businesses.

Page 1, Summary (a two-minute read): five scorecards for total spend, CRM leads, qualified leads, cost per lead and cost per qualified lead, each compared with the previous period; a line chart of leads per week for twelve weeks; and a text box where the agency writes what changed and what it plans next.

Page 2, Paid media: Google Ads and Meta side by side with spend, platform-reported results and cost per result, each labelled as the platform's own number; a campaign table sorted by spend; creative-level results for Meta and search-term highlights for Google.

Page 3, SEO and website: Search Console clicks and impressions with top queries and pages; GA4 sessions and key events by channel; a landing-page table with sessions and key events.

Add one date control that applies to every page, a channel filter, and a short definitions box stating what counts as a lead, which attribution each platform uses and when data was last checked. If leads arrive through WhatsApp, a WhatsApp CRM that records each conversation's stage gives the dashboard more than "clicked the button". For the site itself, see our website creation page.

A worked example (illustrative numbers only)

This is a hypothetical example to show how the pieces fit. The figures are invented placeholders, not a client result and not a benchmark.

A Pune physiotherapy clinic spends on Google search ads and Meta lead ads, writes a few articles a month for SEO, and takes enquiries by form, phone and WhatsApp. The front desk logs each enquiry in a Google Sheet that the clinic owns, with columns for date, name, phone, source as told by the patient, stage and notes.

Month in the dashboard (illustrative):

The platforms together claim 30 + 45 = 75 conversions, and GA4 adds 25 organic key events on top. The sheet says 70 distinct people enquired. The owner reads the dashboard like this:

• Total enquiries is 70, not 100 or more. The platforms overlap, and some people use more than one route.
• Cost per enquiry across paid is 70,000 divided by the paid-attributed enquiries, not by 75. If the clinic knows from the "source" column that, say, 50 of the 70 came from paid, then paid cost per enquiry is 1,400, and the owner can compare that to the platforms' own cost per result to see how far they differ.
• Cost per qualified enquiry matters more. If 28 became appointments and 20 of those were paid-sourced, paid cost per appointment is 3,500. A channel with cheaper leads but fewer appointments may be the weaker channel.
  Now the setup. Google Ads, GA4 and Search Console connect through Google connectors, authorised by the clinic's own business account that has been given read access on each. Meta comes in through a partner connector subscribed to in the clinic's name, authorised by the clinic's Meta business admin. The sheet connects through the Google Sheets connector. The report is owned by the clinic's business account, with the agency as editor. The data freshness for Google Ads is the fixed 12 hours, so the owner knows not to expect last night's spend at 9 am.

Everything above is a teaching device. Your numbers will differ.

Questions to ask a digital marketing agency about reporting

1. Who will own the Looker Studio report, and which Google account will be listed as owner?
2. For each data source, who is the credential owner, and can you show me the settings?
3. Which connectors are Google's own and which are partner connectors? Who pays for the partner ones, and what will they cost per month?
4. How will Meta and CRM data get into the report, and how often will it refresh?
5. Which conversion actions count as a lead for Google Ads and Meta, and how do they relate to my CRM count?
6. Will the dashboard show my own lead and qualified-lead numbers beside the platform numbers?
7. What happens to the dashboard, the connectors and my data access if we end the contract?
8. Can you give me a copy of the report template and the definitions in writing?

An agency that answers clearly and shows the screens is one you can work with. Our post on retainer deliverables and reporting lists what a reporting line item in a retainer should include.

A checklist you can use

• Report and all data sources owned by a business Google account; at least two internal editors
• GA4, Google Ads and Search Console connected through Google connectors; Meta and CRM through partner connector or Sheet, subscribed in your name
• Summary page shows CRM total leads and qualified leads next to platform-reported results, labelled
• Same date range and completed periods throughout; data cut-off and definitions shown on the page
• Sharing restricted to named people; personal lead details limited; agency set as editor, not owner

Working with Govindani Infotech

Govindani Infotech is a web design and development company at 2nd Floor, Landmark Plaza, 206 Satara Road, Parvati Paytha, Pune 411009. A dashboard is only worth trusting if the website, forms and CRM underneath it record the right things, and that wiring is where our work usually starts. We can look at your current setup, check who owns each report and data source, and tell you what is solid and what is held together by one person's login. We build the forms, thank-you flows and CRM hand-offs that feed the numbers, and we do not promise lead volumes or cost figures.

For the traffic side, see our SEO and Google Ads services; for the site and enquiry flow, see lead generation. To talk to us, use the contact page or message us on WhatsApp.

Frequently Asked Questions

Is Looker Studio free for a small business?

I did not confirm Google's current pricing terms in October 2026, so check Looker Studio's own page. Costs most often come from partner connectors, such as one for Meta Ads, and from any BigQuery or database usage you add.

Does Looker Studio connect to Meta Ads directly?

Not through the Google connector list I read in October 2026. Meta data generally comes in through a partner or community connector, or through an export to Google Sheets or BigQuery. Ask for the current price and make sure the subscription is in your business name.

How often does Looker Studio data refresh?

It depends on the connector. Google's documentation lists 12 hours for Google Ads and Search Console, options of 1, 4 or 12 hours for Google Analytics, and 15 minutes up to 12 hours for Google Sheets. Report auto-refresh does not override the data source's freshness setting.

Who should own the report and the data sources?

Your business, through a Google account on your own domain, with the agency added as an editor. Report ownership and data source credentials are separate settings, so check both. Google notes that a data source can keep using its owner's credentials until they are revoked.

Why do my dashboard numbers not match Google Ads or Meta?

Common reasons are cached data, different attribution windows, conversions credited back after the fact, different date ranges, and each platform counting its own conversions. Use your CRM count as the single total and treat each platform's figure as that platform's own claim.

Sources:

• https://docs.cloud.google.com/looker/docs/studio/available-connectors
• https://docs.cloud.google.com/looker/docs/studio/manage-data-freshness
• https://docs.cloud.google.com/looker/docs/studio/data-credentials-article
• https://docs.cloud.google.com/looker/docs/studio/how-blends-work-in-looker-studio
• https://seranking.com/blog/looker-studio-connectors/ (secondary summary of partner connectors)