Hello, in google ads api i'm executing a query to select my campaings but a specific campaign appears 3 times (they have the same name, but differents ids and status), i want those 3 to appear only one but time with their stats added. But i dont know how to do it
SELECT campaign.id, campaign.name, campaign.status, campaign.start_date, campaign.end_date, metrics.clicks, metrics.ctr, metrics.impressions FROM campaign WHERE segments.date >= "'2023-01-01" AND segments.date <= "'2023-01-19'" using this image of google ads interface as reference, in yellow are how they appear in the query results, but i want it to appear only one time with the stats in red [image: photo.png] Trying to add 'campaign.status != "REMOVED"' to the query only remove two of them, but it dont group them. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/3e2b97ea-c139-48b4-9dfb-2cdfd194ecf8n%40googlegroups.com.
