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.
Import from Scratch with Microsoft Ads
Schedule your Import, Snapshots, and Add Automations
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/Excel using Coefficient.
|
1. Open the Coefficient Sidebar and click the Menu. |
2. Select “Connected Sources”. |
3. Select “Add Connection” at the bottom and then “Connect” to Microsoft Ads. |
|
4. “Authorize” the connection. |
5. Sign in to your Microsoft Ads account. You will be redirected back to Google Sheets once the connection is established. |
Import from Scratch with Microsoft Ads
|
1. From the Coefficient Sidebar, select “Import from…”. |
2. Choose “Microsoft Ads” from the list. |
3. Select “Start from scratch.” |
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.
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. 6. 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.
7. 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”
8. Congratulations on your first Microsoft Ads import with Coefficient! 🙌🏼
Schedule your Import, Snapshots, and Add Automations
Once you have pulled your data into spreadsheets using Coefficient, you can set up the following:
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 review the suggested dimensions to add or update, then try your import again.