Prebuilt Reports
Prebuilt reports for our Google Ads connector sync a pre-defined set of fields. Fivetran supports the following Google Ads prebuilt reports.
ACCOUNT_STATS report
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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
IMPORTANT: ➤ 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.
IMPORTANT: ➤ 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 connector 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 |