Skip to main content

Understanding Your Membership Metrics and Exports

Learn more about why Join It's metrics and charts might not match your membership records.

Written by Mitch Colleran

Summary

Your membership charts, automated reports, and membership exports help you understand different parts of your organization’s performance.

When comparing them, you may notice that the numbers don’t always match. Often, that’s because they answer different questions:

  • Activity metrics: How many joins, renewals, expirations, or cancellations happened during a period?

  • Membership exports: Which memberships match your filters, and what details are stored on them now?

  • Payment reports: What payments were recorded?

This guide explains how those differences work, which information appears in your reports, and how to compare your numbers.

Membership activity and membership records

Think about the difference between a member’s current details and their membership history.

A membership record shows information such as its current status, membership type, joined date, and expiration date. Those details can change over time.

Activity reporting keeps track of actions along the way. Throughout this article, we call these actions events—for example, joining, renewing, expiring, or cancelling.

One membership can have several events.

Here’s an example:

Date

What happened

January 10

A membership joins your organization.

February 10

The membership renews.

March 10

The membership expires.

March 15

The membership renews and becomes active again.

After March 15:

  • Your active membership export includes one membership.

  • The membership’s history includes one join, two renewals, and one expiration.

  • March’s activity includes one expiration and one renewal.

All of these figures can be correct. The export shows the membership’s current details, while the activity figures describe what happened.

Renewing does not erase the earlier expiration. That expiration remains part of the membership’s history.

What the main membership metrics mean

Metric

What it counts

What to keep in mind

New memberships

Recorded join events during the period.

A membership can count even if it has since become inactive.

Renewed memberships

Recorded renewal actions during the period.

One membership can renew more than once.

Churned memberships

Recorded expirations and cancellations during the period.

A membership can later renew and become active again.

Active memberships

Memberships counted as active under that report’s criteria.

This is a membership total, rather than a count of actions.

These figures count memberships and membership activity. They should not automatically be interpreted as counts of unique people, households, or payments.

For example, someone with two membership records may contribute more than once to your membership totals.

How this information appears in your reports

Join It’s reporting tools can combine activity figures, membership totals, and payment information. That means different sections of the same report may use different counting rules.

Report or feature

What it helps you understand

Membership Metrics

Trends in new, renewed, churned, and active memberships over time.

Monthly Metrics Report

The previous month’s membership activity, membership totals, and payment performance.

Weekly Metrics Report

Recent activity, current membership information, and payment figures.

Membership exports

A list of memberships matching your filters, with the fields you choose.

Renewal Memberships Report

Membership records selected using renewal-date filters.

Payment reports

Transactions and financial details.

You can explore membership charts under Insights → Metrics. Learn more about Membership Metrics.

Understanding your Monthly Metrics Report

The Monthly Metrics Report combines several views of your organization:

  • New This Month counts recorded joins during the month.

  • Churned This Month counts recorded expirations and cancellations during the month.

  • The new-versus-renewed chart compares those activities over time.

  • Active membership figures and membership type tables use membership information.

  • Payment figures use payment information.

One useful distinction: the membership type table’s “New this Month” figures use memberships’ joined dates and status criteria. The headline new-membership figure counts join events.

For that reason, adding together the membership type table’s new-membership figures may not reproduce the headline total.

The report covers the previous month. You can manage it under Insights → Automated Reports.

Understanding your Weekly Metrics Report

The weekly report also combines membership activity with membership details.

Its reporting period is the previous Sunday–Saturday week, shown on the report.

A particularly helpful distinction is:

  • “New This Week” in the summary counts memberships that are currently active and have a joined date within that week.

  • The growth charts count recorded joins and renewals within each week.

For example, suppose a membership joins on Monday and expires on Friday.

Its join can appear in the weekly growth chart. However, it would not qualify for a summary that requires the membership to still be active when the report is generated.

You can manage the weekly report and its admin recipients under Insights → Automated Reports.

Why your metrics may differ from a membership export

A membership export gives you a list of memberships matching your selected filters. It usually contains one row per membership, with details available when the report runs.

An activity metric counts actions during a period.

Here are the most common reasons those totals differ.

One membership can contribute several activities

Suppose one membership renews twice during your selected period.

The renewal chart can count two renewals, while a membership export contains one row for that membership.

Neither figure is necessarily wrong: one counts renewals, and the other counts memberships.

Today’s status may differ from the status during the reporting period

Suppose a membership expires in April and renews in May.

It can appear in:

  • April’s churn activity.

  • May’s renewal activity.

  • An active membership export run after the renewal.

Similarly, an export of currently expired memberships may include memberships that expired months or years before the period shown in your chart.

The dates being compared may be different

A membership can have several relevant dates:

Date

What it tells you

Joined date

The joined date saved on the membership.

Activity date

When Join It recorded a join, renewal, expiration, or cancellation.

Expiration date

The expiration date currently saved on the membership.

Renewal dates

When recorded renewals took place.

Payment date

The date associated with a payment.

For example, changing a membership’s joined date from June to January can change which joined-date export includes it. That edit does not automatically move its original join activity from June to January.

Likewise, an export filtered by expiration date is not the same as a count of expiration activity recorded during that period.

Imported memberships may not have matching historical activity

