Redemption Report

You can view the Redemption Report in Offers > Redemption Report. The Redemption Report is comprised of two tabs:

1. Overview
2. Deals Summary

Date Range Available

Data is made available for the last two years, not counting today. For example, if today is 2024-Jul-24, the data from 2022-Jul-24 to 2024-Jul-23 is made available in the report.

Data Refresh Frequency

Data is reported from an aggregated source and refreshed daily once at 7 AM EST. However, it may vary, up to a maximum of 11 AM EST. This can be checked from the latest refresh data time stamp shown on the dashboard.

Overview

This tab displays both high-level redemption stats and granular redemption data for each unique redeemable.

This report does not cover redemptions associated with Promo and Coupon campaigns that are configured with the option of "Directly Processed at POS". Therefore, the metrics on the Redemption Report may not match the metrics for Redemptions and Redemption Sales on the Dashboard (landing page). For more information on different redemption workflows, please refer to Understanding Punchh Data: Redemption Workflows.

Overall Metrics

The top section summarizes the report with four metrics and the respective comparison to the previous period.

Report Metric	Definition
Redemptions	Represents all redemption attempts, including successful, expired, etc. in a given time period. The successful redemptions (Honored Redemptions) are filtered based on the date-time stamp of the successful redemption in the business time zone. For unsuccessful/expired redemptions, the redemption attempt date-time stamp in the business time zone is used The colors in the pie chart and the different lines in the line chart denote the redemptions by their respective status (honored, expired, etc.)
Redeemed Points	Represents the total points redeemed as part of the redemption. Note that not all redemptions will have points associated with them. For example, some item-based offers sent as part of campaigns may not be associated with points at all. The colors in the pie chart and the different lines in the line chart denote the redeemed points associated with redemptions by their respective status (honored, expired, etc.)
Gross Sales	Represents the total gross sales associated with all the transactions of which successful redemptions were a part.
Honored Redemption Discount	Represents the total gross sales associated with all the transactions of which successful redemptions were a part.

Redemption and Redeemed Points Distribution

This section shows the distribution of redemptions and redeemed points in the selected time frame and a toggle to choose between a pie chart and a line chart.

Gross Sales, Discount Distribution, and Top 10 Offers

Gross Sales: Shows the distribution of gross sales.

Honored Redemption Discount: Shows the distribution of the discount amount (bar chart) and discount rate i.e. Honored Redemption Discount/Honored Redemption Gross Sales expressed as a percentage (line chart).

Top 10 Offers: Top 10 offers (redeemable) are shown based on the metrics selected from the drop-down menu i.e. Total Redemptions, Honored Redemptions, Honored Redemptions Discount, Honored Redemptions Gross Sales.

Heatmap

Based on the metric selected under Top 10, the Heatmap shows the data that selected metrics on a per-day basis.

Redeemable Performance List

This view shows the performance of each redeemable based on the date range and locations you select, with one row per redeemable, reward origin, and redemption status.

The following are the metrics shown for each redeemable:

Redeemable Metric	Definition
Redeemable ID	The unique identifier of a Redeemable on Punchh
Redeemable Name	Name of the Redeemable
Reward Origin	Represents the origin of the reward on which redemption is made. The possible values include Loyalty, Campaign and Others, and Deals Loyalty indicates that a reward that was gifted as a result of achieving a loyalty program milestone was redeemed Deals indicate that the redemption is made on a reward generated based on a Deal (check if your business has this functionality enabled) Campaign and Others indicate that the redemption on a reward disbursed as part of a campaign or disbursed by Admins as part of ad-hoc gifting activities
Status	Represents the status of a redemption. Possible values include Honored, Expired, and Others (which include Staged or Unassigned Redemptions that weren’t successful)
Redemptions	Represents the count of redemptions for the given Redeemable ID, from a specific Reward Origin with a given status
Discount Amount	Represents the discount amount associated with the redemptions for the given Redeemable ID, from a specific Reward Origin with a given status Note that the Discount Amount is always 0 in case of redemptions with the status that is not “Honored”
Gross Spend	Represents the discount amount associated with the redemptions for the given Redeemable ID, from a specific Reward Origin with a given status Note that the Gross Spend could be non-zero in case of expired redemptions. The gross receipt amount associated with this redemption attempt is shown
Discount Rate	(Discount Amount)/(Gross Spend) expressed as a percentage Note that the Discount Rate is always 0 in case of redemptions with status that is not “Honored”
Redeemed Points	Represents the points redeemed associated with the redemptions for the given Redeemable ID, from a specific Reward Origin with a given status Note that not all Honored or Expired redemptions have non-zero Redeemed Points. It is usually non-zero for Loyalty based redemptions, but it could be non-zero for rewards originating from Campaigns and Others too Also note that Redeemed Points for Expired redemptions can have a non-zero value, to show the attempted count of points redeemed with a redemption attempt

