This can be accomplished by setting up a Sustaining Gift Attempt Summary report and filtering down to failed attempts in the last seven days.
  1. Navigate to Data Management > Reports.
  2. Select the Report Writer tab.
  3. Select Create New Report.
  4. From the drop down, select Transactions and mark the radio button for Sustaining Gift Attempt Summary.
  5. Under Step 2., mark the columns that you want in your output file. For this example, we have chosen the following columns: First Name, Last Name, Email, Contact ID, Failed Payment Count, Successful Payment Count, Error Code, Last Try Date, Next Payment Date and Start Date.
  6. Make any renaming or sorting adjustments for steps 3-4.
  7. Under Step 5 Configure Filters, Create a Filter and make the following selections from the drop-down menus starting at the top: "Sustaining Gift Attempt Information" and "Last Try Date and Time" in "Predefined Range" and "Last 7 days".
  8. Create another filter and make the following selections from the drop-down menus starting at the top: "Sustaining Gift Attempting Information" and "Succeeded" and "Is" and "False".
  9. Select next and name the report and give it a description. Save all of your changes.
  10. Run the report. From here you will be able to make the necessary configuration to set up the report to run a recurring basis.