Add a Query Source View: Constituents with household info rolled up (from the BB Data Warehouse)

We are upgrading to 4.0 and are very excited about the new Rolling Date feature in Queries. However, I was surprised to see that it is only available in a single Source View "Constituents (From the BB Data Warehouse)."

It would be great to also have the same rolling date feature in another Source View for Constituent Household Rollup.

We base our segmentation off of the combined giving history of the Household and it's individual members using the Constituent HH rollup Source View in Queries.  So it would be great to have a similar DW Source view for HH Rollup. Rolling Dates are needed for last gift 0-12 months, 13-24 months etc.

  • Guest
  • Apr 29 2016
Organization Name (Please enter full organization name) Operation Mobilization
Reported Version 4.0
  • Attach files