How to sort a report

500 views
Skip to first unread message

stiggywigget

unread,
Mar 6, 2011, 11:28:12 PM3/6/11
to adwor...@googlegroups.com
I'm trying to sort by date when defining and adding a report.
In PHP:

$selector->fields = array('CampaignId', 'CampaignName', 'Status', 'Clicks', 'Cost', 'Date');
$selector->ordering = array('Date'); // Is this correct?
$reportDefinition = new ReportDefinition();
$reportDefinition->reportName = 'name';
$reportDefinition->dateRangeType = 'LAST_7_DAYS';
$reportDefinition->reportType = 'CAMPAIGN_PERFORMANCE_REPORT';
$reportDefinition->downloadFormat = 'XML';
$reportDefinition->selector = $selector;

I suspect there's more to it. Thanks.

AdWords API Advisor

unread,
Mar 7, 2011, 10:36:18 PM3/7/11
to AdWords API Forum
Hi,

ordering is an array of OrderBy objects, so I believe it would be
array(new OrderBy('Date', 'ASCENDING'));.
See http://code.google.com/apis/adwords/docs/reference/latest/ReportDefinitionService.Selector.html#ordering
for details.

Cheers,
Anash P. Oommen,
AdWords API Advisor.
Reply all
Reply to author
Forward
0 new messages