Collecting data from Microsoft Ads

Follow this guide to collect data from Microsoft Ads and preview the data.

Introduction

This guide explains how to collect data from Microsoft Ads and preview the data.

This guide does not cover the whole functionality of the Microsoft Ads connector. For more information on all features of the Microsoft Ads connector, see Microsoft Ads connector reference.

For more information on the data fields that you can collect from Microsoft Ads, see List of supported fields.

Understanding datastreams and authorizations

When you connect to Microsoft Ads through Adverity, you authorize Adverity to access your account. Adverity stores this authorization information in an authorization, and stores the data collection configuration in a datastream.

You can create several datastreams using the same authorization. The datastreams collect information from the same source, with the same login credentials, with different configurations.

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 using Microsoft Ads

Connecting to Microsoft Ads

To connect to Microsoft Ads, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  2. In the top right corner, click + Create datastream.

  3. Search for and click Microsoft Ads.

  4. Choose one of the following options:

    • Click Setup a new authorization and set up the new authorization with your own login credentials.

    • Click Send an access request to ask someone else to set up the new authorization. In the Email field, enter the email address of the person you want to ask to authorize the new authorization.

    • If you already have an authorization to Microsoft Ads, choose an existing authorization.

  1. Click Next.

  1. In Set up or edit Ad Accounts, 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 Ad Accounts created in the future.

  1. Click Next.

Choosing what data to collect

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

  1. Click Custom configuration.

  1. Click Next.

  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.

  1. Click Next.

Choosing where to transfer your data

To choose where to transfer your data, follow these steps:

  1. To assign destinations to your datastream, select their checkboxes. For more information on destinations and their configuration settings, see Introduction to transferring data.

  1. Click Next.

Collecting initial data

To collect the initial data, follow these steps:

  1. Choose the time period for which data is collected.

  1. Click Run fetch.

Previewing data collected from Microsoft Ads

The fetch collects data from Microsoft Ads which takes some time. The Overview page of the newly created datastream is now displayed. To preview the collected data, follow these steps:

  1. In the All tasks tab, find the task at the top of the list, and click Show extracts.

  2. Click the top hyperlink.

  3. The data extract is displayed in a table containing the data that you have fetched.

What’s next?

After collecting data from Microsoft Ads, harmonize your data so that it conforms with Adverity's unified naming and formatting conventions.