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.
416 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Team,
I see duplicates in the response:
Here is the request:
POST https://reporting.api.bingads.microsoft.com/Api/Advertiser/Reporting/V13/ReportingService.svc
<?xml version="1.0" encoding="utf-8"?>
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns0="https://bingads.microsoft.com/Reporting/v13"
xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns2="http://schemas.microsoft.com/2003/10/Serialization/Arrays"
xmlns:tns="https://bingads.microsoft.com/Reporting/v13"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Header>
<tns:AuthenticationToken>{{access_token}}</tns:AuthenticationToken>
<tns:CustomerAccountId>{{account_id}}</tns:CustomerAccountId>
<tns:CustomerId>{{customer_id}}</tns:CustomerId>
<tns:DeveloperToken>{{token}}</tns:DeveloperToken>
</SOAP-ENV:Header>
<ns1:Body>
<ns0:SubmitGenerateReportRequest>
<ns0:ReportRequest
xsi:type="ns0:UserLocationPerformanceReportRequest">
<ns0:Format>Csv</ns0:Format>
<ns0:ReportName>My
Campaign Summary Report</ns0:ReportName>
<ns0:ReturnOnlyCompleteData>false</ns0:ReturnOnlyCompleteData>
<ns0:Aggregation>Daily</ns0:Aggregation>
<ns0:Columns>
<ns0:UserLocationPerformanceReportColumn>AccountName</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>AccountNumber</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>AveragePosition</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>CampaignId</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>CampaignName</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>City</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>Clicks</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>Conversions</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>Country</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>Impressions</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>Revenue</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>Spend</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>State</ns0:UserLocationPerformanceReportColumn>
<ns0:UserLocationPerformanceReportColumn>TimePeriod</ns0:UserLocationPerformanceReportColumn>
</ns0:Columns>
<ns0:Filter>
<ns0:CountryCode/>
</ns0:Filter>
<ns0:Scope>
<ns0:AccountIds>
<ns2:long>{{account_id}}</ns2:long>
</ns0:AccountIds>
</ns0:Scope>
<ns0:Time>
<ns0:CustomDateRangeEnd>
<ns0:Day>02</ns0:Day>
<ns0:Month>08</ns0:Month>
<ns0:Year>2022</ns0:Year>
</ns0:CustomDateRangeEnd>
<ns0:CustomDateRangeStart>
<ns0:Day>02</ns0:Day>
<ns0:Month>08</ns0:Month>
<ns0:Year>2022</ns0:Year>
</ns0:CustomDateRangeStart>
</ns0:Time>
</ns0:ReportRequest>
</ns0:SubmitGenerateReportRequest>
</ns1:Body>
</SOAP-ENV:Envelope>
I've tried to add different dimensions from this list https://video2.skills-academy.com/en-us/advertising/reporting-service/userlocationperformancereportcolumn?view=bingads-13#assists , but there is no single dimension that will not change the granularity with different values. I haven't tried to add metrics.
Any idea why I've got duplicates?
Thanks!