A Microsoft API that provides programmatic access to Microsoft Advertising to manage large campaigns or to integrate your marketing with other in-house systems.
BingAds API returing duplicate record with 0 counts in performance metrics
Prime Molina@3Q
1
Reputation point
Our Bing Ads API report request to object CampaignPerformanceReport is returning a duplicate record, and the duplicate record has 0 data in the metrics field.
This issue does not occur in other accounts using the same routine. Can tech support please follow up with me so that I can get into more details?

The microsft.bingads SDK version: com.microsoft.bingads - microsoft.bingads - version 13.0.12
The report request code block:
protected ReportRequest buildReportRequest() {
CampaignPerformanceReportRequest report = new CampaignPerformanceReportRequest();
report.setAggregation(ReportAggregation.DAILY);
report.setScope(new AccountThroughCampaignReportScope());
ArrayOflong accountIds = new ArrayOflong();
accountIds.getLongs().add(account.engineId);
report.getScope().setAccountIds(accountIds);
report.setTime(reportTime());
ArrayOfCampaignPerformanceReportColumn columns = new ArrayOfCampaignPerformanceReportColumn();
columns.getCampaignPerformanceReportColumns().addAll(Arrays.asList(getReportFields()));
report.setColumns(columns);
return report;
}
Report fields requested:
TIME_PERIOD,
ACCOUNT_NUMBER,
ACCOUNT_NAME,
ACCOUNT_STATUS,
CAMPAIGN_ID,
CAMPAIGN_NAME,
CAMPAIGN_TYPE,
CAMPAIGN_STATUS,
CURRENCY_CODE,
AD_DISTRIBUTION,
DEVICE_TYPE,
NETWORK,
IMPRESSIONS,
CLICKS,
CTR,
PTR,
AVERAGE_CPC,
SPEND,
RETURN_ON_AD_SPEND,
AVERAGE_POSITION,
CONVERSIONS,
CONVERSION_RATE,
COST_PER_CONVERSION,
ASSISTS,
COST_PER_ASSIST,
REVENUE,
REVENUE_PER_ASSIST,
REVENUE_PER_CONVERSION,
LOW_QUALITY_IMPRESSIONS,
LOW_QUALITY_IMPRESSIONS_PERCENT,
LOW_QUALITY_CLICKS,
LOW_QUALITY_CLICKS_PERCENT,
LOW_QUALITY_GENERAL_CLICKS,
LOW_QUALITY_SOPHISTICATED_CLICKS,
LOW_QUALITY_CONVERSIONS,
LOW_QUALITY_CONVERSION_RATE,
PHONE_IMPRESSIONS,
PHONE_CALLS,
QUALITY_SCORE,
EXPECTED_CTR,
AD_RELEVANCE,
ALL_CONVERSIONS,
ALL_CONVERSION_RATE,
ALL_COST_PER_CONVERSION,
ALL_REVENUE,
ALL_RETURN_ON_AD_SPEND,
ALL_REVENUE_PER_CONVERSION,
CLICK_SHARE_PERCENT,
IMPRESSION_SHARE_PERCENT,
IMPRESSION_LOST_TO_BUDGET_PERCENT,
IMPRESSION_LOST_TO_RANK_AGG_PERCENT,
EXACT_MATCH_IMPRESSION_SHARE_PERCENT,
ABSOLUTE_TOP_IMPRESSION_SHARE_PERCENT,
ABSOLUTE_TOP_IMPRESSION_RATE_PERCENT,
ABSOLUTE_TOP_IMPRESSION_SHARE_LOST_TO_BUDGET_PERCENT,
ABSOLUTE_TOP_IMPRESSION_SHARE_LOST_TO_RANK_PERCENT,
TOP_IMPRESSION_SHARE_PERCENT,
TOP_IMPRESSION_RATE_PERCENT,
TOP_IMPRESSION_SHARE_LOST_TO_RANK_PERCENT,
TOP_IMPRESSION_SHARE_LOST_TO_BUDGET_PERCENT,
VIEW_THROUGH_CONVERSIONS,
HISTORICAL_QUALITY_SCORE,
HISTORICAL_EXPECTED_CTR,
HISTORICAL_AD_RELEVANCE,
HISTORICAL_LANDING_PAGE_EXPERIENCE,
LANDING_PAGE_EXPERIENCE,
TRACKING_TEMPLATE,
FINAL_URL_SUFFIX
Microsoft Advertising API
Microsoft Advertising API
Sign in to answer