Gift Card Analysis Dashboard

Updated March 21, 2024

The Gift Card Analysis Dashboard provides a holistic view of gift card metrics. Key indicators include gross sales, net sales after discounts, and the day's ending balance of gift cards. Detailed logs and balances for individual gift cards are also accessible, with export options for comprehensive data analysis. 

Note: Gift card balances are calculated from selected time period.

Gift Card Analysis Dashboard Elements


KPI

  • Gross Sales: Gift Card Value.
  • Net Sales: Gross Sales - Discounts.
  • Discounts: Discount applied to the sale of the gift card.
  • Closing Balance: The closing balance of all issued and sold gift cards at the end of the day.

Visualisations

  • Sales Over Time chart visualises gift card sales over selected time periods.
  • Distribution of Sold Quantity by Gift Card Value histogram showcases the distribution of sold quantities based on gift card values, specifically based on the date when an order was created. By examining the frequency of sold quantities within each gift card value range, it offers valuable insights into consumer preferences.
  • Sales Logs table shows an overview of key metrics, including gift card gross sales, the net quantity of gift cards sold, discounts and gift card net sales. The results are displayed, taking into account your selected date filter and granularity.
  • Gift Card Logs table lists created gift cards with current balance.  Table results are sorted in descending order based on the gift card's creation date. The table shows the top 500 results. Please note that the results are available on a daily basis. For the complete dataset, you can export all results using the "Download Data" option and selecting "Advanced data options" followed by "All results".
  • Gift Card Balance table presents total sum and balances from gift cards sold and redeemed during selected time periods per connected stores. The results are sorted in ascending order. The table shows the top 500 results. Please note that the results are available on a daily basis. For the complete dataset, you can export all results using the "Download Data" option and selecting "Advanced data options" followed by "All results".
  • Gift Card Gross Sales By Region map visualization shows gift card gross sales per region.  The visualization includes data from both online purchases and in-store Point of Sale (POS) transactions.