Creating a report

Getting started

Go to Reports and select "Create report".



Select the level of analysis

As a first step, you need to decide what level you want to create a report.


User-based reports

It allows you to analyze the data based on user-level behaviors.

Examples:

  • How is my WAU changing over time? (unique users)
  • How often are my users getting value? (frequency analysis)
  • What is the distribution of my users across regions/devices, etc? (attribute breakdown)

Account-based reports

If you select β€œAnalyze Uniques by Account,” you can visualize trends and compositions aggregated based on user groups like companies.

πŸ“˜

Good to know

An Account is an object that a set of users might belong to - such as a Company of customers or a team of users. If you are a B2B company, this will help you understand how your accounts interact with your product rather than just seeing the individual users in those companies.

Examples:

  • Analyzing how many distinct accounts were active or fired a certain event
  • Tracking how many charts are copied, saved, and modified in your organization and then identifying which ones are interacted with most often
  • Discovering how conversion rates change between different types of orders
  • Determining how many accounts have converted from free trials to paid accounts
  • Tracking how many posts are drafted but never published in your social media platform

Choose the object to analyze

For each report, you can select these objects to analyze:

Attribute typeDescription
EventsAnalyze the events that are tracked within your website or application
SegmentsAnalyze user membership trends in specified segments
JourneysAnalyze the data on the user entering or exiting the journey


Choose aggregation type

Event aggregation determines the number of events within a certain period.

Event aggregationDescription
Total countThe total number of times this event was performed in a given period
Attribute valuePlots an aggregation for a selected event attribute (all users)
Unique usersThe total number of unique users who have performed this event in a given period. Example: If the same user performs an event twice, this will only count as 1
Monthly active users (MAU)The total number of unique users who have performed this event within the last 30 days. This is a rolling count for each period, counting the previous 30 days
Weekly active users (WAU)The total number of unique users who have performed this event within the last 7 days. This is a rolling count for each period, counting the previous 7 days
Unique accountsThe total number of unique accounts that performed these events within a period.
Count per usersThe number of events performed per user. Plots an average aggregation for a selected event attribute per user

πŸ“˜

Good to know

Aggregations are only supported when selecting events as graph series. They are not supported for segments and journeys objects.


Attribute value aggregation

Attribute aggregation allows you to combine and plot the values of an event attribute.

FunctionEvents calculation
TotalThe total count of all instances of the attribute value.

Example: What's the total number of times the user started a session?
SumThe total of a numeric attribute value across all instances of [event].

Example: What's the total number of minutes of videos watched?
AverageAverage of a numeric attribute value across all instances of [event].

Example: What's the average number of minutes per video watched?
MedianThe median of a numeric attribute value across all instances of [event].

Example: What's the median number of minutes per video watched?
MinimumMinimum of a numeric attribute value across all instances of [event].

Example: What's the minimum number of minutes per video watched?
MaximumMaximum of a numeric attribute value across all instances of [event].

Example: What's the maximum number of minutes per video watched?
Percentiles (25/75/90/99)The 25/75/90/99th percentile of a numeric attribute value across all instances of [event].

Example: What's the 25th percentile number of minutes

πŸ“˜

Good to know

Currently, attribute aggregation only works on attributes with numerical (integer) values.


Choose an inline filter

Inline filters allow you to plot data for only a subset of events based on their attributes. For example, you might only want to see pageview events for a specific URL or only view events from users within specific countries, which can all be done using filters.

Click the icon next to the event name to add a filter to an event series.


This will bring up a dropdown where you can search through all events and user attributes and choose the one you want to filter based on.

By clicking on and/or beside the filters, you can select whether you would like your query to match any or all of them.


Choose a global filter

Global filters allow you to apply filters to all series within a report. The main difference between the inline filters is that global filters work not for a specific event but all events within the report.

Global filters can be combined in the following two ways:

AND - Events have to match every filter within the group
OR - Events only have to match a single filter within the group

πŸ“˜

Good to know

One thing to note about global filters: since they apply to all events within an report, and these events may not share all their attributes, global filters allow you to use any attribute that has been seen in at least one of your events. If you happen to create a filter that references a attribute that not all events have, events that do not contain this attribute will automatically fail the check and will be excluded by the filter.


Choose a breakdown

Breakdowns allow you to split up your report's graph by the values of a certain attribute or segment. This is very useful when analyzing a trend and determining the cause of a change in one of your metrics.

Once you've selected an attribute to break down, your graph should be split into multiple lines, each corresponding to a distinct attribute value.

πŸ“˜

Good to know

Currently, you're only able to breakdown an report by a single attribute.


Add multiple series

Reports support adding multiple series onto the same insight, each tracking a separate event. This is useful when comparing the usages of different events across the same period.

To add a second series to a trend, click the 'Add graph series' button and select the event you would like to plot from the dropdown.

Another option is clicking the duplicate icon, which duplicates that series and its inline filters. This is helpful when comparing the same event with slightly different filters.


Formulas

Formulas are custom mathematical expressions that you can use to compare and combine the values of multiple series.

To add a formula, enable toggle "Formula mode," and within the input box, type out the expression you want to evaluate.

This expression can contain any number of basic mathematical operators (+, -, *, /) along with variables (A, B, C, ...) corresponding to the series with that letter.

For example, if you have two series A and B, then the formula A / B will plot the value of series A divided by the value of series B at each point in time.

You can also use numbers as constants in a formula. Multiply a ratio by 100 to display as a percentage, for example. Divide an attribute value tracked in seconds by 3,600 to display the value in hours. You can rename a formula by selecting Rename in the formula overflow menu.

πŸ“˜

Good to know

When using a formula, only one series will be displayed on the chart, which will show the output of the formula at each point in time.


Analyzing graphs

Go to Data visualization for a complete guide on understanding the charts and tables.