garf-bid-manager 0.0.2

Garf implementation for Google Bid Manager API

garf for Bid Manager API

garf-bid-manager simplifies fetching data from Bid Manager API using SQL-like queries.

Prerequisites

• Bid Manager API enabled.
• Credentials configured.

Installation

pip install garf-bid-manager

Usage

Run as a library

import garf_bid_manager
from garf_io import writer

# Fetch report
query = """
  SELECT
    advertiser_name,
    metric_clicks AS clicks
  FROM standard
  WHERE advertiser = 1
    AND dataRange = LAST_7_DAYS
"""
fetched_report = (
  garf_bid_manager.BidManagerApiReportFetcher()
  .fetch(query, query=query)
)

# Write report to console
console_writer = writer.create_writer('console')
console_writer.write(fetched_report, 'output')

Run via CLI

Install garf-executors package to run queries via CLI (pip install garf-executors).

garf <PATH_TO_QUERIES> --source bid-manager \
  --output <OUTPUT_TYPE> \
  --source.<SOURCE_PARAMETER=VALUE>

where:

• <PATH_TO_QUERIES> - local or remove files containing queries
• <OUTPUT_TYPE> - output supported by garf-io library.
• <SOURCE_PARAMETER=VALUE - key-value pairs to refine fetching, check available source parameters.

Available source parameters

name	values	comments
credentials_file	File with Oauth or service account credentials	You can expose credentials_file as GARF_BID_MANAGER_CREDENTIALS_FILE ENV variable