Issue with Google Ads Query for shopping_product Metrics – Date Segmentation Error

The query below is showing as valid in the query builder, but when I attempt to run it, I receive the following error message: SELECT shopping_product.title, metrics.cost_micros, metrics.conversions, metrics.clicks, metrics.conversions_from_interactions_rate, segments.mo

Issue with Google Ads Query for shopping_product Metrics – Date Segmentation Error

The query below is showing as valid in the query builder, but when I attempt to run it, I receive the following error message: const query = SELECT shopping_product.title, metrics.cost_micros, metrics.conversions, metrics.clicks, metrics.conversions_from_interactions_rate, segments.month

Reports based on Location

I am trying to fetch location-based reports from the *'**gegoraphic_view* *'* and from campaigns, but the segments are not working, and I am getting an empty response. Is there any other way I can get location-based metrics? let query = ` SELECT geographic_view.country_criterion_id

Re: GAQL query is working for predefined date ranges but not for custom date range

ering is different. There is no longer a DURING clause; instead, DURING is an operator that can be used in WHERE clauses. Filter the field date using the DURING clause for the same functionality as the DURING clause in AWQL." On Monday, March 13, 2023 at 1:37:48 PM UTC-7 Roy Steves wrote:

Re: GAQL query is working for predefined date ranges but not for custom date range

Maybe there wasn't at the time, but there sure is now. There is according to the examples here: https://developers.google.com/google-ads/api/docs/query/overview#querying_for_segments I haven't found the list of acceptable values yet, so maybe that documentation is out of date, but it is for th

Asset level cost metric summed up does not match Campaign level

r, but they're higher. We checked cost directly from the API for the ad account for a month and confirmed that the numbers are indeed more on the asset level. What could be the reason for this? Regards, Ranajoy Roy -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us

Re: Exception: Call to GoogleAdsService.Search failed: Null response from Google Ads API

I just got this same error from within Google Ads Scripts, so it's not limited to API call configuration, specifically. On Friday, October 7, 2022 at 1:52:38 AM UTC-7 adsapi wrote: > Hi Thomas, > > Thank you for providing more details to your concern. > > To take a closer look at the issue and t

Re: I want to get user list usage status in Google Ads API

Thank you support team! When do you think it will be ready. It was working on v7 and it's now not working which is problematic for our new application. I have userList id but I want to get userList by Id to get the size of the userList. Thank you On Wednesday, August 10, 2022 at 8:09:37 AM U

Re: I want to get user list usage status in Google Ads API

https://developers.google.com/google-ads/api/rest/reference/rest/v11/customers.userLists How can we get the userList by id? It see only mutate but I dont see get. Thank you for your help. On Wednesday, August 10, 2022 at 2:20:30 AM UTC-4 adsapi wrote: > Hi Kume, > > Thank you for reaching us o

How to get full clicks and costs for a PMax campaign?

For example: In Google Ads for a PMax campaign on 14-06-2022 we have: 2.124 clicks and 926,71 EUR costs. When we get the clicks and costs for the campaign with Google ADS API for that date we get: 2.037 clicks and 877,22 EUR costs. We use the following query: SELECT metrics.clicks, metrics.aver

InvalidArgument when migrating from AdWords to Ads API v8

Hi, we need some help at Google Ads API configuration, we developed an integration using Google AdWords that will auto create Google Ads customers and we are migrating to Google Ads API v8 recently. After the change, the request to get a customer ID failed with below error message: { "Statu

Re: Google Ads PHP V8 missing V8 directory

Hello this is solved. The number of the API version is not the same as the number of the Php library version Didier Roy Head of Software WIHP Hotels Le mer. 16 juin 2021 à 11:13, did...@wihphotels.com a écrit : > Hello > > I am upgrading Google Ads PHP V6 to V8 > I have used

Re: REST Api and Updating Campaign Bidding Strategy

Thank you for the clarification! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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

Re: REST Api and Updating Campaign Bidding Strategy

Than you very much for the quick reply Teja, I tried what I think is a functionally equivalent code in the php sdk (as expressed in the opening post.) $campaign->setMaximizeConversions(new MaximizeConversions()); But nothing is happening. The remote campaign is not UPDATED In any

Re: REST Api and Updating Campaign Bidding Strategy

Than you very much for the quick reply Teja, I tried what is think a functionally equivalent code in php sdk, as expressed in the opening post. $campaign->setMaximizeConversions(new MaximizeConversions()); But nothing is happening. The remote campaign is not UPDATED In any case I

Re: Google Ads PHP client library V2 fail get conversions and conversions_values from hotel_performance_view with

a écrit : > > The problem is you need convert 1 parameter in to DoubleValue. > > > > [image: adrian] > > > > *From:* adwor...@googlegroups.com > *On Behalf Of *Didier Roy > *Sent:* Monday, September 9, 2019 2:49 PM > *To:* AdWords API and Go

Re: Google Ads PHP client library V2 fail get conversions and conversions_values from hotel_performance_view with

Hello Sai the error is a PHP error. It occurs before the API call is done. There is no log of the request into the log. it seems to be a PHP client library bug. I have tried V2 and V1 and got the same error PHP Fatal error: Uncaught Exception: Expect float. in /home/metaio-dev-v5/google-ads-p

Google Ads PHP client library V2 fail get conversions and conversions_values from hotel_performance_view with

Hello PHP issue trying to get conversions and conversions_values from hotel_performance_view with Google Ads PHP client library V2 PHP Fatal error: Uncaught Exception: Expect float. in /home/metaio-dev-v5/google-ads-php/V2/vendor/google/protobuf/src/Google/Protobuf/Internal/GPBUtil.php:182 St

Re: Hotels campaing reservations properties

Hi Antony thank you for you answer. OK for checkin and checkout. Is there any place we can find the reservation reference (booking number)? *Didier Roy* Head of Software [image: WIHP] <http://www.wihphotels.com> wihphotels.com <http://www.wihphotels.com> 77 rue du Faubourg St-A

Hotels campaing reservations properties

Hello How can we retreive reservations properties with Google Ads API? We need reference of reservations as well as booking dates, arrival and departure dates. We were able to get these information from Hotel Ads into reservation reports. is this still possible with Google Ads? thanks -- --

Re: Hotel campaign with commission incompatible with shared budget

Hello Dannisson my issue was that I was trying to affect commission campaign to a shared budget. it is working fine when I assign to a not shared budget this is solved thanks *Didier Roy* Head of Software [image: WIHP] <http://www.wihphotels.com> wihphotels.com <http://www.wihphotel

Re: Hotel campaign with commission incompatible with shared budget

any idea? Le jeudi 30 mai 2019 14:40:44 UTC+2, Didier Roy a écrit : > > Hello Dannison > > thank you for you answer. I have created a shared budget with *type= > HOTEL_ADS_COMMISSION* > I have added* paymentMode = CONVERSION_VALUE* on the campaign I am trying > to create

Re: Hotel campaign with commission incompatible with shared budget

"fieldPathElements": [ { "fieldName": "operations", "index": "0" }, { "fieldName": "create" }, { "fieldName": "campaign_budget" } ]

Hotel campaign with commission incompatible with shared budget

Hello I fail to create a hotel campaign with bidding strategy Commission. It says it is incompatible with shared budget but it is not possible to remove the shared budget. could you help to find what is wrong we are using PHP client library V1_3 request with shared budget : {"customerId":"9392

migrating Google ads api from v0 to v1 authorization_error: The developer must sign the terms of service

hello I have migrated from Google Ads API V0 to V1. I am using the same google_ads_php.ini file but got this error : *authorization_error: The developer must sign the terms of service. They can be found here: ads.google.com/aw/apicenter* My MCC id is *4123241990* thanks -- -- =~=~=~=~=~=

increase API number of requests quota

Hello we need to make à lot of request because of our big number of campaign / ad groups / ad groups criterions / ad group bids multipliers we are making request by 1000 operations except for ad group criterion where 8 seems to be the maximum. nevertheless we get this message Failure: {"errors

Re: Adding Hotel AdGroupCriterion without bidding value

Hello Sai thank you for you answer. I can create an adgroup criterion with negative field to true and it appears as Excluded on the Google Ads Platform. This is good thank you. I am trying now to update the adgroup with a bid value and switching negative to false and I get the error : Google A

Re: Adding Hotel AdGroupCriterion without bidding value

Hello Sai thank you for this. I still have a question about API. How can we set the bid value of a hotel group to "Exclude" with the API ? thanks Didier ROY -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.bl

Re: Adding Hotel AdGroupCriterion without bidding value

Hello I have found the answer for question 1 : I use function $adGroupCriterion->setCpcBidMicros(new Int64Value(['value' => $bid*1])); there is still pending question - When hotel group level bidding is disabled ("exclude" on Google Ads dash) for a hotel selection. Is the Adgroup biddin

Re: Adding Hotel AdGroupCriterion without bidding value

Hello Sai > > thank you for your answar I understand that PercentCpcBidMicros is mandatory when using PercentCpc bidding strategy. - What to do if the campaign is on Manual CPC? - When hotel group level bidding is disabled for a hotel selection. Is the Adgroup bidding value taken into account in

Adding Hotel AdGroupCriterion without bidding value

Hello I want to create an AdGroupCriterion with a hotel selection setting any bid ( My bid is defined at adGroup level) Ahen I remove line $adGroupCriterion->setPercentCpcBidMicros(new Int64Value(['value' => 1])) I get message field_error: The required field was not present in the resource. wh

Re: ad_group_criterion_error: Subdivided listing groups must have an "others" case.

Hello the difference is on my side it is working well on percent CPC campaign. The error occurs on Manual CPC campaigns is there any restriction on Manual CPC ? thanks Le mercredi 27 mars 2019 10:58:46 UTC+1, Didier Roy a écrit : > > Hello > > since this morning I am not ab

ad_group_criterion_error: Subdivided listing groups must have an "others" case.

Hello since this morning I am not able to assign hotels to adGroups. I get message : Google Ads failure details: ad_group_criterion_error: Subdivided listing groups must have an "others" case. field_error: The required field was not present in the resource. Same with examples/

Hotel Campaign Bidding strategy manual CPC

Hello what is the parameter to pass to Campaign method in order to create a Hotel campaign with manual CPC bidding strategy? I don' find it at https://developers.google.com/google-ads/api/docs/fields/campaign I am using PHP client library v0_7 thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Creating Hotel campaign without shared budget

Hello is there a way to create a campaign without assigning a shared budget. I am tried to use Campaign class without campaign_budget resource name but it failed I am using Google Ads PHP client library V0_7 thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our b

Re: how to disable traces using PHP Client Library V0_7

hello anybody knowing how to disable these outputs that are generating huge logs when using php client library? thanks Le mardi 19 mars 2019 10:58:36 UTC+1, Didier Roy a écrit : > > Hello > > I am using PHP Client Library V0_7 > > how to disable traces that are automatica

Re: Google Hotel Ads Account number linked to Google Ads Account

Hello is there a way to get the Hotel Ads Account number before any campaign has been created? my goal is to create campaigns with the API once the account has been linked to Hotel Ads Center. I need to get this information either with Google Ads API or with Hotel Partner API thanks -- --

how to disable traces using PHP Client Library V0_7

Hello I am using PHP Client Library V0_7 how to disable traces that are automatically generated like following when I run examples/BasicOperations/GetCampaigns.php : [2019-03-19 10:55:18] google-ads.INFO: Request made: Host: "googleads.googleapis.com", Method: "/google.ads.googleads.v0.servi

Google Hotel Ads Account number linked to Google Ads Account

Hello how to retreive with PHP client library PHP the Google Hotel Ads Account number linked to the Google Ads Account thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Assign Hotels Ads hotel to Google Ad AdGroup

Hello I am trying to create a hotel group on a Ad Group of a Hotel Campaign. I am using PHP Google Ads Library anybody has a working example ? thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=

Google Hotel Ads Sites Local Universal and Google Map

Hello What is the equivalent in Google Ads to Google hotel Ads Site Types : localuniversal and googlemap With Goggle Hotel Ads we were able to get reports segmented by Site type. Is this still possible with Google Ads? thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find

GetAccountHierarchy.php on Google Ads API

Hi All I a looking for the equivalent of Google Adwords API GetAccountHierarchy.php on Google Ads API. thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You receiv

Re: PHP example/reporting/GetHotelAdsPerformance of Google Ads API v0_7 not working

thank you it works Le vendredi 1 mars 2019 20:34:43 UTC+1, Didier Roy a écrit : > > Hi All > > I am trying to get hotel performance report using below code and get this > error : > > PHP Fatal error: Call to undefined method > Google\Ads\GoogleAds\

PHP example/reporting/GetHotelAdsPerformance of Google Ads API v0_7 not working

Hi All I am trying to get hotel performance report using below code and get this error : PHP Fatal error: Call to undefined method Google\Ads\GoogleAds\V0\Services\GoogleAdsRow::getHotelCheckInDayOfWeek() in /home/reports/gha/google-ads-php/examples/Reporting/GetHotelAdsPerformance.php on

Re: Adwords Location Criteria ID - boundaries

Thank you for your answer Milind, very helpfull. I have an additional question: Does this also mean that when I make a keyword volume search for a given location "A" (a city or a zip code for example) through the "Keyword planner" tool the index I get is the search volume for the given keyword

Adwords Location Criteria ID - boundaries

Hello, what is the area associated to a location id (from the following list : https://fusiontables.google.com/DataSource?docid=1Jlxrqc1dU3a9rsNW2l5xxlmQEKUu0dIPusImi41B#rows:id=1)? Are the administrative boundaries taken into account when targeting a specific area from the list? Or a radius ar

Adwords report output to html

http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific l

API version v201609 warning email: Does this apply to Scripts somehow?

I received this today: Dear AdWords API Developer (MCC ID XX), You’re receiving this message because your AdWords API Developer account submitted 100% of your API requests to an outdated API version within the past seven days. *AdWords API v201609 has been deprecated and will stop acce

Main shopping interface vs. product group editor vs. AWQL confusion

Forgive the linked, rather than embedded, screenshots, but my first attempt to post this failed. And while this isn't solely an API-level question, the moment I mention awql or the like, I'm always redirected here, as I'm sure you can understand. Here's the root concern: https://www.evernote.

Invalid version for use with report XML ??

I'm new to AdWordsAPI and how do I know what is wrong with my request ?? I put the logging, but don't know what is wrong here. I only know it is 400 and it said "Invalid version for use with report XML", but what to do next ?? Any help is appreciated. POST /api/adwords/reportdownload/v2015

Invalid version for use with report XML

quot;" array(3) { [0] => string(54) "!!!2|||-1|||Invalid version for use with report XML???" [1] => string(2) "-1" [2] => string(39) "Invalid version for use with report XML" } int(400) PHP Fatal error: Uncaught exception 'ReportDow

how i get category list

Hello, How i get the category list through API. My programme language is PHP. I want the below mentioned url category lists https://developers.google.com/adwords/api/docs/appendix/productsservices?hl=en Please reply as soon as possible. Thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=

Re: error invalid_grant OAUTH2

Solved it myself. When I run GetRefreshToken.php I get an url to validate my account for the app. There I get a token. I insert the token directly in the code ($code) of GetRefreshToken.php and than I get the refresh token for OAuth2. When I put the refreshtoken in the auth.ini...all works fin

error invalid_grant OAUTH2

from https://code.google.com/apis/console#access using my MMC account. The developerToken is also from the MMC account. What am I doing wrong? Best regards, Roy Roes -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwo

API Migration questions

Hi, I have some problems understanding the API migration to v201206 I'm currently using v201109_1 with a PHP client library I've read the guide: https://developers.google.com/adwords/api/docs/guides/migration-v201206 Now I'm not sure what to migrate. Do I need a need a new PHP client library

Re: Is it OK to use the API for the TargetingIdeaService feature only?

sistent > across various tools. So even if your aim is not to offer that > functionality as part of your service, the functionality still needs to be > accessible if needed. > > > > > On Thursday, October 4, 2012 4:07:00 PM UTC+1, Roy wrote: > >> Actually, I do have

Re: Is it OK to use the API for the TargetingIdeaService feature only?

ere. On Thu, Oct 4, 2012 at 4:56 PM, Anash P. Oommen < anash.p.oommen+fo...@google.com> wrote: > Hi Roy, > > In addition to what Dorian said, you might need to check > https://developers.google.com/adwords/api/docs/terms and > https://developers.google.com/adwords/api/docs/r

Re: Is it OK to use the API for the TargetingIdeaService feature only?

Anyone? On Friday, September 28, 2012 3:01:13 AM UTC+2, Roy wrote: > > Hello, > > I'd like to know if its ok to apply for an AdWords API if I only want to > use the TargetingIdeaService? > I want to develop an enhanced Keyword Research tool which add more metrics >

Is it OK to use the API for the TargetingIdeaService feature only?

on if its worth targeting the keyword (for PPC and SEO). I went over the ToS of the API application, didn't see anything problematic with this concept, but I want to double check. Thanks, Roy -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion g

Re: AddAdGroups.php gives error

Is there a workaround? Because installing another php version on the server isn''t really an option. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~

Re: AddAdGroups.php gives error

I think I found something here: http://code.google.com/p/google-api-adwords-php/wiki/PhpCompatibility But this isn''t ginving any solution other than using another php version. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi

Re: AddAdGroups.php gives error

Hi, When I run the script in command prompt I get the following error: ALERT - canary mismatch on efree() - heap overflow detected (attacker 'REMOTE_ADDR not set', file '/home/httpd/vhosts/mydomain.nl/httpdocs/aw_api/Google/Api/Ads/Common/Lib/AdsSoapClient.php', line 201) Is that the err

Re: AddAdGroups.php gives error

Hi, Nope, can't catch the Exception (see my previous post)... I tried $user->LogAll() But nothing in the log files. So I'm stuck right now... -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.goog

Re: AddAdGroups.php gives error

Hi, I try to catch the Exception like this: try { $result = $adGroupService->mutate($operations); } catch (Exception $e) { printf("An error has occurred: %s\n", $e->getMessage()); } But no exception is catched... I can output anything before the line $result = $adGroupService->muta

Re: AddAdGroups.php gives error

Hi, Added the error handling around the mutate call as you suggested, but without any result. It didn't catch any error. I still get the following error in Chrome: Error 324 (net::ERR_EMPTY_RESPONSE) -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion

Re: AddAdGroups.php gives error

Hi Kevin, I enabled logging and used the LogAll function, but nothing is logged. Even the SOAP request isn't logged. I've also tested the log with the AddCampaign.php and that's working fine. So the log is configured properly. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us o

AddAdGroups.php gives error

I'm testing the Adwords API in the sandbox. When I try to add AdGroups to a campaign with the AddAdGroups.php from the PHP client library, I get the following error in Chrome: Error 324 (net::ERR_EMPTY_RESPONSE) With a bit of debugging the line causing the error: $result = $adGroupService

Re: API developer token taking crazy long

Hi Kevin, Would be great if you can speed up things for us too! Customer ID: 522-467-9622 Thank you for your help! -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=

Generating AuthToken without email

In the new v201109 version of the API it says that they are deprecating the use of the email as the client identifier. I am using the php client library and I am trying to create a AuthToken. However, the aw_ap_php_lib_2.7.0 library is still looking for the email field. Can you help me under

AdWords API Error from add criteria

can I buy more ad groups / creatives / negative keywords? 2) What does it mean "this campaign may not be activated."? Do I need to do something special in order to activate it now? Thanks, Roy -- You received this message because you are subscribed to the Google Groups "AdWords API