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

How do I create a table to show ONLY referral traffic in Data Studio?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to create a table that just lists the top referral sites and the number of sessions that came from the referrals (the table found here on Google Analytics: Acquisition-> All Traffic -> Referrals). I tried excluding organic and direct traffic, but had no luck. I also tried downloading the data into Google Sheets and uploading from there, but the data won't populate correctly. Does anyone have tips on how to get this done?

Re: How do I create a table to show ONLY referral traffic in Data Studio?

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi,

 

create a table with "source" as dimension and "sessions" as metric

 

then at the bottom, add a filter with:

dimension: medium

equal to (=)

expression: referral

 

table.JPG

 

sorry the image is in french, but thats just to show you where to change the data

 

tell me if it's what you wanted

How do I create a table to show ONLY referral traffic in Data Studio?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks! Exactly what I´ve been looking for. Worked like a charm!