Subject: RE: NFC sheet
From: "Johnson, Matt" <[email-masked]>
To: "Parrish, Daniel" <[email-masked]>
Cc: "Hoffman, Alex" <[email-masked]>
Date: Mon, 16 May 2016 07:30:39 -0700

Hey Team,
  Happy to chat tomorrow. One thing I want to flag is that before we do any significant work, we should double-check with Legal.

From: Parrish, Daniel
Sent: Friday, May 13, 2016 5:22 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: Re: NFC sheet

Interesting. I know it's technically an off week, but could we discuss that more on Tuesday? That might be really useful, but I want to talk to some of the people in our dept first.

On May 13, 2016, at 5:06 PM, Johnson, Matt <[email-masked]<mailto:[email-masked]>> wrote:
My understanding is that FEC data can't be used for prospecting donors, but can be used on our current donors.

So, for example, if we have a donor that has dropped off, we can see where else they are giving/etc. I don't think that's overly useful, but it might be nice to know how they ARE spending their money before jumping on the phone.

In addition, without the aggregate amounts across campaigns/committees, we could see how much they are giving in general.

I dunno; I'm just spitballing ideas right now.

-Matt

From: Parrish, Daniel
Sent: Friday, May 13, 2016 4:12 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Haha I know, it would make life so much easier.

From: Johnson, Matt
Sent: Friday, May 13, 2016 4:05 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Yeah, no problem.

If only the FEC allowed us to do it for other organizations as well. :/

-Matt

From: Parrish, Daniel
Sent: Friday, May 13, 2016 4:02 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet

That's perfect. Thank you so much for this!

From: Johnson, Matt
Sent: Friday, May 13, 2016 3:19 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Hey Team,
  I added these to the yearly report!

It should be anyone who gave more than $5k over the years.

The totals are a huge blanket of donations. It doesn't matter how/where the money is coming from, just that it came in.

-Matt

From: Parrish, Daniel
Sent: Thursday, May 12, 2016 10:02 AM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Hey, one more question - could we add email, work phone, and home phone after the region column? We should be all set then.
Thanks!

From: Parrish, Daniel
Sent: Wednesday, May 11, 2016 6:14 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: Re: NFC sheet

Looks great! And thank you for the other report- that's going to be a huge help. Is this everyone from 5k+ to any account? I forget where we ended up on who to pull from. And this also updates nightly?
Thanks again!

On May 11, 2016, at 5:36 PM, Johnson, Matt <[email-masked]<mailto:[email-masked]>> wrote:
Yeah! Take a look.

From: Parrish, Daniel
Sent: Wednesday, May 11, 2016 5:36 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: Re: NFC sheet

Haha sounds good. Thanks!

On May 11, 2016, at 5:33 PM, Johnson, Matt <[email-masked]<mailto:[email-masked]>> wrote:
Hey! I didn't think we could but apparently we can.

-Matt

From: Parrish, Daniel
Sent: Wednesday, May 11, 2016 5:01 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Yep! All looks good. We just had one more request from Max - could we combine TX/OK and South on the regional tabs? He does both, so it's helpful to see the distinction, but he'd like them in one place. Is that possible?
Thanks!

From: Johnson, Matt
Sent: Wednesday, May 11, 2016 10:43 AM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Looping back: everything working with this at least? The formula are still there, and it says everything ran last night.

-Matt

From: Parrish, Daniel
Sent: Tuesday, May 10, 2016 3:41 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Perfect. Thank you so much! And no rush on the other report - by the end of the week is definitely fine.
Thanks again!

From: Johnson, Matt
Sent: Tuesday, May 10, 2016 3:40 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Cool; I've updated the scripts and we are good for tomorrow.

I'll try and tackle the report we talked about later today.

-Matt

From: Parrish, Daniel
Sent: Tuesday, May 10, 2016 3:32 PM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Thanks! I just updated it on the master, let me know if you have any questions!

From: Johnson, Matt
Sent: Tuesday, May 10, 2016 2:16 PM
To: Parrish, Daniel
Cc: Hoffman, Alex
Subject: RE: NFC sheet

Yeah, absolutely! You want to add the columns and formulas and I'll update the script?

We could knock this out today.

-Matt

From: Parrish, Daniel
Sent: Tuesday, May 10, 2016 10:50 AM
To: Johnson, Matt
Cc: Hoffman, Alex
Subject: NFC sheet

Hi Matt,
We'd like to add two columns just to the right of the convention package column that will not be overwritten (so we can add formulas). Is it possible to add them this afternoon? Some of the finance staff asked about the possibility of including it just after we got back, so we'd love to get it all set today.
Thanks!
Dan

-------------
Daniel Parrish
Democratic National Committee
Finance | Director of Data & Strategic Initiatives
Phone: (202) 479-5141 | Mobile: (717) 283-7521
430 South Capitol Street, SE | Washington, DC 20003