Collecting data from Microsoft Ads

This guide explains how to collect data from Microsoft Ads. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.


For a list of the fields that you can collect from Microsoft Ads, see Microsoft Ads.

  • Microsoft Ads can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.


Before you start collecting data from Microsoft Ads, perform all of the following actions:

  • You can authenticate the authorization to a Microsoft Ads account using Microsoft's work account authentication. If you choose this authentication method, your company's Azure Active Directory admin must first grant Adverity access. Invite the Azure Active Directory admin to the Microsoft Ads account to grant the relevant permissions.

    When granting permissions, Azure Active Directory admins can select the Grant permissions on behalf of your organization checkbox. If selected, all Microsoft Ads users within their domain can then grant access to Adverity without admin intervention.

    For more information on work accounts and Azure Active Directory admin permissions, see the Microsoft documentation.

  • Register your application to access the Microsoft Ads API with Adverity and set Redirect URI to https://{YOUR_INSTANCE}

    For more information and detailed instructions, see the Microsoft documentation.

Creating a datastream to collect data from Microsoft Ads

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Microsoft Ads.

Authorization: Allow Adverity to access Microsoft Ads

  1. If you choose Access using your credentials or Access using someone else's credentials, in Set up or edit Ad Accounts, you or the person granting access must choose one of the following options:

    • Choose Grant access to all Ad Accounts, including those created in the future to allow Adverity to access all existing Ad Accounts and all Ad Accounts created in the future.

    • Choose Select specific Ad Accounts to which you want to grant access to determine the specific Ad Accounts that you want Adverity to access. Adverity will not automatically have access to Ad Accounts created in the future. You will need to grant Adverity access to any Ad Accounts created in the future.

    If you use your credentials to grant Adverity access to Microsoft Ads, all the Ad Accounts available to you using your credentials will be visible in the Authorizations page to all Adverity users with permission to edit this authorization.

    If someone else uses their credentials to grant Adverity access to Microsoft Ads, the same applies to the Ad Accounts available using their credentials.

    This is important to consider if you do not want all Adverity users with permission to edit the authorization to be able to see the details of the Ad Accounts. For more information about user permissions, see Managing user permissions.

Configuration: Choose the data you want to collect from Microsoft Ads

To choose what data to collect and customize the Microsoft Ads datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Accounts, select the accounts for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.

  1. In Report type, select the type of data to collect from Microsoft Ads.

  1. In Columns, change the list of fields that you want to see in your data extract. Select at least one performance statistic.

For information on configuring other Microsoft Ads fields, see Advanced Microsoft Ads tips.

What's next?

Advanced Microsoft Ads tips

Configuring data collection from Microsoft Ads

In the Settings tab of your Microsoft Ads datastream overview, you can configure a number of additional settings:


Select the time interval in which to aggregate the collected data.

Include empty rows

Select this checkbox to collect rows where all metric values are zero or empty.


For the Bulk report report type, select entities for which you want to collect data.