Hi team,
We developed a small app that retrieves a large amount of properties and
metrics from ad_group with this query:
SELECT segments.date,
ad_group.ad_rotation_mode,
ad_group.base_ad_group,
ad_group.campaign,
ad_group.cpc_bid_micros,
ad_group.cpm_bid_micros,
ad_group.cpv_bid_micros,
ad_group.display_custom_bid_dimension,
ad_group.effective_target_cpa_micros,
ad_group.effective_target_cpa_source,
ad_group.effective_target_roas,
ad_group.effective_target_roas_source,
ad_group.id,
ad_group.labels,
ad_group.name,
ad_group.resource_name,
ad_group.status,
ad_group.target_cpa_micros,
ad_group.target_cpm_micros,
ad_group.target_roas,
ad_group.type,
metrics.absolute_top_impression_percentage,
metrics.active_view_cpm,
metrics.active_view_ctr,
metrics.active_view_impressions,
metrics.active_view_measurability,
metrics.active_view_measurable_cost_micros,
metrics.active_view_measurable_impressions,
metrics.active_view_viewability,
metrics.all_conversions,
metrics.all_conversions_by_conversion_date,
metrics.all_conversions_from_interactions_rate,
metrics.all_conversions_value,
metrics.all_conversions_value_by_conversion_date,
metrics.average_cost,
metrics.average_cpc,
metrics.average_cpe,
metrics.average_cpm,
metrics.average_cpv,
metrics.average_page_views,
metrics.average_time_on_site,
metrics.bounce_rate,
metrics.clicks,
metrics.conversions,
metrics.conversions_by_conversion_date,
metrics.conversions_from_interactions_rate,
metrics.conversions_value,
metrics.conversions_value_by_conversion_date,
metrics.cost_micros,
metrics.cost_per_all_conversions,
metrics.cost_per_conversion,
metrics.cost_per_current_model_attributed_conversion,
metrics.cross_device_conversions,
metrics.ctr,
metrics.current_model_attributed_conversions,
metrics.current_model_attributed_conversions_value,
metrics.engagement_rate,
metrics.engagements,
metrics.gmail_forwards,
metrics.gmail_saves,
metrics.gmail_secondary_clicks,
metrics.impressions,
metrics.interaction_event_types,
metrics.interaction_rate,
metrics.interactions,
metrics.percent_new_visitors,
metrics.phone_calls,
metrics.phone_impressions,
metrics.phone_through_rate,
metrics.search_absolute_top_impression_share,
metrics.search_budget_lost_absolute_top_impression_share,
metrics.search_budget_lost_top_impression_share,
metrics.search_exact_match_impression_share,
metrics.search_impression_share,
metrics.search_rank_lost_absolute_top_impression_share,
metrics.search_rank_lost_impression_share,
metrics.search_rank_lost_top_impression_share,
metrics.search_top_impression_share,
metrics.top_impression_percentage,
metrics.value_per_all_conversions,
metrics.value_per_all_conversions_by_conversion_date,
metrics.value_per_conversion,
metrics.value_per_conversions_by_conversion_date,
metrics.value_per_current_model_attributed_conversion,
metrics.video_quartile_p100_rate,
metrics.video_quartile_p25_rate,
metrics.video_quartile_p50_rate,
metrics.video_quartile_p75_rate,
metrics.video_view_rate,
metrics.video_views,
metrics.view_through_conversions
FROM ad_group WHERE segments.date >= '${startDate}' and segments.date <=
'${endDate}'
For our first account it worked, we retrieved the correct amount of metrics
such as clicks and cost_micros, but after that we applied the same process
with this same query for other account and we are not getting the correct
numbers (we are a behind) . So we tried getting the metrics from campaign
instead of ad_group and we obtained the correct data that is showed in the
Google ADS UI using this query:
SELECT segments.date,
metrics.absolute_top_impression_percentage,
metrics.active_view_cpm,
metrics.active_view_ctr,
metrics.active_view_impressions,
metrics.active_view_measurability,
metrics.active_view_measurable_cost_micros,
metrics.active_view_measurable_impressions,
metrics.active_view_viewability,
metrics.all_conversions,
metrics.all_conversions_by_conversion_date,
metrics.all_conversions_from_interactions_rate,
metrics.all_conversions_value,
metrics.all_conversions_value_by_conversion_date,
metrics.average_cost,
metrics.average_cpc,
metrics.average_cpe,
metrics.average_cpm,
metrics.average_cpv,
metrics.average_page_views,
metrics.average_time_on_site,
metrics.bounce_rate,
metrics.clicks,
metrics.conversions,
metrics.conversions_by_conversion_date,
metrics.conversions_from_interactions_rate,
metrics.conversions_value,
metrics.conversions_value_by_conversion_date,
metrics.cost_micros,
metrics.cost_per_all_conversions,
metrics.cost_per_conversion,
metrics.cost_per_current_model_attributed_conversion,
metrics.cross_device_conversions,
metrics.ctr,
metrics.current_model_attributed_conversions,
metrics.current_model_attributed_conversions_value,
metrics.engagement_rate,
metrics.engagements,
metrics.gmail_forwards,
metrics.gmail_saves,
metrics.gmail_secondary_clicks,
metrics.impressions,
metrics.interaction_event_types,
metrics.interaction_rate,
metrics.interactions,
metrics.percent_new_visitors,
metrics.phone_calls,
metrics.phone_impressions,
metrics.phone_through_rate,
metrics.search_absolute_top_impression_share,
metrics.search_budget_lost_absolute_top_impression_share,
metrics.search_budget_lost_top_impression_share,
metrics.search_exact_match_impression_share,
metrics.search_impression_share,
metrics.search_rank_lost_absolute_top_impression_share,
metrics.search_rank_lost_impression_share,
metrics.search_rank_lost_top_impression_share,
metrics.search_top_impression_share,
metrics.top_impression_percentage,
metrics.value_per_all_conversions,
metrics.value_per_all_conversions_by_conversion_date,
metrics.value_per_conversion,
metrics.value_per_conversions_by_conversion_date,
metrics.value_per_current_model_attributed_conversion,
metrics.video_quartile_p100_rate,
metrics.video_quartile_p25_rate,
metrics.video_quartile_p50_rate,
metrics.video_quartile_p75_rate,
metrics.video_view_rate,
metrics.video_views,
metrics.view_through_conversions
FROM campaign WHERE segments.date >= '${startDate}' and segments.date <=
'${endDate}'
The problem with this is that we can not retrieve all the ad_group
properties from campaign, is there a way to call both ad_group and campaign
tables from a single query? it would be really helpful.
Best regards,
Emmanuel
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/4c0aa1a5-bf65-4474-bea4-de62c9e03f9bn%40googlegroups.com.
