• 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.

Parents
  • $organization

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

  • $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).

Reply
  • $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).

Children
No Data