Hi All,
When certain fields are added to the report, such as date / time
fields, rows with zero impressions are not returned. Because the
sandbox environment doesn't serve ads there can't be any impressions,
so there will be no results. If you exclude the date / time fields
you should see results again. We apologize for the confusion and we
are working to document this functionality better.
Best,
- Eric Koleda, AdWords API Team
On Oct 29, 5:11 am, Wilrik Mook <wil...@gmail.com> wrote:
> Hmm, the same seems to happen here when I add the Date field, no rows
> are returned (using the sandbox, which normally returns rows with 0 as
> value for each field).
> Looks like a server-side problem to me, maybe an API advisor could
> look into this?
>
> Regards,
>
> Wilrik
> 050media
>
> On Oct 28, 6:34 pm, SW <ga...@structuredweb.com> wrote:
>
>
>
>
>
>
>
> > Thank you Wilrik for the quick response.
>
> > If I have following report fields for adgroup report, I get some data
> > back (empty rows per adgroupid specified for the whole date range). I
> > am using last thirty days for the date range.
>
> > public string[] adGroupReportFields = new string[] { "CampaignId",
> > "CampaignName", "CampaignStatus", "Id", "Status", "AdGroupName",
> > "Impressions", "Clicks", "Ctr", "CostPerConversion",
> > "AveragePosition" };
>
> > Changing this to include both the fields you mentioned earlier doesn't
> > yield any results returned at all. It just returns the columns but no
> > rows.
>
> > either this:
> > public string[] adGroupReportFields = new string[] { "CampaignId",
> > "CampaignName", "CampaignStatus", "Id", "Status", "AdGroupName",
> > "Impressions", "Clicks", "Ctr", "CostPerConversion",
> > "AveragePosition", "Date", "DayOfWeek" };
>
> > or this:
> > public string[] adGroupReportFields = new string[] { "CampaignId",
> > "CampaignName", "CampaignStatus", "Id", "Status", "AdGroupName",
> > "Impressions", "Clicks", "Ctr", "CostPerConversion",
> > "AveragePosition", "DayOfWeek" };
>
> > or this:
> > public string[] adGroupReportFields = new string[] { "CampaignId",
> > "CampaignName", "CampaignStatus", "Id", "Status", "AdGroupName",
> > "Impressions", "Clicks", "Ctr", "CostPerConversion",
> > "AveragePosition", "DayOfWeek" };
>
> > Does not return any rows with stats. Please shed some light. If it
> > helps, here is my code:
>
> > public List<ReportDefinition> GenerateReport(string minDate, string
> > maxDate, string[] fields, string reportName, string folderPath,
> > ReportDefinitionReportType reportType, XmlDocument reportXml,
> > List<Predicate> predicates)
> > {
> > Selector selector = GetReportSelector(minDate, maxDate,
> > fields, predicates.ToArray());
> > ReportDefinition reportDefinition =
> > GetReportDefinition(selector, reportName, reportType, true,
> > ReportDefinitionDateRangeType.CUSTOM_DATE, DownloadFormat.XML);
> > ReportDefinitionOperation reportOperation =
> > GetOperation(reportDefinition, Operator.ADD);
>
> > List<ReportDefinitionOperation> defList = new
> > List<ReportDefinitionOperation>();
> > defList.Add(reportOperation);
>
> > List<ReportDefinition> mutatedDefinitions =
> > Mutate(defList);
>
> > if (mutatedDefinitions.Count >= 1)
> > {
> > ReportUtilities utility = new ReportUtilities(user);
> > string reportFile = folderPath + reportName + ".xml";
>
> > utility.DownloadReportDefinition(mutatedDefinitions[0].id,
> > reportFile);
> > reportXml.Load(reportFile);
> > }
> > return mutatedDefinitions;
> > }
>
> > On Oct 28, 11:17 am, Wilrik Mook <wil...@gmail.com> wrote:
>
> > > Sorry if I wasn't clear enough, I meant to say: if you include those
> > > fields (though only Date should do the trick), it will show statistics
> > > for each day separately.
> > > The same kind of thing happened to me when including the
> > > AdNetworkType1 field in a report: a row was given for each separate
> > > value of that field. Since the Date field will 'give' you multiple
> > > dates in that period, a row for each date will be added. This is what
> > > I observed, but I could be wrong.
> > > I hope this clarifies things a bit!
>
> > > Regards,
>
> > > Wilrik
> > > 050media
>
> > > On Oct 28, 5:03 pm, SW <ga...@structuredweb.com> wrote:
>
> > > > If I omit the Date or DayOfWeek, will it get me statistics for days
> > > > separately?
>
> > > > On Oct 28, 10:58 am, Wilrik Mook <wil...@gmail.com> wrote:
>
> > > > > Hi SW,
>
> > > > > When you include the Date or DayOfWeek field in the selector, I think
> > > > > this automatically happens.
>
> > > > > Regards,
>
> > > > > Wilrik
> > > > > 050media
>
> > > > > On Oct 28, 4:35 pm, SW <ga...@structuredweb.com> wrote:
>
> > > > > > Hi,
>
> > > > > > We are using ReportDefinitionService of v201008 version. The version
> > > > > > v200909 allowed us to get the report data to include the daily
> > > > > > aggregation. If we specify two date range, the report would include
> > > > > > statistics data separately for single day within the date range.
>
> > > > > > However, new service aggregates all the days within the date range.
> > > > > > It doesn't break down the statistics data for each separate day. I
> > > > > > was wondering how can we do that using new v201008 report definition
> > > > > > service.
>
> > > > > > Thanks
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
