Prebuilt Reports
Prebuilt reports for our Google Ads connector sync a pre-defined set of fields. Fivetran supports the following Google Ads prebuilt reports.
We include prebuilt reports by default. You can enable or disable prebuilt report tables on the Schema tab to avoid syncing data you don't need.
ACCOUNT_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | ad_network_type, device | active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, clicks, conversions, conversions_value, cost_micros, impressions, interactions, interaction_event_types, view_through_conversions |
CAMPAIGN_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | id ➤ CAMPAIGN_HISTORY.id | ad_network_type, device | active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, clicks, conversions, conversions_value, cost_micros, impressions, interactions, interaction_event_types, view_through_conversions |
AD_GROUP_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id | ad_network_type, device | active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, clicks, conversions, conversions_value, cost_micros, impressions, interactions, interaction_event_types, view_through_conversions |
AD_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id, ad_id | ad_network_type, device | active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, clicks, conversions, conversions_value, cost_micros, impressions, interactions, interaction_event_types, view_through_conversions |
AUDIENCE_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 | ad_group_criterion_criterion_id ➤ AD_GROUP_CRITERION_HISTORY.id, ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id | ad_network_type, device | active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, clicks, conversions, conversions_value, cost_micros, impressions, interactions, interaction_event_types, view_through_conversions |
KEYWORD_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | ad_group_criterion_criterion_id ➤ AD_GROUP_CRITERION_HISTORY.id, ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id | ad_network_type, device | active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability, clicks, conversions, conversions_value, cost_micros, impressions, interactions, interaction_event_types, view_through_conversions |
ACCOUNT_HOURLY_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | click_type, day_of_week, device, hour, month, quarter, ad_network_type, week, year | active_view_cpm, active_view_ctr, active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability average_cost, average_cpc, average_cpm, clicks, conversions_from_interactions_rate, conversions, conversions_value, cost_micros, cost_per_conversion, ctr, impressions interaction_rate, interactions, interaction_event_types, value_per_conversion |
CAMPAIGN_HOURLY_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | id ➤ CAMPAIGN_HISTORY.id | click_type, day_of_week, device, hour, month, quarter, ad_network_type, week, year | active_view_cpm, active_view_ctr, active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability average_cost, average_cpc, average_cpm, clicks, conversions_from_interactions_rate, conversions, conversions_value, cost_micros, cost_per_conversion, ctr, impressions interaction_rate, interactions, interaction_event_types, value_per_conversion |
AD_GROUP_HOURLY_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | id ➤ CAMPAIGN_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id | click_type, day_of_week, device, hour, month, quarter, ad_network_type, week, year | active_view_cpm, active_view_ctr, active_view_impressions, active_view_measurability, active_view_measurable_cost_micros, active_view_measurable_impressions, active_view_viewability average_cost, average_cpc, average_cpm, clicks, conversions_from_interactions_rate, conversions, conversions_value, cost_micros, cost_per_conversion, ctr, impressions interaction_rate, interactions, interaction_event_types, value_per_conversion |
CLICK_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 | ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id, gclid | clicks |
LANDING_PAGE_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id, resource_name, unexpanded_final_url | average_cpc, clicks, cost_micros, ctr, impressions, mobile_friendly_clicks_percentage, speed_score, valid_accelerated_mobile_pages_clicks_percentage |
SEARCH_KEYWORD_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | ad_group_criterion_criterion_id ➤ AD_GROUP_CRITERION_HISTORY.id, ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id, resource_name | absolute_top_impression_percentage, average_cpc, average_cpm, clicks, conversions_from_interactions_rate, conversions_value, cost_micros, ctr, impressions, top_impression_percentage, view_through_conversions |
SEARCH_TERM_STATS report
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Segments | Metrics |
|---|---|---|---|
| _fivetran_id🔑, date🔑, customer_id🔑 ➤ ACCOUNT_HISTORY.id | ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id, resource_name, search_term, status | search_term_match_type | absolute_top_impression_percentage, average_cpc, clicks, conversions, conversions_from_interactions_rate, conversions_from_interactions_value_per_interaction, cost_micros, ctr, impressions, top_impression_percentage, view_through_conversions |
LEAD_FORM_SUBMISSION_DATA report
This prebuilt report sources a Google Ads report without segments or metrics. See Google's documentation for more information.
➤ indicates a foreign key relation.
| Primary keys | Resource fields | Attributes |
|---|---|---|
| id 🔑, submission_date_time 🔑, customer_id🔑 | ad_id ➤ AD_HISTORY.id, ad_group_id ➤ AD_GROUP_HISTORY.id, campaign_id ➤ CAMPAIGN_HISTORY.id | custom_lead_form_submission_fields, gclid, lead_form_submission_fields, resource_name |
Access to LEAD_FORM_SUBMISSION_DATA
The user account you use to authenticate your connection must have Standard or Admin access to your organization's Google Ads account to sync the LEAD_FORM_SUBMISSION_DATA prebuilt report.
LOCAL_SERVICES_LEAD report
This prebuilt report sources a Google Ads report without segments or metrics. See Google's documentation for more information.
| Primary keys | Resource fields | Attributes |
|---|---|---|
| id 🔑, creation_date_time 🔑, customer_id🔑 | category_id, contact_details, credit_details_credit_state, credit_details_credit_state_last_update_date_time, lead_charged, lead_status, lead_type, locale, note_description, note_edit_date_time, service_id |
LOCAL_SERVICES_LEAD_CONVERSATIONS report
This prebuilt report sources a Google Ads report without segments or metrics. See Google's documentation for more information.
| Primary keys | Resource fields | Attributes |
|---|---|---|
| id 🔑, event_date_time 🔑, customer_id🔑 | conversation_channel, local_services_lead_id,message_details_attachment_urls, message_details_text, participant_type, phone_call_details_call_duration_millis, phone_call_details_call_recording_url |