Live

Meta and Google Ads data in Google Sheets, refreshed for you

Pick a client, platforms, date range and metrics from the sidebar. We refresh it on schedule and leave your formulas alone.

What you get

Any client and date range

Build a query from the sidebar in a minute.

Refreshed on schedule

Daily, or hourly on Growth.

Formulas left alone

A refresh only writes inside the query’s own output range.

How to connect

Data available

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

  • Refreshes daily, or hourly on Growth
  • Break data down by date or by campaign

Dimensions

  • date
  • campaign
  • campaign status

Metrics

  • spend
  • impressions
  • clicks
  • conversions
  • conversion value

Calculated

  • CTR
  • CPC
  • CPA
  • ROAS

FAQ

Google Sheets 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.

No. It only writes inside the query’s own output range.