Forum Discussion
sid6mathur
Jul 09, 2024Brass Contributor
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...
- Jul 26, 2024
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
Jul 09, 2024sid6mathur thanks for the feedback here, I'll be passing your suggestion along to the appropriate team.
KyleCallahan
Microsoft
Jul 26, 2024I 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.
- sid6mathurAug 12, 2024Brass Contributor
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
- KyleCallahanAug 12, 2024
Microsoft
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!
- sid6mathurJul 28, 2024Brass Contributor
KyleCallahan Great answer, thanks. Didn't realize one could "JOIN" the Revenue and Orders reports until you mentioned it. That indeed solves the problem.