Metrics & Dashboards
#casestudy #secondfriendstore
I was assigned to create a real-time dashboard for Second Friend Store by defining product metrics to help the company track project performance and its impact on business processes.
KEY METRICS
  • Acquisition
    Customer Acquisition Cost (CAC)
    MAU /WAU / DAU
    New buyers
    New sellers
  • Activation
    # of Sign Ups
    Sign up Rate
    # of Subscriptions
    Subscription Rate
    Add to Cart Rate
    # of Shopping carts created
    Cart Abandonment Rate
    Check out rate
  • Retention
    CR to 2nd order
    Effectiveness of recommendation engines
    NPS
  • Monetization
    GMV
    Revenue
    Cost of sales
    Cost of shipping
    Cost per order (operational expenses)
    # of Orders
    CR to Order
    Average Order Value (AOV)
    # of Redeemed orders / transactions
    CR to Order redemption
    Purchases per paying user
    Average Revenue Per User (ARPU)
    Average Revenue Per Paying User (ARPPU)
    Payment abandonment Rate
    Paying share
Rick.ai analytics system was chosen to build dashboards. The system receives information from the internal CRM system, Google Analytics, Facebook, Google Ads, etc. Rick imports orders and payments for all time and connects them to ads channels and campaigns. Rick imports sessions, User Stories, events, pagePath’s, creates auto-metrics and shows reports and growth points. Rick imports advertising costs, imps, clicks, etc. for each campaign, keywords, ads, creatives and joins them with users, buyers, payments. For data accuracy, it was necessary to mark up events in GA4.
EVENTS MARKUP
This analytics system allows me to create a range of task-specific reports and funnels that help make quick decisions based on the data displayed.
DASHBOARDS
Let's Connect