Snapshots are required
Recently a couple of different clients have asked me why it's necessary to take a snapshot of data (e.g., a member count) in order to track the history of data (e.g., comparing year over year membership counts). They ask: "Why can't we just query the data from last year?"
The answer? Because your AMS is a transactional database, data changes over time, which makes querying on historical data a challenge. Here's a good example:
A trade association has 500 organization members on January 1, 2022. In June of 2022, two members merge to become one new company. Those two company records are merged into one company record. Any time after that, when a query is run to count all members as of January 1, 2022, the count will now be 499 companies (because two records have been merged into one).*
Because the AMS is a transactional database, data is going to change over time. This is why historical queries can be inaccurate, and why snapshots are necessary.
So if you want to track history or make year over year comparisons, you'll need to take snapshots.
*And in case you're wondering, yes, this also applies to individual membership organizations!
![]()
Wes's Wednesday Wisdom Archives
What AI can’t replace…
What AI can’t replace… I attended a users group meeting for an AMS company this […]
Don’t do that…
Don’t do that… One of my very favorite pieces of advice to give clients is […]
A harsh truth about your members…
A harsh truth about your members… Just over 20 years ago, the book “He’s Just Not […]
Should you chug or sip?
Should you chug or sip? I was recently meeting with two staff at a client […]
Why bother with a consultant when I have AI?
Why bother with a consultant when I have AI? As AI becomes increasingly powerful, the […]
Guardrails can be helpful!
Guardrails can be helpful! When selecting a new AMS, I find my clients are often […]
“If you knew this information, what might you do differently?”
“If you knew this information, what might you do differently?” I had a conversation with […]
Showing is not teaching
Showing is not teaching In my experience, when new staff members are taught how to […]
Data management is improvisation
Data management is improvisation I was listening to a podcast recently featuring TV writer Rob […]
Who own the AMS company is like the weather…
Who own the AMS company is like the weather… When I work with clients to […]
