Type: Detail
Data Period: Complete Member list, 6 months or more historical data
Data Sections: Members, Attendance, Classes / Bookings and Payments
Complete list of Active, Cancelled and Suspended members from the earliest available date
| Column | Detail |
|---|---|
| Club ID | Club or location ID |
| Member ID* | Unique membership ID |
| First Name | Member first name |
| Last Name | Member last name |
| Email address | |
| Phone | With country code |
| Membership Plan Name** | Current plan name |
| Membership Duration | Monthly, Annual or any other |
| Payment Terms | Monthly, Annual or any other |
| Status | Active, Cancelled, Suspended or any other |
| Date of Birth or Age | eg. 28/02/1990 or 29 |
| Gender | Male, Female |
| State | State name |
| City | City name |
| Street | Street name |
| Zip | Area or postal code |
| Join Date | First join date |
| Start Date | Membership start date |
| Expiry Date | Membership expiry date |
| Cancellation Date | Membership cancellation date |
| Monthly Dues | Monthly membership dues |
Unique member ID should be in all source files. If a member has multiple IDs, we require details on how to identify such members to map the data correctly on aieasyfit.
* Membership type or plan - we require a brief description for each type such as any special provisions like early termination allowed, etc.
Period: Last 6 months or more for active, cancelled and suspended members
| Column | Detail |
|---|---|
| Club ID | Club or location ID |
| Member ID | Unique membership ID |
| Checkin Date | Checkin date and time |
Period: Last 6 months or more for active, cancelled and suspended members
| Column | Detail |
|---|---|
| Club ID | Club or location ID |
| Member ID | Unique membership ID |
| Event Category | Category name |
| Event Class | Class name |
| Event Type | Appointment Booking or Class |
| Event Status | Completed, Cancelled or No-Show |
| Trainer Name | For appointments, if available |
| Date | Class date and time |
Period: Last 6 months or more for active, cancelled and suspended members
| Column | Detail |
|---|---|
| Club ID | Club or location ID |
| Member ID | Unique membership ID |
| Payment | Transaction amount |
| Type | Membership Dues or Pro Shop etc |
| Detail | Item transaction detail |
| Date | Payment date |