Bing API. Duplicates in UserLocationPerformanceReportRequest

Daniyar Urazov 0 Reputation points
2023-07-19T09:39:32.0166667+00:00

Hi Team,

I see duplicates in the response:User's image

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!

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.
416 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.