Forum Discussion
Solved
Revenue report for SaaS ISVs: Contract duration field to help with Rev Rec
Hello, We are a SaaS ISV, and this is about revenue reporting for Marketplace SaaS offers that have (say) an annual commitment/contract but a monthly billing cadence. I.e., neither a month-to-month...
I agree this is good feedback sid6mathur - you should be able to reference the PurchaseRecordId from Revenue Report to find BillingTerm and BillingPlan fields in the Orders report. Not exactly what you are looking for, but hopefully helps you understand where revenue aligns with a monthly, annual, or an upfront payment for the full term.
justinroyal
Microsoft
Microsoftsid6mathur thanks for the feedback here, I'll be passing your suggestion along to the appropriate team.
KyleCallahanMicrosoft
MicrosoftI agree this is good feedback sid6mathur - you should be able to reference the PurchaseRecordId from Revenue Report to find BillingTerm and BillingPlan fields in the Orders report. Not exactly what you are looking for, but hopefully helps you understand where revenue aligns with a monthly, annual, or an upfront payment for the full term.
KyleCallahan May I request that the pre-built system query for Orders (ID bd1b0cc1-ce45-4578-beba-6fe5a69fd421) contain all the columns the web dashboard offers in the table view? For example, BillingTerm and BillingPlan aren't available in the pre-built one.
Expressed more generally, a pre-built query that covers ALL columns listed in the Orders data dictionary ought to exist in the system-defined list of queries:
https://learn.microsoft.com/en-us/partner-center/insights/orders-dashboard#orders-data-dictionary
We could expand this even more generally to views such as Revenue, where a system-defined query should track what's on the web interface table design for the Revenue view.
PS: By "web interface", version I mean the CSV columns as obtained from the three-dots menu on Orders or Revenue pages.
Thanks,
Sid
- KyleCallahan
sid6mathur Thanks for your feedback. I have forwarded your message along to the proper product managers who work on these reports and dashboards. Your feedback will help inform where improvements can be made, so thanks for being part of the community!
KyleCallahan Great answer, thanks. Didn't realize one could "JOIN" the Revenue and Orders reports until you mentioned it. That indeed solves the problem.
