Re: Retrieve each campaigns geographic target

2022-03-13 Thread scratch27
Hi Nirmita, I have written the following query but I get a Call to Undefined Method... SELECT campaign.name FROM campaign_criterion WHERE campaign_criterion.proximity.address.country_code='FR' My sole and only question is how to get the country geographically targeted from a search campaign.

Re: Retrieve each campaigns geographic target

2022-03-11 Thread scratch27
Hi Aryeh, Going with your first query, how do you get the targeted country for the campaign please? I understood that we can get the country code like FR for France if France is targeted by this campaign? Thank a lot! Le jeudi 10 mars 2022 à 15:53:56 UTC+1, adsapi a écrit : > Hi Scratch, > >

Re: Retrieve each campaigns geographic target

2022-03-09 Thread scratch27
Hi Jinky, Thank you for you help. How do I get the campaign name from the Geo Target Constant please? I can't get it in my query, could you write down the query please? Massive thanks! Le mercredi 9 mars 2022 à 16:32:04 UTC+1, adsapi a écrit : > Hi Scratch, > > Thank you for the replies. I

Re: Retrieve each campaigns geographic target

2022-03-09 Thread scratch27
Hi Darwin, Thank you for you reply! I'm sorry I can't figure out how to get for each campaign the targeted country location. I select the campaign.name and the geographic_view.country_criterion_id from the geographic.view But when I echo the country criterion Id in php I have int(2250) but

Re: Retrieve each campaigns geographic target

2022-03-08 Thread scratch27
Hi Nirmita, Thank you for your reply :) I have been to the page of the geographic view but I can't find out how to get the campaign name... I also checked on the Google ads query builder and in attributed resource fields I only see customer and can't find campaign name. Could you tell me

Retrieve each campaigns geographic target

2022-03-08 Thread scratch27
Hi there, I would like to retrieve my search campaigns geographic targets. The one that they are targeting and with targeting type (person located in the area etc.) And the one that are excluded from the campaign. I tried to do it with the geographic_view but I am unable to get the campaign

Re: GAQL Insert PHP variable in query

2022-03-04 Thread scratch27
Exactly what I needed, thank you so much! Mat Le vendredi 4 mars 2022 à 17:10:32 UTC+1, adsapi a écrit : > Hi there, > > For support for the PHP Client Library you may reach out to their issue > tracker . With that > being said, here is an

GAQL Insert PHP variable in query

2022-03-03 Thread scratch27
Hi, I would like to create a query with a php variable for the WHERE statement. Here is an example: $query = "SELECT campaign.name FROM ad_group WHERE ad_group.id = $adGroupId"; I am using PHP library and I want to insert dynamic values in queries that I can get for example from the frontend