Details:
We need to get a list of:

• CID
• Name
• Primary Street Address

The filtering criteria would be:

• Contribution Amount is greater than "5.00" AND less than "149.99"
• Contribution Status In Completed is Paid
• Primary Street address is in the US
• Individual contact type

Note from me: They need all donors in this range but I'm wondering if it would be easier to run this based on time range. Maybe run one query for the last 5 years and another one for >5 years.

I've added target-smart-export.zip to the Fundraising folder on the file server. It contains 9 separate parts of the list exported which contains a total of 4,420,345 entries.

I had to do some clean up on the export output as a bunch of records were breaking the CSV layout, and I replaced the empty cells with NULL to make it clearer that they are intended to be empty.

Any questions or addition tweaks needed, fire them over.

Thanks

Jack