Transaction trends dashboard

Published March 08, 2023
Modules
Difficulty
Industry
Automotive
Finance
Books
Construction
Cosmetics
Electronics
Fashion & Apparel
FMCG
Home & Furniture
Jewelry
Retail
Telco
Media
Multi
Travel

Creating a transaction trends dashboard is an efficient way for businesses to keep track of their financial performance by analyzing transactional data. With this reporting tool, businesses can easily monitor trends in transaction values and purchase data. The goal of this dashboard is to provide a quick and clear overview of transactional activity, helping businesses to make data-driven decisions in real time.

In this use case, you will design a transaction trends dashboard that enables businesses to gain insights into their financial performance by visualizing transactional data.

Prerequisites

Process

In this use case, you will go through the following steps:

  1. Create metrics for a number and value of transactions, Average Order Value (AOV), and number of bought products.
  2. Create a histogram that presents a number and value of transactions in time.
  3. Create an expression that returns the month and year for the product.buy event.
  4. Create reports for most frequently bought products, most frequently bought products by categories and by month, most frequently bought categories by month, most frequently visited products, most frequently visited products by categories.
  5. Create a dashboard that gathers created analyses.
Note: These are just examples of analytics you can use, such a dashboard can be expanded with various other analytics suitable for your business needs.

Create metrics

In this part of the process, you will create four metrics for the transaction.charge, product.buy and Visited page events. They will be later used in a histogram,reports and the dashboard.

Number of transactions

This metric will return the number of all transactions.

  1. Go to Analytics icon Analytics > Metrics > New metric.
  2. Enter the name of the metric.
  3. As a metric kind, select Simple metric.
  4. As the type, set Event.
  5. As the aggregator, set Count.
  6. As the occurrence type, set All.
  7. From the Choose event dropdown list, select transaction.charge.
  8. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  9. Click Save.
The view of the configuration of the metric returning the number of all transactions
Configuration of the metric returning the number of all transactions

Transactions value

This metric will return the value of transactions.

  1. Go to Analytics icon Analytics > Metrics > New metric.
  2. Enter the name of the metric.
  3. As a metric kind, select Simple metric.
  4. As the type, set Event.
  5. As the aggregator, set Sum.
  6. As the occurrence type, set All.
  7. From the Choose event dropdown list, select transaction.charge.
  8. Click the + where button.
    Result: The Choose parameter button appears.
  9. From the Choose parameter dropdown list, choose $totalAmount.
  10. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  11. Click Save.
The view of the configuration of the metric returning the value of transactions
Configuration of the metric returning the value of transactions

AOV

This metric will return the avarage order value.

  1. Go to Analytics icon Analytics > Metrics > New metric.
  2. Enter the name of the metric.
  3. As a metric kind, select Simple metric.
  4. As the type, set Event.
  5. As the aggregator, set Average.
  6. As the occurrence type, set All.
  7. From the Choose event dropdown list, select transaction.charge.
  8. Click the + where button.
    Result: The Choose parameter button appears.
  9. From the Choose parameter dropdown list, choose $totalAmount.
  10. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  11. Click Save.
The view of the configuration of the metric returning the AOV*
Configuration of the metric returning the AOV

Number of bought products

This metric will return the number of bought products.

  1. Go to Analytics icon Analytics > Metrics > New metric.
  2. Enter the name of the metric.
  3. As a metric kind, select Simple metric.
  4. As the type, set Event.
  5. As the aggregator, set Sum.
  6. As the occurrence type, set All.
  7. From the Choose event dropdown list, select product.buy.
  8. Click the + where button.
    Result: The Choose parameter button appears.
  9. From the Choose parameter dropdown list, choose $quantity.
  10. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  11. Click Save.
The view of the configuration of the metric returning the number of bought products
Configuration of the metric returning the number of bought products

Number of visits on the product page

This metric will return the number of visits on the product page.

  1. Go to Analytics icon Analytics > Metrics > New metric.
  2. Enter the name of the metric.
  3. As a metric kind, select Simple metric.
  4. As the type, set Event.
  5. As the aggregator, set Count.
  6. As the occurrence type, set All.
  7. From the Choose event dropdown list, select Visited page.
  8. Click the + where button.
    Result: The Choose parameter button appears.
  9. From the Choose parameter dropdown list, choose product:retailer_part_no.
  10. From the Choose operator dropdown list, select Regular expression (String).
  11. In the text field, enter .
  12. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  13. Click Save.
