TonyS

[icy whale]

👋 happy to help

[primal stream]

Hello Tarzan!

[icy whale]

what are you trying to achieve?

[primal stream]

In the dashboard in the billing section, there is this report MRR per product

I would love to export the data to have the evolution of MRR through multiple month

Apparently it's not possible to export directly such data, hence I'm trying to find an alternative option

[icy whale]

you can either generate the report from the API

[primal stream]

How could I achieve this?

[icy whale]

https://stripe.com/docs/api/reporting/report_run/create

[primal stream]

I'm checking this thank you

[icy whale]

or you can query the invoices and try to create your custom report from the data there

[primal stream]

Do you know how you would tune the query to retrieve MRR per product per day or per month?

[icy whale]

you can leverage Sigma, but you need to contact https://support.stripe.com/?contact=true for more help with Sigma queries

this is the 3rd way of achieving this

[primal stream]

We need to pay for this tool right?

[icy whale]

for pricing questions it's better to contact support, we don't have a lot of knowledge about it on this channel

[primal stream]

Ho ok no worried, but yes I can confirm to you that Sigma would be expensive for us

I'm trying the solution 1 you provided but I'm not very confident it's possible to retrieve the data we want, I'll dig though thank you very much

I think I'll probably end using solution 2 meaning recomputing every refund/charge and divide yearly subscription by 12 which is quite complicated to replicated the figure you show on the report

[icy whale]

unfortunately there's no other easy way to achieve what you want

[primal stream]

Thank you very much for you time, have a great day !