Re: Report with day field
Thanks David, Now got the desired report. On Wednesday, May 23, 2012 2:52:04 AM UTC+5:30, David Torres wrote: > > Hi Chirag, > > Your are including many fields that will segment your report in multiple > rows (i.e. 'AdNetworkType1', 'AdNetworkType2', 'Date') > > Please read the section behavior of this reference > https://developers.google.com/adwords/api/docs/appendix/reports for more > information. > > Best, > > -David > > On Friday, May 18, 2012 3:28:55 AM UTC-4, Chirag wrote: >> >> Hello Anash, >> Any update? >> What i am doing wrong with the code. >> >> Thanks, >> Chirag >> >> On Saturday, May 12, 2012 5:52:25 PM UTC+5:30, Chirag wrote: >>> >>> Hello Anash, >>> Here is the report definition for ad performance report. here also i am >>> getting for same day multiple row and same ad id. >>> >>> $selector = new Selector(); >>> $reportDefinition = new ReportDefinition(); >>> $selector->dateRange = new DateRange($startDate, $endDate); >>> $array = array( >>> 'AdGroupId', 'AdGroupName', 'AdGroupStatus', >>> 'AdNetworkType1', 'AdNetworkType2', 'AdType', 'AverageCpc', 'AverageCpm', >>> 'AveragePosition', 'Device', >>> 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', >>> 'Ctr', 'Cost', 'Conversions', 'CostPerConversion', >>> 'ConversionRate', 'ConversionsManyPerClick', >>> 'CostPerConversionManyPerClick', >>> 'ConversionRateManyPerClick', 'Headline', 'Id', 'Status', 'Description1', >>> 'Description2', >>> 'Impressions', 'TotalConvValue', >>> 'ValuePerConversion','DisplayUrl','Url','Date'); >>> >>> $campaignStatusPredicate = new >>> Predicate('CampaignStatus', 'IN', array('ACTIVE', 'PAUSED')); //ACTIVE, >>> DELETED, PAUSED >>> $AdgrpstatusPredicate = new Predicate('Status', 'IN', >>> array('ENABLED')); //ENABLED, PAUSED, DELETED >>> $statusPredicate = new Predicate('AdGroupStatus', 'IN', >>> array('ENABLED')); >>> $selector->predicates = array($AdgrpstatusPredicate, >>> $statusPredicate, $campaignStatusPredicate); >>> $reportDefinition->reportName = 'Ad performance report >>> #' . time(); >>> $reportDefinition->dateRangeType ='CUSTOM_DATE'; >>> $reportDefinition->reportType = 'AD_PERFORMANCE_REPORT'; >>> $reportDefinition->includeZeroImpressions = FALSE; >>> >>> Thanks, >>> Chirag >>> >>> >>> >>> On Saturday, May 12, 2012 12:53:55 AM UTC+5:30, David Torres wrote: Hi Chirag, You might be including another segmentation field in your report that is causing multiple rows for the same day/campaign combination, how your report definition looks like exactly? Best, -David Torres - AdWords API Team On Tuesday, May 8, 2012 8:34:38 AM UTC-4, Chirag wrote: > > Hello All, > > I wants to get data day basis. So that i am including day field, but > result is more than one row for same campaign and same day. is there any > way so that i can get one day field for one campaign in report? > > 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
Re: Report with day field
Hi Chirag, Your are including many fields that will segment your report in multiple rows (i.e. 'AdNetworkType1', 'AdNetworkType2', 'Date') Please read the section behavior of this reference https://developers.google.com/adwords/api/docs/appendix/reports for more information. Best, -David On Friday, May 18, 2012 3:28:55 AM UTC-4, Chirag wrote: > > Hello Anash, > Any update? > What i am doing wrong with the code. > > Thanks, > Chirag > > On Saturday, May 12, 2012 5:52:25 PM UTC+5:30, Chirag wrote: >> >> Hello Anash, >> Here is the report definition for ad performance report. here also i am >> getting for same day multiple row and same ad id. >> >> $selector = new Selector(); >> $reportDefinition = new ReportDefinition(); >> $selector->dateRange = new DateRange($startDate, $endDate); >> $array = array( >> 'AdGroupId', 'AdGroupName', 'AdGroupStatus', >> 'AdNetworkType1', 'AdNetworkType2', 'AdType', 'AverageCpc', 'AverageCpm', >> 'AveragePosition', 'Device', >> 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', >> 'Ctr', 'Cost', 'Conversions', 'CostPerConversion', >> 'ConversionRate', 'ConversionsManyPerClick', >> 'CostPerConversionManyPerClick', >> 'ConversionRateManyPerClick', 'Headline', 'Id', 'Status', 'Description1', >> 'Description2', >> 'Impressions', 'TotalConvValue', >> 'ValuePerConversion','DisplayUrl','Url','Date'); >> >> $campaignStatusPredicate = new >> Predicate('CampaignStatus', 'IN', array('ACTIVE', 'PAUSED')); //ACTIVE, >> DELETED, PAUSED >> $AdgrpstatusPredicate = new Predicate('Status', 'IN', >> array('ENABLED')); //ENABLED, PAUSED, DELETED >> $statusPredicate = new Predicate('AdGroupStatus', 'IN', >> array('ENABLED')); >> $selector->predicates = array($AdgrpstatusPredicate, >> $statusPredicate, $campaignStatusPredicate); >> $reportDefinition->reportName = 'Ad performance report #' >> . time(); >> $reportDefinition->dateRangeType ='CUSTOM_DATE'; >> $reportDefinition->reportType = 'AD_PERFORMANCE_REPORT'; >> $reportDefinition->includeZeroImpressions = FALSE; >> >> Thanks, >> Chirag >> >> >> >> On Saturday, May 12, 2012 12:53:55 AM UTC+5:30, David Torres wrote: >>> >>> Hi Chirag, >>> >>> You might be including another segmentation field in your report that is >>> causing multiple rows for the same day/campaign combination, how your >>> report definition looks like exactly? >>> >>> Best, >>> >>> -David Torres - AdWords API Team >>> >>> On Tuesday, May 8, 2012 8:34:38 AM UTC-4, Chirag wrote: Hello All, I wants to get data day basis. So that i am including day field, but result is more than one row for same campaign and same day. is there any way so that i can get one day field for one campaign in report? 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
Re: Report with day field
Hello Anash, Any update? What i am doing wrong with the code. Thanks, Chirag On Saturday, May 12, 2012 5:52:25 PM UTC+5:30, Chirag wrote: > > Hello Anash, > Here is the report definition for ad performance report. here also i am > getting for same day multiple row and same ad id. > > $selector = new Selector(); > $reportDefinition = new ReportDefinition(); > $selector->dateRange = new DateRange($startDate, $endDate); > $array = array( > 'AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdNetworkType1', > 'AdNetworkType2', 'AdType', 'AverageCpc', 'AverageCpm', 'AveragePosition', > 'Device', > 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', > 'Ctr', 'Cost', 'Conversions', 'CostPerConversion', > 'ConversionRate', 'ConversionsManyPerClick', > 'CostPerConversionManyPerClick', 'ConversionRateManyPerClick', > 'Headline', 'Id', 'Status', 'Description1', 'Description2', > 'Impressions', 'TotalConvValue', > 'ValuePerConversion','DisplayUrl','Url','Date'); > > $campaignStatusPredicate = new Predicate('CampaignStatus', > 'IN', array('ACTIVE', 'PAUSED')); //ACTIVE, DELETED, PAUSED > $AdgrpstatusPredicate = new Predicate('Status', 'IN', > array('ENABLED')); //ENABLED, PAUSED, DELETED > $statusPredicate = new Predicate('AdGroupStatus', 'IN', > array('ENABLED')); > $selector->predicates = array($AdgrpstatusPredicate, > $statusPredicate, $campaignStatusPredicate); > $reportDefinition->reportName = 'Ad performance report #' > . time(); > $reportDefinition->dateRangeType ='CUSTOM_DATE'; > $reportDefinition->reportType = 'AD_PERFORMANCE_REPORT'; > $reportDefinition->includeZeroImpressions = FALSE; > > Thanks, > Chirag > > > > On Saturday, May 12, 2012 12:53:55 AM UTC+5:30, David Torres wrote: >> >> Hi Chirag, >> >> You might be including another segmentation field in your report that is >> causing multiple rows for the same day/campaign combination, how your >> report definition looks like exactly? >> >> Best, >> >> -David Torres - AdWords API Team >> >> On Tuesday, May 8, 2012 8:34:38 AM UTC-4, Chirag wrote: >>> >>> Hello All, >>> >>> I wants to get data day basis. So that i am including day field, but >>> result is more than one row for same campaign and same day. is there any >>> way so that i can get one day field for one campaign in report? >>> >>> 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
Re: Report with day field
Hello Anash, Here is the report definition for ad performance report. here also i am getting for same day multiple row and same ad id. $selector = new Selector(); $reportDefinition = new ReportDefinition(); $selector->dateRange = new DateRange($startDate, $endDate); $array = array( 'AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdNetworkType1', 'AdNetworkType2', 'AdType', 'AverageCpc', 'AverageCpm', 'AveragePosition', 'Device', 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', 'Ctr', 'Cost', 'Conversions', 'CostPerConversion', 'ConversionRate', 'ConversionsManyPerClick', 'CostPerConversionManyPerClick', 'ConversionRateManyPerClick', 'Headline', 'Id', 'Status', 'Description1', 'Description2', 'Impressions', 'TotalConvValue', 'ValuePerConversion','DisplayUrl','Url','Date'); $campaignStatusPredicate = new Predicate('CampaignStatus', 'IN', array('ACTIVE', 'PAUSED')); //ACTIVE, DELETED, PAUSED $AdgrpstatusPredicate = new Predicate('Status', 'IN', array('ENABLED')); //ENABLED, PAUSED, DELETED $statusPredicate = new Predicate('AdGroupStatus', 'IN', array('ENABLED')); $selector->predicates = array($AdgrpstatusPredicate, $statusPredicate, $campaignStatusPredicate); $reportDefinition->reportName = 'Ad performance report #' . time(); $reportDefinition->dateRangeType ='CUSTOM_DATE'; $reportDefinition->reportType = 'AD_PERFORMANCE_REPORT'; $reportDefinition->includeZeroImpressions = FALSE; Thanks, Chirag On Saturday, May 12, 2012 12:53:55 AM UTC+5:30, David Torres wrote: > > Hi Chirag, > > You might be including another segmentation field in your report that is > causing multiple rows for the same day/campaign combination, how your > report definition looks like exactly? > > Best, > > -David Torres - AdWords API Team > > On Tuesday, May 8, 2012 8:34:38 AM UTC-4, Chirag wrote: >> >> Hello All, >> >> I wants to get data day basis. So that i am including day field, but >> result is more than one row for same campaign and same day. is there any >> way so that i can get one day field for one campaign in report? >> >> 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
Re: Report with day field
Hi Chirag, You might be including another segmentation field in your report that is causing multiple rows for the same day/campaign combination, how your report definition looks like exactly? Best, -David Torres - AdWords API Team On Tuesday, May 8, 2012 8:34:38 AM UTC-4, Chirag wrote: > > Hello All, > > I wants to get data day basis. So that i am including day field, but > result is more than one row for same campaign and same day. is there any > way so that i can get one day field for one campaign in report? > > 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
Report with day field
Hello All, I wants to get data day basis. So that i am including day field, but result is more than one row for same campaign and same day. is there any way so that i can get one day field for one campaign in report? 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