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 you know, what will you do?

November 13, 2024

Once you know, what will you do? I’ve yet to meet a client who didn’t […]

If it’s not in your AMS, why not?

November 6, 2024

If it’s not in your AMS, why not? I like to tell my clients they’ll […]

Why checkboxes and tags are awesome and dangerous

October 30, 2024

Why checkboxes and tags are awesome and dangerous One of the most common functions in […]

Don’t miss obvious engagement data

October 23, 2024

Don’t miss obvious engagement data What I’ve experienced with my clients over the years is […]

All data requires active management

October 16, 2024

All data requires active management It’s a simple fact of data management that is often […]

Documentation is critical for consistency

October 9, 2024

Documentation is critical for consistency There are so many reasons why documenting your data management […]

Consumer demands change and technology changes

October 2, 2024

Consumer demands change and technology changes When I work with clients on the selection of […]

Why I write

September 25, 2024

Why I write Thirty years ago, I started a new job as director of membership […]

DAN – The Data Analytics Network

September 18, 2024

DAN – The Data Analytics Network I’m a huge fan of users groups (both internal […]

Process before technology

September 11, 2024

Process before technology In a conversation with a client recently, I was reminded (yet again) […]

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top