Forum Discussion

andrea_chiappo's avatar
andrea_chiappo
Helper III
6 years ago

parameterise data extraction from Google Analytics

I have access to Google Analytics data of a website (obtained through tagging imposed by the website's developer).  Here I have a access to several sections of the "property".   In my case I am in...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi andrea_chiappo 

Firstly, connect to the data source and open the advanced editor, you would get codes as below:

let
        Source = GoogleAnalytics.Accounts(),
        #"11223344" = Source{[Id="11223344"]}[Data],
        #"UA-11223344-2" = #"11223344"{[Id=UA-11223344-2]}[Data],
        #"556677889" = #"UA-11223344-2"{[Id="556677889"]}[Data],
        #"Added Items" = Cube.Transform(#"556677889",

Change it to the following:

let
        Source = GoogleAnalytics.Accounts(),
        step1 = Source{[Id="11223344"]}[Data],
        step2= step1{[Id=parameter1]}[Data],
        step3 = step2{[Id=parameter2]}[Data],
        #"Added Items" = Cube.Transform(step3,

meanwhile, create two parameter:

parameter1, parameter2

 

Best Regards

Maggie

andrea_chiappo's avatar
andrea_chiappo
Helper III
6 years ago

I tried this but it didn't work