I’ve chatted with a few customers about this lately — while you can always get fancy with Power BI or use our Salesforce activity sync feature, sometimes a good old Excel export does the trick 😅
Here’s how you can quickly see activity by company domain using just the User Export and some simple formulas.
Step 1: Export Your User Data
From your dashboard:
- Go to Moderation → Users → Export.
- The export will include fields like:
Email, First Visit, Last Visit, Points, Posts, Rank ID, Rank Name, Roles, URL, User ID, Username
…plus any custom profile fields you’ve configured.
📄 If you’re not familiar with configuring which columns show up, you can read more in the docs.
Step 2: Bring It Into Excel
Now that you’ve got your download, you can bring it into Excel (or Google Sheets) to start playing with the data.
👉 You can name the tab whatever you like — I usually rename it to Raw Data since the default export filename is long and annoying cumbersome.
Most communities don’t store “organization” as a field, so the trick is to use the email domain as a proxy for company.
In your export tab (let’s call it Raw Data), add a new column called email domain and use this formula (assuming Email is in column A):
=RIGHT(A2, LEN(A2) - FIND("@", A2))
This will return just the part after the @, like higherlogic.com. Copy the formula down for all rows.
In a new tab called Dashboard, start by pulling in the unique email domains:
=UNIQUE('raw data'!B:B)
(Assuming column B is your email domain column in the raw data tab).
Step 3: Add Formulas for Key Metrics
For each domain (starting in row 2 of your Dashboard tab):
=COUNTIF('raw data'!B:B, A2)=SUMIF('raw data'!B:B, A2, 'raw data'!G:G)=SUMIF('raw data'!B:B, A2, 'raw data'!F:F)=COUNTIFS('raw data'!B:B, A2, 'raw data'!E:E, ">" & TEXT(TODAY()-30,"yyyy-mm-dd") & "T")
⚠️ These formulas are based on the column order from my demo site export. Your export might have more or fewer columns, or you may want to delete private things like IP addresses. If that’s the case, just adjust the column references.
💡 Pro tip: You can paste your actual export headers into an AI tool (like ChatGPT) and have it generate the formulas for you. Here’s a prompt you can use
I have an Excel export with the following columns: [paste your column headers]. I want to build a dashboard that shows, by email domain: - # of users - # of posts - total points - # of users logged in during the last 30 days Please write the Excel formulas I should use, assuming the raw data is on a tab called "Raw Data" and the domains are listed in column A of a "Dashboard" tab.
Step 4: Review Your Dashboard
That’s it! Once set up, you can:
- Drop in a new User Export anytime → the Dashboard updates automatically.
- Quickly see which companies are most active, how many posts they’ve made, and how many users logged in recently.
Want More?
This method keeps it simple with logins, posts, and points. If you want to go deeper (like reactions or accepted answers), that requires using the API. If that would be helpful, drop a comment below 👇 and I’ll put together a follow-up post with API examples :)
✨ Over to you:
- How are you reporting on community activity today?
- Do you have any of your own tricks (Excel or otherwise) to make this easier?
Share your approaches below — I’d love to see the creative ways you’re tackling this! 🤓
