Skip to main content

Search Ads 360 API Connector

Updated today

Google Search Ads 360 (SA360) starter guide

Summary

This configuration manages the automated import and refresh of Search Ads 360 (SA360) data into your data platform. It consists of three primary jobs:

  • Delivery Data Import: Imports campaign, adgroup, and keyword-level delivery metrics filtered for impressions greater than zero.

  • Activity Data Import: Imports conversion-related activity data at campaign, adgroup, and keyword levels, filtered for conversions greater than zero.

  • Meta Data Refresh: Regularly refreshes SA360 metadata such as accounts, customers, campaigns, ad groups, and ads for accurate mapping and reporting.

Each job is scheduled to run daily at 6 AM, with lookbacks of 5 days for activity and delivery data and 1 day for metadata. The configuration also defines dimensions, base and composite metrics (like spend, clicks, CTR, CPM, CPC), and how source data joins with metadata tables to provide a unified dataset for analysis.

For more information on this integration, please follow the link here.

Jobs Configuration

1. Job: SA360 - Delivery Data Import

  • Feed: sa360

  • Status: 2 (Active)

  • Job Label: SA360 - Delivery Data Import

  • Lookback: 5 days

  • First Run Hour: 6 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

Table

Description

Filter

Date Column Name

sa360_data_campaign_delivery

Campaign Delivery Data

metrics.impressions > 0

date

sa360_data_adgroup_delivery

Adgroup Delivery Data

metrics.impressions > 0

date

sa360_data_keyword_delivery

Keyword Delivery Data

metrics.impressions > 0

date

2. Job: SA360 - Activity Data Import

  • Feed: sa360

  • Status: 2 (Active)

  • Job Label: SA360 - Activity Data Import

  • Lookback: 5 days

  • First Run Hour: 6 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

Table

Description

Filter

Date Name

sa360_data_campaign_activity

Campaign Activity Data

metrics.all_conversions > 0

date

sa360_data_adgroup_activity

Adgroup Activity Data

metrics.all_conversions > 0

date

sa360_data_keyword_activity

Keyword Activity Data

metrics.all_conversions > 0

date

3. Job: SA360 - Meta Data Refresh

  • Feed: sa360

  • Status: 2 (Active)

  • Job Label: SA360 - Meta Data Refresh

  • Lookback: 1 day

  • First Run Hour: 6 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

Type

Table

Description

Update Mode

Create Target

lookup

sa360_meta_accounts

SA360 - Accounts

refresh

true

lookup

sa360_meta_customer

SA360 - Customers

refresh

true

lookup

sa360_meta_campaign

SA360 - Campaign

refresh

true

lookup

sa360_meta_adgroup

SA360 - AdGroup

refresh

true

lookup

sa360_meta_ad

SA360 - Ad

refresh

true

Connection Settings

Key

Description

Type

Value (example)

Required

sa360_manager_accounts

Top-level Manager Accounts / MCC IDs

text

(user input, max size 60)

yes

google_client_secret

Google Secret value for authentication

hidden

########

yes

google_client_id

Google Client ID for authentication

hidden

########

yes

  • Token: (empty)

  • Username: (empty)

  • Password: (empty)

  • Description: SA360

Dimensions

Name

Result Fields

Account [SA360]

sa360_meta_customer.customer_name

Campaign [SA360]

sa360_meta_campaign.campaign_name

Adgroup [SA360]

sa360_meta_adgroup.ad_group_name

Keyword [SA360]

sa360_data_keyword_delivery.keyword_text

Device [SA360]

sa360_data_campaign_delivery.device

sa360_data_adgroup_delivery.device

sa360_data_keyword_delivery.device

Base Metrics

Name

Description

Formula (aggregate over Campaign / Adgroup / Keyword)

Round

Prefix

Spend [SA360]

Total spend in £

SUM(cost_micros) / 1,000,000 (from campaign, adgroup, keyword tables)

2

£

Clicks [SA360]

Total clicks

SUM(clicks) (from campaign, adgroup, keyword tables)

Impressions [SA360]

Total impressions

SUM(impressions) (from campaign, adgroup, keyword tables)

All Conversions [SA360]

Total conversions

SUM(all_conversions) (from campaign, adgroup, keyword activity tables)

