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.

Introduction

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

Prerequisites

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}.datatap.adverity.com/.

  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 items, including those created in the future to give Adverity Ad Accounts to access all existing items and all items created in the future.

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

   If you use your credentials to grant Adverity access to Microsoft Ads, all the items 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 items 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 authorization items. 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.

2. 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.

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

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

What's next?

• Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.

• Transform your data to meet your needs by creating and applying transformations to your datastream.

• Load your data into Explore & Present to visualize your data in Adverity

• Load your data into an external destination of your choice

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:

Aggregation

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.

Entities

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