My name is Nicolò Grando and i’m a consultant at The PoriniInSight company .
I started out as an economist , graduated in Management at Bocconi I turned my passion for computers in a work combining economy and programming.
I deal with consulting and development of Business Intelligence solutions applied to Microsoft technology , starting from the analysis to the modeling .
The main technologies that use everyday are
- SQL Server since 2008 until the most recent version , with all its components , integration services , reporting services , analysis services .
- Excel since 2007 up to the latest version .
- Sharepoint 2010 up to the latest version but only as a front end for data sharing
- Datazen
- Power BI
Hey, Thanks for this article https://powerbloggerbi.com/2016/06/09/google-analytics-multiple-site-and-power-bi/
I researched quite a bit about merging multiple GA accounts and yours was the only one I found. However, I have had difficulty understanding your English but I managed to get going but it is failing at the last step.
When I run this query I get a window with Enter Parameters and three fields for id1, id2, id3.
let Multiple = (id1 as text,id2 as text,id3 as text)=>
let
Source = GoogleAnalytics.Accounts(),
#”9231159″ = Source{[Id=id1]}[Data],
#”UA-9231159-1″ = #”9231159″{[Id=id2]}[Data],
#”18579777″ = #”UA-9231159-1″{[Id=id3]}[Data],
#”Added Items” = Cube.Transform(#”18579777″, {{Cube.AddAndExpandDimensionColumn, “ga:exitPagePath”, {“ga:exitPagePath”}, {“Exit Page”}}, {Cube.AddAndExpandDimensionColumn, “ga:hostname”, {“ga:hostname”}, {“Hostname”}}, {Cube.AddAndExpandDimensionColumn, “ga:landingPagePath”, {“ga:landingPagePath”}, {“Landing Page”}}, {Cube.AddAndExpandDimensionColumn, “ga:pagePath”, {“ga:pagePath”}, {“Page”}}, {Cube.AddAndExpandDimensionColumn, “ga:pageDepth”, {“ga:pageDepth”}, {“Page Depth”}}, {Cube.AddMeasureColumn, “% Exit”, “ga:exitRate”}, {Cube.AddMeasureColumn, “Avg. Time on Page”, “ga:avgTimeOnPage”}, {Cube.AddMeasureColumn, “Entrances”, “ga:entrances”}, {Cube.AddMeasureColumn, “Entrances / Pageviews”, “ga:entranceRate”}, {Cube.AddMeasureColumn, “Exits”, “ga:exits”}, {Cube.AddMeasureColumn, “Page Value”, “ga:pageValue”}, {Cube.AddMeasureColumn, “Pages / Session”, “ga:pageviewsPerSession”}, {Cube.AddMeasureColumn, “Pageviews”, “ga:pageviews”}, {Cube.AddMeasureColumn, “Time on Page”, “ga:timeOnPage”}, {Cube.AddMeasureColumn, “Unique Pageviews”, “ga:uniquePageviews”}})
in
#”Added Items”
in
Multiple
When you have a couple of minutes can you respond with a note on what I should be checking to resolve this. Thanks a lot.
Mi piaceMi piace
Its correct, you have to use this script as a fuction of another power query table. In particular you have to create a custom column in the table where there is the list of your websiye. Have you got the table with the 3 ids for all your website?
Mi piaceMi piace