All Conversions Value [SA360]

Total value of conversions

SUM(all_conversions_value) (from campaign, adgroup, keyword activity tables)

Cross Device Conversions [SA360]

Cross-device conversions

SUM(cross_device_conversions) (from campaign, adgroup, keyword activity tables)

Cross Device Conversions Value [SA360]

Value of cross-device conversions

SUM(cross_device_conversions_value) (from campaign, adgroup, keyword activity tables)

Composite Metrics

Name

Formula

Round

Prefix

Suffix

CTR [SA360]

(Clicks [SA360] / Impressions [SA360]) * 100

2

%

CPM [SA360]

(Spend [SA360] / Impressions [SA360]) * 1000

2

£

CPC [SA360]

Spend [SA360] / Clicks [SA360]

2

£

Datasource Joins

Each join specifies how to link fact tables to meta tables using these keys:

Join Index

Source Table

Join Specs

0

sa360_data_adgroup_activity

ad_group_id → sa360_meta_adgroup.ad_group_id

campaign_id → sa360_meta_campaign.campaign_id

customer_id → sa360_meta_customer.customer_id

1

sa360_data_adgroup_delivery

same as above

2

sa360_data_keyword_activity

same as above

3

sa360_data_keyword_delivery

same as above

4

sa360_data_campaign_activity

campaign_id → sa360_meta_campaign.campaign_id

customer_id → sa360_meta_customer.customer_id

5

sa360_data_campaign_delivery

same as above

📊 SA360 Custom Columns Integration Configuration

🔍 Summary

This configuration sets up the automated import of custom activity metrics from Search Ads 360 (SA360). It includes two key jobs:

  1. SA360 - Activity Custom Import:
    Imports campaign, adgroup, and keyword-level custom activity data using a filter on conversions.

  2. SA360 - Meta Data Refresh:
    Refreshes SA360 metadata, specifically the custom column definitions needed to interpret the imported custom metrics.

All jobs are scheduled daily at 6 AM, with a 5-day lookback for activity data and a 1-day lookback for metadata.

⚙️ Jobs Configuration

🛠️ Job 1: SA360 - Activity Custom Import

Field

Value

Feed

sa360

Status

1 (Active)

Label

SA360 - Activity Custom Import

Lookback

5 days

First Run Hour

6 AM

Poll Frequency

24 hours

Lookback Window

0

🎯 Targets

Priority

Table

Description

Filter

1

sa360_data_campaign_activity_custom

Campaign Activity Data

metrics . all_conversions > 0

2

sa360_data_adgroup_activity_custom

Adgroup Activity Data

metrics . all_conversions > 0

3

sa360_data_keyword_activity_custom

Keyword Activity Data

metrics . all_conversions > 0

🛠️ Job 2: SA360 - Meta Data Refresh

Field

Value

Feed

sa360

Status

2 (Active)

Label

SA360 - Meta Data Refresh

Lookback

1 day

First Run Hour

6 AM

Poll Frequency

24 hours

Lookback Window

0

🎯 Target

Priority

Table

Description

Update Mode

Create Target

1

sa360_meta_customColumns

SA360 - Custom Cols

refresh

true

🔐 Connection Settings

Key

Description

sa360_manager_accounts

Manager Account / MCC ID

google_client_secret

Google API Secret used for OAuth

google_client_id

Google OAuth Client ID

google_client_scopes

Google OAuth scopes

🔗 Datasource Joins

Used to join imported custom activity data with SA360 metadata for enriched reporting.

Source Table

Join Specs

sa360_data_adgroup_activity_custom

ad_group_id → sa360_meta_adgroup.ad_group_id
​campaign_id → sa360_meta_campaign.campaign_id
​customer_id → sa360_meta_customer.customer_id

sa360_data_keyword_activity_custom

Same as above

sa360_data_campaign_activity_custom

campaign_id → sa360_meta_campaign.campaign_id
​customer_id → sa360_meta_customer.customer_id

📐 Dimensions & Metrics

Currently empty (no standard dimensions or metrics declared at this config level), as the values are defined dynamically via the customColumns metadata. Once fetched, these can be configured in reporting or downstream data transformations.

Did this answer your question?