Service Account API Access Not Returning Report Data

[Gonzalo Oyarce]

We are attempting to retrieve report information via API access using Service Accounts. Despite our assigned Service Account Role having all permissions enabled within the Role tab, our report queries return no data.

However, when we use a regular user account's access token for the same query, we receive the expected data.

Please help us determine what access permissions our Service Account is missing to access the data in this report.

The query we are using, and report id that returned no data:

ReportJob{

    id=15443366644,
    ReportQuery{
        adUnitView=TOP_LEVEL,
        columns=[
            AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE,
            AD_EXCHANGE_LINE_ITEM_LEVEL_IMPRESSIONS,
            AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS],
        dimensionAttributes=[
            LINE_ITEM_CURRENCY_CODE,
            LINE_ITEM_COST_TYPE
            ],
        dimensions=[
            CLASSIFIED_ADVERTISER_NAME,
            CREATIVE_SIZE_DELIVERED,
            AD_UNIT_ID,
            CLASSIFIED_ADVERTISER_ID,
            PROGRAMMATIC_CHANNEL_NAME,
            AD_UNIT_NAME,
            MONTH_AND_YEAR,
            LINE_ITEM_ID
            ],
        endDate=
            Date{day=4, month=1, year=2025},
        startDate=
            Date{day=31, month=12, year=2024},
        statement=
            Statement{query=
                WHERE PROGRAMMATIC_CHANNEL_NAME IN ('Private Auction', 'Open Auction', 'Preferred Deal')
            },
        timeZoneType=PUBLISHER
    }
}

[Ad Manager API Forum Advisor]

Hi,

Thank you for contacting the Ad Manager API support team.

To analyze the issue further, could you please provide the following information for further analysis.

• Complete SOAP request (SOAP logging must be enabled) from API for both users.
• Network Code.
• Downloaded API report for both users. 
• UserService.getCurrentUser for both the regular user account, and also the service account(if unable, you may just provide the email address used to make API requests).

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vH1d8:ref" (ADR-00288147)

Thanks,
 

Ad Manager API Team

Feedback
How was our support today?