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 Integrate 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.

   

Step 5: Create a unit metric

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

1. Create a custom allocation rule named Everything, using the Provider dimension to include the relevant datasets. See Create allocations.

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.

   

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.