Here's How to Get Data from Microsoft Ads into Bionic for Agencies.
Integration with Microsoft Ads will enable you to automate the delivery of your performance data into Bionic.
Refer to Learn About Integrating Your Performance Data for the complete list of steps to complete your integration set up.
For all integrations, you will first need to Define Your Integration.
In this help article, we'll cover the steps on how to configure your Microsoft Ads Report in your Microsoft Ads account for integration with Bionic:
Notify Bionic Customer Support
Bionic Customer Support will need to create an email address for your reports to be delivered to.
Here is what we need to get the process started:
- In Microsoft Ads, find your Account Number. This will be the account number for your company's instance of Microsoft Ads, not a specific Client number.
- Send the Account Number via email to support@bionic-ads.com or your CSM.
- Bionic Customer Support will complete the set up of the email address and notify you. The email address will in a format similar to:
*******@marketing-performance-monitoring.com
Add User to Microsoft Ads
You are only able to email reports to users of Microsoft Ads, so you will need to set up a user for the email address we provided.
In Microsoft Ads:
- Add a user "Bionic Reports" using the email address you were provided.
- Notify Bionic Customer Support or your CSM that you have completed this process. While we will receive the invitation, we need to confirm it is from you.
From there we will complete the set up process they require to confirm this user. - You will be notified once this process is complete.
Set Up Microsoft Ads Report
Once you have received confirmation that the process has been completed, you can set up and schedule the report that will be sent to Bionic.
- In Microsoft Ads, create a report.
- Name the report clearly, such as Bionic Daily Performance Results.
- Add the following fields (only include KPIs you want to carry into Bionic):
- Date
- Campaign ID
- Campaign Name
- Spend
- Impressions
- Clicks
- Conversions
- Filter to Yesterday.
- Set Schedule to Daily at some time after midnight.
- Schedule to deliver to the email address provided by Bionic.
- Select .CSV as the format.
TIP: If you need to backfill data, you can send a one-time report that includes data from a date range that represents the time period you want to include.
Here is how data will map from Microsoft Ads to Bionic:
Microsoft Ads Field | Bionic Field | Notes |
Date |
Date |
Date of results |
Campaign ID | Source Campaign ID | Used for mapping to Source ID |
Campaign | -- | Used for mapping to Bionic Placement ID <BA:ID> |
Spend | Net Media Cost | See Net Media Cost Actuals Based on Cost Method |
Impressions | Impressions | |
Clicks | Clicks | |
Conversions | Conversions |