Identify products purchased at a promotional price

Published March 22, 2022
Modules
Difficulty
Selected Clients
eobuwie logo

In order to better match the offer with the customer’s needs, a company needs to conduct an in-depth analysis of the customers’ behavior and buying habits on its website. Knowing what products have been purchased as part of a promotion can prove to be very important and beneficial and can be used later while creating different campaigns.

Prerequisites


  • A tracking code implemented into the website.
  • Send information about transactions through SDK or API.

Process


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

  1. Create an expression.
  2. Create a metric.
  3. Create segmentation.
  4. Create report.

Create an expression


After a purchase is made, the product.buy event appears in the customer’s profile. This event contains two parameters: product:price:amount - describing the original price of the product and $finalUnitPrice - describing the final price of the product. The transaction event does not indicate whether the purchased product was covered by a promotion (unless such a parameter has been implemented into the workspace).

Example of the product.buy event
Example of the product.buy event

Using Synerise Analytics, you can create an event expression that deducts the price of the purchased product from the regular price.

Create an expression that calculates the difference between the initial and the final price of the product.

  1. Go to Profiles icon Analytics > Expression > New expression.
  2. Enter the name of the expression.
  3. Set the Expression for option to Event.
  4. From the dropdown list, select Bought products.
  5. Click the unnamed node.
  6. From the Choose attribute dropdown list, select product:price:amount.
  7. Click the plus icon.
  8. From the dropdown list, select Event attribute.
  9. From the Choose attribute dropdown list, select $finalUnitPrice.
  10. Change the mathematical operator between these two parameters to minus.
  11. Save the expression.
Formula of the expression
Formula of the expression

Create a metric


In this part of the process, you create metrics to see how many products were purchased at a discount. This metric will include the expression - if the result of this expression is greater than 0, it means that the product was bought at a discount.

  1. Go to Profiles icon Analytics > Metrics > New metric.
  2. Enter a meaningful metric name.
  3. Leave the metric kind at default (Simple).
  4. As the aggregator type, select Sum.
  5. Select the Bought product event.
  6. Add the $quantity parameter.
  7. Select the where input that appeared on the canvas.
  8. Select the expression created in the previous step.
  9. Choose the More than number operator.
  10. Keep clicking the icon next to the logical operator until you get # icon.
  11. In the blank field, enter 0.
  12. Select the date range of the metric (for example, last 30 days)
  13. Save the metric.
Metiric configuration
Metric configuration

Create a segmentation


Create a segmentation to see how many customers bought discounted products.

  1. Go to Profiles icon Analytics > Segmentation > New Segmentation.
  2. Enter the name of segmentation.
  3. On the canvas, click Choose filter.
  4. From the dropdown list, select the Bought product event.
  5. Select the where input that appeared on the canvas.
  6. Select the expression created in the previous step.
  7. Choose the More than number operator.
  8. Keep clicking the icon next to the logical operator until you get # icon.
  9. In the blank field, enter 0.
  10. Select the date range of the segmentation (for example, last 30 days).
  11. Save the segmentation.
Segment configuration
Segment configuration

Create a report


In this part of the process, create a report to clearly show the most frequently purchased discounted products, displaying the product parameters that interest you the most (in our example, we display the product names).

  1. Go to Profiles icon Analytics > Report > New report.
  2. Enter the name of the report.
  3. Select the metric you created in this 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.
  5. In the Dimension section, choose a parameter from product.buy suggesting what the product is. Among the most common parameters, you can choose $name or $sku.
  6. In the date range, select the time that will be analyzed.
    Important: Select the same date range as you selected for the metric and the segmentation.
  7. Save the report.
  8. Click preview to see the results.
Segment configuration
The configuration of report with products bought on promotion

The report will return information about how many, for example, XYZ shoes were purchased at a discount.

Segment configuration
Report preview

Check the use case set up on the Synerise Demo workspace


You can find the analyses created in this use case in our Synerise Demo profile at the following links:

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