For all the cool and sophisticated things that you can do in Customer Insights, the one thing that people really want to do (or at least really need to do) is pretty simple: take a look at the total number of user profiles you have today, and compare that with the total number of user profiles you had, say, a week ago. Like we said, pretty simple.
Or at least it sounds pretty simple. However, there have been a few issues that complicated matters (not counting the fact that you had to create these profile-counting queries yourself). For example, you faced the very real problem of knowing what constituted a day, something that can be especially problematic for organizations that span multiple time zones. After all, if it’s 1:00 AM on December 11th in New York City, it’s 11:00 PM on December 10th in Portland, Oregon. If a new user from Portland registers at 11:00 PM Pacific Standard Time, was that profile created on December 10th, or December 11th?
To help clear up this type of confusion, Customer Insights 2.1 includes a new Dashboard called App Profile Counts. By default, App Profile Counts shows you the exact number of user profiles you had as of midnight UTC time for the past 7 days. (It also shows how those profile totals have changed from day-to-day.) In other words:
Two things make App Profile Counts. First, the Dashboard is built on top of a query that automatically runs at the same time every single day (midnight UTC time). That means that you don’t have to do anything: the query has already been written and has already been scheduled to run. All you have to do is open the Dashboard and view the results.
In addition to that, you can be confident that your profile totals are always based on a 24-hour period, and on the exact same 24-hour period. You just have to remember that you must take your local time zone into account when viewing the totals. Yes, if you live smack dab on the Prime Meridian, then that 24-hour period runs from midnight to midnight. But if you live in Portland, OR, that 24-hour period runs from 4:00 PM to 4:00 PM. But for every day displayed in the Dashboard, the 24-hour period will always be the same.
By default, App Profile Counts shows a single value representing the combined user profile totals for all your entity types. However, you do have the option of running your query against a subset of your entity types. For example, this filter only returns the user profile counts for the IT_User entity type:
Depending on how your entity types have been configured, this makes it easy to view profile counts for, say, all your users from Africa, or all your users from southeast Asia.