SQL: get a bird's-eye view of a customer's usage of your product

Get a breakdown of your customer's activity on your product.

The process

Try It for Yourself

What do I get out of it?

Have your team be more knowledgeable about your customers usage of your product. If you're sending your product data into your database, you’ll be able to understand with Actiondesk how a customer behaves or why he churned.

How does it work?

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

  1. Import in an Actiondesk sheet the table "Events". Call this sheet "Events" and add an emoji to your sheet name 🤓.
  2. Create a new sheet called "User product metrics".
  3. Copy the unique values of the column "event_name" by right clicking on the column and clicking on "Copy Unique value".
  4. Paste the unique values in the cell B4 of the sheet "User product metrics".
  5. In B2, write the email address of one of your users, let's say: tony.stark@actiondesk.io
  6. In C4, in order to count the number of events for that particular user, write the following formula: =COUNTIFS(Events!#event_name, B4, Events!#email_address, $B2$)
  7. Copy and paste this formula so that you have the count for every event name.
  8. Now, just change the email address in B2, and you'll get your product metrics for any user.


Bonus step: You could also have the same dashboard over a specific period of time by adding a condition on the timestamp in your COUNTIFS formula.

What do I get out of it?

Have your team be more knowledgeable about your customers usage of your product. If you're sending your product data into your database, you’ll be able to understand with Actiondesk how a customer behaves or why he churned.

How does it work?

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

  1. Import in an Actiondesk sheet the table "Events". Call this sheet "Events" and add an emoji to your sheet name 🤓.
  2. Create a new sheet called "User product metrics".
  3. Copy the unique values of the column "event_name" by right clicking on the column and clicking on "Copy Unique value".
  4. Paste the unique values in the cell B4 of the sheet "User product metrics".
  5. In B2, write the email address of one of your users, let's say: tony.stark@actiondesk.io
  6. In C4, in order to count the number of events for that particular user, write the following formula: =COUNTIFS(Events!#event_name, B4, Events!#email_address, $B2$)
  7. Copy and paste this formula so that you have the count for every event name.
  8. Now, just change the email address in B2, and you'll get your product metrics for any user.


Bonus step: You could also have the same dashboard over a specific period of time by adding a condition on the timestamp in your COUNTIFS formula.

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.