looking for alternative to Biq Query, yep me too, so I built a connector for the new API.
So, I started working in GA4 earnestly mid last year. The first bit was easy, getting data into GA4, the latter bit of getting data back out and in to a place I could swing it around in a way I was comfortable was going to take some more work.
Options
If you are a user of Power BI or equivalent you may have felt this same pain. They don’t have native API connectors yet, so our choices were limited to using BigQuery, a paid connector solution (nope!) or rolling our own data connector. With a lot of help from my coding buddies I’ve chosen the latter as I want to be a bit more flexibility with my queries.
I’ve decided to go it myself for now and build my own custom connector for Power BI. You are welcome you to join me in giving it a go. It’s not a perfect solution, it won’t currently refresh via PBI online without modification for example but, as a stop gap, it’s ok. It’s also totally without warranty, support or liability 😉
Saying that, take it slowly, read the instructions first. I won’t be held responsible if it goes wrong but I will try to support you to get it working where I can.
How You Get It Working
I’m splitting this across a few posts as there are a few things to care off.
- Setup the connector
- our first query
- sorting results, metric and dimension filters
- using filters with logic operators
Also the API is capable of doing a couple of neat things, such as pivot charts and funnels. let me know in the comments or via twitter which you would like me to add first.
If you have already done the setup and are just looking for the setup file it’s here
If you want to help contribute or review the code the GitHub is here
Github.com/GavinBrogan/GA4PowerBIConnector

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
photo credit Graeme Brogan