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

How to calculate CTR from Page 1 to Page 2

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I want to be able to show in a "scorecard" widget the CTR from one page to another. So if I have 100 users on Page 1 and 50 "users" on Page 2, the scorecard should show 50%.

 

I have a landing page and I want to see how many people are going to the next page and have it display in percentage on my report.

 

You know like simple mathematics. I am sure everyone needs to see this data one way or the other. 

 

So I figured I could use a calculated field like

CASE WHEN PAGE="MYPAGENAME" THEN SUM(USERS) ELSE 0 END

 

But it does not allow to use dimensions and metrics in the same condition. (page being a dimension and users being a metric)

 

What is workaround my friends? 

 

Thanks in advance.

1 Expert replyverified_user

How to calculate CTR from Page 1 to Page 2

Top Contributor
# 2
Top Contributor

Just create a goal with page 2 as destination and page 1 as the first step in your funnel.

Then add your conversion rate as your scorecard widget.

 

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Re: How to calculate CTR from Page 1 to Page 2

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks for your response!

Yes, I figured that way but just wanted to know how to achieve this without
setting up the goals bcz setting goals will not work on historical data.

Appreciate your response.

Shadab