Microsoft advertising api - requesting with compatible fields does not return report url

Feroj 1 Reputation point
2021-03-25T10:30:56.813+00:00

Hi, We are trying to generate report for our customer where we have ImpressionSharePercent with AdGroupName and ** AdGroupStatus**. We see that when we have all these 3 fields requested together the api does not return any url nor any error message (just url having value null). If we request with only AdGroupName and ** AdGroupStatus** or ImpressionSharePercent, it works as usual. From here: https://learn.microsoft.com/en-us/advertising/reporting-service/adgroupperformancereportcolumn?view=bingads-13 We can see that ImpressionSharePercent is listed compatible. Please assist. Thanks.

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.
386 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Feroj 1 Reputation point
    2021-04-14T08:56:17.843+00:00

    The combinations (both AdGroupName + ImpressionSharePercent and AdGroupStatus + ImpressionSharePercent) does not return any report url.

    The initial request for the report had

    <h:ReportRequest xsi:type="h:ProductPartitionPerformanceReportRequest"><h:ExcludeColumnHeaders>false</h:ExcludeColumnHeaders><h:ExcludeReportFooter>true</h:ExcludeReportFooter><h:ExcludeReportHeader>true</h:ExcludeReportHeader><h:Format>Csv</h:Format><h:Aggregation>Daily</h:Aggregation><h:ReturnOnlyCompleteData>false</h:ReturnOnlyCompleteData><h:Columns><h:ProductPartitionPerformanceReportColumn>ImpressionSharePercent</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>Clicks</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>Impressions</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>Spend</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>AdGroupCriterionId</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>CampaignName</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>PartitionType</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>ProductGroup</h:ProductPartitionPerformanceReportColumn><h:ProductPartitionPerformanceReportColumn>TimePeriod</h:ProductPartitionPerformanceReportColumn></h:Columns><h:Filter/><h:Scope><h:AccountIds><a:long>1223569</a:long></h:AccountIds></h:Scope><h:Time><h:CustomDateRangeEnd><h:Day>27</h:Day><h:Month>5</h:Month><h:Year>2020</h:Year></h:CustomDateRangeEnd><h:CustomDateRangeStart><h:Day>11</h:Day><h:Month>4</h:Month><h:Year>2020</h:Year></h:CustomDateRangeStart></h:Time></h:ReportRequest>  
    

    Which resulted in

    <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:TrackingId xmlns:h="https://bingads.microsoft.com/Reporting/v13">51504a60-1a6c-4f6f-9419-c02406a94b64</h:TrackingId></s:Header><s:Body><SubmitGenerateReportResponse xmlns="https://bingads.microsoft.com/Reporting/v13"><ReportRequestId>1581374020914</ReportRequestId></SubmitGenerateReportResponse></s:Body></s:Envelope>  
    

    Then making request for that report

    <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:TrackingId xmlns:h="https://bingads.microsoft.com/Reporting/v13">cbd63059-c818-4ad2-b9cd-eee2bf802b17</h:TrackingId></s:Header><s:Body><PollGenerateReportResponse xmlns="https://bingads.microsoft.com/Reporting/v13"><ReportRequestStatus xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><ReportDownloadUrl i:nil="true"/><Status>Success</Status></ReportRequestStatus></PollGenerateReportResponse></s:Body></s:Envelope>  
    

    Here there is no report url.

    @Eric Urban - MSFT these have the tracking id and report id.

    0 comments No comments