problem in reports generation

[afzaal]

Hi Jeff,

I have some problem in report generation in google adwords. I have
designed the form according to the fields required for adding a
report, when i submit the data without any error the controlled is
returned to my page saying report was added successfully. But the area
where i am trying to view the added reports does not show me anything.
Can you please help me in this regard?

Can you elaborate the working of reports? I have read it on the site
but its not pretty clear to me. I will be thankful to you if you can
help me in this.

Regards,

Afzaal.

[AdWords API Advisor]

Hello Afzaal,

It's very unclear from what you wrote exactly what kind of guidance
you're looking for. Could you please elaborate by explaining which
specific AdWords API calls you're making, whether you're getting any
errors back, and at what point in the report scheduling process you're
running into an issue?

There is sample code for scheduling reports included with all of our
AdWords API client libraries, I believe. The normal process involves:

- calling validateReportJob()
- calling scheduleReportJob()
- periodically calling getReportJobStatus() until the report
finishes
- calling getGzipReportDownloadUrl()/getReportDownloadUrl() to get
the URL of the report
- using some HTTP client library to download the report locally

Cheers,
-Jeff Posnick, AdWords API Team

[Afzaal]

Hi Jeff,

Thanks for your reply and sorry for the last email by which you
couldn't get what i wanted to say. Ok here i am going to explain in a
bit detail what i am doing and what i further require.

I have already created Campaigns, Groups and Advertisements and all
these 3 scenarios are working fine. Now my client requires a
functionality that he can generate reports against different campaigns
for his customers. My client has further couple of customers and my
client wants that his customers can login to his website and see the
reports of the advertisements that they requested.

So i am trying to give facility to my client in website admin area
that he can add / schedule different reports. I have taken the help
from the code of report scheduling from the following link

http://code.google.com/p/adwords-api-php-samples/source/browse/trunk/src/schedule_report.php

By using this everything goes fine even i switch on the debug mode to
1, no error is generated. So i just want an idea from you that if the
report is added successfully how i can show it on my client's website?
Is there any facility that instead of giving an instant download link
for the report i can give a reports management area to my client and
from there he can download any report previously added / scheduled?

I hope now you will get what i want, if still anything you further
require please let me know.

Thanks,

Regards,

Afzaal.

On Nov 5, 9:00 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:

[AdWords API Advisor]

Hello Afzaal,

Once your report finishes and you retrieve its URL with
getGzipReportDownloadUrl()/getReportDownloadUrl() you should retrieve
the report using some sort of HTTP client library--shelling out to
curl might be appropriate for the PHP use case. Once you retrieve the
report you should store it locally and expose a link to the local copy
of the report in your web interface.

It's tempting to just expose links to the URLs returned by
getReportDownloadUrl() in your web interface, but those URLs are not
valid indefinitely and will expire after a period of time, so you
really should retrieve the report right away and serve it locally.

Cheers,
-Jeff Posnick, AdWords API Team

On Nov 6, 1:51 am, Afzaal <afzaalgo...@gmail.com> wrote:
> Hi Jeff,
>
> Thanks for your reply and sorry for the last email by which you
> couldn't get what i wanted to say. Ok here i am going to explain in a
> bit detail what i am doing and what i further require.
>
> I have already created Campaigns, Groups and Advertisements and all
> these 3 scenarios are working fine. Now my client requires a
> functionality that he can generate reports against different campaigns
> for his customers. My client has further couple of customers and my
> client wants that his customers can login to his website and see the
> reports of the advertisements that they requested.
>
> So i am trying to give facility to my client in website admin area
> that he can add / schedule different reports. I have taken the help
> from the code of report scheduling from the following link
>

> http://code.google.com/p/adwords-api-php-samples/source/browse/trunk/...

[Afzaal]

Hi Jeff,

Thanks for your reply.

Can you tell me that is there any possibility of the following:

1. Can we get a report against a specific campaign?

2. Can we get a report against a specific group?

3. Can we get a report against a specific advertisement?

