What auction software imports well/easily into Raiser's Edge?

Hi Theresa-

 

We currently use 501 Auctions, but we're also exploring other possibilities. 501 Auctions provides a great customer experience and their support is top notch (they deploy three support technicians to us the day of our auction, provide training to volunteers, and stay with us the entire night to ensure everything goes smoothly), but the data exports leave something to be desired. There are five main reports I use for getting data out of 501 Auctions. Those exports/reports are Silent Auction, Live Auction, Sales (we sell 150 mystery boxes with a grand prize in one of the boxes), Donations (which includes Fund A Need), and Tickets and Sponsorships.


The first thing you'll notice in the screenshot below is that the five report columns don't align perfectly. You can finagle them so that everything does line up, but it takes a little bit of time.

 


Once you get over that hurdle, you'll have to add in any columns of data you need for your constituent import and your gift import.


[Update! I've just discovered they have another report which does combine all five reports I mentioned. You learn something new every day! My comments below still apply.]


For us on the constituent import, that means adding and populating columns for Import Id, Cons Code Import Id, Cons Code, Cons Code Date From, Title, First name, Nick name, Last name, Primary Addressee, Primary Salutation, Gender, Phone Type,  Phone Import Id, Phone Num, Phone is Primary?, Addr Import Id, Pref Addr?, Addr Type, Addr Send Mail?, Addr Lines, City, State, Zip, Country, and another set of Phone columns for email.

 

For the gift import, that means adding and populating columns for Gift Reference, Gift Date, Gift Amt, Gift Receipt?, Gift Receipt Amount, Gift Receipt Date, Gift Code, Gift Type, Gift Subtype, Gift Pay Method, Campaign Id, Appeal Id, Fund Id, Letter Code, Gift Acknowledge?

 
Before combining the five reports into one report, I also add an additional column to each report indicating which report the data came from (Silent Auction, Live Auction, etcetera) so that I can be sure to attach each gift to the appropriate appeal since we have different appeals for Live Auc, Silent Auc, etc..

 

So, in summary, donors love the 501 Auctions experience and the support is outstanding, but there's quite a bit of work that goes into turning their exports into something importable into Raiser's Edge.

 

We sat through the first half of an Auction Maestro demo and they claim to have an integration with Raiser's Edge, but we didn't get that far into the demo as we didn't like what we were seeing on how to configure and manage the software in general. The interface looked really outdated to us.

 

Hope that helps!

We currently use Greater Giving and I've found the export/import to be pretty easy. There are two canned reports which you can Import right into RE, one for Constituents and one for Gifts. However, my org has ImportOmatic which can do Constituents and Gifts at the same time. There is a basic accounting report which shows all the info you need and I pull it in through ImportOmatic.


I'm not terribly sure about Greater Giving since I'm pretty new here and I suspect we are not using it to its fullest potential (story of every DBA's life). It seems straightforward and I've been happy with the support when I have questions.

Theresa Larsen:

We are looking at selecting new auction software and I want to find one that imports all the auction data well into Raiser's Edge. We will have the typical auction activities - ticket sales, live auction, silent auction, raffle, fund-a-need, etc. For years, our organization has been manually re-entering in all of the auction items that each donor purchased into RE but we really want to automate it this year. Any recommendations of ones that are relatively easy to import into RE. Right now we are looking at Greater Giving, BidPal, and Give Smart. Does anybody have good or bad experiences with any of these products? Any other suggestions of products that we should look at?