This guide will help you understand:

  • What is a report in Exponea
  • How can reports empower you in understanding your data
  • How to create a report using Exponea
  • How to further specify the settings of reports in Exponea
  • How to customize the report view

What is a report in Exponea

Reports in Exponea are a powerful analytical tool that summarises your data in a grid table. You can specify the attribute or event to be displayed in the rows and columns of the table. Then, if you chose a specific metric, the report tool will generate a table with the specified rows and columns. Each cell of the table will contain the number of customers or events satisfying the row and column settings measured by the given metric. What's more, the reports tool in Exponea allows you to automatically highlight the most important cells, or even visualize the table as a chart.

Watch this short introductory video about this feature:

👍

Pivot tables

Reports in Exponea share many similarities with pivot tables in Microsoft Excel. If you are already an experienced user of pivot tables, you will easily transfer your knowledge to reports in Exponea.

To further illustrate the usage of reports in Exponea, consider the following example.

Suppose you wanted to better understand during which hour of the day are your customers making purchases. Firstly, note that traffic on your website will vary not only throughout the day but throughout the week as well. Hence, you can choose to make a report and set the columns to be the weekdays of purchase and the rows to be the hours of purchase. What is left is the choice of the metric, you might be interested in the total price of purchases, the average price of a purchase, or just the number of purchases. Each choice of metric may tell you something different, we chose to display the total number of purchases, see the picture below for the outcome.

The table created as in the example showing the number of purchases, highlighted yellow to white.

Learn how to do this in the "Weekly Heat-map" Analysis article.

How can reports empower you in understanding your data

A lot of the power of Exponea comes from a single customer view. For each customer, your database will contain a lot of events and customer attributes. However, to give the data meaning, you will almost always need to condense and visualize your data. This is where reports come in handy, they allow you to summarise your data into an easily comprehensible structure of a grid table, which you can further clarify using either highlighting or the chart view. Consequently, you will be able to gain quick insights into the raw data stored in Exponea.

For a step by step guide through a typical use case, view this article about creating a report from AB testing.

How to Create a Report

You can find the Report tool by clicking on the buttons highlighted by red rectangles

1. Creating a New Report.

a. Navigate to Analyses > Reports.

b. Click on the + sign next to the Reports item in the drop-down menu.

c. You will now see the edit window with a new, empty Report editor.

2. Navigating the Report Editor

An empty report consists of a table editor with empty rows and columns, but with one metric already filled in - customer count. You can start building your report by adding event attributes or customer attributes to the rows and columns of your table. Also, don't forget to give your report a name and save it, so your valuable work would not get lost.

The initial configuration of a new report.
Important parts are highlighted by red rectangle.

The Rows and Columns sections in this Table editor correspond to the rows and columns of a table. In turn, this table will be used as the basis for the output chart.

The Report Editor will generate a bar graph by default. Here, the row attributes represent the values of the x-axis of the bar chart, and the column attributes are represented by one or more bars per value on the x-axis. The METRICS section in the table editor represents the values on the y-axis of the bar graph.

(Please see the metrics guide for more details.)

a. Click on the + sign in the ROWS section to set your row values.

b. Click on the EVENT or CUSTOMER tabs to browse through the respective attributes.

