• Replies 5 replies
  • Subscribers 961 subscribers
  • Views 92 views
  • Users 0 members are here
Related

Membership Current Status - Merged status Not Showing

Neil Cole
$organization

I was wondering if anyone else has the issue of memberships with Merged status not showing up in Analytics (Membership cube)? It doesn't show up as an option in our RAMP hosted Analytics. I'm just trying to figure out if this is a known issue in Analytics or if our organization asked for it to be this way.

Clicking on Advanced and Test, it only shows 5 results for "all":true.

  • $organization

    They are filtered out of the BI views, so Yes, not available in Analytics. I asked this question to Chris Wallingford in a separate post and he mentioned that they will be included in v16

  • $organization

    Answered my own question. This issue is fixed in V16.

  • $organization in reply to Stephen Lang

    Thanks Stephen. I'm glad to hear that it will be in Analytics. I found a record that has a total of 29 memberships in their history (spanning 30 years). All but 4 of them have Merged status, so only 4 show in Analytics.

    I did notice that the Merged memberships level and status show up as (none) in the Contributions cube. Since they are in separate cubes, I can't use the data within the same widget.

  • $organization in reply to Neil Cole

    Yeah, we encounter a ton of duplicate records, resulting in merges, which then renders historical memberships as Merged. Personally I'd love to see that status no longer be a thing, but rather just show as Inactive. Having it marked as Merged doesn't benefit us at all.

  • $organization in reply to Neil Cole

    For those that don't click on the pictures, here are some changes in Analytics in V16.

    1. Merged memberships are now included in the Analytics Memberships cube.
    2. Deactivated memberships are visible in the Analytics Memberships cube, but were excluded from the Contributions cube's membership related fields, even when associated with a contribution. This has been aligned to include deactivated memberships associated with a contribution in the Analytics Contributions cube.

    Stephen, deactivated and merged status' are killing me when trying to count how many memberships expired within a past timeframe. I had to write a SQL query to get the data and then manually edit an extraction with my SQL code to get the constituents as a list in Tessitura. Now that I got a list, I'm finding data not available or partially available in Analytics. Did they renew, doesn't look like it because the membership now has merged status (Membership cube)? Did they make a contribution, the contributions cube shows the membership as (none) because it was deactivated due to an early renewal (now I can't tell the difference between a non-membership contribution and a membership contribution).