4. Is the report generated is only for one google adword account?

5. For multiple reports do we need multiple google adword accounts?

Regards,

Afzaal.

On Nov 6, 9:17 pm, AdWords API Advisor <adwordsapiadvi...@google.com>

[AdWords API Advisor]

Hello Afzaal,

I think you really need to spend some time familiarizing yourself
with AdWords reports in general. A good place to start would be to use
the AdWords web interface to schedule some reports (which will not
incur any usage fees) and find the right mix of columns and report
types to get the data you're looking for. Once you have done that, you
should be able to map the request you made in the AdWords web
interface into a specific report definition in the AdWords API,
starting with the selectedReportType:

http://code.google.com/apis/adwords/docs/developer/DefinedReportJob.html#selectedReportType

and then choosing the corresponding selectedColumns.

If you schedule your report using the AdWords API from the context of
your MCC account then you can run a cross-client report and get data
from one or more of the AdWords accounts underneath the MCC at one
time. See

http://code.google.com/apis/adwords/docs/developer/adwords_api_services.html#ReportService_section

Cheers,
-Jeff Posnick, AdWords API Team

[Afzaal]

Hi Jeff,

The help you provided in the above reply was quite good. I am now just
trying to generate a report against a particular advertisement. I am
also pasting the code that i am using in generating a report against a
specific report. Can you just have a look at it and let me know that
if its correct? If there is something wrong can you guide me through
by writing some lines of correct code?

Also i have added my comments like ==> in the following code while
creating $report_job xml string.

I would also like to mention here that i am trying to show the advert
report for complete duration from the date it was created. And in
below code i have used some dumy dates.

