How to Setup Alerts in Report Toaster
In this article, we'll look at one of the more underutilized features in Report Toaster - using Scheduled Reports to setup Alerts for your store!
What are Alerts?
Alerts are email notifications that can warn you of any changes in a key report.
The applications are very broad, but a few common use cases include things like:
- Letting you know if certain products are low stock/out of stock.
- Letting you know if products are missing certain details.
- Letting you know if items fall below a certain threshold on Days Available, based on Sales Velocity.
- Letting you know how well a certain sale is performing.
The core idea here is that you use alerts so you don't have to keep checking on certain reports manually.
Basically, Alerts give you only the information you need and only when you need it.
Let's look at how to set this up.
Creating the Report
First, we need to create the custom report that includes the things we care about.
For this example, we'll use the Low Stock Products report, found in the Inventory section:
Here you can see that the report shows any products in my store that have less than 10 units available
(I can adjust this threshold to anything I want via changing the filter).
Once I've customized the report in terms of filters, columns, dates, sorting etc, I just need to Save to My Reports for future use.
Setting Up Alerts
Next, we simply create a Scheduled Report.
First, the important thing here is to choose a frequency that works for you.
For most people this might be daily, but if it's something you expect to change often, then even an hourly frequency might be a good idea.
The most crucial part of setting up an Alert is that we use the 'Skip Empty' feature.
Skip Empty ensures that the scheduled report will ONLY send if there's actually something to show in the report (i.e. it isn't blank or has no results).
Finally, make sure the recipient(s) are the people who are most capable of taking action on those items in your store.
Don't forget you can always have multiple recipients here. This is a good idea if you're managing staff and need to be kept in the loop for what's happening.
(or you just need redundancy in case somebody missed the message!)
Here's how the end result might look.
Click Save and then that's it, you're done!
Common Use Cases
Now that we understand how this works, let's take a look at setting up some alerts for some really common situations:
1.) Days Available <X
The Sales Velocity report that measures how fast items are selling, so let's say I want an alert whenever I have less than 30 days available of a particular SKU.
Perhaps I know it can take a month to reorder certain items from my supplier, or I just always want a good amount of inventory kept in stock?
First, we can go to the Sales Velocity report, and add a Metrics Filter to limit the results to only items between 0-30 days available:
Save this and schedule it following the process above.
2.) Product Cleanup
This report tells me if I setup products in my store and forgot to include certain details.
(e.g. missing costs, missing images, missing skus, missing product type...)
Simply change the filter for Product Issues for the things we care about (e.g. here I just limited the results to those products missing a product type)
See below for other great reports to use in the exact same way:
Duplicate SKUs
Low/High Margin Products
3.) Sales Performance
There are lots of great examples here:
- Suppose I setup a particular discount code and I want to get notified when anybody uses it?
- Suppose I'm running a new ad campaign and want to see if it resulted in any sales?
- Suppose I just launched a new customizable product and want to be notified of any custom orders?
The principle is always the same. Filter the report to only the results you care about*,*Save it, and Schedule the Alert.
And then that's basically it!
If you need help setting up Alerts for your account then please contact us at support@cloudlab.com and we'll be happy to help you out.