Den nye version af Google Analytics API er nu frigivet.
Den nye version af Google Analytics API er nu frigivet.
Google Analytics Reporting API V4 er den mest avancerede programmatisk metode til at få adgang til rapportdata i Google Analytics. Med Google Analytics Reporting API kan du:
* Byg brugerdefinerede dashboards at vise Google Analytics-data.
* Spar tid ved at automatisere komplekse rapportering.
* Integrer dine Google Analytics-data med andre forretningsapplikationer.
https://developers.google.com/analytics/devguides/reporting/core/v4/
“Integrer dine Google Analytics-data med andre forretningsapplikationer”. Hmmm interessant.
Jeg leder pt. efter en god metode til, at hive daglige data ud og ind i Excel. Måske jeg skulle kigge lidt på API’et, i stedet for alle mulige plugins?
“Integrer dine Google Analytics-data med andre forretningsapplikationer”. Hmmm interessant.
Jeg leder pt. efter en god metode til, at hive daglige data ud og ind i Excel. Måske jeg skulle kigge lidt på API’et, i stedet for alle mulige plugins?
Someone made a plugin for excel it its third party though. The google Analytics team has one for App script that dumps it into Google Sheets. I have a custom connection manager SSIS. There are loads of ways to get data out Let me know if you need any help.
Someone made a plugin for excel it its third party though. The google Analytics team has one for App script that dumps it into Google Sheets. I have a custom connection manager SSIS. There are loads of ways to get data out Let me know if you need any help.
There’s a ton of third party Excel plugins out there. But they’re either too expensive for me, or way too simple.
The Custom Connection Manager sounds interesting. That way I can query the API with SQL I guess?
Got any details on it? Is it something you made yourself, or?
There’s a ton of third party Excel plugins out there. But they’re either too expensive for me, or way too simple.
The Custom Connection Manager sounds interesting. That way I can query the API with SQL I guess?
Got any details on it? Is it something you made yourself, or?
Uuuh! I can Google stuff myself! (doh)
http://www.targit.com/en/resources/store/datareaderforgoogleanalytics
Uuuh! I can Google stuff myself! (doh)
http://www.targit.com/en/resources/store/datareaderforgoogleanalytics
LOL yup that’s it. The task is free to use you dont have to buy a TARGIT licence. Its technically unsupported but if you have a problem you know where to find me. Currently supports v3 API we are going to wait a little while before we add v4 support want to give the API time to stablise.
LOL yup that’s it. The task is free to use you dont have to buy a TARGIT licence. Its technically unsupported but if you have a problem you know where to find me. Currently supports v3 API we are going to wait a little while before we add v4 support want to give the API time to stablise.
Sweet!
Now I just need to figure out how to run it on a local SQL Express… 😉
Sweet!
Now I just need to figure out how to run it on a local SQL Express… 😉
SQL server express doesn’t support SSIS (if memory serves). Here is a console application that just downloads everything as CSV files. http://www.daimto.com/tools/google-analytics-get/ I made it a while ago mostly for my own testing you are welcome to play with it as well.
SQL server express doesn’t support SSIS (if memory serves). Here is a console application that just downloads everything as CSV files. http://www.daimto.com/tools/google-analytics-get/ I made it a while ago mostly for my own testing you are welcome to play with it as well.
I really need to find time to make a free excel plugin. I dont mind people making money off of stuff but seriously they charge to much sometimes.
I really need to find time to make a free excel plugin. I dont mind people making money off of stuff but seriously they charge to much sometimes.
How about an ODBC driver? Doesn’t people use those anymore (it’s 10+ years sine I worked in that world)? Would make you able to query Analytics from all kinds of Windows programs.
How about an ODBC driver? Doesn’t people use those anymore (it’s 10+ years sine I worked in that world)? Would make you able to query Analytics from all kinds of Windows programs.
Google Analytics api is a Rest api which means all of the data goes over HTTP. its basically just http gets (V3) posts (v4) so no i dont think odbc will help you here. Technically you can do it in any programming language that supports HTTP posts and gets. Google has client libraries for most of the more common langues for windows i use C# to access it.
Google Analytics api is a Rest api which means all of the data goes over HTTP. its basically just http gets (V3) posts (v4) so no i dont think odbc will help you here. Technically you can do it in any programming language that supports HTTP posts and gets. Google has client libraries for most of the more common langues for windows i use C# to access it.