I created graph on our Sales dashboard that reports out how many leads have been added by each user, each month. Strangely, one of our users (has an assigned ID, can look them up on our list of added members, let’s call him User X) comes up as “Unknown user”. I can find User X’s list of contacts if I search for him by user ID, so the contacts are in our list of contacts.
User X also doesn’t show up as the Owner of any contacts, despite the fact that all of these contacts are listed as “Owned” by User X when searched for in “Contacts”. I tried also changing the time bounding to look at all contacts in the history of ever being added, and User X still does not show up.
Any ideas on what the cause is? Is User X’s account broken? Should we delete and re-add him and his contacts?
Update, we’ve identified that for some reason the report is not even pulling this data in. Those 29 contacts from “Unknown user” do not map back to User X. For some reason, the report is not pulling in the contacts from User X, even though we can find them under “Contacts”.
Yep, active user and has access to new leads. I can actually view his leads.
Found out what the issues - though it’s unsatisfying. You apparently can’t create this through single object report; has to be ‘custom report builder.’
A HubSpot veteran on our team figured this out. For reasons that aren’t totally clear, if you want to create this you should do it through “Custom Report Builder”, NOT “Single Object.” Why? I don’t know. But hey it works now.
This is what it looks like when you select “Single Object Report”. It grays out the option to select “Created by user ID” if you add “Count of Contacts”; though you can trick it into creating a report by adding other valid variables and then “Created by user ID”…though this generates a broken report.
THIS IS WHERE YOU SHOULD CREATE THE REPORT (Custom report builder). It should look like this, with # signs next to the variables and the ability to drag “# Created by user ID” into the field.
