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.

Report accounts

[Luis Manuel]

[image: ok.PNG]
Hi guys,

I'm using the adwords API and I'm downloading the reports correctly, the 
problem I have is that I need to extract the data but not download it, I 
have not found in the documentation how to perform this process since all 
the information that appears is to make the report and download the data.

Thanks for the help.


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/55daac28-cef0-44fc-9155-dbaec0698345%40googlegroups.com.

How to get the metrics of an account, campaign, or ad group (adwords-php)

[Luis Manuel]

Hi all,


I am using the adwords API for php but I have not found how to perform very 
simple queries.

I want to make this query, but I do not understand how to make the query,I 
want to make a report, but not to download it.

"SELECT CampaignId, AdGroupId, Impressions, Clicks, Cost FROM 
ADGROUP_PERFORMANCE_REPORT WHERE AdGroupStatus IN [ENABLED, PAUSED] DURING 
LAST_7_DAYS"

I have managed to make this query, but I do not understand how to do the 
one I mentioned earlier.

$query = (new ServiceQueryBuilder())
->select(['Id', 'Name', 'Status'])
->orderByAsc('Name')
->limit(0, self::PAGE_LIMIT)
->build()


I hope you have understood me and that you can help me

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/0653e6ae-96e8-492d-9d40-d79550a5a948%40googlegroups.com.