This article covers
Why is my Renewal report showing subscription ID in some cases and email id at others?
Is it possible to add the customer name under subscription in my renewal report?
Summary
The Subscription column displays the Subscription identifier which gets populated based on the following order depending on which information is available:
1. Email address
2. First Name, Last Name
3. Subscription ID
To sum up the above, if an email address is present for a customer then it takes the first priority and gets displayed under the subscription column. If the email address is not present then the first name and last name are present.
If both email and first name/last name are not available then the Subscription ID of that customer gets displayed.
The Renewal report is currently structured in this logic and that’s why you can see the difference as mentioned below.
Related articles and Documentation