Advertising
Search Ads 360 schema
SightShark syncs Search Ads 360 into a data warehouse you own. It creates 22 tables holding 305 fields, refreshed daily. Customer, campaign, ad group and ad structure with engine ids, plus day-level and hour-level report tables at each level, split by device and by conversion action.
22 tables / 305 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
campaign_report
25 fields
- customer_id
- campaign_id
- bidding_strategy_id
- date
- all_conversions
- all_conversions_value
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- content_budget_lost_impression_share
- content_impression_share
- content_rank_lost_impression_share
- conversions
- conversions_value
- cost_micros
- ctr
- historical_quality_score
- impressions
- search_budget_lost_impression_share
- search_impression_share
- search_rank_lost_impression_share
- visits
keyword_device_report
18 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- ad_group_criterion_criterion_id
- ad_group_criterion_engine_id
- date
- device
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- cost_micros
- ctr
- impressions
- visits
campaign
17 fields
- advertising_channel_sub_type
- advertising_channel_type
- bidding_strategy_id
- creation_time
- customer_id
- end_date
- engine_id
- id
- labels
- last_modified_time
- name
- network_settings_target_content_network
- network_settings_target_google_search
- network_settings_target_partner_search_network
- network_settings_target_search_network
- start_date
- status
customer
12 fields
- account_type
- associate_manager_id
- creation_time
- currency_code
- descriptive_name
- engine_id
- id
- last_modified_time
- manager_id
- status
- sub_manager_id
- time_zone
ad_group
18 fields
- ad_group_bid_modifier_bid_modifier
- ad_group_bid_modifier_device_type
- bidding_strategy_id
- campaign_id
- cpc_bid_micros
- creation_time
- customer_id
- end_date
- engine_id
- engine_status
- id
- labels
- language_code
- last_modified_time
- name
- start_date
- status
- targeting_setting_target_restrictions
ad
24 fields
- ad_group_id
- campaign_id
- creation_time
- customer_id
- display_url
- engine_id
- engine_status
- expanded_dynamic_search_ad_description_1
- expanded_dynamic_search_ad_description_2
- expanded_text_ad_description_1
- expanded_text_ad_description_2
- expanded_text_ad_headline
- expanded_text_ad_headline_2
- expanded_text_ad_headline_3
- final_urls
- id
- labels
- last_modified_time
- name
- status
- text_ad_description_1
- text_ad_description_2
- text_ad_headline
- type
bidding_strategy
3 fields
- customer_id
- id
- name
customer_report
10 fields
- customer_id
- customer_engine_id
- date
- historical_quality_score
- search_impression_share
- search_budget_lost_impression_share
- search_rank_lost_impression_share
- content_impression_share
- content_budget_lost_impression_share
- content_rank_lost_impression_share
ad_group_report
10 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- date
- content_impression_share
- content_rank_lost_impression_share
- historical_quality_score
- search_impression_share
- search_rank_lost_impression_share
customer_report_hourly
10 fields
- customer_id
- customer_engine_id
- date
- hour
- search_impression_share
- search_budget_lost_impression_share
- search_rank_lost_impression_share
- content_impression_share
- content_budget_lost_impression_share
- content_rank_lost_impression_share
campaign_report_hourly
25 fields
- customer_id
- campaign_id
- bidding_strategy_id
- date
- hour
- all_conversions
- all_conversions_value
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- content_budget_lost_impression_share
- content_impression_share
- content_rank_lost_impression_share
- conversions
- conversions_value
- cost_micros
- ctr
- impressions
- search_budget_lost_impression_share
- search_impression_share
- search_rank_lost_impression_share
- visits
ad_group_report_hourly
10 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- date
- hour
- content_impression_share
- content_rank_lost_impression_share
- search_impression_share
- search_rank_lost_impression_share
customer_device_report
14 fields
- customer_id
- customer_engine_id
- date
- device
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- cost_micros
- ctr
- impressions
- visits
campaign_device_report
15 fields
- customer_id
- campaign_id
- bidding_strategy_id
- date
- device
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- cost_micros
- ctr
- impressions
- visits
ad_group_device_report
16 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- date
- device
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- cost_micros
- ctr
- impressions
- visits
ad_device_report
16 fields
- customer_id
- ad_id
- ad_group_id
- campaign_id
- ad_group_ad_engine_id
- date
- average_cpc
- average_cpm
- clicks
- client_account_conversions
- client_account_conversions_value
- client_account_view_through_conversions
- cost_micros
- ctr
- impressions
- visits
customer_conversion_action_and_device_report
9 fields
- customer_id
- customer_engine_id
- date
- device
- conversion_action_name
- all_conversions
- all_conversions_value
- cross_device_conversions
- cross_device_conversions_value
campaign_conversion_action_and_device_report
10 fields
- customer_id
- campaign_id
- bidding_strategy_id
- date
- device
- conversion_action_name
- all_conversions
- all_conversions_value
- cross_device_conversions
- cross_device_conversions_value
ad_group_conversion_action_and_device_report
11 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- date
- device
- conversion_action_name
- all_conversions
- all_conversions_value
- cross_device_conversions
- cross_device_conversions_value
ad_conversion_action_and_device_report
12 fields
- customer_id
- ad_id
- ad_group_id
- campaign_id
- ad_group_ad_engine_id
- date
- device
- conversion_action_name
- all_conversions
- all_conversions_value
- cross_device_conversions
- cross_device_conversions_value
keyword_conversion_action_and_device_report
13 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- ad_group_criterion_criterion_id
- ad_group_criterion_engine_id
- date
- device
- conversion_action_name
- all_conversions
- all_conversions_value
- cross_device_conversions
- cross_device_conversions_value
keyword_report
7 fields
- customer_id
- ad_group_id
- campaign_id
- bidding_strategy_id
- ad_group_criterion_criterion_id
- date
- historical_quality_score
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from Search Ads 360?
22 tables, including campaign_report, keyword_device_report, campaign. campaign_report is one row per campaign, per day. Every one is listed on this page, with its fields.
Which Search Ads 360 fields can I get?
All 305 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does Search Ads 360 data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Search Ads 360 data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Search Ads 360 and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 6 min read
Budget pacing: the formula, and the report.
Spend against plan, while there is still time to do something about it.
Read it - 5 min read
How often marketing data should refresh.
Almost always daily. Here is why more often is usually worse, not better.
Read it - 7 min read
Reporting across currencies and time zones.
Both are the same failure. A number that means something different depending on where it was read, and no error either way.
Read it
Get started
Want Search Ads 360 in your own warehouse?
A call with someone who can answer the schema questions.