Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Zuora add Charge-Metrics data

Not planned
Dominik Ruf User

Net MRR is a key metric for any SaaS business / Zuora customer. This is currently not included / available in your data model. I see a ChargeMetric table in the Zuora connector Schema tab but it sais "this object is not available for your tenant". According to Zuora support the only way to report on this metric is via their quite new charge-metric service.

More info here:
https://knowledgecenter.zuora.com/Billing/Subscriptions/Charge_Metrics
https://knowledgecenter.zuora.com/Billing/Subscriptions/Customer_Accounts/A_How_to_Manage_Customer_Accounts/E_Key_Metrics/B_Monthly_Recurring_Revenue#Accessing_MRR

If you don't want to use the rather painful data query interface, I'd recommend the charge-metrics API as interface.

Additional hint if you're up for implementation: It seems Zuora did an initial load of all historical data on 2020-08-19 around 8am so there is no data before that and a spike on data volume at this time.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Bjorn User
    • Edited

    Hi Dominik - these metrics are derived from the underlying raw data, which is why we are not syncing them. Generally our approach is not to sync any denormalized data, because it undermines the quality of the data our customers are getting. Because of that you would need to need to calculate them on your end the way it is described in your second link.

    You can find the reasoning behind this decision here:
    https://fivetran.com/docs/getting-started/core-concepts#sharedresponsibilitymodel

  • Dominik Ruf User

    Hi Bjorn, thanks for your feedback. You are correct that the page in my second link says

    Net MRR = Gross MRR - Discount MRR

    However, if you read further under "Accessing MRR" you'll notice that both Discount and Net MRR are only available via Data Query or Charge Metrics API. So to calculate it myself I would at least need Discount MRR. I do not believe this is available anywhere in your current schema but would be happy to learn if so.

  • Dominik Ruf User

    Hello, wanted to check if there is already any update on this topic?