c. Click on an attribute to add it to the `ROWS section.

d. Alternatively, click on the text Add timestamp if you want to plot the attributes in your COLUMN section over time.

e. Please follow the same steps, from a to d, for the COLUMN section.

f. Press the Preview button on the upper right-hand side of the page.

g. Scroll down to see the result.

How to further specify the settings of reports in Exponea

Grouping

Grouping is useful when there are too many values to display or you want to group the values based on certain properties.

❗️

The number of rows in a report is limited to 9 999. Trying to go beyond this limit will result in an error.

There are the following options for grouping:

none

Disables any grouping

auto

Selects the best possible grouping based on the attribute

top

Selects only first X values (max 9 999) in rows according to the first metric used in the report.

discretization

Creates equally large groups, the number defines the number of groups.

histogram

Automatically creates groups from available values based on average and standard deviation to create a histogram-like distribution.

Show N/A

If turned on, it will display also values that are not defined and will also allow users who don't have any value for the field to enter the calculation.

Metrics

Metrics compute values in the table according to the drill-down specified in rows and columns. For example, metric customer count, when combined with session start > country attribute in rows, will compute how many customers started a session in given countries.

Formats

Formats allow you to format values in the report. There are 3 groups of formatting related to time (date format, date part, date difference) and 1 group of numeric filters. Only one filter can be applied at a time.

Filters

Date filter

The Date filter on the top right limits the time frame concerning the events that are used for the calculation of the report. This setting does not apply to customer attributes, but it does apply to event aggregates and segmentations.

📘

Please read the Filtering data article to learn more about Date filters.

Customer filter

You can specify an additional customer filter at the bottom of the report editor. Only customers who pass this filter will be used for the report.

📘

Please read the Filtering data article to learn more about Customer filters.

Actions

On the right-hand side of each field in the report definition, you'll find a delete icon, duplicate icon, and move icon. Click on the delete or duplicate button to either delete or duplicate the row, or click and drag the move icon to move the field up or down.

Report view

Above the Report view, which allows you to select a table view, a chart view, or both.

Chart

By default, the Report view will select the most appropriate chart type to display the contents of the table.

There are 8 types of charts available in the reports:

  • column
    Classic column chart
  • stacked column
    Available when using field in columns
  • bar
    Limits to 15 values
  • line
    Adjusts y-axis based on the values (can start from negative values)
  • area
    Doesn't adjust y-axis (starts from 0)
  • pie
    Shows additional information on hover (percentage of the whole)
  • percentage area
  • bubble
    • In order to create a bubble chart (more complex scatter plot), you ideally want to have a report with:
    • One row - the different values in this attribute will determine the discrete bubbles
    • One column - the different values in this attribute will determine the color of the bubble (overrides fourth metric)
    • Up to four metrics:
      • first metric will determine the size of the bubble
      • second metric will determine the position of the bubble on the X axis
      • third metric will determine the position of the bubble on the Y axis
      • fourth metric will determine the color of the bubble

Table

Report result is displayed in the table.

Example: report with session start > country in rows and count customer metric

Modifiers

There are multiple modifiers in report metrics, which help visualize the data in tables. There are three categories: summarize, show value as, visualize

  • Summarize provide some statistical data about the metric at the bottom of the rows. You can choose from sum, average, maximum, minimum, standard deviation, variance
  • Show value as
    • Column total % shows the percentage distribution within column
    • Grand total % shows percentage distribution considering all columns
    • Running total counts values from all previous rows up to the current one, being effective in YTD revenue reporting
    • Running total % counts percentages from all previous rows up to the current one, resulting in last row always being 100%
  • Visualize
    • Heatmap changes the background of the cells based on their value in the selected color scale
    • Highlight changes the background of the cells based on the selected condition

Send via Email

Exponea offers you the possibility to frequently receive updated reports straight to your email account. This allows you to be always up to date on what has been recently happening to your project.

In order to set this up, navigate to > Send via email
There you can set how often do you wish to receive updates on the Report.

You can choose to receive it:

  • Daily – you will receive the Report every day on 8 a.m.
  • Weekly – you will receive the Report every Monday on 8 a.m.
  • Never – you will not receive the Report.

In order for you to review all the Reports you are receiving, navigate to your profile, and go into the email digest tab. There you will be able to view what Reports and other analyses you are currently subscribed to. You can also choose to stop receiving them by clicking on the trashcan icon.

Cloning Reports

You can close reports into other projects and accounts. Read more about it in Cloneable data mapping.

Updated about a month ago


Reports


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.


We rely on cookies

to optimize our communication and to enhance your customer experience. By clicking on the Accept and Close button, you agree to the collection of cookies. You can also adjust your preferences by clicking on Manage Preferences. For more information please see our Privacy policy.

Manage cookies
Accept & close

Cookies preferences

Accept & close
Back