Datasource Migration Guide

This page is currently in-progress.

Overview

Microsoft Ads (Bing)

In ADL 2.0, Microsoft Ads (Bing) datasources will be enhanced to incorporate a broader array of dimensions and metrics while leveraging the recently resolved Index Exceptions.

Creating your Microsoft Ads datasources using Alli Marketplace

1. Navigate to My Apps -> Browse and search for the Alli Data Library 2.0 - Onboard Platform app

2. Install the app, and select Microsoft Ads you intend to onboard:

3. Copy and paste your Alli email and user id into the corresponding fields (see your Alli user profile for the info)

4. Select Save & Run to execute the app. This will build the necessary datasources for Microsoft Ads

5. When finished, validate that your datasources were successfully created by checking the output, e.g.:

   NONE

   ------------------------------------------------------------------------------------------------------------------------
   CREATING DATASOURCES
   ------------------------------------------------------------------------------------------------------------------------
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_ad.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_ad', 'id': '650332661d39550007a29d82', 'link': 'https://data.alliplatform.com/datasource/650332661d39550007a29d82/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_adgroup.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_adgroup', 'id': '65033267dd975100076075ef', 'link': 'https://data.alliplatform.com/datasource/65033267dd975100076075ef/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_audience.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_audience', 'id': '65033265dd975100076075ee', 'link': 'https://data.alliplatform.com/datasource/65033265dd975100076075ee/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_campaign.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_campaign', 'id': '6509d6e3a1070700063578da', 'link': 'https://data.alliplatform.com/datasource/6509d6e3a1070700063578da/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_keyword.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_keyword', 'id': '65033268dd975100076075f0', 'link': 'https://data.alliplatform.com/datasource/65033268dd975100076075f0/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_productpartition.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_productpartition', 'id': '650332666f07fa000759c896', 'link': 'https://data.alliplatform.com/datasource/650332666f07fa000759c896/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_insights_searchquery.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_insights_searchquery', 'id': '650332641d39550007a29d81', 'link': 'https://data.alliplatform.com/datasource/650332641d39550007a29d81/bing'}
   {'configFile': '/code/cli/sub_commands/config/data/datasources/search_microsoftads_settings_campaign.json', 'success': True, 'client_id': '553e88bd0bad40a62d4cdbeb', 'name': 'microsoftads_settings_campaign', 'id': '650332659878250007bf45fb', 'link': 'https://data.alliplatform.com/datasource/650332659878250007bf45fb/bingStructure'}

Each line item corresponds to a datasource created by the app. Take note of the following three key-value pairs for each datasource:

• name - the name of the datasource created

• success - returns True if datasource was successfully created (if False, datasource likely already exists for the customer)

• link - the URL of the created datasource in Alli Data

Authenticating your Microsoft Ads datasources in Alli Data

1. Navigate to your newly created datasource(s) by either (1) visiting the URL value(s) from the link key, OR (2) following:How to find your Data Library datasources in Alli Data

2. Authenticate the datasource(s) accordingly and log an issue within the Alli Service Desk if you have any issues.

(Optional) Creating child datasources to pull data from multiple ad accounts

This step is optional and only applies IF:

1. You need to pull data from multiple ad accounts

2. The datasource does not allow for selecting multiple accounts under the Additional Configuration Needed tab

1. In the datasource Audit page, select Duplicate to create a duplicate of your datasource. This should take you to the newly duplicated datasource.

2. Under the Advanced Settings tab:

• Select the parent datasource in the Data Location dropdown. This ensures that the data loads into the same table.

• Change the name of the datasource to follow the same format of the parent, e.g.:, dv360_insights_ad → dv360_insights_ad_1

3. Update the Required Authorization and Additional Configuration Needed tabs as needed

4. Save the datasource and backfill as needed