Datapipe
Start free

Client reporting · USE CASE

Know what changed before the client call.

Review GA4, Search Console, and Google Ads together. Bring the numbers and a useful next question to the conversation.

Google AnalyticsSearch ConsoleGoogle Ads
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE
The client review, in three numbers
Website sessions · GA4+18.4%12,500 → 14,800
Search clicks · GSC+20.0%2,000 → 2,400
Ad spend · Google Ads+50.0%$1,440 → $2,160
Oct 5 – Nov 1, 2026 vs previous 28 days

Compare the same complete periods across the three sources.

EXAMPLE CONVERSATION

Your question.
A useful answer.

✦ AI assistant
Google AnalyticsSearch ConsoleGoogle Ads
YOU

  1. 01
    GA4 + Search ConsoleLead with this

    Next

  2. 02
    Google Ads · USDDiscuss next

    Next

Last 28 days · compared with previous 28 days

01 · CONNECT YOUR DATA

Your tools. One place to ask.

3 of 3 Free data sources
No credit card · Daily refresh

Google AnalyticsSearch ConsoleGoogle Ads
DatapipeYour project
Your AI assistantor a report in Sheets / Data Studio
  1. Create your free workspace

    Sign up with your company email. Your first project opens on Data sources.

  2. Add the data sources

    Choose the accounts for this workflow. Authorize access and select the property or site.

  3. Bring your question

    Connect your project to a supported AI assistant, or build your source reports.

Create a free account →
Setup steps & what you need

Email/password signups confirm their email first. Use Google signup with a company account if you prefer.

  • Google Analytics: Authorize Google Analytics and select the GA4 property for the same website. Setup guide ↗
  • Search Console: Authorize Search Console with Google and select the property you can access. Setup guide ↗
  • Google Ads: Authorize Google Ads and select the intended customer account. Check availability ↗

Free includes 3 data sources across the workspace. One account/property added to one project counts as one. Extra properties or the same account in another project use another slot.

02 · ASK A USEFUL QUESTION

Start with a prompt.
Follow the evidence.

Copy these in order into your connected assistant.
Each builds on the answer before it.

01

Prepare the client’s comparison

Read the full prompt
Use only this Datapipe project’s authorized data sources. Discover the connected accounts, datasets, and fields first. If the right account or required data is missing, ask me rather than substituting sample data. Show the actual dates, filters, coverage, and any partial results.

For this client’s project, compare the latest complete 28 days with the preceding 28 days. Report GA4 sessions, Google Search Console clicks, and Google Ads spend separately. Show source, dates, account currency, current and prior values, absolute change, and percentage change. Do not combine clicks and sessions or infer attribution.
02

Explain what changed

Read the full prompt
Use only those returned reports to draft a concise client-call summary: what grew, what needs attention, and three questions worth investigating. Separate observations from hypotheses. A spend increase is not automatically an improvement, and missing data must remain visible.
03

Turn it into a client agenda

Read the full prompt
Create a five-point review agenda using that summary. For each point include one observed number, one relevant question, and the next analysis needed. Do not invent ROI, attribution, or a cause that the data does not establish.
Need to connect your assistant?Claude guide ↗ChatGPT guide ↗

03 · USE WHAT YOU FIND

Explain the gains and the cost alongside them.

  1. 01

    Refresh each client’s saved reports on a schedule.

  2. 02

    Compare the same periods within each source.

  3. 03

    Share the output and add the explanation the client needs.

Check the result at your next review.

At the next review, revisit the agreed questions using the same metric definitions. Track which questions were answered rather than treating a generated summary as the final explanation.

Implementation tips for this use case

Refresh the saved reports before each review, check account/date/currency context, then add what you know about campaigns, launches, or business changes. Share only the relevant client project or destination.

WHEN YOU NEED MORE CONTEXT

Go a little deeper.

The method and reporting checks
behind this example.

How to prepare a client performance review

  1. Choose the client’s project and accounts.

    Keep each client’s data in its authorized project. Connect the relevant GA4, Search Console, and Google Ads accounts using their source guides.

  2. Compare equal periods within each source.

    Read sessions, search clicks, and spend for the same review window and comparison window. Keep the metrics separate; they do not count the same activity.

  3. Build the narrative from the returned evidence.

    Use Sheets or Data Studio for the reporting view, or ask the connected assistant to summarize the reports. Add campaign and business context before the client call.

See the complete example report
EXAMPLE REPORTFictional sample data

The client review, in three numbers

Oct 5 – Nov 1, 2026 vs previous 28 days

The client review, in three numbers · fictional sample data
MetricPreviousCurrentChange
Website sessions · GA412,50014,800+18.4%
Search clicks · GSC2,0002,400+20.0%
Ad spend · Google Ads$1,440$2,160+50.0%
WHAT TO LOOK ATSearch clicks rose 20%. Ad spend rose 50%.

Explain the gains and the cost alongside them.

Illustrative report output · no live query or source change

The review shows traffic and search clicks growing, while paid spend rose faster. That gives you a specific question for the client conversation without claiming the three metrics measure the same thing.

Try the example with sample CSVs

Fictional rows matching the example above. Attach these files to your assistant for a sample analysis.

Data method, reporting checks & sources

Keep each metric at its native source and period grain. Combine independent scorecards in Sheets or Data Studio; do not add sessions to clicks or infer attribution from this comparison. The spend example uses a single USD advertising account.

More spend is not automatically better or worse. This example is a discussion prompt, not a return-on-investment calculation. Client access and delivery destinations must be configured separately.

  • The client, accounts, dates, and currency are the intended ones.
  • Source-specific metrics remain independent rather than being added together.
  • The summary cites numbers, distinguishes hypotheses, and keeps cost increases neutral.
  • The client’s authorized data source accounts in their project.
  • Comparable date ranges and the correct currency.
  • A configured destination or permitted sharing method.

For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions. This is an illustrative workflow; live accounts and destinations need their own setup.

Report starting points ↗

A FEW USEFUL ANSWERS

Before you start.

Can I turn the three sources into one growth percentage?

No. Sessions, search clicks, and ad spend measure different things. Show their changes alongside each other, and do not add or average them into an invented overall growth metric.

Can the assistant tell me why performance changed?

It can suggest investigations from the returned evidence. A causal explanation needs the relevant campaign, tracking, market, or business context. Keep observations separate from hypotheses.

YOUR NEXT STEP

Try it with your own data.

Start free with up to 3 data sources. No credit card.

Start free →

What else are you working on?

Browse all use cases →
SEO & content · 3 data sources

Which pages work on Google but struggle on Bing?

Compare Search Console and Bing page performance, then use WordPress content to choose the next investigation.

Search ConsoleBing WebmasterWordPress
See the example SEO & content · 3 data sources

Should we refresh a page or write something new?

Combine Search Console, current WordPress content and a Google Sheet of DataForSEO research to decide what deserves a brief.

Search ConsoleWordPressGoogle Sheets
See the example