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

Once it’s lost, trust can be difficult to regain

May 15, 2024

Once it’s lost, trust can be difficult to regain I recall hearing once long ago […]

Share your successes!

May 8, 2024

Share your successes! I was speaking at an association meeting recently and one of the points […]

What are YOUR data integrity reports?

May 1, 2024

What are YOUR data integrity reports? Sitting in an AMS demo with a client recently, […]

You might have to do SOME of the work yourself!

April 24, 2024

You might have to do SOME of the work yourself! Many, many years ago I […]

Don’t manage to the exception!

April 17, 2024

Don’t manage to the exception! One of the universal truths about data management is, wherever possible, […]

It’s always about improvement

April 10, 2024

It’s always about improvement Talking with a client recently, she expressed frustration about one particular project […]

Don’t be a hoarder!

April 3, 2024

Don’t be a hoarder! The simple truth is that it’s almost “free” to collect data. […]

With data analytics (as with most things), keep it simple!

March 27, 2024

With data analytics (as with most things), keep it simple! Over the past several years […]

Don’t forget about periodic maintenance

March 20, 2024

Don’t forget about periodic maintenance Just as most automobiles need periodic maintenance, keeping your data as […]

Users Groups are ALWAYS Valuable

March 13, 2024

Users Groups are ALWAYS Valuable I am a huge fan of users groups. (Here’s a […]

Scroll to Top