date:20180311

Fatel error for 'cURL error 60: SSL certificate problem: unable to get local issuer certificate' on Adword API V201802

2018-03-11 Thread leadportalclient

Hi guys,

i m trying to Update to Adword API to  V201802 PHP client library in my 
project. After getting configured with adword credentials and all , i have 
run examples files and get one error after another. BUt I got this *'Fatel 
error of '**cURL error 60: SSL certificate problem: unable to get local 
issuer certificate' * 

*Fatal error*: Uncaught exception 'GuzzleHttp\Exception\RequestException' 
with message 'cURL error 60: SSL certificate problem: unable to get local 
issuer certificate (see http://curl.haxx.se/libcurl/c/libcurl-errors.html)' 
in 
C:\Users\ladewig\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php:187 
Stack trace: #0 
C:\Users\ladewig\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php(150): 
GuzzleHttp\Handler\CurlFactory::createRejection(Object(GuzzleHttp\Handler\EasyHandle),
 
Array) #1 
C:\Users\ladewig\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php(103): 
GuzzleHttp\Handler\CurlFactory::finishError(Object(GuzzleHttp\Handler\CurlHandler),
 
Object(GuzzleHttp\Handler\EasyHandle), 
Object(GuzzleHttp\Handler\CurlFactory)) #2 
C:\Users\ladewig\vendor\guzzlehttp\guzzle\src\Handler\CurlHandler.php(43): 
GuzzleHttp\Handler\CurlFactory::finish(Object(GuzzleHttp\Handler\CurlHandler), 
Object(GuzzleHttp\Handler\EasyHandle), 
Object(GuzzleHttp\Handler\CurlFactory)) #3 
C:\Users\ladewig\vendor\guzzlehttp\guzzle\src\Handler\Proxy.php(28): Gu in 
*C:\Users\ladewig\vendor\guzzlehttp\guzzle\src\Handler\CurlFactory.php* on 
line *187*

I've found on several pages that the file cacert.pem is missing. So i 
downloaded it and set the curl.cainfo in php.ini to 

curl.cainfo = "D:\wamp\bin\php\extras\ssl\cacert.pem"

and restarted the Webserver but that didn't work.

What else can i do?

So, could you please let me know which steps i am missing in these case of 
migration of Adword API from V201708 to v201802, as soon as possible.

Thanks & Regards,

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/5d79cac0-e047-42a5-91ae-f85a8d9ab1ef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Targeting Idea STATS service: RATE_LIMIT error after 3 consecutive operations

2018-03-11 Thread Federico Conti

Hi All,

What is the limit of Targeting Idea STATS service per minute?

I can't find this in the documentation.

I created a script that requests the service 3 consecutive times, but if I 
don't put a 30 seconds pause between the requests, I encounter the 
RateExceededError called "RATE_LIMIT".

These are the details of the error - my API access is Basic:

RateExceededError
rateName=RATE_LIMIT
rateKey=null 
rateScope=ACCOUNT
retryAfterSeconds=30


I would like to minimize the time of the script, but I have no indications 
from the documentation regarding requests per minute limits, can you please 
help?

Thanks in advance,
Federico 


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/7c03b8e4-31a7-4cdb-983f-432bb4dd88a3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

downloadReportWithAwql returning bad numbers in PHP

2018-03-11 Thread Jay Chuck Mailen

Hello All,

I've run into an issue and was hoping someone would point me in the right 
direction.

I'm using downloadReportWithAwql (client v201802) to run a query with the 
KEYWORDS_PERFORMANCE_REPORT - it's actually a query we use in an AdWords 
script and it works fine there.

But in the PHP script I'm writing some of the number columns return 
correctly, but others are not.

For example; "Search Impr. share" on one of our keywords is returning 44.83, 
which is correct, but on the same keyword the "Cost" is returning 725 
but the cost is actually 7.25

The cost field isn't the only one doing this. All of these fields are doing 
the same thing: "Avg. CPC", "CPC Bid", "Cost", "CPC" & "Conv. rate" (unless 
their value is 0, in that case it does spit out 0).

All other numeric fields are returning correctly. But these fields return 7 
digits. It appears the whole number separator ( . ) is missing and it's 
cramming all the decimals right into it. (ie x.xx becomes xxx and xx.xx 
also becomes xxx). If it was always one number before the decimal I'd 
just grab the first digit and drop in a decimal, but sometimes it's a value 
like 12.54 becoming 1253267. So that won't work.

Here's a slightly modified version of the code:

private function get_data() {
$reportFormat = DownloadFormat::CSV;
$oAuth2Credential = (new OAuth2TokenBuilder())
->fromFile( self::$ini_path )
->build();

$session = (new AdWordsSessionBuilder())
->fromFile( self::$ini_path )
->withOAuth2Credential( $oAuth2Credential )
->withClientCustomerId( self::$client_id )
->build();

$adWordsServices = new AdWordsServices();
$reportQuery = $this->query( 'KEYWORDS_PERFORMANCE_REPORT' );
/* This is an example of the returned value of $reportQuery
SELECT 
Criteria,CampaignName,AdGroupName,KeywordMatchType,Clicks,Impressions,Ctr,AverageCpc,CpcBid,Cost,AveragePosition,Conversions,CostPerConversion,ConversionRate,SearchImpressionShare,QualityScore
FROM KEYWORDS_PERFORMANCE_REPORT
WHERE 
IsNegative = FALSE
AND Status = ENABLED
AND AdGroupStatus = ENABLED
AND CampaignStatus = ENABLED
DURING 20170911,20180309
*/

$reportDownloader = new ReportDownloader( $session );

$reportSettingsOverride = ( new ReportSettingsBuilder() )
->includeZeroImpressions( false )
->build();

$reportDownloadResult = $reportDownloader->downloadReportWithAwql(
$reportQuery,
$reportFormat,
$reportSettingsOverride
);

return $reportDownloadResult->getAsString();
}


This is an example of what it's kicking out:


"KEYWORDS_PERFORMANCE_REPORT (Sep 11, 2017-Mar 9, 2018)"
Keyword,Campaign,Ad group,Match type,Clicks,Impressions,CTR,Avg. CPC,Max. 
CPC,Cost,Avg. position,Conversions,Cost / conv.,Conv. rate,Search Impr. 
share,Quality score
keyword1,campaign1,group1,Broad,2,127,1.57%,1589,500,3178,2.2,0.00,0,0.00%,59.71%,5
keyword2,campaign2,group2,Broad,2,26,7.69%,2745000,488,549,2.3,0.00,0,0.00%,89.47%,6


Obviously I switched out the keywords, campaigns and ad group names. But 
what's going on with the 7 digit numerical values?

If anyone can shed any light on this and steer me in the right direction I 
would greatly appreciate it. I don't have much hair left and you'd be 
saving me from pulling what little remains out.

Thanks,
-Jay



-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/1d12b842-7ba2-4cc7-a9da-0681d8ba929a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: AWQL: Error in Where statement trying to filter CAMPAIGN_PERFORMANCE_REPORT by Label

2018-03-11 Thread 'Peter Oliquino' via AdWords API Forum

Hi,

You should be able to filter your report using the Labels 

 fields 
as seen in its field attributes 

 in 
the Campaign Performance Report. However, seeing that this is already quite 
an old thread, I would recommend that you create a new one for better 
tracking.

Also, you may include the complete report definition 

 so 
our team could better look into the issue you are currently encountering.

Best regards,
Peter
AdWords API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/535ecf4c-0c10-44dd-b236-cee907fdf844%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: TargetingIdeaService not returning exact number of results

2018-03-11 Thread 'Vincent Racaza (AdWords API Team)' via AdWords API Forum

Hi,

Can you provide to me your complete SOAP request and response logs via *Reply 
privately to author* option so I can further investigate? If you haven't 
enabled the SOAP logs yet, then kindly tell me what client library you are 
using so I can provide to you the guide to enable SOAP logs.

Thanks,
Vincent
AdWords API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/2c27c756-2b05-4d44-8dfe-e235f7569145%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: AdWords API application

2018-03-11 Thread 'Peter Oliquino' via AdWords API Forum

Hi Simon,

There shouldn't be too many issues when applying for a developerToken and 
getting basic access granted. You could follow the easy steps from our sign 
up  guide and 
fill out this basic access application form 
 once you have created your 
MCC. The AdWords Compliance Team should then get in touch with you within 2 
business days for the status. Should it take longer than the mentioned 
period, let me know so I can notify their team about your application.

Additionally, since you wish to use the AdWords API to create a bid 
management tool, you will also need to generate your OAuth2 credentials 
 to 
access and modify information of your AdWords production account(s). You'll 
then need to download the client library 
 of your 
choice. Once your setup has been completed and basic access has been 
granted, you could then proceed making calls to your production account(s).

As for the bidding part, you may refer to our bidding 
 guide for 
more information regarding its implementation. I hope this has been helpful 
and feel free to write back should you require further information.

Best regards,
Peter
AdWords API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/b8687eb0-4d72-42ff-a769-b7b5d34307bc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Unique records with below columns

2018-03-11 Thread 'Peter Oliquino' via AdWords API Forum

Hi Chaitanya,

The Shopping Performance Report 

 is 
aggregated at the OfferId 

 level 
and depending on the columns you selected, it should return one row for 
each OfferId. However, since you mentioned that you included the Date 

 field 
in your SELECT query, then similar rows would usually be returned since 
statistics generated on different dates would be broken down and returned 
in other rows of the reports.

Technically, for your current query, each row returned should be considered 
unique for the OfferId and Date combination.

Best regards,
Peter
AdWords API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/a507e7e6-99cd-472c-abd9-36672f56209e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Fatel error for 'cURL error 60: SSL certificate problem: unable to get local issuer certificate' on Adword API V201802

Targeting Idea STATS service: RATE_LIMIT error after 3 consecutive operations

downloadReportWithAwql returning bad numbers in PHP

Re: AWQL: Error in Where statement trying to filter CAMPAIGN_PERFORMANCE_REPORT by Label

Re: TargetingIdeaService not returning exact number of results

Re: AdWords API application

Re: Unique records with below columns

7 matches

Site Navigation

Mail list logo

Footer information