Hi Tom,
It doesn't appear to be documented correctly, but if you also pass in
the aggregation type "Daily" you'll get the date breakdown like the UI
delivers.
DefinedReportJob myJob = new DefinedReportJob();
myJob.name = "Geographic Report";
myJob.selectedReportType = "Geographic";
myJob.aggregationTypes = new string[] { "AdGroup",
"Daily" };
myJob.endDay = DateTime.Today;
myJob.startDay = new DateTime(2010, 3, 1);
myJob.selectedColumns = new String[] {"Campaign",
"AdGroup","AdNetworkType" , "Impressions", "Clicks" ,"Cost",
"Country" ,"Region" ,"Conversions" };
Best,
- Eric Koleda, AdWords API Team
On Mar 7, 2:31 pm, Tom <t.w.wet...@googlemail.com> wrote:
> Hi there,
>
> I want to create a Geographic report with the help of the API.
> But somehow there is no way to aggregate the data on a daily basis.
>
> When I create a Geographic report manually then the result have a
> 'date' column.
>
> The columns are:
>
> <columns>
> <column name="date"></column>
> <column name="campaign"></column>
> <column name="country"></column>
> <column name="region"></column>
> <column name="campStatus"></column>
> <column name="imps"></column>
> <column name="clicks"></column>
> <column name="cpc"></column>
> <column name="dailyctr"></column>
> <column name="cost"></column>
> <column name="conv"></column>
> <column name="convRate"></column>
> <column name="costPerConv"></column>
> </columns>
>
> When I create the report by API the (example) columns are:
>
> <columns>
> <column name="campaign"></column>
> <column name="adgroup"></column>
> <column name="country"></column>
> <column name="region"></column>
> <column name="adNetworkType"></column>
> <column name="imps"></column>
> <column name="clicks"></column>
> <column name="cost"></column>
> <column name="conv"></column>
> </columns>
>
> But how do I get the column 'date' in a geographic report created by
> the API?
>
> My code is the following:
>
> DefinedReportJob myJob = new DefinedReportJob();
> myJob.name = "Geographic Report";
> myJob.selectedReportType = "Geographic";
> myJob.aggregationTypes = new string[] { "AdGroup" };
> myJob.endDay = DateTime.Today;
> myJob.startDay = new DateTime(2010, 3, 1);
> myJob.selectedColumns = new String[] {"Campaign",
> "AdGroup","AdNetworkType" , "Impressions", "Clicks" ,"Cost",
> "Country" ,"Region" ,"Conversions" };
>
> Thank you
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Have you migrated to v200909 yet?
The v13 sunset is on April 22, 2010.
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 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
