Microsoft Ads

Section header image mobile

Explore the potential of data-driven advertising with Coefficient's integration for Microsoft Ads. Connect your Microsoft Ads account for seamless data imports - empowering your advertising strategies with detailed insights and analytics.

Connecting to Microsoft Ads

Import from Scratch with Microsoft Ads

Schedule your Import, Snapshots, and Add Automations

FAQs for Microsoft Ads

Connecting to Microsoft Ads

When you begin a Microsoft Ads import for the first time, you will need to follow a few steps to connect your account to Coefficient before you can import data from Microsoft Ads to Google Sheets using Coefficient.

1. Open the Coefficient Sidebar and click the Menu.

Menu_Icon (1).png

2. Select “Connected Sources”. 

Screenshot 2023-10-10 at 5.18.29 AM.png

3. Select “Add Connection” at the bottom and then “Connect” to Microsoft Ads.

Screenshot 2024-03-07 at 5.30.55 AM.png

4. “Authorize” the connection.

Screenshot 2024-03-07 at 5.31.25 AM.png

5. Sign in to your Microsoft Ads account. You will be redirected back to Google Sheets once the connection is established.

Screenshot 2024-03-07 at 5.32.27 AM.png

Import from Scratch with Microsoft Ads

1. From the Coefficient Sidebar, select “Import from…”.

ImportFrom (1).png

2. Choose “Microsoft Ads” from the list.

Screenshot 2024-03-07 at 5.55.27 AM.png

3. Select “Start from scratch.”

Screenshot 2024-03-07 at 5.57.03 AM.png

4. Select your Microsoft Ads account from the “Import Preview” window. Select “Next”.

ℹ️ NOTE: This screen will only appear if you have multiple accounts to select from - if you do not have multiple accounts, you will not see this screen - you can proceed to step 5 below.Screenshot 2024-03-07 at 6.15.44 AM.png

5. Select a report from those listed. (example: ”Campaign Performance”). Popular reports are displayed at the top, but you can scroll down to find Other reports. Screenshot 2024-03-07 at 6.16.48 AM.png6. Select fields for the Metrics, Dimensions, and Time Granularity needed for your import. Click inside the white box area for each section to search for the fields you need. The data previewer shows a sample of the data from the fields you select.  Screenshot 2024-03-07 at 6.20.07 AM.png7. Customize your import by adding filters and adjusting the data range. Click the “Refresh Preview” option to update the sample data based on the customizations that have been added. Then “Import”Screenshot 2024-03-07 at 6.23.46 AM.png8. Congratulations on your first Microsoft Ads import with Coefficient! 🙌🏼Screenshot 2024-03-07 at 6.27.15 AM.png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into Sheets using Coefficient, you can set up the following:

1. Schedule your Importa.png

2. Turn on Snapshotsb.png

3. Set Up Automations


FAQs for Microsoft Ads

My import shows a 'Mandatory dimensions missing' error on my import. What can I do?

Due to Microsoft's API limitations, you may see this error when combining metrics and dimensions for your import. If this error appears, please check the suggestions for the dimensions to add, update, and try your import again. MS Ads.png


Was this article helpful? 0 out of 0 found this helpful