question

Feroj-1509 avatar image
0 Votes"
Feroj-1509 asked Feroj-1509 commented

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

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://docs.microsoft.com/en-us/advertising/reporting-service/adgroupperformancereportcolumn?view=bingads-13 We can see that ImpressionSharePercent is listed compatible. Please assist. Thanks.

advertising-api
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

To clarify do either of these combinations work for you, or does ImpressionSharePercent always need to be requested without ad group name / status?
- AdGroupName + ImpressionSharePercent
- AdGroupStatus + ImpressionSharePercent

Some column combinations are not supported, although I don't see ad group name / status listed.

If you still observe this issue please send the latest tracking ID + timestamp and we can review it. The SOAP request message with all requested columns is also helpful.

Thanks


0 Votes 0 ·

@EricUrban-MSFT had to post it as an answer since comment ran out of characters. Please take a look

0 Votes 0 ·

1 Answer

Feroj-1509 avatar image
0 Votes"
Feroj-1509 answered Feroj-1509 published

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.

@EricUrban-MSFT these have the tracking id and report id.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.