=============================
$namespace = 'https://sandbox.google.com/api/adwords/v12';
$report_service = SoapClientFactory::GetClient($namespace . '/
ReportService?wsdl', 'wsdl');
$report_service->setHeaders($headers);
$debug = 0;

# Create report job structure.
$report_job =
'<selectedReportType>Creative</selectedReportType>' .
'<name>Sample Keyword Report</name>' .
'<aggregationTypes>Summary</aggregationTypes>' .
'<adWordsType>SearchOnly</adWordsType>' .
'<keywordType>Broad</keywordType>' .
'<startDay>2008-01-01</startDay>' .
'<endDay>2008-12-31</endDay>' .
'<selectedColumns AdId="127650">CreativeId</selectedColumns>' .
==> is this correct way of passing ad id?
'<selectedColumns CampaignId="1786">Campaign</selectedColumns>' .
==> is this correct way of passing campaign id?
'<selectedColumns AdGroupId="5000001207">AdGroup</
selectedColumns>' . ==> is this correct way of passing group id?
'<selectedColumns>Keyword</selectedColumns>' .
'<selectedColumns>KeywordStatus</selectedColumns>' .
'<selectedColumns>KeywordMinCPC</selectedColumns>' .
'<selectedColumns>KeywordDestUrlDisplay</selectedColumns>' .
'<selectedColumns>Impressions</selectedColumns>' .
'<selectedColumns>Clicks</selectedColumns>' .
'<selectedColumns>CTR</selectedColumns>' .
'<selectedColumns>AveragePosition</selectedColumns>';
$request_xml =
'<validateReportJob>' .
'<job xmlns:impl="https://adwords.google.com/api/adwords/v12" ' .
'xsi:type="impl:DefinedReportJob">' .
$report_job .
'</job>' .
'</validateReportJob>';

# Validate report.
$report_service->call('validateReportJob', $request_xml);
if ($debug) show_xml($report_service);
if ($report_service->fault) show_fault($report_service);

# Schedule report.
$request_xml =
'<scheduleReportJob>' .
'<job xmlns:impl="https://adwords.google.com/api/adwords/v12" ' .
'xsi:type="impl:DefinedReportJob">' .
$report_job .
'</job>' .
'</scheduleReportJob>';
$job_id = $report_service->call('scheduleReportJob', $request_xml);
$job_id = $job_id['scheduleReportJobReturn'];
if ($debug) show_xml($report_service);
if ($report_service->fault) show_fault($service);

# Wait for report to finish.
$request_xml =
'<getReportJobStatus>' .
'<reportJobId>' .
$job_id .
'</reportJobId>' .
'</getReportJobStatus>';
$status = $report_service->call('getReportJobStatus', $request_xml);
$status = $status['getReportJobStatusReturn'];
if ($debug) show_xml($report_service);
if ($report_service->fault) show_fault($service);
while ($status != 'Completed' and $status != 'Failed') {
//echo 'Report job status is "' . $status . '".' . "\n";
sleep(30);
$status = $report_service->call('getReportJobStatus',
$request_xml);
$status = $status['getReportJobStatusReturn'];
if ($debug) show_xml($report_service);
if ($report_service->fault) show_fault($service);
}

if ($status == 'Failed') {
echo 'Report job generation failed.' . "\n";
return;
}

# Download report.
$request_xml =
'<getReportDownloadUrl>' .
'<reportJobId>' .
$job_id .
'</reportJobId>' .
'</getReportDownloadUrl>';
$report_url = $report_service->call('getReportDownloadUrl',
$request_xml);
$report_url = $report_url['getReportDownloadUrlReturn'];
if ($debug) show_xml($report_service);
if ($report_service->fault) show_fault($service);
=============================

Your quick response will be highly appriciated.

Regards,

Afzaal.

On Nov 7, 9:28 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hello Afzaal,
>

>  I think you really need to spend some time familiarizing yourself
> with AdWords reports in general. A good place to start would be to use
> the AdWords web interface to schedule some reports (which will not
> incur any usage fees) and find the right mix of columns and report
> types to get the data you're looking for. Once you have done that, you
> should be able to map the request you made in the AdWords web
> interface into a specific report definition in the AdWords API,
> starting with the selectedReportType:
>

>  http://code.google.com/apis/adwords/docs/developer/DefinedReportJob.h...

>
> and then choosing the corresponding selectedColumns.
>
>  If you schedule your report using the AdWords API from the context of
> your MCC account then you can run a cross-client report and get data
> from one or more of the AdWords accounts underneath the MCC at one
> time. See
>

>  http://code.google.com/apis/adwords/docs/developer/adwords_api_servic...

[AdWords API Advisor]

Hello Afzaal,

It looks like you're writing Perl code, so you might want to try
using the third-party Perl client library for the AdWords API:

http://search.cpan.org/~rohan/Google-Adwords-v1.9.3/

You can use SOAP::Lite directly if you want, but it might be simpler
for you to make use of Google::AdWords.

Anyway, regarding the XML you posted above, that's mostly correct,
but the lines you had questions about are not right:

<selectedColumns AdId="127650">CreativeId</selectedColumns>

<selectedColumns CampaignId="1786">Campaign</selectedColumns>

<selectedColumns AdGroupId="5000001207">AdGroup</selectedColumns>

There is no filter to make a report run only against a specific
creative id. If you do want to limit your report to only a specific ad
group id and campaign id (though really, you'd only need to limit
based on ad group id, since the campaign id is assumed from the ad
group id), the syntax would be:

<campaigns>1786</campaigns>
<adGroups>5000001207</adGroups>
<adGroups>123456789</adGroups> <!--just illustrating how multiple ad
groups would look-->

I also wouldn't recommend including the KeywordMinCPC
<selectedColumns>, as it's been deprecated in favor of FirstPageCpc.

Stepping back a bit, though, if all you care about is the stats for
one particular ad then you might be better off just making use of the
getAdStats() method:

http://code.google.com/apis/adwords/docs/developer/AdService.html#getAdStats

It will use fewer API units than running a report and its more
straightforward. I'm assuming that later on you're going to want to
get info for more than one ad, though, and as you scale up it will
make more sense to run a report.

Cheers,
-Jeff Posnick, AdWords API Team

> ...
>
> read more »