Skip to content

Last updated

Marketing and analytics · data connector

Automated Google Ads reports, delivered on schedule

Rahoto connects to Google Ads through Google sign-in and lists the customer accounts it can see. For the account you choose it offers five ready-made reports, Campaign Performance, Ad Group Performance, Keyword Performance, Search Terms and Geographic Performance, each a set Google Ads query of attributes, metrics and the date. By default they cover the last 30 days.

Connect Google Ads Read connection guidance

What Rahoto reads

Five ready-made reports

Each report is a fixed set of Google Ads fields, listed here exactly as Rahoto requests them.

What Rahoto reads from Google Ads, with the fields it requests
Report What it covers Fields
Campaign Performance Daily campaign performance metrics

campaign.id , campaign.name , campaign.status , campaign.advertising_channel_type , metrics.impressions , metrics.clicks , metrics.cost_micros , metrics.conversions , metrics.ctr , metrics.average_cpc , segments.date

Ad Group Performance Ad group level metrics

ad_group.id , ad_group.name , ad_group.status , campaign.name , metrics.impressions , metrics.clicks , metrics.cost_micros , metrics.conversions , metrics.ctr , segments.date

Keyword Performance Keyword level performance

ad_group_criterion.keyword.text , ad_group_criterion.keyword.match_type , campaign.name , ad_group.name , metrics.impressions , metrics.clicks , metrics.cost_micros , metrics.conversions , metrics.average_cpc , segments.date

Search Terms Search query performance

search_term_view.search_term , campaign.name , ad_group.name , metrics.impressions , metrics.clicks , metrics.cost_micros , metrics.conversions , segments.date

Geographic Performance Performance by location

geographic_view.country_criterion_id , geographic_view.location_type , metrics.impressions , metrics.clicks , metrics.cost_micros , metrics.conversions , segments.date

How you connect

What you need before connecting

Sign-in
Google sign-in (OAuth)
Access requested

https://www.googleapis.com/auth/adwords

Choosing what to read
After sign-in, Rahoto lists the Google Ads customer accounts that sign-in can see, and you pick from the list.
You provide
  • The Google Ads customer ID, in the 123-456-7890 form (optional)
  • A manager (MCC) account ID, if you sign in through one (optional)
Defaults
  • Date range: the last 30 days

Connectors read from your sources and are read-only by default. See the connection guidance for the steps.

How it refreshes

Refreshed on your schedule

Refresh mode: Snapshot.

  • On each scheduled run Rahoto takes a fresh snapshot of the data and rebuilds the report from it.
  • You can preview the data before you bind it to the page.
  • Before an issue goes out, Rahoto checks the pages and notices when a source changed shape.
  • Google Ads limits how fast its API can be read, and Rahoto paces its requests to stay within that limit.

Where the report goes

Delivered where your readers already work

Slack
thread or channel
Teams
channel post
Email
inline or attached
Web
viewer or embed
Webhook
your endpoint
S3
bucket drop
Drive
shared folder
SFTP
your server

Web publishing is on every plan; the other seven channels come with every paid plan. PDF, PowerPoint and PNG travel on any of them.

An example report

Weekly performance pack

Every Monday morning, built from Google Ads.

  1. A cover with the reporting period and the account it covers
  2. A headline page: the period’s main measures, each with a line of commentary your team writes
  3. A trend chart for each headline measure across the date range
  4. A breakdown table by campaign, channel or page, from the report that carries it
  5. A closing page of notes and next steps

The structure of a report, with no figures shown. You design the pages; Rahoto binds them to the data and sends them on schedule. See finished examples in the sample gallery.

Connect Google Ads and set the schedule

Bind it into the document, check a run, and choose where it goes.

Start 14-day trial Read connection guidance