“Is there a (free) way to fetch the Microsoft Advertising data to Google sheets?”
Many of us use (paid for) sheet plugins like Supermetrics to automatically pull data from different platforms in Google Sheets.
Another option might be to test some free alternatives like Advronix (Note: I’ve not tested this myself, so I don’t know the ins and outs).
BUT, you can also easily create a Microsoft/Bing Ads Script to push campaign stats to a Google Spreadsheet.
Here’s how it works:
1. Get your authentication credentials for accessing Google services uch as Google Drive, Sheets, and Email via the API
See instructions: https://learn.microsoft.com/en-us/advertising/scripts/examples/authenticating-with-google-services
(I recommend option 2 or 3 to get your refresh token)
2. Create a script to fetch your Bing Ads data from the Bing Ads API and send the data to Google Sheets.
See instructions: https://learn.microsoft.com/en-us/advertising/scripts/examples/calling-google-services
These are two freely available scripts that show you exactly how to do this:
Report Bing Ads last_week’s campaign cost in Google Sheet:
https://gist.github.com/tbrzica/bec52b8a17fa05988af414e712676b31
Create a Google Sheet report containing yesterday’s Impressions, Clicks, Cost and Conversions for your Bing Ads campaigns:
https://gist.github.com/krsoninikhil/30f5b0339c3c7f35645dff1713674473
Happy scripting!
Join thousands of PPC geeks who already have access:
If the button above isn’t working for you, you can sign up here to get access.