Audience Report
Hello, I am trying to replicate a UI report provided by a client through the Google Ads API. Here are the UI column names the client is requesting: - Account name - Customer ID - Audience segment - Audience segment type - Campaign - Ad group - Campaign status - Campaign status reasons - Campaign ID - Day - Currency code - Clicks - Cost - Impr. I have come up with the following query: SELECT customer.descriptive_name, customer.id, ad_group_criterion.display_name, campaign.name, ad_group.name, campaign.status, campaign.primary_status, campaign.primary_status_reasons, campaign.id, segments.date, customer.currency_code, metrics.clicks, metrics.cost_micros, metrics.impressions FROM ad_group_audience_view The issue that I am running into is that I am also not able to find an API equivalent of audience segment and audience segment type. ad_group_cirterion.display_name seems to be close to audience segment, but doesn't seem to be a 100% match. Could you point me in the right direction for those two fields? I can provide the report and more client information if needed. Thanks, Michael -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/2c494020-a50e-4a70-9161-6382dcc2d8ffn%40googlegroups.com.
Change Event Service not Returning Data
I have a client who is trying to track changes that they make to tRoas for their various campaigns. To this end we are requesting data from the Change Event resource to track these changes. Whenever I make the request, no data is returned. I have tried using the manager ID by itself, and with the customer client ID, and neither returns any data. The client says that they have made changes to the tROAS, and so we expect to see data. I am using the following query: SELECT change_event.change_date_time,change_event.ad_group,change_event.campaign,change_event.change_resource_name,change_event.change_resource_type,change_event.changed_fields,change_event.feed,change_event.feed_item,change_event.new_resource,change_event.old_resource,change_event.resource_change_operation,change_event.resource_name,change_event.user_email FROM change_event WHERE change_event.change_date_time BETWEEN '2023-04-01' AND '2023-04-01' LIMIT 1000 The customer client ID is: 764-484-4189 Let me know if there is anything else you need. Thanks, Michael -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f18c5a36-9248-4992-875e-bfbaaf158fe2n%40googlegroups.com.
Certain campaigns are not being returned from the API, but show in the UI
Hi, I have a user that says they are missing some campaigns from the data we are pulling from the API. They are able to see them in the UI, however they are not being returned from the API. Some of the campaign IDs that are missing are: - 18513200562 - 18538972442 - 18532530921 This is the query we are building to pull the data from the API: SELECT segments.date, customer.descriptive_name, customer.id, campaign.name, campaign.id, campaign.status, ad_group.name, ad_group.id, ad_group.status, ad_group.type, segments.ad_network_type, segments.device, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions_value, metrics.conversions, metrics.all_conversions, metrics.all_conversions_value, 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, ad_group.labels, metrics.search_absolute_top_impression_share, metrics.search_budget_lost_absolute_top_impression_share, metrics.search_budget_lost_top_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.absolute_top_impression_percentage FROM ad_group WHERE segments.date BETWEEN '2022-11-01' AND '2022-11-30' Thanks for the help -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/9eb8104e-efe7-4c7b-9d5c-ad657cfbd4fan%40googlegroups.com.
