Forum Discussion

StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
7 years ago

Google Analytics filter by date with connector

This GA connector looks a bit basic.

 

How would you filter on date with it - it seems to pull all the data it can at the moment.

 

Im looking to pull the last 28 days data aggregated so it can count unique users. So i need to filter by date without including the date field as a column.

 

Is there a manual line or two I can add to to the query?

 

Here is my expression i want to date bound on import.

 

= Cube.Transform(#"105237604",
        {
            {Cube.AddAndExpandDimensionColumn, "ga:userAgeBracket", {"ga:userAgeBracket"}, {"Age"}},
            {Cube.AddAndExpandDimensionColumn, "ga:userGender", {"ga:userGender"}, {"Gender"}},
            {Cube.AddAndExpandDimensionColumn, "ga:pagePathLevel1", {"ga:pagePathLevel1"}, {"Page path level 1"}},
            {Cube.AddMeasureColumn, "Users", "ga:users"}
        })

 

 

4 Replies