This alert will check last Contract invoice and alert if the overage is greater than Variable W % of the Base copies AND/OR if the underage is less than Variable X % of Base. The alert looks at the last week of invoices, therefore this alert should be run weekly so that your team can react quickly to any significant underage/overage charges.
Variable W: set the % for overages to check. If you don't want to check for overage put 999.
Variable X: set the % for underages to check. If you don't want to check for underage put 999.
Variable Y: either set to 1 or 0. A '1' means report invoices where counted copies greater than 1, '0' means report all invoices.
Sample Output:
1) Example of Underage less than 30% 2) Example of Overage greater than 30%
Alert ID256 is an alert for last 3 months over previous 3 months volume trending on invoiced clicks. But it requires that a contract have at least 2 quarters of billing to work.
0 Comments