Skip to main content

Find Inactive Clients with Latest-Activity Smart Views

Use the new Latest Workout, Latest Weight, Latest Photo, Latest Meal, and Last Check-In columns to build one-click Smart Views that surface clients who have gone quiet.

Written by Xenios Charalambous

FitMetrics tracks the date of every client's latest activity across five different signals — progress photos, weight logs, completed workouts, meal logs, and AI Form submissions. Combined with Trainerize Clients Smart Views, this lets you build one-click filters that surface exactly the clients who need attention this week.

This article walks through the most useful patterns. For a full reference of every column, see Trainerize Clients Table: Complete Column Guide.


The Latest-Activity Columns

Six new columns under Dates & Activity in the Trainerize Clients table:

  • Latest Progress Photo — last upload date

  • Latest Weight Date + Latest Weight — last logged weight and its value (in the client preferred unit)

  • Latest Workout Date — last completed workout (scheduled-but-skipped workouts don't count)

  • Latest Meal Date — last meal log with calories above zero (water-only days don't count)

  • Latest Form Submission — last AI Form submission (check-ins, intake forms, assessments, feedback forms — any form type)

All six are off by default. Enable them via the columns visibility menu in the Trainerize Clients table.

All six are filterable using relative-time operators (older than N days, within last N days) and update automatically as new data syncs from Trainerize.


Inactivity Smart Views (find clients who've gone quiet)

When you filter a date column with older than N days, FitMetrics returns clients whose last activity is past the threshold and clients who have never logged that activity at all. The "Never" clients are often the most at-risk — they show up first in the sorted view.

No Workout in 14 Days

Filter: Latest Workout Date older than 14 days

Catches every active client who hasn't completed a workout in two weeks, including new clients who never started. Pair with a saved bulk message to nudge them all in one click.

No Form Submission This Week

Filter: Latest Form Submission older than 7 days

Surfaces clients who skipped the weekly check-in form (or any other form your business uses on a weekly cadence). Combine with Status = Active to exclude paused or cancelled clients.

Missing Recent Progress Photo

Filter: Latest Progress Photo older than 30 days

For coaches who run monthly photo check-ins. Sort by Latest Progress Photo ascending — clients with "Never" land at the top.

No Recent Weigh-In

Filter: Latest Weight Date older than 7 days

If you require weekly weigh-ins, this view surfaces who's behind.

Stopped Tracking Meals

Filter: Latest Meal Date older than 5 days

Catches clients who dropped off their food log. Combine with a "Check in on nutrition" saved message template.


Engagement Smart Views (find your most active clients)

Same columns, opposite operator: within N days.

Active This Week

Filter: Latest Workout Date within last 7 days

See everyone who completed at least one workout this week. Great for picking testimonial candidates or weekly leaderboard spotlights.

Weekly Weigh-In Compliance

Filter: Latest Weight Date within last 7 days + Status = Active

Quick count of clients who weighed in this week. The Smart View count badge gives you weekly compliance % at a glance.


Composite Smart Views (multiple filters together)

Smart Views can stack any number of filters. A few high-leverage combinations:

At-Risk (about to expire AND silent)

Filters:

  • Remaining Days <= 30

  • Last Coach Message older than 14 days

  • Latest Workout Date older than 14 days

Surfaces clients who are about to expire and have been quiet on both sides — the highest-risk segment for non-renewal.

New & Ghosting

Filters:

  • Days in Program between 1 and 30

  • Latest Workout Date older than 7 days

  • Latest Meal Date older than 7 days

New clients who haven't engaged with workouts or nutrition in their first month. Catch them before they cancel.


Ask FitMetrics AI (Cmd+K) — the natural-language alternative

If you prefer asking questions in plain English, the Cmd+K search bar (top of every page, also known as the Ask FitMetrics AI Experimental command bar) can run the same lookups. Ask things like:

  • "Which clients haven't uploaded a progress photo in 30+ days?"

  • "Who hasn't logged a meal in 14 days?"

  • "Show me the 10 clients with the most recent completed workout"

  • "Who hasn't submitted a form in 7 days?"

The AI returns a markdown table of matching clients. It uses the same indexed columns Smart Views use, so results are fast even with hundreds of clients.

Note: the Cmd+K Ask FitMetrics AI bar is separate from the AI Command Bar in the Program Builder — that one edits workouts via natural language. They're different features that both use natural-language input.


How Fresh Is the Data?

All six latest-activity columns update in real time as new data syncs from Trainerize (or in the case of Last Check-In, when a client submits an AI Form). A nightly drift-correction job double-checks every snapshot against the source data and corrects anything that's out of sync.

In practice: if a client logs a workout in Trainerize, the Smart View reflects it within seconds.


Key Takeaways

  1. Six new columns track each client's latest activity across photos, weight, workouts, meals, and form submissions.

  2. Older than N days filters always include clients who never logged the activity — the "Never" segment is usually the most at-risk.

  3. Stack filters to build composite Smart Views like "At-Risk" or "New & Ghosting".

  4. The Cmd+K Ask FitMetrics AI bar answers the same questions in natural language.

  5. Snapshots update in real time + reconcile nightly — no manual refresh needed.

Did this answer your question?