North Report — Advertising Data Reporting Platform

Overview

North Inc. is a digital marketing agency in Tokyo, Japan. We manage paid search and display advertising on behalf of client companies, and their Google Ads accounts are linked to our manager account (MCC 615-276-0062) with each client's approval.

North Report consolidates delivery results from several advertising platforms (Google Ads / Yahoo! Japan Ads / Microsoft Advertising) into BigQuery and normalises them into a common set of metrics. Support for Meta Ads is being added. Each client we work for has a dedicated report screen.

Our account managers no longer have to open each platform's console separately: daily, weekly and monthly trends, the breakdown by campaign, and changes in cost per conversion are all followed on one screen.

North Report summary screen, showing cost, conversions and CPA cards with a month-to-date summary table — Summary screen. Cost, conversions and CPA across platforms, together with month-to-date progress and a projected month-end figure, on a single screen.

Client names and performance figures in the screenshots are masked under our confidentiality obligations.

Key features

Cross-platform aggregation of delivery results (impressions, clicks, cost, conversions)
Daily / weekly / monthly and per-campaign trend views
Consolidated view of conversions that platform tags cannot measure, such as phone enquiries
Performance analysis at the creative level (ad headlines, descriptions and images)
Automatically generated summary comments derived from the performance data

North Report monthly trend screen, listing metrics for the last 13 months with an automatically generated summary comment — Monthly trend. Medium- and long-term trends are listed metric by metric, with a summary comment generated from the data shown below the table.

North Report campaign performance screen, listing metrics per campaign and platform — Campaign performance. All metrics, plus each campaign's share of cost and conversions, compared per campaign and platform.

Users and access

Who uses the tool: North employees (account managers and analysts), and designated staff at the client companies whose accounts we manage.
Do clients log in: Yes. Clients can view read-only reports for their own accounts only. They cannot access other clients' data and cannot operate any ad account.
Is it sold or licensed: No. Not a product, SaaS offering, or service resold to third parties. Access is provided only to clients under our management contract.
Publicly reachable: No. Google account sign-in required (Identity-Aware Proxy), with access granted per individual.

Google Ads API usage

We manage our clients' advertising accounts through a Google Ads manager account (MCC, ID 615-276-0062). The API is used solely to read performance data from the accounts linked to that manager account.

Day-to-day results at campaign, ad group and ad level are retrieved through BigQuery Data Transfer Service, and we intend to keep using it. Asset-level results (headlines, descriptions and images) cannot be obtained from that service — in our own transferred tables, asset performance rows for HEADLINE and DESCRIPTION field types are absent, asset names for text assets are empty, and image asset URLs are not present in the schema. The Google Ads API fills exactly that gap, so that we can compare which creative performs better.

What we retrieve

Asset-level performance metrics (impressions, clicks, conversions, cost)
Ad headline and description text
Image asset URLs

How we call it

Read-only. We call GoogleAdsService.SearchStream to run GAQL queries
We do not call any mutate service. We do not create, modify, pause or remove campaigns, ad groups, ads, keywords, bids or budgets through the API
Once per day, as a scheduled batch job in the early morning (JST), at a volume of a few dozen requests per day
Retries use exponential backoff

The data retrieved is used only inside North Report, for the clients whose accounts it came from. It is not made public, sold or licensed to any third party.

Data handling

Retrieved data is stored in BigQuery within our own Google Cloud project and is used only to display reports. Each client has a separate dataset and access is granted per dataset, so one client's data is never visible in another client's report.

We do not retrieve or store personally identifiable information. The data consists of aggregated delivery metrics and creative content (ad text and image URLs) belonging to the advertiser.

Credentials — the developer token, OAuth client ID and secret, and refresh tokens — are held in Google Secret Manager. They are not written into source code or configuration files. If a client relationship ends, the account link to our manager account is removed and we stop retrieving data for that account.

Advertising data
reporting platform.

Overview

Key features

Users and access

Google Ads API usage

What we retrieve

How we call it

Data handling

Provider

Advertising datareporting platform.

Overview

Key features

Users and access

Google Ads API usage

What we retrieve

How we call it

Data handling

Provider

Advertising data
reporting platform.