SQL: track the usage of a new feature

Track the usage of a new feature after it was released.

The process

Try It for Yourself

What do I get out of it?

A best practice in product management is to analyze the usage of a new feature after it was released. With Actiondesk, distinguish successful features from failures and improve the way you manage your product priorization.


You can answer the following questions:

- How often was the feature used each day since it was released?

- Who are the users using it?

How does it work?

Let's assume you have an "Events" table with the following properties: event_name, timestamp and user_id.

Let's also assume you want to track the usage of the new feature "Add emoji to sheet" (yes, this might be a real life use case 🙃).

We're going to count the total number of times this features was used, and the total number of users who used it.

  1. Import the table "Events" in an Actiondesk sheet Call this sheet "Events".
  2. Create a new sheet called "Add emoji feature analysis" (don't forget to add an emoji to your sheet name 🤓).
  3. In the row 2, starting in C2, write the days for which you want to have the data: "10/26/2020" ; "10/27/2020" ; "10/28/2020" ; etc .
  4. In B3, write "# of features usages" and in B4 "# of users who used the feature".
  5. In C3, write the formula =COUNTIFS(Events!#event_name, "Add emoji to sheet", Events!#timestamp, C2). Copy and paste on the right.
  6. In C4, write the formula =COUNTUNIQUEIFS(Events!#user_id, Events!#event_name, "Add emoji to sheet", Events!#timestamp, C2). Copy and paste on the right. This will count the number of unique user_id having used the features, so the number of unique users.


Et voilà!

What do I get out of it?

A best practice in product management is to analyze the usage of a new feature after it was released. With Actiondesk, distinguish successful features from failures and improve the way you manage your product priorization.


You can answer the following questions:

- How often was the feature used each day since it was released?

- Who are the users using it?

How does it work?

Let's assume you have an "Events" table with the following properties: event_name, timestamp and user_id.

Let's also assume you want to track the usage of the new feature "Add emoji to sheet" (yes, this might be a real life use case 🙃).

We're going to count the total number of times this features was used, and the total number of users who used it.

  1. Import the table "Events" in an Actiondesk sheet Call this sheet "Events".
  2. Create a new sheet called "Add emoji feature analysis" (don't forget to add an emoji to your sheet name 🤓).
  3. In the row 2, starting in C2, write the days for which you want to have the data: "10/26/2020" ; "10/27/2020" ; "10/28/2020" ; etc .
  4. In B3, write "# of features usages" and in B4 "# of users who used the feature".
  5. In C3, write the formula =COUNTIFS(Events!#event_name, "Add emoji to sheet", Events!#timestamp, C2). Copy and paste on the right.
  6. In C4, write the formula =COUNTUNIQUEIFS(Events!#user_id, Events!#event_name, "Add emoji to sheet", Events!#timestamp, C2). Copy and paste on the right. This will count the number of unique user_id having used the features, so the number of unique users.


Et voilà!

Read more
Create My First Report
see all SQL use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your SQL data. Analyze it alongside data from other sources, and build custom SQL dashboards and reports.

View and organize your SQL data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your SQL data. Analyze it alongside data from other sources, and build custom SQL dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within SQL are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.