Deals Summary

This tab displays both high-level redemption stats and granular redemption data for each unique redeemable specific to Deals.

This report does not cover amount or discount-based promos/coupons. All the metrics in the dashboard are based on the date range and the locations you have selected.

Overall Metrics

The top section summarizes the report with seven metrics and the respective comparison to the previous period.

Report Metric	Definition
Redemptions	Represents all redemption attempts, including successful, expired, etc. in a given time period specific to Deals. The successful redemptions (Honored Redemptions) are filtered based on the date-time stamp of the successful redemption in the business time zone. For unsuccessful/expired redemptions, the redemption attempt date-time stamp in the business time zone is used. The colors in the pie chart and the different lines in the line chart denote the redemptions by their respective status (honored, expired, etc.)
Gross Spend	Represents the total gross sales associated with all the transactions of which successful redemptions were a part, specific to Deals.
Discount	Represents the discount amount associated with all the transactions of which successful redemptions were a part, specific to Deals.
Net Spend	Gross Spend - Discount
Gross AoV	Gross Spend/Redemptions
Net AoV	Net Spend/Redemptions
Discount Rate	(Discount Amount)/(Gross Spend) expressed as a percentage Note that the Discount Rate is always 0 in case of redemptions with status that is not “Honored.”

Redemption Breakdown, Redemption Trends, Gross Sales, Honored Redemption Discount, and Top 10 Offers

Redemption Breakdown: Shows the breakdown of total redemptions by their status (Honored, Expired, and others) for the selected time frame and locations.

Redemption Trends: Shows the trends of total redemptions by their status (Honored, Expired, and others) for the selected time frame and locations over a period of time, specific to Deals.

Gross Sales: Shows the distribution of gross sales specific to Deals.

Honored Redemption Discount: Shows the distribution of the discount amount (bar chart) and discount rate, i.e., Honored Redemption Discount/Honored Redemption Gross Sales expressed as a percentage (line chart) over a period of time. This is specific to Deals.

Top 10 Offers: Top 10 offers (redeemable) are shown based on the metrics selected from the drop-down menu, i.e., Total Redemptions, Honored Redemptions, Honored Redemptions Discount, Honored Redemptions Gross Sales, specific to Deals.

Redeemable Performance List

This view shows the performance of each redeemable based on the date range and locations you select, with one row per redeemable, reward origin, and redemption status, specific to Deals.

The following are the metrics shown for each Redeemable specific to Deals:

Redeemable Metric	Definition
Redeemable ID	The unique identifier of a Redeemable on Punchh
Redeemable Name	Name of the Redeemable
Status	Represents the status of a redemption. Possible values include Honored, Expired, and Others (which include Staged or Unassigned Redemptions that weren’t successful).
Redemptions	Represents the count of redemptions for the given Redeemable ID from Deals.
Gross Sales	Represents the discount amount associated with the redemptions for the given Redeemable ID from Deals. Note that the Gross Spend could be non-zero in case of expired redemptions. The gross receipt amount associated with this redemption attempt is shown.
Gross AoV	Gross Sales/Redemptions
Net Sales	Gross Sales - Discount
Net AoV	Net Sales/Redemptions
Discount	Represents the discount amount associated with the redemptions for the given Redeemable ID from Deals. Note that the Discount Amount is always 0 in case of redemptions with the status that is not “Honored.”
Discount Rate	(Discount Amount)/(Gross Spend) expressed as a percentage Note that the Discount Rate is always 0 in case of redemptions with status that is not “Honored.”

Exporting

Click the Export button on the top right of the page as shown in the screenshots below, and select a sheet to download the data instantaneously to your local machine.