Data Studio
4.7K members online now
4.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data Studio - Custom Dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I would like to make a funnel on Data Studio; And I would like to create a formula to calculate the % of users that went from the first page to the second page;

 

Any tip on how to make this formula on Data Studio?

 

best

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Felipe P
July 2016

Re: Data Studio - Custom Dimension

Google Employee
# 4
Google Employee

Re: Data Studio - Custom Dimension

Google Employee
# 2
Google Employee
This can only be done if your GA data is first exported to BigQuery (which is a feature available for Premium properties only).

Re: Data Studio - Custom Dimension

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks Dimitris!

I used Google Spreadsheet and the analytics plugin; Then I get users of each step of the funnel by device (mobile, tablet and desktop), consolidate and make the formulas on other table and import to DataStudio; Inserted a rule to update every hour ;-)
Marked as Best Answer.
Solution
Accepted by topic author Felipe P
July 2016

Re: Data Studio - Custom Dimension

Google Employee
# 4
Google Employee
Sounds good.

Re: Data Studio - Custom Dimension

Follower ✭ ✭ ✭
# 5
Follower ✭ ✭ ✭

See this related post...

https://www.en.advertisercommunity.com/t5/Data-Studio-Reports/How-to-visualize-page-path-to-a-page/m...

 

You can do...

Chart1: ga:pagePath
Chart2: ga:secondPagePath

 

Or... a reverse funnel:

Chart1: ga:previousPagePath
Chart2: ga:exitPagePath

 

Or just group on:

ga:pageDepth

 

Thanks

 

Phil.

 

Note: If you have GA premium & BigQuery the timeStamp, URI and clientId/sessionId is exposed - so it`s possible to build the Funnel Query in BigQuery and then visualise in DataStudio.

Data Studio - Custom Dimension

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Hello,

 

I want to know how can I create a filtered metric,  in these case I need to do a variation metric to compare pageviews of this month versus last month or other time comparison.

 

Thank you..

Data Studio - Custom Dimension

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Hi Felipe,

 

I Need help on this. I have 4 columns and data not fixed, we have 20 brands those are will capture in 4 columns only. Respondent will give codes (1-20) randomly.

How can we show this data(Floating) into single column.

 

 

Sample Data

Data Studio - Custom Dimension

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

The way I currently do it is by creating (funnel) segments in GA and then load that segment over to GDS.