Is there a household id that can be exported?

Unfortunately, no. Households aren't a concrete unit in RE. The existence of a household is determined solely by the existence of a relationship with the "spouse" checkbox checked. 


RE is a per-individual system, not a per-household system. There are pros and cons to each model, but when you're used to one, trying to figure out how to deal with the other can be a pretty big pain.


You could try running whatever query you have through an export, checking the "export only head of household" box, and then making sure you set any gift information outputs such that soft credits are counted on 'both' records and that it defaults to the distribution on the gift record. This would group all gifts hard credited to either spouse on a single export line, assuming that you are automatically soft crediting spouses for each gift. However, by the sounds of what you're trying to do, this doesn't seem like a perfect solution. 


The only complication comes in cases where other kinds of gifts are soft credited only to one spouse or the other, which is why some experts suggest not to use soft credits at all unless they are spousal soft credits. 


Another thought - you could potentially use primary address line 1 + zip code as a key. It seems likely that almost every household will share a unique address, though you'll certainly want to check for duplicates once you've generated this combined value in Excel.

Yeah, I've attempted to do something similar before. I got results, and I could verify the accuracy in spot checks, but I always felt iffy about whether or not their were major errors hidden in the resulting data.


Godspeed. 

@Sammy Darren:

@Ryan Hyde Yes, a household ID can often be exported from systems like CRM or census databases. This allows for easier data management and analysis across different platforms or for reporting purposes. <!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}-->First EGP

While the bold statement is true, it is only true if it exists. Raiser's Edge does NOT have a household object so there is no ID field available I'm only adding that here for future readers of this thread.

@Alan French:

@Karen Diener I think Sammy may be a bot - very generic answer from a new account with a link to an external website

Good point! Also picking up on an old thread. Real live people sometimes do that too, but this definitely lines up with your two observations.