search

mozilla / donate.mozilla.org

Mozilla donation platform
https://donate.mozilla.org
Mozilla Public License 2.0
64 stars 48 forks source link

Spreadsheet of total donations by US state in 2014 #1159

Open valianttry opened 8 years ago

valianttry commented 8 years ago

@jbuck or @adamlofting is it possible to pull together a simple spreadsheet with these columns:

US state, total donations in 2014

Pamela in accounting needs this for legal filings per each state.

Thank you!

jbuck commented 8 years ago

@valianttry what do we do in the case where we don't know the state? For example, with Paypal I was easily able to calculate per-country totals, but I don't know what state it came from. Also, for sure this is 2014? Not 2015?

valianttry commented 8 years ago

@jbuck 2014 only. We need state only. Each state requires us to register as a charity and need to know as closely as possible how much revenue we made in 2014. Close is good enough.

jbuck commented 8 years ago

I spoke to Pamela really quickly and she said that estimates are also a-okay. Also, it's 4 states (Oregon, Ohio, Indiana, and one other) that require this information, not all of them, thankfully enough.

adamlofting commented 8 years ago

@jbuck do you know if we can get 'State' from the PayPal API? When I looked at these docs I couldn't see it (as we're not collecting a shipping address).

valianttry commented 8 years ago

@jbuck it's likely she'll want other states in the future. It really helps to have one spreadsheet so we don't have to go digging for future one-off requests by state.

jbuck commented 8 years ago

@adamlofting damn, I think you're right. I could've sworn the state was available in the API, but yeah, it totally isn't...

On Tue, Dec 22, 2015 at 3:31 PM, Adam Lofting notifications@github.com wrote:

@jbuck https://github.com/jbuck do you know if we can get 'State' from the PayPal API? When I looked at these docs https://developer.paypal.com/docs/classic/api/merchant/GetTransactionDetails_API_Operation_NVP/ I couldn't see it (as we're not collecting a shipping address).

— Reply to this email directly or view it on GitHub https://github.com/mozilla/donate.mozilla.org/issues/1159#issuecomment-166722991 .

adamlofting commented 8 years ago

One option would be to get the % of US donations in those States via Stripe, and use those %s to estimate the income from those states in PayPal.