NickVanHoof-balance

[zealous smelt]

what do you mean by 'balance per product' exactly?

like how much revenue/volume has been processed on payments that were using that Product?

[rare heart]

Hi karllekko, thanks for getting back to me.
Yes indeed, that is what I am looking for!

[zealous smelt]

ah fair enough. Yeah, for some reason we don't have a reporting pipeline that specifically exports a breakdown like that, and I don't think the reports you can generate include columns to help with directly tying it together yourself(https://stripe.com/docs/reports/report-types)

There are some dashboard-only reports for MRR (https://support.stripe.com/questions/billing-analytics-dashboard) which might help you.

But overall I wish there was a better option but tagging payments and running a job to count them up over a time period in your own integration is mostly the way to go today.

(or there might be third party reporting platforms you can attach to your account https://stripe.com/partners/apps-and-extensions that do some of this already)

[rare heart]

Thanks for all this info.
Is there an API endpoint (either sigma or stripe reporting) that I could use to run a predefined (self written) query (and via the API I then provide the productId)

Cause I imagine I could write the query to give me revenue per product in Sigma. If tag all my charges / payment intents with the productId.
But then I need a way to provide the product Id dynamically to the query. Which is why I am thinking about providing it via an API.

[zealous smelt]

Sigma is the only way to run a user-defined query like that

I think you can schedule Sigma queries(https://stripe.com/docs/sigma/scheduled-queries) but I don't know about including variables in each run. Sigma is not something my team knows about unfortunately

[rare heart]

Okay, I'll look into that.