Google Ads

garf for Google Ads API

Install

Install garf-google-ads library

pipuv

pip install garf-executors garf-google-ads

uv pip install garf-executors garf-google-ads

Usage

Prerequisites

Google Ads API enabled.

clipython

echo """
SELECT
  campaign.id,
  metrics.clicks AS clicks
FROM campaign
WHERE segments.date DURING LAST_7_DAYS
  " > query.sql
garf query.sql --source google-ads \
  --output console

import os

from garf_io import writer
from garf_google_ads import GoogleAdsApiReportFetcher

query = """
SELECT
  campaign.id,
  metrics.clicks AS clicks
FROM campaign
WHERE segments.date DURING LAST_7_DAYS
"""

fetched_report = (
  GoogleAdsApiReportFetcher(
    path_to_config=os.getenv('GOOGLE_ADS_CONFIGURATION_FILE_PATH')
  )
  .fetch(query, account=os.getenv('GOOGLE_ADS_ACCOUNT'))
)

console_writer = writer.create_writer('console')
console_writer.write(fetched_report, 'query')

Available source parameters

name	values	comments
`account`	Account(s) to get data from	Can be MCC(s) as well
`path-to-config`	Path to `google-ads.yaml` file	`~/google-ads.yaml` is a default location
`expand-mcc`	Whether to force account expansion if MCC is provided	`False` by default
`customer-ids-query`	Optional query to find account satisfying specific condition
`version`	Version of Google Ads API