Ruby: CAMPAIGN PERFORMANCE REPORT differ and returned incorrect metrics in report

[SOHAIR AHMAD]

Attached the actual metrics from my adwords account.

CAMPAIGN_PERFORMANCE_REPORT is the report which I am using, with the following metrics

generate_report(
  client_customer_id,
  ['Amount', 'AveragePosition', 'CampaignId', 'CampaignName', 'CampaignStatus', 'Clicks', 'CustomerDescriptiveName', 'Conversions',
    'ConversionRate', 'Cost', 'CostPerConversion', 'Ctr', 'Impressions', 'Date'],
  'Campaigns',
  'CAMPAIGN_PERFORMANCE_REPORT',
  'LAST_30_DAYS',
  true
)

And this returned me multiple records but the one that is in attached image is as follow:

Amount="7000000", AveragePosition ="0.0", CampaignId ="759273350", CampaignName ="AI_Cmpn_Mon Feb 20 04:43:48 UTC 2017", CampaignStatus ="enabled", Clicks  ="0", CustomerDescriptiveName ="AdIntern", Conversions ="0.0", ConversionRate ="0.00%", Cost ="0", CostPerConversion ="0", Ctr  ="0.00%", Impressions  ="0", Date ="2017-02-04"

If someone can confirm that why Am I getting the difference with metrics ?  as Amount, CampaignName, and CampaignId is same as in Adwords Account in the attached image.

Thanks In advance

[Vishal Vinayak (Adwords API Team)]

Hi Sohair,

Date field in the Campaign Performance Report is a segmentation field; hence the data in the report is split into various segments, one for each date.  If you segment your web interface report based on the date (or apply the custom date filter for 4th Feb 2017), the web interface report data should match with that of the API report. In case you are still facing issues, could you please confirm if you applied any other predicates/filters when trying to download the report via the API? Just in case you have the SOAP XML report definition, please feel free to send it across along with the downloaded report and I would be happy to take a further look.  

Regards,

Vishal, AdWords API Team

[SOHAIR AHMAD]

True,
Adding Date return many duplicate records and i am applying unique by if on that duplicate record. Can you please confirm what field should i get instead of DATE if i really needed the DATE ?

[Vishal Vinayak (Adwords API Team)]

Hi Sohair,

If you only want data of a specific date, you can specify the corresponding date range on your report instead of using LAST_30_DAYS. Unfortunately, Date is a segmentation field and you would see multiple segments of data in your report if this field is added. However, individual segments cannot be considered duplicates since each segment contains data for a different date. 

[SOHAIR AHMAD]

YES true. Thanks alot for your help. I appriciate this.