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

Visitor loyalty metric question

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Under the Frequency and Recency report, I can see how many sessions/pageviews once a month, twice a month, etc. But is there a way I can calculate the percentage of total visitors that view 1,2,3, etc pages per month?

Re: Visitor loyalty metric question

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
a) You could add a Pie chart using Frequency and Recency report as a data source.

Or b) using a Table, sort Decending by Frequency, and then Recency & tick the box to "show bars" in the table

Or c) use a calculated metric
https://www.youtube.com/watch?v=dOMC3ArtTyU&list=PLFwbZ-mNsefWTL5EFcbmXCvPizGew9Jed&index=6

Calculated metric can also incudLe functions which work the same as countif() in excel...
CASE
WHEN Pageviews >= 3 THEN "SuperEngaged"
WHEN (Pageviews <= 2 AND Pageviews < 3) THEN "Engaged"
ELSE "Not Engaged"
END
https://support.google.com/360suite/datastudio/answer/6299685?hl=en&ref_topic=6370331#create_a_calcu...
https://support.google.com/360suite/datastudio/answer/7020724?hl=en

Thanks

Phil.