Importing existing memberships brings their membership information into Join It. It does not recreate every join, renewal, expiration, or cancellation from their earlier history.

For example, if you import 200 active memberships, they can appear in your active membership totals and exports without adding 200 join events to your activity charts.

This is especially relevant when comparing your first reports after moving to Join It.

Deleting or merging records changes the membership list

Deleting a membership removes it from future membership exports. Ordinary deletion does not automatically erase its previously recorded activity.

Similarly, merging duplicate memberships can reduce the number of rows in your export while leaving earlier activity in historical totals.

A cleaner membership list therefore does not necessarily produce smaller historical activity figures.

Membership details can change

A membership may change type after joining or renewing.

An export normally shows its current membership type. Historical activity may be associated with the type it held when the activity was recorded.

Keep this in mind when comparing results by membership type.

The figures may have been prepared at different times

A downloaded PDF reflects the report when it was generated. A fresh export uses information available when that export runs.

Monthly membership metrics are also calculated periodically, rather than updating immediately after every change. A recent renewal or correction may therefore appear in membership information before it appears in a monthly chart. Read more about metric update timing.

Choosing the right report

Start with the question you want to answer:

Your question

Best starting point

How much joining, renewal, or cancellation activity did we have?

Membership activity metrics.

Which memberships are active now?

An active membership export.

Which memberships have a joined date in this period?

A membership export filtered by joined date.

Which memberships renewed?

The Renewal Memberships Report, including the Renewals column.

Which memberships have an expiration date in this period?

A membership export filtered by expiration date.

How much money did we collect?

A payment report.

You can choose filters and fields when running membership exports. Learn more about running reports.

Frequently asked questions

Does “new memberships” mean people who have never belonged to our organization before?

Not necessarily. It counts recorded joins associated with membership records.

Someone who creates another membership may generate another join. The metric does not automatically combine memberships belonging to the same person or household.

Are free memberships included?

Yes. The main new, renewed, and churned activity figures are not limited to paid memberships.

Use payment reports when you need to understand payments received.

Does every automatic recurring payment count as a renewal?

No. Automatic recurring payments and membership renewal actions are tracked separately.

A recurring charge can appear in payment reporting without adding a renewal to the membership renewal metric. Use payment reports to review recurring charges.

Does adding an offline payment also renew the membership?

Only when the workflow also processes a membership renewal.

Recording a payment alone should not be assumed to renew the membership. Directly editing an expiration date is also different from processing a renewal.

Does a renewal mean payment has been received?

Not necessarily. For example, a renewal can be recorded while an offline payment is still due.

Check the associated payment information when confirming whether dues have been paid.

Can the same membership count as both churned and renewed in one month?

Yes. A membership can expire early in the month and renew later that month.

Both actions count toward the month’s activity, even though the membership is active again by the end of the month.

Does cancelling automatic rebilling immediately count as churn?

Not necessarily. A membership can remain active until the end of its current term after future rebilling is switched off.

Stopping future payments and ending the membership are separate steps. Churn figures follow recorded expiration and cancellation activity.

Why doesn’t new memberships minus churn equal the change in active memberships?

Activity counts and active membership totals measure different things.

Imports, deletions, direct status changes, returning memberships, and reporting dates can all affect the relationship between them.

Renewals also do not always increase the active total. Renewing an already active membership extends it without adding another active membership.

How are group memberships counted?

Membership activity is associated with the individual membership records within a group.

If a group renewal renews four memberships, it can produce four renewal events—even if the group makes only one payment.

Why does my renewal export have fewer rows than the renewal chart?

The chart counts renewal actions. The export lists membership records.

A membership with multiple renewals can appear as a single exported row. Including the Renewals column helps you review the dates associated with each membership. Learn more about tracking renewals.

How far back can I report on renewals?

Join It’s renewal-reporting tools support recorded renewal history from December 1, 2023. Do not expect these reports to provide a complete renewal history before that date or to recreate renewals that happened before a membership was imported. Read the renewal reporting history note.

Can I use an export to see exactly who was active on a date in the past?

A current export filtered to an older date still uses current membership information.

For example, selecting memberships with joined dates before December 31 does not, by itself, recreate the exact active membership list from December 31.

Activity charts and monthly totals also do not contain a complete historical copy of every membership’s details.

Does the churn figure explain why members left?

No. It counts recorded expirations and cancellations.

Cancellation-reason insights are a separate feature based on feedback supplied during the member cancellation process. They do not cover every expiration or administrative cancellation. Learn more about Membership Churn Insights.

What should I check if two figures still don’t match?

Work through these checks:

  1. Compare the same thing. Are both figures counting memberships, activities, or payments?

  2. Match the dates. Use the same reporting period and check which date each report filters.

  3. Match the filters. Review membership status, membership type, and other restrictions.

  4. Check for repeated activity. One membership may have several renewals or other events.

  5. Consider recent changes. Imports, merges, deletions, and date or status edits can affect comparisons.

  6. Check when each report was generated. A saved report and a fresh export may reflect different information.

  7. Review a few examples. Compare specific memberships’ renewal dates, activity, and payments.

If you still need help, contact Join It Support with the report or chart name, reporting period, filters, the two totals you’re comparing, and a few example membership IDs. These details help us investigate the difference.

Did this answer your question?