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

Opting out and communication preferences

September 4, 2024

Opting out and communication preferences Last week’s newsletter discussed the need for associations to collect mobile […]

Are you collecting mobile phone numbers? You should be.

August 28, 2024

Are you collecting mobile phone numbers? You should be. Are you collecting (and using) the […]

Spend less time on data management and more on higher value activities

August 21, 2024

Spend less time on data management and more on higher value activities Data management is very […]

Change anything you want, except your name!

August 7, 2024

Change anything you want, except your name! This is an oldy but a goody, but […]

If you don’t trust your vendor…

July 24, 2024

If you don’t trust your vendor… When I start an AMS selection project with a […]

Your RFP should go to no more than five vendors!

July 17, 2024

Your RFP should go to no more than five vendors! As a rule, when I […]

Be concise!

July 10, 2024

Be concise! I started a monthly newsletter almost 25 years ago (which I recently discontinued). […]

A great example of a data integrity report!

June 26, 2024

A great example of a data integrity report! A couple months back I discussed the […]

“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.”

June 5, 2024

“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.” I saw […]

Rather than adding something new, try subtracting

May 29, 2024

Rather than adding something new, try subtracting I read recently that sociological research suggests, when presented […]

Leave a Comment

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

Scroll to Top