BingAds API returing duplicate record with 0 counts in performance metrics

Prime Molina@3Q 1 Reputation point
2022-01-27T19:15:15.95+00:00

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?

169983-3qdigital-duplicatedataissueposted-20220131.jpg

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
A Microsoft API that provides programmatic access to Microsoft Advertising to manage large campaigns or to integrate your marketing with other in-house systems.
402 questions
0 comments No comments
{count} votes