Hi,
As for the AWQL, do you have the exact same string literal you used?
(In your example, it contains still some PHP variables)
As for the second, I'm not sure why you added up the Average Cpc
(2013-10-13 11-45-37.png).
Looks like the data is segmented by some other columns please check your
requested fields when you pulled the report.
Best,
- Takeshi, AdWords API Team
On Sunday, October 13, 2013 3:27:07 PM UTC+9, Hardik Raval wrote:
>
>
> Hello Sir/Mem,
>
> I working on my clients MCC account for reporting functionalities.
> I am using PHP API version v201309 (latest).
> Ok i fetching the result set with AWQL
> (Reporting/DownloadCriteriaReportWithAwql.php) but i facing one query error
> while executing that file.
> which is : Type = 'QueryError.INVALID_ORDER_BY_CLAUSE', Trigger = '',
> FieldPath = ''.
>
> while there is nothing wrong in my query :
>
> $dateRange = sprintf('%d,%d',
> date('Ymd', strtotime('1989-01-01')), date('Ymd', strtotime('now')));
>
> SELECT CampaignId, CampaignName, AverageCpc, Conversions,
> 'Cost, Date FROM CRITERIA_PERFORMANCE_REPORT '
> 'WHERE CampaignName IN ["Local - Search", "Local - Display", "Display
> New Landing"] DURING '.$dateRange.' ORDER BY Date';
>
> Another issue is i am facing is of Average CPC, there is a different in
> client MCC account and in API response output for particular date.
> i want to clarify you that i am using AWQL
> (Reporting/DownloadCriteriaReportWithAwql.php) which creates direct .csv
> file of output.
> Please check screenshots.
>
> Thank you,
> Hardik
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