The view of the configuration of the metric returning the number of visits on the product page
Configuration of the metric returning the number of visits on the product page

Create a histogram

In this part of the process, you will create a histogram for the transactions value and number of bought products metrics. They will be later used in the dashboard.

  1. Go to Analytics icon Analytics > Histograms > New histogram.

  2. Enter the name of the histogram.

  3. From the Choose metric dropdown, select the transactions value metric created in the previous step.

  4. Click the Interval button and set it for day.

  5. To select a specific time range, click the calendar icon. In our case, it will be Last 30 days. Confirm your choice with the Apply button.

  6. Add another metric to the histogram:

    1. Click the Add new tab button.
    2. Repeat steps 3-5 for the number of bought products metric created in the previous step.

  7. Click Save.

    The view of the configuration of the histogram
    Configuration of the histogram

Create an expression

In this part of the process, create an expression for the product.buy event. It will return month and year of the purchase and will be later used in reports.

  1. Go to Analytics icon Analytics > Expressions > New expression.

  2. Enter the name of the expression.

  3. Set the Expression for option to Event.

  4. From the Choose event dropdown list, select product.buy event.

  5. Build the following formula of the expression:

    The view of the configuration of the expression
    Configuration of the expression which returns the date in month/year format

  6. Save the expression.

Create reports

In this part of the process, you will create reports:

  • for most frequently bought products,
  • most frequently bought products by categories,
  • most frequently bought products by month,
  • most frequently bought categories by month,
  • most frequently visited products,
  • most frequently visited products by categories. All the reports will be used in the dashboard in the further part of the process.
Most frequently bought products

This report will return the names of most frequently bought products and its values.

  1. Go to Analytics icon Analytics > Reports > New report.
  2. Enter a meaningful name of the report.
  3. Click the Choose metric and from the dropdown list, select a metric that returns the number of bought products, created in the previous part of the process.
  4. From the Range dropdown list, select the number of top (the most frequently bought) products to be shown in the preview of the report. In this case, it will be TOP 20 products.
  5. In the Dimension section, from the dropdown list, select Events > Parameters. To be able to show product names in the report, choose title.
  6. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  7. Click Save.
    The view of the configuration of the wost frequently bought products report
    Configuration of the most frequently bought products report

Most frequently bought products by categories

This report will return the names of most frequently bought products and its values by its categories.

  1. Go to Analytics icon Analytics > Reports > New report.
  2. Enter a meaningful name of the report.
  3. Click the Choose metric and from the dropdown list, select a metric that returns the number of bought products, created in the previous part of the process.
  4. From the Range dropdown list, select the number of top (the most frequently bought) products to be shown in the preview of the report. In this case it will be TOP 20 products.
  5. In the Dimension section, from the dropdown list, select Events > Parameters. To be able to show products name in the report, choose category.
  6. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  7. Click Save.

Most frequently bought products - monthly comparison

This report will return the names of most frequently bought products by categories and its values in a specific month.

  1. Go to Analytics icon Analytics > Reports > New report.
  2. Enter a meaningful name of the report.
  3. Click the Choose metric and from the dropdown list, select a metric that returns number of bought products, created in the previous part of the process.
  4. From the Range dropdown list, select the number of top (the most frequently bought) products to be shown in the preview of the report. In this case, it will be TOP 20 products.
  5. In the Dimension section, from the dropdown list, select Events > Parameters. To be able to show product names in the report, choose title.
  6. Click Add dimension.
    1. Click Choose dimension and from the dropdown list, select Events > Expressions. To be able to show the date of the transaction in the month/year format choose the expression you created in the previous part of the process.
  7. To select a specific time range, click the calendar icon. In our case it will be Lifetime. Confirm your choice with the Apply button.
  8. Click Save.

Most frequently bought products by categories - monthly comparison

