Snapshots are required

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

You don’t have to automate EVERYTHING to be successful

January 25, 2024

You don’t have to automate EVERYTHING to be successful I was discussing a data management […]

Technology won’t solve your process problems

January 17, 2024

Technology won’t solve your process problems Over the past few years I’ve watched as many […]

“Screen noise” is a real thing. You might be able to fix it.

January 10, 2024

“Screen noise” is a real thing. You might be able to fix it. One of […]

Success Starts at the Top

December 20, 2023

Success Starts at the Top I recently had a conversation with an association staffer who was […]

Who are you bringing along?

December 13, 2023

Who are you bringing along? Last week I had the opportunity to attend the AWTC […]

Write it down!

December 6, 2023

Write it down! If you’re in the market for a new AMS (or any new […]

Why “weeding the garden” is so important

November 30, 2023

Why “weeding the garden” is so important One of the most important activities for maintaining […]

It’s time to stop excusing association professionals

November 15, 2023

It’s time to stop excusing association professionals I worked in associations for nearly 10 years, […]

More demos is not better

November 8, 2023

More demos is not better When I work with clients on selecting a new system, […]

The database owner should be “passionate”

November 1, 2023

The database owner should be “passionate” I’m frequently asked by my clients: “Who should we […]

Scroll to Top