Funnel Creation

Load the ggplot2 and plotly packages

library(ggplot2)
library(plotly)
## 
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout

Create a data frame for the funnel steps

# Create a data frame for the funnel steps
funnel_data <- data.frame(
  Step = factor(
    c("Search/Land on question page", "Login", "Register", "Confirm", "Subscribe Page", "Actual Subscribers"),
    levels = c("Search/Land on question page", "Login", "Register", "Confirm", "Subscribe Page", "Actual Subscribers")
  ),
  Users = c(4000, 3690, 280, 133, 110, 1)
)

Create the funnel plot using plotly

fig <- plot_ly(funnel_data, type = "funnel", y = ~Step, x = ~Users) %>%
  layout(title = "User Conversion Funnel")

Convert ggplot2 object to plotly object

fig

Summary

Based on the funnel data provided for MathsGee, here is a summary of the performance:

Search/Land on Question Page (4000 users): This is the top of the funnel and represents the total number of users who land on a question page. This is a good number, indicating that the platform is attracting a significant amount of traffic.

Login (3690 users): Out of 4000 users who land on the question page, 3690 proceed to log in. This is a very high conversion rate of approximately 92.25%, which suggests that the majority of visitors are engaged enough to take the next step.

Register (280 users): The number drops significantly here, with only 280 users registering. This represents a conversion rate of approximately 7.6% from the users who logged in. This could be an area that needs attention, as the drop is quite significant.

Confirm (133 users): Out of the 280 who register, 133 confirm their registration. This is a conversion rate of approximately 47.5%, which is less than half of the users who registered. This suggests that many users are not completing the registration process, which could be a point of concern.

Subscribe Page (110 users): 110 users proceed to the subscribe page, which is a conversion rate of approximately 82.7% from those who confirmed. This is a strong rate, indicating that most users who confirm their registration are interested in subscribing.

Actual Subscribers (1 user): Finally, only 1 user becomes an actual subscriber. This is a drastic drop and represents a conversion rate of less than 1% from those who visited the subscribe page. This is a critical area that needs immediate attention.

Key Takeaways:

  • The initial steps of the funnel (landing and login) are performing very well with high conversion rates.
  • The most significant drop occurs at the registration stage, followed by the confirmation stage.
  • The final conversion to actual subscribers is extremely low and is the most critical point that needs to be addressed.

While MathsGee seems to be doing well in attracting users and getting them to log in, there are significant bottlenecks in the registration and subscription processes that need to be addressed to improve overall performance.

NB: The data used for this analysis based on the web analytics data tracked https://web-analytics.acalytica.com