RE: How can I generate report using Google adwords api without downloading the file?

[Google Ads API Forum Advisor Prod]

Hi Luis,

You may refer to this sample on how to print the results from AdWords reports. 
You may find more examples here based on your preferred language.

Regards,
Hiroyuki
Google Ads API Team
ref:_00D1U1174p._5001UEFUdB:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/Z3iIB0PV14W300hkmg5FjfTBKcoVrV8Ulpdw%40sfdc.net.

How can I generate report using Google adwords api without downloading the file?

[Luis Manuel]

Hi all,


I am using the adwords API with version v201809 and I have the following 
question.


How can I generate the report CAMPAIGN_PERFORMANCE_REPORT without 
downloading the file (for example just showing the result). Here is 
actually what I do:


$reportQuery = 'SELECT CampaignId,CampaignName, Impressions, Clicks, Ctr , Cost 
'
. ' FROM CAMPAIGN_PERFORMANCE_REPORT '
. ' WHERE CampaignId = '.$campaignId.' DURING 
'.$date.','.$date;

// Download report.
ReportUtils::DownloadReportWithAwql($reportQuery, $filePath, 
$user,$reportFormat, $options);
$dataArray =file($filePath);


I download the file, then I read from the data to show it up.


Check the response of Anthony Madrigal answer 

 but 
I am not clear with awql, since the example is in xml.


I hope you can help me.


Thanks.

 

This is the answer of the previous post.


[


$report = ReportUtils::DownloadReport($reportDefinition, NULL, $user,
 $options);

$xml = simplexml_load_string($report);
print "";
print_r($xml);
print ""; 


]

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/326f0710-fc30-4ece-b6f6-38d95045ada1%40googlegroups.com.

Re: How can I generate report using Google adwords api without downloading the file?

[Luis Manuel]

Hello,


Did you manage to solve your query? I still have not been able to solve it 
and I have the same question, I have not found content with AWQL to help me 
solve it

Thanks

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/20bc0cb8-476d-4ce4-83a4-29eea97677e2%40googlegroups.com.

How can I generate report using Google adwords api without downloading the file?

[weedoitmarket]

 

How can I generate the report CAMPAIGN_PERFORMANCE_REPORT without 
downloading the file (for example just showing the result). Here is 
actually what I do:

$reportQuery = 'SELECT CampaignId,CampaignName, Impressions, Clicks, Ctr , Cost 
'
. ' FROM CAMPAIGN_PERFORMANCE_REPORT '
. ' WHERE CampaignId = '.$campaignId.' DURING 
'.$date.','.$date;

// Download report.
ReportUtils::DownloadReportWithAwql($reportQuery, $filePath, 
$user,$reportFormat, $options);
$dataArray =file($filePath);

I download the file, then I read from the data to show it up.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 http://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/2ca9ec71-6160-4d09-ae53-2a55182110db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: How can I generate report using Google adwords api without downloading the file?

[Anthony Madrigal]

Hello,

You could have your report returned as a string instead of downloading it. 
In order to do so, you should pass a NULL value in place of the $filePath 
as such:
$report = ReportUtils::DownloadReport($reportDefinition, NULL, $user,
 $options);

You also look at this previous post 

 for 
more details since the user was trying to accomplish the same feature.

Cheers,
Anthony
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 http://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/5860ac1d-ffba-4976-866f-89bcb2170405%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.