Memberships by Guest

List of guests in a pivot table showing membership packages they have.

Parameters

Membership Package: membership package name

Column Visibility: select which columns you'd like shown in the report

Expiration Date On or Before - memberships expiring before this date.

Fields

Guest Id: guestId of the guest associated to the membership

First Name: first name of the guest associated to the membership

Last Name: last name of the guest associated to the membership

Primary Email: primary email of the guest associated to the membership

Birthdate: birthdate of the guest associated to the membership

Guest Street Address 1: primary street address line 1 of the guest associated to the membership

Guest Street Address 2: primary street address line 2 of the guest associated to the membership

Guest City: primary city of the guest associated to the membership

Guest State: primary state of the guest associated to the membership

Guest Zip Code: primary postal code of the guest associated to the membership

Guest Account Name: guest account name of the guest associated to the membership

Guest Account Id: unique guestAccountId of the guest associated to the membership

Account Street Address 1:primary street address line 1 of the guest account associated to the membership

Guest Street Address 2: primary street address line 2 of the guest account associated to the membership

Guest City: primary city of the guest account associated to the membership

Guest State: primary state of the guest account associated to the membership

Guest Zip Code: primary postal code of the guest account associated to the membership

Account Primary Email:  primary email of the guest account associated to the membership

Membership Package Name(s): the column pivot portion of the report variably lists your membership package names 

Total: total count of all membership package names