How to report Salesforce1 mobile app usage?

Bad thing, in the user login report, you cannot identified which login is coming from Salesforce1. Work around, you can download Login History into CSV file and using Ms Excel to filter Application contain Salesforce1. It is pretty complex using Login History and you cannot run it as a report to use it as source for Dashboard and present it your management team.

Instead of using standard User report type, create a new custom report. Here is the step:

Create Custom Report Type
Start with create a new custom report type:
•  From Setup, click Create | Report Types
•  Click New Custom Report Type button
•  Enter the following values.
•  Primary Object: Users
•  Report Type Label: a unique label such as Login History with Identity
•  Report Type Name: this field will be automatically populated based on Label, just skip it.
•  Description: Give a useful description that other user will understand in the future.
•  Store in Category: Pick a category for this report; such as Administrative Reports.
•  Deployment Status: Keep as In Development until ready to deploy this report for other users.
•  Click Next
•  Select Click to relate to another object
•  Select Identity Event Logs (Users)
•  Keep A to B Relationship to default \”Each \”A\” record must have at least one related \”B\” record\”

•  Click the Reports tab and New Report button
•  In Administrative Reports, select Login History with Identity and click Create.
•  Drag-and-drop fields on to the report. Some useful fields to add into report: Full Name, App: Connected App Name, Timestamp, Status and Usage Type
•  Add filter “App: Connected App Name contains Salesforce1”
•  Give the report a name, such as: Salesforce1 Adoption.
•  Click Save
As this is a normal report, you can adjust the Time Frame.

Here is the screenshot of the report created:

If you see above report, in Usage Type:
•  OAuth Authorization: when the user first logs in
•  OAuth Token Exchange: when user has been idle for some time and the app needs to re-authenticate
In the Status, Error: App access denied tell you if user hit \”Deny\” in Salesforce1 app

Another example of report below, App: Connected App Name tell you each transaction of login attempt or re-authenticate attempt from Salesforce1 app from iOS or Android devices.

Using the \”Power of One\”, you can easily count how many users login to Salesforce1 app from iOS and Android device, then add a simple chart to the report. In sample below, it show number users for Android = 34 and iOS = 276, with total of 305 users. This mean 29 (34 – 5) users using Android only, 271 (276 – 5) users on iOS only and 5 users are using both Android and iOS devices to access Salesforce1.

If you need to do further analysis, you can download the CSV file and use Pivot Table in Ms Excel.