-
What’s the most cost-effective way to blend more than 5 Google Ads data sources on the same report in Google Data Studio?
I manage a lot of short-term Google Ads campaigns that run 2-3 weeks and then turn off. On any given week, I might have 5-10 campaigns that are active from a pool of over 35 different accounts.
While I report on each campaign individually, I’d also like to create a single report in Data Studio that shows a summary of all currently running campaigns. This not only helps me track budgets, it’s also a nice way to see overall performance in views that I can’t easily get directly in Google Ads.
The problem is I don’t think I can blend more than 5 data sources at once without using a 3rd party connector. Supermetrics is the one I’m most familiar with, but for my specific needs I’d be in a $299 a month package — unless I was willing to manually turn my data sources on and off as needed.
Since that’s way too expensive for my needs, and I’m not looking forward to constantly toggling data sources on and off, I thought I’d reach out to see if there were any alternatives. Again I don’t need to mix data from different sources, which is what I normally use third party connectors for, I just need to be able to blend a lot of Google Ads data together onto a single report.
-
2 Replies
-
Get all your Google ads data into Google Sheets. Blend them there and connect sheets to data studio. Look into Supermetrics for google sheets or alternative options.
-
Have a look at [KPIBees](https://kpibees.com/) to pull your data to google sheets as an affordable alternative. Then you can connect google data studio to that spreadsheet.
Log in to reply.