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

Funnel Visualization - Sorting Issue

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

To replicate the funnel visualization of GA I have set up a horizontal bar chart in Data Studio.

The funnel has a total of 10 steps which correlate to a screen name (it's a dashboard for a mobile app)

 

The way I have it set up currently;

Data Source = Analytics

Dimension = Custom Dimension with Case Formula to rename funnel steps (see below)

Metric = Unique Screen Views

Bar Chart Filter = Funnel Steps

 

The Bar Chart Filter has each funnel step configured in the following way (using the OR statement in between)

include Screen Name equal to (=) CarMyDetails

 

The Custom Dimension has the following CASE formula to rename the funnel steps

 

 

 

 

 

CASE

WHEN REGEXP_MATCH(Screen Name, ".*CarMyDetails.*") THEN "Step 1: Details"

WHEN REGEXP_MATCH(Screen Name, ".*CarMyVehicle.*") THEN "Step 2: Vehicle"

WHEN REGEXP_MATCH(Screen Name, ".*CarDamageFree.*") THEN "Step 3: Damage Free"

WHEN REGEXP_MATCH(Screen Name, ".*CarMileage.*") THEN "Step 4: Mileage"

WHEN REGEXP_MATCH(Screen Name, ".*CarLoan.*") THEN "Step 5: Loan"

WHEN REGEXP_MATCH(Screen Name, ".*CarRiskTaking.*") THEN "Step 6: Risk Taking"

WHEN REGEXP_MATCH(Screen Name, ".*CarCoverage.*") THEN "Step 7: Coverage"

WHEN REGEXP_MATCH(Screen Name, ".*CarOwnRisk.*") THEN "Step 8: Own Risk"

WHEN REGEXP_MATCH(Screen Name, ".*CarFinalResults.*") THEN "Step 9: Final Results"

WHEN REGEXP_MATCH(Screen Name, ".*CarFinalResultsApply.*") THEN "Step 10: Final Results Apply"

END

 

No clue where it's going wrong but it's currently not showing step 10 at all while there are screen views for this step recorded in Analytics. Perhaps I should be using a different RegEx for the last step?

 

Or is there another setup I could use to show the funnel steps in the right order?