Applicable plans: ❎ The free plan, ❎ The complete plan
There’s no ready-made report that shows which users aren’t using Waldo — but you can spot them by combining two existing reports: User Settings and User Adoption.
Here’s how it works:
- Go to the Waldo Administration portal, then navigate to Metrics → Export.
- Select User Settings.
- Select a building (optional).
ℹ️ Note: When selecting a building, Waldo filters users based on their Primary Workplace.
👉 More about Primary Workplace - Repeat the same steps to export the User Adoption report.
- Create an empty Excel file and name it AdoptionAnalysis.xlsx.
- Copy the content of UserSettings.xlsx into a new tab in AdoptionAnalysis.xlsx and rename the tab to UserSettings.
- Copy the content of UserAdoption.xlsx into another new tab and rename it to Adoptions.
In the end, your file should look like this:
Now let’s spot the users who don’t use Waldo:
- In the UserSettings tab, add a new column and type this formula:
=XLOOKUP(A2;Adoptions!A:A;Adoptions!A:A;"This user doesn't use Waldo")
💡 This formula checks if the user in cell A2 appears in the Adoptions tab. If not, you’ll see “This user doesn’t use Waldo”.
You should see something like this:
✅ And there you go — you've identified non-users using the tools already at your fingertips.
Comments
0 comments
Please sign in to leave a comment.