Data Studio and Google Sheets

Client reporting for Meta and Google Ads

Every client’s ad data, grouped and kept fresh in Data Studio (formerly Looker Studio), Google Sheets or your AI assistant.

Free for 1 client. Paid plans from $19 a month.

Reports for one client or all of them

Three data sources in Data Studio: Meta Ads, Google Ads, and both combined.

Reports per client

Accounts are grouped by client, so each report shows one brand across its Meta and Google Ads.

Compares every client

A cross-client overview shows all your clients side by side in one report.

Adds budget pacing

Monthly budget, month-to-date spend, projected spend and pacing % are ready as fields.

Client numbers in Google Sheets

Pick a client, platforms, date range and metrics from the sidebar. Refreshes only write inside the query’s own output range.

  • Break data down by date or by campaign
  • Refreshes daily, or hourly on Growth
  • Your formulas are left alone

See the Sheets add-on

Reports that load fast and show their age

Reads from stored data

Reports read from our stored data instead of calling the ad platforms each time, so they load faster.

Shows when data updated

Data Studio and Sheets reports can show when their data was last updated.

Warns before reports go wrong

If a connection breaks, you get one notice with the fix before anyone reads a stale report.

See data health

Campaign fields in every report

Data is at campaign level, in each ad account’s own currency and time zone.

Dimensions

  • date
  • campaign
  • campaign status

Metrics

  • spend
  • impressions
  • clicks
  • conversions
  • conversion value

Calculated

  • CTR
  • CPC
  • CPA
  • ROAS

FAQ

Client reporting questions

How we handle client data

  • Read-only accessWe never pause campaigns or change budgets.
  • Sign in with Meta and GoogleWe never see your passwords.
  • Encrypted access tokensStored encrypted at rest.
  • No customer personal dataOnly campaign performance and your client groups.
  • Your data, your callDelete your account and the data goes within 30 days.
Read the security page
Still have a question?

Email support@myprometrics.com. We reply within one business day.

Data Studio (formerly Looker Studio) and Google Sheets on every plan. Claude, ChatGPT and Gemini connect on Solo, Agency and Growth.