Monthly Report Not Returnning Full Data

[basker reddy]

Hi ,

I am using adwords api version v201502 latest  to download AD_PERFORMANCE_REPORT

For the date 2015-03-01 i am getting 216 rows but when i use date range 2015-03-01 to 2015-03-31

then i am getting 26 rows for the date 2015-03-01

please help on this why i am getting half data 

Regards,
bhasker

[Anash P. Oommen (AdWords API Team)]

Hi Bhasker,

Are the report definitions identical except for the date range? Could you please use the "Reply to Author" option to share with me the downloaded reports and report definition xmls in both cases? I'll take a look.

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[basker reddy]

Hi,

i am using below function

function DownloadDestinationUrlReport(AdWordsUser $user, $filePath) {
      // Load the service, so that the required classes are available.
      $user->LoadService('ReportDefinitionService', 'v201502');
      // Create selector.
      $selector = new Selector();
#        $selector->fields = array('AccountCurrencyCode', 'AccountDescriptiveName', 'AccountTimeZoneId', 'AdGroupId', 'AdGroupName', 'AdGroupStatus', 'AdNetworkType1', 'AdNetworkType2', 'AverageCpc', 'AverageCpm', 'AveragePosition', 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', 'ClickType', 'ConversionCategoryName', 'ConversionRate', 'ConversionRateManyPerClick', 'Conversions', 'ConversionsManyPerClick', 'ConversionTrackerId', 'ConversionTypeName', 'ConversionValue', 'Cost', 'CostPerConversion', 'CostPerConversionManyPerClick', 'CriteriaDestinationUrl', 'CriteriaParameters', 'CriteriaStatus', 'CriteriaTypeName', 'Ctr', 'CustomerDescriptiveName', 'Date', 'DayOfWeek', 'Device', 'EffectiveDestinationUrl', 'ExternalCustomerId', 'Impressions', 'IsNegative', 'Month', 'MonthOfYear', 'PrimaryCompanyName', 'PrimaryUserLogin', 'Quarter', 'Slot', 'TotalConvValue', 'ValuePerConv', 'ValuePerConversion', 'ValuePerConversionManyPerClick', 'ValuePerConvManyPerClick', 'ViewThroughConversions', 'Week', 'Year');

#    $selector->fields = array('EffectiveDestinationUrl', 'Impressions', 'Clicks', 'Cost', 'Conversions','Date','AdNetworkType1');
    $selector->fields = array('CreativeDestinationUrl', 'Impressions', 'Clicks', 'Cost', 'ConvertedClicks','Date','AdNetworkType1');
    $sql = "select date_format(date_sub(now(),interval 1 day),'%Y%m%d') as date";
        $result = mysql_query($sql);
    $row = mysql_fetch_assoc($result);
    $startdate = $row['date'];
    $enddate = $row['date'];
    $startdate = '20150301';
    $enddate = '20150331';
    $selector->dateRange=array('min'=>"$startdate",'max'=>"$enddate");

      // Create report definition.
      $reportDefinition = new ReportDefinition();
      $reportDefinition->selector = $selector;
  #    $reportDefinition->reportName = 'Destination URL report #' . uniqid();
    $reportDefinition->reportName = 'Ad performance  report #' . uniqid();
    $reportDefinition->dateRangeType = 'CUSTOM_DATE';
#    $reportDefinition->reportType = 'DESTINATION_URL_REPORT';
      $reportDefinition->reportType = 'AD_PERFORMANCE_REPORT';
      $reportDefinition->downloadFormat = 'CSV';

      // Exclude criteria that haven't recieved any impressions over the date range.
      $reportDefinition->includeZeroImpressions = FALSE;

      // Set additional options.
//      $options = array('version' => 'v201502', 'returnMoneyInMicros' => false);
    $options = array('version' => 'v201502');

      // Download report.
      ReportUtils::DownloadReport($reportDefinition, $filePath, $user, $options);
    return $filePath;
}

i am just changing the date range as
from
    $startdate = '20150301';
    $enddate = '20150301'; 

to

$startdate = '20150301';
    $enddate = '20150331';

please help on this

[Anash P. Oommen (AdWords API Team)]

Hi Basker,

I'd still need the customer ID and a specific campaign for which you are seeing partial data. Could you please use the "Reply to Author" option to provide details?

Cheers,

Anash