Relation between click data from 'click_view' and 'ad_group_ad'.

2023-10-26 Thread Suvigya Agrawal
I am using below queries to pull 'ad_group_ad' and 'click_view' data. *Adgroup:* *SELECT campaign.name, campaign.id, campaign.start_date, campaign.end_date, campaign.status, ad_group.name, ad_group.id, ad_group.status, ad_group_ad.ad.id, ad_group_ad.status,

How is 'keyword' related to a particular 'Ad' ?

2023-09-29 Thread Suvigya Agrawal
I am using below queries to pull data- *Adgroup:* *SELECT campaign.name, campaign.id, campaign.start_date, campaign.end_date, campaign.status, ad_group.name, ad_group.id, ad_group_ad.ad.id, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.descriptions,

Re: how can we pull "gclid" for adgroup.

2023-09-26 Thread Suvigya Agrawal
clicks, metrics.ctr, metrics.cost_micros, metrics.conversions, metrics.all_conversions, metrics.average_cpc, segments.date FROM keyword_view* Thanks. On Friday, September 22, 2023 at 7:34:20 PM UTC+5:30 Suvigya Agrawal wrote: > How I can pull "gclid"? Is "gclid" different at *camp

Re: how can we pull "gclid" for adgroup.

2023-09-22 Thread Suvigya Agrawal
How I can pull "gclid"? Is "gclid" different at *campaign* and *ad* level? Is "gclid" related to *keyword* in any way? Can you provide query for each case (also the query builder link)? Thanks. On Friday, September 22, 2023 at 6:12:52 PM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > >

Re: how can we pull "gclid" for adgroup.

2023-09-22 Thread Suvigya Agrawal
How can I pull "gclid"? Please give the query through I can pull. Also give the reference link of query builder. Thanks. On Friday, September 22, 2023 at 6:12:52 PM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > The

How can we pull "GCLID" for Adgroup.

2023-09-22 Thread Suvigya Agrawal
I want to pull "GCLID" for Adgroup data. I am pulling "ad_group_ad.ad.final_urls" from ad_group_ad tables, but in this final URL's query parameter I don't see any "gclid" query parameter. How can I get it? Thanks. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our

Relation among Metrics Data of Campaign, Adgroup and Keyword

2023-09-20 Thread Suvigya Agrawal
We are pulling following metrics data for campaign, adgroup and keyword- *Impressions, Clicks, CTR, Cost, Conversions, All_Conversions, Average_CPC* I am using following queries- *Campaign:* *SELECT campaign.name, campaign.id, campaign.start_date, campaign.end_date, campaign.status,

"Headlines" and "Description" of AdGroup

2023-06-23 Thread Suvigya Agrawal
I want to make a report on AdGroup which includes the following fields- *Campaign name, adgroup name, Headlines, Descriptions, Imp., Clicks, CTR, Cost, Conversions* In this case, the Headlines and Description and all the metrics are of that specific AdGroup. Please suggest a single query with

Re: total cost of a each campaign and adgroup

2023-06-18 Thread Suvigya Agrawal
Here is the screenshot for "Platform", "Channel" and "Segment" field we need to pull from Google Ads API- On Friday, June 16, 2023 at 4:08:43 PM UTC+5:30 Google Ads API Forum Advisor wrote: > Hello, > > Greetings from the Google Ads API Support team. > > Allow me to address your concerns

Total Cost of a each Campaign and Adgroup

2023-06-14 Thread Suvigya Agrawal
1. How can I get the "Total Cost" data of a campaign and adgroup (tell for each case). Some are suggesting to use "metrics.cost_micros", but if this is the case then what is the currency of the value returned by this. 2. How can I get the segment name of my campaign. For example- the segment