SLM Reporting and Analytics 3 — Questions and Answers
Question 1: In CRM Analytics for Loyalty Management, what does a 'breakage rate' KPI measure?
- The percentage of members who downgrade tiers annually
- The rate at which issued points expire without being redeemed (Correct answer)
- The frequency of transaction errors in the loyalty system
- The proportion of members who cancel their membership
Correct answer: The rate at which issued points expire without being redeemed
Breakage rate measures the percentage of issued loyalty points that expire unredeemed, representing revenue recognized by the program operator.
Question 2: A loyalty analyst needs to compare redemption behavior between Gold and Platinum tier members. Which report type in Salesforce enables this side-by-side comparison most efficiently?
- Summary report with tier as grouping
- Matrix report with tier in columns and month in rows
- Joined report with one block per tier (Correct answer)
- Tabular report filtered by tier with export to Excel
Correct answer: Joined report with one block per tier
A joined report allows creating separate report blocks per tier that share a common view, enabling direct side-by-side behavioral comparison.
Question 3: Which object stores the historical record of a member's point balance changes that feeds into analytics dashboards?
- Loyalty Member Currency
- Transaction Journal (Correct answer)
- Member Points Summary
- Loyalty Ledger Record
Correct answer: Transaction Journal
The Transaction Journal object logs every credit and debit event affecting a member's point balance, providing the raw data for analytics.
Question 4: What analytic insight does the 'Average Transaction Value by Tier' metric provide to a loyalty program manager?
- It shows how many transactions each tier completes per month
- It reveals whether higher-tier members spend more per transaction (Correct answer)
- It calculates the cost of rewards issued to each tier
- It measures the time between purchases for each tier segment
Correct answer: It reveals whether higher-tier members spend more per transaction
Average Transaction Value by Tier reveals spending patterns across tiers, helping validate whether the tier structure is driving higher spend.
Question 5: A Salesforce admin wants to schedule a loyalty analytics report to email stakeholders every Monday. Where is this configured?
- In the Report Builder under 'Schedule Report'
- In Salesforce Scheduler under Process Automation
- In the Report's detail page under 'Subscribe' (Correct answer)
- In Flow Builder with a Scheduled-Triggered Flow
Correct answer: In the Report's detail page under 'Subscribe'
Report subscriptions are configured on the report's detail page via the 'Subscribe' button, allowing scheduled email delivery to stakeholders.
Question 6: Which Loyalty Management analytics metric helps identify the optimal point-to-currency conversion rate for redemptions?
- Redemption Value Efficiency
- Cost Per Redeemed Point (Correct answer)
- Point Currency Ratio Analysis
- Reward Margin Index
Correct answer: Cost Per Redeemed Point
Cost Per Redeemed Point calculates the actual cost incurred per point redeemed, helping optimize the conversion rate for profitability.
Question 7: In Salesforce Loyalty Management, which dashboard component would best visualize the geographic distribution of high-value members across US states?
- Scatter plot with longitude/latitude coordinates
- Map chart component in CRM Analytics (Correct answer)
- Heat map using custom Visualforce page
- Bar chart grouped by state abbreviation
Correct answer: Map chart component in CRM Analytics
The Map chart component in CRM Analytics natively renders geographic data on a map, making it ideal for visualizing member distribution by state.
SLM Reporting and Analytics 3
In CRM Analytics for Loyalty Management, what does a 'breakage rate' KPI measure?