Overview

The Frequent Buyer Dashboard provides manufacturers with insight into how customers engage with frequent buyer programs over time. Unlike offer-based reports, this dashboard focuses on card progression, completion behavior, abandonment risk, and customer value driven by frequent buyer programs.

This dashboard helps answer key questions such as:

• Are customers completing their frequent buyer cards?
  
  

• Where are cards getting abandoned?
  
  

• How much value do completed cards generate?
  
  

• How does performance compare to industry benchmarks?
  
  

• Which programs and retailers are driving the strongest engagement?
  
  

Section 1: Frequent Buyer Overview

Top Filters & Controls

• Distributor / Program / Location / Product Filters
  Narrow the view to specific programs or retailers.
  
  

• Date Range
  Defines the transaction window used for all metrics.
  
  

• # of Days to Consider Abandoned
  A critical control used throughout the dashboard.
  If a card has no transaction activity for X days, it is considered Abandoned.
  
  

This allows manufacturers to adjust abandonment sensitivity based on buying cadence.

Transactions by Month

Shows total frequent buyer purchases and redemptions by month.

Why it matters:
Tracks program usage and engagement trends over time.

Net ($) by Month

Displays net value generated by frequent buyer activity after costs.

Why it matters:
Shows the financial contribution of frequent buyer programs, not just participation.

Retailers by Month

Counts unique retailers actively participating each month.

Why it matters:
Indicates program adoption and retailer consistency. Growth here signals an expanding retail footprint.

KPIs by Program

This table summarizes performance by frequent buyer program.

Key Columns Explained:

• Abandoned Cards
  Cards with no transactions within the abandonment window.
  
  

• In Progress Cards
  Cards that are started but not yet completed and not abandoned.
  
  

• Redeemed
  Cards that have been fully completed and redeemed.
  
  

• Total Transaction Value
  MSRP value generated from all purchases on these cards.
  
  

• Total Net
  Total Transaction Value minus cost of rewards.
  
  

Why this table matters:

• Identifies which programs keep customers engaged
  
  

• Highlights programs with high abandonment risk
  
  

• Shows which programs generate the most net value
  
  

Card Status by Store

This section breaks card status down by individual retailer.

Metrics include:

• of cards by status (Abandoned, In Progress, Complete, Redeemed)
  
  

• % distribution of cards by status
  
  

• Net value generated by each card status
  
  

Why it matters:

• Identifies retailers with strong completion rates
  
  

• Highlights stores where customers frequently abandon cards
  
  

New Retailers by Month

Tracks first-time retailers participating in frequent buyer programs.

Why it matters:
Shows expansion and adoption of frequent buyer programs across the retail network.

New Customers by Month

Tracks new customers entering frequent buyer programs.

Why it matters:
Indicates whether programs are attracting new participants or relying solely on existing buyers.

Section 2: Card Completion

Card Status Definitions:

• Abandoned
  No transactions within the defined abandonment window.
  
  

• In Progress
  Active cards that are not yet complete and not abandoned.
  
  

• Redeemed
  Card fully completed and reward redeemed.
  
  

Program Cards by Status

Shows completion breakdown by program.

Why it matters:

• Identifies which programs encourage full completion
  
  

• Highlights programs that stall mid-way
  
  

• Helps refine required punch counts or reward structure
  
  

Retailer Cards by Status

Displays how each retailer performs in moving customers toward completion.

Why it matters:

• Reveals execution differences at the store level
  
  

• Highlights retailers that successfully drive repeat visits
  
  

• Pinpoints locations where customers disengage
  
  

Completion % Compared to Industry

Benchmarks your program performance against the market total (all brands on Astro).

Breakdowns include:

• New vs. returning customers
  
  

• Required punch counts
  
  

Why it matters:
Provides context to answer:

“Is our completion rate good or bad compared to the market?”

This comparison helps manufacturers evaluate competitiveness and opportunity.

Punch Abandonment and Exposure

Shows how abandonment risk changes as customers progress through punches.

Why it matters:

• Early punch abandonment suggests onboarding or awareness issues
  
  

• Later punch abandonment may indicate reward friction
  
  

• Helps optimize punch requirements and reward timing
  
  

Customer Value by Completion Rate

This table ties completion behavior directly to revenue.

Metrics include:

• Number of customers by completion %
  
  

• Total Transaction Value
  
  

• Total Net
  
  

• Average Net per Customer
  
  

Why it matters:
This clearly demonstrates that:

• Customers who complete or nearly complete cards generate significantly more value
  
  

• Higher completion rates correlate with higher per-customer revenue
  
  

This is one of the most important sections for understanding long-term program value.

How Manufacturers Should Use This Dashboard

This dashboard helps manufacturers:

 ✔ Understand how customers engage with frequent buyer programs
✔ Identify where and why cards are abandoned
✔ Measure the financial value of completed cards
✔ Compare performance to industry benchmarks
✔ Optimize punch counts, rewards, and program structure
✔ Identify high-performing retailers and programs