Forum Discussion
Anonymous
5 years agoNot applicable
Combining multiple Google Analytics Queries give different results
Hi, I'm fairly new to PowerBI. I am trying to create a dashboard based on Google Analytics data through the GA API. For my report I need more than 10 metrics. I quickly noticed that the limit is ...
Anonymous
5 years agoNot applicable
Query 1:
let
Source = GoogleAnalytics.Accounts(),
#"X" = Source{[Id="X"]}[Data],
#"UA-X-1" = #"X"{[Id="UA-X-1"]}[Data],
#"X" = #"UA-X-1"{[Id="x"]}[Data],
#"Added Items" = Cube.Transform(#"X",
{
{Cube.AddAndExpandDimensionColumn, "ga:userAgeBracket", {"ga:userAgeBracket"}, {"Age"}},
{Cube.AddAndExpandDimensionColumn, "ga:userGender", {"ga:userGender"}, {"Gender"}},
{Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}},
{Cube.AddAndExpandDimensionColumn, "ga:deviceCategory", {"ga:deviceCategory"}, {"Device Category"}},
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:campaign", {"ga:campaign"}, {"Campaign"}},
{Cube.AddAndExpandDimensionColumn, "ga:sourceMedium", {"ga:sourceMedium"}, {"Source / Medium"}},
{Cube.AddMeasureColumn, "Avg. Time on Page", "ga:avgTimeOnPage"},
{Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"}
}),
#"Collapsed and Removed Columns" = Cube.CollapseAndRemoveColumns(#"Added Items", {"Age"}),
#"Added Items1" = Cube.Transform(#"Collapsed and Removed Columns",
{
{Cube.AddMeasureColumn, "Sessions", "ga:sessions"}
}),
#"Inserted Merged Column" = Table.AddColumn(#"Added Items1", "Date/Campaign", each Text.Combine({Text.From([Date], "nl-NL"), [Campaign]}, "/"), type text),
#"Counted Rows" = Table.RowCount(#"Inserted Merged Column")
in
#"Counted Rows"
Query 2:
let
Source = GoogleAnalytics.Accounts(),
#"X" = Source{[Id="X"]}[Data],
#"UA-X-1" = #"X"{[Id="UA-X-1"]}[Data],
#"X" = #"UA-X-1"{[Id="X"]}[Data],
#"Added Items" = Cube.Transform(#"X",
{
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:campaign", {"ga:campaign"}, {"Campaign"}},
{Cube.AddAndExpandDimensionColumn, "ga:sourceMedium", {"ga:sourceMedium"}, {"Source / Medium"}},
{Cube.AddMeasureColumn, "New Users", "ga:newUsers"},
{Cube.AddMeasureColumn, "Users", "ga:users"}
}),
#"Added Items1" = Cube.Transform(#"Added Items",
{
{Cube.AddMeasureColumn, "Sessions", "ga:sessions"}
}),
#"Inserted Merged Column" = Table.AddColumn(#"Added Items1", "Date/Campaign", each Text.Combine({[Campaign], Text.From([Date], "nl-NL")}, "/"), type text),
#"Counted Rows" = Table.RowCount(#"Inserted Merged Column")
in
#"Counted Rows"
Now I see that I add several dimensions later, could this be problematic?
v-jingzhang
Community Support
5 years agoHi Anonymous , that may be. If you count rows after the #"X" step, will they return the same result?