This report will return the names of most frequently bought products by categories and its values in a specific month.

  1. Go to Analytics icon Analytics > Reports > New report.
  2. Enter a meaningful name of the report.
  3. Click the Choose metric and from the dropdown list, select a metric that returns the number of bought products, created in the previous part of the process.
  4. From the Range dropdown list, select the number of top (the most frequently bought) products to be shown in the preview of the report. In this case, it will be TOP 20 products.
  5. In the Dimension section, from the dropdown list, select Events > Parameters. To be able to show products name in the report, choose category.
  6. Click Add dimension.
    1. Click Choose dimension and from the dropdown list, select Events > Expressions. To be able to show the date of the transaction in the month/year format choose the expression you created in the previous part of the process.
  7. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  8. Click Save.

Most frequently visited products

This report will return the names of most frequently visited products and its values.

  1. Go to Analytics icon Analytics > Reports > New report.
  2. Enter a meaningful name of the report.
  3. Click the Choose metric and from the dropdown list, select a metric that returns the number of visits on the product page, created in the previous part of the process.
  4. From the Range dropdown list, select the number of top (the most frequently bought) products to be shown in the preview of the report. In this case, it will be TOP 20 products.
  5. In the Dimension section, from the dropdown list, select Events > Parameters. To be able to show product names in the report, choose og:title.
  6. Switch off the Show null values toggle.
  7. To select a specific time range, click the calendar icon. In our case it will be Lifetime. Confirm your choice with the Apply button.
  8. Click Save.

Most frequently visited products by categories

This report will return the names of most frequently visited products and its values by categories.

  1. Go to Analytics icon Analytics > Reports > New report.
  2. Enter a meaningful name of the report.
  3. Click the Choose metric and from the dropdown list, select a metric that returns the number of visits on the product page, created in the previous part of the process.
  4. From the Range dropdown list, select the number of top (the most frequently bought) products to be shown in the preview of the report. In this case, it will be TOP 20 products.
  5. In the Dimension section, from the dropdown list, select Events > Parameters. To be able to show products name in the report, choose product:category.
  6. Switch off the Show null values toggle.
  7. To select a specific time range, click the calendar icon. In our case, it will be Lifetime. Confirm your choice with the Apply button.
  8. Click Save.

Create a dashboard

In the final part of the process you will create a dashboard with the metrics, reports and the histogram created in previous steps.

  1. Go to Image presents the Analytics icon Analytics > Dashboards > Add dashboard.

  2. Enter the name of the dashboard.

  3. To add a widget to the dashboard, click an icon on the The panel of analysis icons panel. The icons are (left to right): HTML code, text field, image, segmentation, trend, funnel, metric, histogram, aggregate, expression, and a report.

    Tip: You can create a custom template according to your business needs with the help of this article or follow the sample instructions below.

  4. Add a metric by clicking the Metric icon on the dashboard panel on the panel.

    Tip: You can adjust the size of widgest by dragging their lower right corner.

  5. Edit widget contents with the editor on the right. In the Metric section, choose the metric that returns the number of all transactions you have created in the previous part of the process. You can change the title and description. Do the same for the following metrics created in the previous part of the process: transactions value, AOV, and number of bought products

    The view of the configuration of the metric on the dashboard
    Configuration of the metric widget

  6. Add a histogram by clicking the Histogram icon on the panel.

  7. Edit widget contents with the editor on the right. In the Histograms section, choose the histogram for the transactions value and number of bought products you have created in the previous part of the process. You can change the title and description.

  8. Click the Style section in the widget editor and change Visualization type to Column.

    The view of the style configuration of the histogram
    Style configuration of the histogram

  9. Add a report by clicking the Report icon on the panel.

  10. Edit widget contents with the editor on the right. In the Reports section, choose the report for most frequently bought products you have created in the previous part of the process. You can change the title and description.

  11. Click the Style section in the widget editor and change Visualization type to Table.

  12. Do the same for the following reports created in the previous part of the process: most frequently bought products by categories, most frequently bought products - month comparison, most frequently bought products by categories - month comparison, most frequently visited products, most frequently visited products by categories.

    Note: You can look up the sample dashboard created in the Demo workspace here

  13. When you complete creating the dashboard, click Save dashboard.

    Tip: By default, a new dashboard is private. If you want to share it with others, check the instruction here.

Check the use case set up on the Synerise Demo workspace

You can check all configurations directly in Synerise Demo workspace:

If you don’t have access to the Synerise Demo workspace, please leave your contact details in this form, and our representative will contact you shortly.

Read more

😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker