The Shooting Stars report helps you identify high-spending customers and track changes in their purchasing activity. It displays customers with a lifetime spend of over $1,000 and shows their spending activity over the last eight weeks. Use the report to understand customer trends and plan outreach and relationship-building efforts.
The Shooting Stars report lets you view four types of spenders:
- Shooting Star (default view). Customers whose spending ranks in the top 5% in the last 180 days.
- Rising Stars. Customers who are approaching Shooting Star status. Their spending ranks in the top 5% in the last 60 days.
- At-Risk Stars. Customers whose spending ranks in the top 5% in the last 180 days, but who haven’t made a purchase with your business in the last 20 days.
- Lost Stars. Customers whose spending ranks in the top 5% in the last 365 days, but who haven't made a purchase with your business in the last 40 days.
Use the table of contents below to navigate to specific sections of this article:
Run the Shooting Stars Report
- Select Reporting in the side menu of your CommentSold dashboard.
- Select Customers from the report options listed at the top of the page.
- Define your Start Date and End Date in the fields provided, then select the Retrieve button.
- Scroll to Shooting Stars drop-down and expand to view the report.
CommentSold will display your Shooting Stars customers by default, but you can view Rising Stars, At-Risk Stars, and Lost Stars by selecting those options in the submenu.
Analyze the Shooting Stars Report
The following columns appear on the Shooting Stars, Rising Stars, At-Risk Stars, and Lost Stars views:
- Customer Name. Displays the customer’s name. You can select a hyperlinked name to navigate to the customer’s record.
- Customer Email. Displays the customer’s email address.
- Last Order Date. Displays the last date the customer placed an order with your business.
- Lifetime Spend. Displays the total amount the customer has spent with your business since registering as a shopper.
- Orders Per Week. The graph displays the number of orders the customer has placed per week for the last eight (8) weeks. You can hover over the graph columns to view the specific number.
- AOV Per Week. The graph displays the customer's average order value (AOV) for orders they have placed in the last eight (8) weeks. You can hover over the graph columns to view the specific dollar amount.
FAQs
What is the difference between Shooting Stars and Rising Stars?
Shooting Stars are customers whose spending ranks in the top 5% over the last 180 days. Rising Stars are customers whose spending ranks in the top 5% over the last 60 days and who are approaching Shooting Star status.
How does CommentSold identify At-Risk Stars and Lost Stars?
At-Risk Stars rank in the top 5% for spending over the last 180 days and have not purchased in the last 20 days. Lost Stars rank in the top 5% over the last 365 days and have not purchased in the last 40 days.
How far back does the spending activity graph go?
The Orders Per Week and AOV Per Week graphs show activity over the last eight weeks.
Can I open a customer’s record from the report?
Yes. Select the customer’s hyperlinked name to navigate to their customer record.