kmbro-sigma | Stripe Developers | Page 1

near spoke Jul 6, 2022, 3:54 PM

#

For your first question - there isn't a way to get this out of sigma. We have a way of retrieving the next invoice through the API, but the closest thing in Sigma (that wouldn't be that accurate) is just looking at the most recent invoice on the Subscription to get an estimate (but as you can imagine it won't be that accurate)

drifting crescent Jul 6, 2022, 3:55 PM

#

Darn. I was hoping that wasn't the answer. But that is the conclusion I came to before asking here 😂

#

The API has limits that I blew through when i tried to generate this report using it, which is why i wanted Sigma to have it

#

Is there any best practice around projecting MRR? I see stripe does it in the dashboard. If I could somehow duplicate that, but be able to filter it by metadata on a subscription that would be ideal

regal heath Jul 6, 2022, 4:02 PM

#

@drifting crescent we don't really know much about Sigma here

#

I'd recommend working directly with support instead: https://support.stripe.com/contact

drifting crescent Jul 6, 2022, 4:03 PM

#

Ok @regal heath -- I have gotten that on all fronts of stripe support unfortunately.

regal heath Jul 6, 2022, 4:03 PM

#

Yeah I understand but we don't really know much about any of this here unfortunately. I know the tables and I can offer some advice but not any advice on how to do MRR

drifting crescent Jul 6, 2022, 4:04 PM

#

No worries. Support just says "We aren't allowed to talk about specific queries" which is pretty lame.
I have reached out about 8 different times to them about this. I just am trying to find the right place to get projected MRR for my connected accounts. 😄
Thanks!

regal heath Jul 6, 2022, 4:05 PM

#

yeah sorry I can't really help, MRR is extremely complex

drifting crescent Jul 6, 2022, 4:05 PM

#

Preaching to the choir! 😂

#

Another question -- If I only wanted to look at subscriptions that were going to generate another invoice, I was thinking of

getting all subs in my account that are active (not canceled or paused), expanding customers (to get the customer balance for #3) and coupons (also for #3)
filter the subscriptions by "last charge date" + the "interval" (e.g. interval = weeks, interval_count = 2) to get only subscriptions that fall within the 30 days (or calendar month, or whenever I want).
sum the subscription total, associated coupons, and customer balance (min of $0)

I think that will give me the super super rough estimate of what should be charged in the next 30 days/time period I want.

Does this sound reasonable based on your knowledge of the tables @regal heath ?

regal heath Jul 6, 2022, 4:15 PM

#

I'm not sure I even understand the question

#

if you have daily or weekly subs it won't really work right?

drifting crescent Jul 6, 2022, 4:16 PM

#

Right now I only have monthly/quarterly/annual subs, but that is a good point

#

Looks like I have a lot of thinking to do before I am ready to ask a more informed question. Thanks for the help! Feel free to close this channel

#kmbro-sigma