DocumentationCommerceCommerce Intelligence User Guide

Build Investor Dashboard

Last update: Mon Jul 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

Many clients work with investors and need to share information from the platform, but the dashboards that you create to make day-to-day business decisions may not be what an investor is looking for. Below describes some best practices for how to create a dashboard that is comprehensive but simple, ideal for sharing with active and potential investors.

Here is what you need to create reports for your investor dashboard:

Scalar Reports

  • All-time revenue
  • Distinct buyers
  • All-time number of orders
  • AOV
  • Items sold

Visual Reports

  • Revenue by quarter

    • Metric – Revenue

  • Revenue from 1st time orders vs repeat orders

    • Metric – First-time order revenue
    • Filter – User’s order number is equal to 1
    • Metric 2 – Repeat order revenue
      • Filter – User’s order number is greater than 1
    • Uncheck the box for Multiple Y-Axes
    • Change to a Stacked Column chart

  • AOV by quarter

    • Metric 1 – Revenue
      • Hide this metric
    • Metric 2 – Number of orders
      • Hide this metric
    • Formula – AOV
      • A/B

  • All-time revenue by source

    • Metric – Revenue
    • Group by customer’s utm_source

  • Revenue from top 10 products

    • Metric – Product revenue

      • Hide the chart
      • Group by Product’s name. Select all products.
      • Set the time range to All-Time
      • Set the time interval to None
      • In “Show top/bottom”, show only the top 10 sorted by Product profit

  • Cumulative distinct buyers by quarter

    • Metric – Distinct buyers
      • Perspective – Cumulative

  • Site visits - New vs. repeat by month

  • Sessions

With a Google Analytics integration, you can include reports on:

  • Site visits
  • Conversion rate

With the Commerce Data Enrichment services, you can include reports on:

  • Unique customers by state/region, age, gender.

Other Tips

  • Use a clear and concise naming convention
  • Share the dashboard with investor users
  • Or send it via Automated email summary(https://experienceleague.adobe.com/data-user/export-data/email-summaries.html?lang=en)
  • Create only one dashboard. This makes the content easier to maintain, and you know exactly what your investors are looking at.

Organize your reports thoughtfully and pay attention to detail. Once complete, the dashboard looks similar to below:

recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc