⚠️ Legacy Process: This process is no longer in use by Ace Makerspace and this post was last edited on February 2, 2022.
It is retained for reference only.
This process was last followed in May 2023. Archived in 2026.
It is retained for reference only.
This process was last followed in May 2023. Archived in 2026.
The monthly metrics are run as part of the State of the Organization Report (SOO).
Admin access to the primary site and the spreadsheet on the Ace google drive is required.
Pulling Membership Numbers
- Login to acemakerspace.org
- Download the data as CSV’s using the following links:
- https://www.acemakerspace.org/export/members-full/?part=1
- https://www.acemakerspace.org/export/members-full/?part=2
- https://www.acemakerspace.org/export/members-full/?part=3
- https://www.acemakerspace.org/export/members-full/?part=4
- Merge all the data into one spreadsheet before scrubbing
- Remove all non-active accounts
- Remove all accounts that are not in the date range
- Remove all development accounts
- Remove contractor accounts (cleaners, remote dev.s that don’t use the space)
- Add Membership Count Data Column and populate
Soft Demographics
Scan through the Membership director and count the categories.