Where is the best place to find accurate completed registrations numbers?

[mhock]

Hello Community,

As many, I am pulling year end numbers.  I am finding up to a 15% difference between Community Analytics (higher) and the Admin>Metrics>User> Registration report.

Important to note, we are a private community.  You can't find the Community in an SEO search.  You can't register for the Community unless you have a login to one of our products.  This can't be bot traffic. 

Have others seen this issue?  Which report do you trust?

Thanks for insight.

Melissa

[CarolineS]

Hi @mhock!

The most accurate numbers will be from the admin user report (not the one in admin metrics or LSI). The admin user report gives you exact numbers - since it’s a list of all the registered users. You can export it and sum up in excel, or filter to the registration dates you are interested in and count the number of pages of results.

Not sure why the LSI report or the admin metrics ones would be different other than that they may handle partially-completed registrations differently? But I do have high confidence in the admin user report.

Cheers! Happy new year!

[mhock]

@CarolineS,

Thank you for the reply. Any chance you could supply the path to that one?  I only know the two I listed.  I use the User Report.  See screenshot below:

[CarolineS]

Ah, yes, @mhock , we're using the same report. I was thinking there was another report under Metrics > Metrics that was called 'User report' too. My bad!

[lilim]

We are also encountering this problem. Community Analytics and Admin Metrics show one number for Completed Registrations. However, pulling a User Report from Admin Metrics shows a different number when filtering on the registration date for a given month.

@mhock - did you ever figure out why the numbers were different?

[JosephA]

The best place to find registration numbers is in Community Analytics (LSI). In LSI we have recently released a new feature 'Bulk member report' download using which you can also download user reports (similar to the one in Admin-Metrics). Once you download this report, you can filter using the registration date field and get the actual users who registered during that time period. You need to be granted a new community role 'AdvancedAnalyticsUser' to access this report.  Please see more details in this release note  and this page (How to enable the new role)

There is one reason for the discrepancy between the bulk member report and the completed registration metric. The reason is given below. 

• Registration is a 2 level process. Start -> Partial registration -> Completed registration.
• 'Registration date' in the bulk member report is the time when the user completed the first step (Partial registration). 
• The metric 'Completed Registrations' uses the time when the user completed the second step. Hence a minor variance could happen when you compare these two.

We are planning to fix this variance in the 20.5 release.  @NickH 

In case you are comparing with Admin-metrics, there is another reason for variance, that is timezone. LSI is reporting in UTC time zone.  In the Admin metrics, the metrics are reported based in your time zone.

[lilim]

Hi @JosephA - thanks for the information. This is helpful to know.

Are we able to somehow reconcile the numbers by doing a combo of completed / abandoned / reconciled registrations from Admin Metrics? Our community is relatively new and the month we went live we're seeing a 30+ user discrepancy between the user reports and LSI/Admin Metrics.

Also, won't the bulk member export / user reports not include any deleted users and their activity? 

Finally, we are wondering what is the equivalent source to using the Bulk Data API? Could we compare the numbers there to what's in Admin Metrics?

Thank you!

[JosephA]

@lilim , Bulk member report in LSI will have all the users who have completed the registration process. It also includes deleted users, however, in the case of deleted users, we would have already deleted their Personally Identifiable Information (PII) like name, email, etc permanently (so those fields will be blank).

LSI provides 2 aggregate metrics - Completed Registrations, Partial registrations. LSI is the best source for metrics and member bulk download data.  LSI is also the source for Bulk Data API data.

[lilim]

Hi @JosephA - thanks for the response.

We are attempting to use LSI and the Bulk Member export for the registration breakdown. We want to see not only new users within a given timeframe, but if they were employees or not.

However, applying the filter in LSI always brings back no results.

With the bulk member export, we are seeing an issue with the date field not displaying in a consistent format. Is there a suggestion for the best way to format this data?

Thank you!

[JosephA]

@lilim , Completed Registrations and Partial registrations metrics cannot be filtered using Role/Rank. The role is typically assigned after registration so filtering this metric using role may not really provide much value. (Feel free to correct me here)

I checked the second issue where the bulk download date field is displayed in different formats in the excel file. The CSV file downloaded doesn't seem to have this issue. We will investigate the reason behind this.