Skip to main content

Analyze unit economics cost

Objectives​

In this tutorial, you'll learn how to:

  • Upload CSV from the DoiT console.

  • Create a unit metric to measure the unit economics per user interaction of features delivered by different teams.

Warning

This tutorial uses contrived data for demonstration purposes. In real-world scenarios, always sanitize your data, for example, mask personally identifiable information (PII), before sending it.

Step 1: Identify data source​

In this tutorial, the organization fetches product usage data from a third-party service provider. The data shows how many user interactions happened during each calendar month, per team.

Below is the example source CSV file.

user-interactions-per-team.csv
Month,Team,User Interactions
2024-03-01,platform,"1,042"
2024-04-01,platform,979
2024-05-01,platform,"1,103"
2024-03-01,adoption,575
2024-04-01,adoption,671
2024-05-01,adoption,722
2024-03-01,data,"2,206"
2024-04-01,data,"2,649"
2024-05-01,data,"2,840"
2024-03-01,growth,365
2024-04-01,growth,449
2024-05-01,growth,512
2024-03-01,qa,31
2024-04-01,qa,30
2024-05-01,qa,31

Step 2: Define data granularity, prepare CSV​

To measure the unit economics per user interaction, you first need to ingest the dataset of user interactions into DoiT DataHub.

When preparing the CSV:

  • Add label.team to the header row, indicating that team is a custom dimension.

  • Add metric.user_interactions to the header row, indicating that user_interactions is a custom metric

Below is the reformatted example CSV.

user-interactions-per-team-to-upload.csv
usage_date;label.team;metric.user_interactions
2024-03-01T00:00:00Z;platform;1042
2024-04-01T00:00:00Z;platform;979
2024-05-01T00:00:00Z;platform;1103
2024-03-01T00:00:00Z;adoption;575
2024-04-01T00:00:00Z;adoption;671
2024-05-01T00:00:00Z;adoption;722
2024-03-01T00:00:00Z;data;2206
2024-04-01T00:00:00Z;data;2649
2024-05-01T00:00:00Z;data;2840
2024-03-01T00:00:00Z;growth;365
2024-04-01T00:00:00Z;growth;449
2024-05-01T00:00:00Z;growth;512
2024-03-01T00:00:00Z;qa;31
2024-04-01T00:00:00Z;qa;30
2024-05-01T00:00:00Z;qa;31

Step 3: Upload CSV​

  1. Sign in to the DoiT console. select the gear icon () from the top navigation bar, and then select DataHub.

  2. Select Create new dataset.

  3. Follow the instructions to Create a new dataset and Upload CSV file.

If successful, the data will be available in DoiT console in 15 minutes.

Step 4: Explore the ingested dataset​

  1. Sign in to the DoiT console.

  2. Create a new Cloud Analytics report:

    • Select Include DataHub data under Data source.

    • In the Metric drop-down, select User Interactions under DataHub metrics.

    • In the Group by section, select team under Labels and filter by team names.

  3. Run the report.

    Update data source

Step 5: Create a unit metric​

Create a unit metric to measure the cost per user interaction:

  1. Create a custom attribution named Everything, using the Provider dimension to include the relevant datasets. See Create attributions.

  2. Create a custom metric named Cost per Interaction, using the DataHub metric user_interactions and the basic metric Cost as base metrics. See Create metrics.

    Update data source

  3. Create a new Cloud Analytics report:

    • Select Include DataHub data under Data source.

    • In the Metric drop-down, select Cost per Interaction under Custom metrics.

    • In the Group by section, select team under Labels and filter by team names.

  4. Run the report.

    Update data source

Interactive demo​

Try out our interactive demo for a hands-on walk-through experience.

If the demo doesn't display properly, try expanding your browser window or opening the demo in a new tab.

Last updated on