Happy Business Starts Here

Highlighted
Support SME
Support SME

How to run a customer account report that shows all accounts that don't have a subscription attached

Question or Problem Statement:
I am trying to run a report that shows all accounts we have that don't have a subscription attached to the account. Is that possible?






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Support SME
Support SME

Re: How to run a customer account report that shows all accounts that don't have a subscription

Solution:

If you are interested in knowing how many active customers you have in Zuora which do not have an active subscription - this report is for you! 

 

1Run a Customer Account report with the filter Account.Status = Active, so that we can only pull out all the active accounts.

1.png

 

2).To run a subscription report with the filter Account.Status = Active, so that we can only pull out all the active accounts with subscriptions.

2.png

 

3).Filter the duplicate account from subscription report CSV.

 

4).Combine the account CSV and subscription CSV with Excel Vlookup function.


Supporting References:

https://knowledgecenter.zuora.com/CD_Reporting/D_Data_Sources_and_Exports/AB_Data_Source_Availabilit...






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √