Life after Common Ground: Part 6 – Apsona

This post is part 6 in a series of articles pointing out what’s cool about some of my favorite Salesforce apps for nonprofits. Previously, I highlighted favorite features in Nonprofit Starter PackClick & PledgeCauseviewSoapbox Engage and Conga Composer. Now I’m going to talk about my favorite parts of Apsona for Salesforce.

Apsona isn’t a non-profit specific app, but it’s so incredibly wonderful and useful I couldn’t leave it out of this series.

Continue reading

About these ads

Life after Common Ground: Part 5 – Conga Composer

This post is part 5 in a series of articles pointing out what’s cool about some of my favorite Salesforce apps for nonprofits. Previously, I highlighted favorite features in Nonprofit Starter PackClick & PledgeCauseview and Soapbox Engage now I’m going to talk about my favorite parts of Appextremes Conga Composer.

Before I started working for Convio, I thought I was comfortable with Conga Composer. It’s what I used at Fight Colorectal Cancer to generate our acknowledgement letters out of Common Ground. When you say “mail merge” and “Salesforce” in the same sentence, the next sentence is simply: Conga Composer. But it’s good for so much more than acknowledgment letters.

Common Ground has mail merge functionality built in. And it’s decent. IF you are using Word 2003 or 2007. And Windows XP. And a 32 bit Windows-based OS. And if your browser is Internet Explorer. If one or more of those requirements aren’t true, then the Common Ground mail merge sucked and believe me, those of us who worked on the Common Ground team knew it. It was a great concept built on Salesforce technology that was never upgraded with the times. In fact, 10 days before we found out Common Ground was getting the ax we had a long brainstorming session with the developers about what would be the next version of Common Ground mail merge. I’m sure it would have been amazing.

Before I dive into technology, I have to say something about Appextreme’s support team. Phone or email, it’s incredible. Have to experience it to believe.

Anyway, I know a lot of nonprofits are already familiar with how to do a basic acknowledgement letter using Conga Mass Merge, and it’s awesome for that. But did you know that you can use Conga to generate a fully formatted Word file of your monthly donors, let’s say for your newsletter or annual report?

Continue reading

Life after Common Ground: Part 4 – Soapbox Engage

This post is part 4 in a series of articles pointing out what’s cool about some of my favorite Salesforce apps for nonprofits. Previously, I highlighted favorite features in Nonprofit Starter PackClick & Pledge and Causeview, now I’m going to talk about my favorite parts of Soapbox Engage.

Truth be told, my favorite thing about Soapbox Engage isn’t a technology feature. It’s the company itself. When I was laid off from Blackbaud last summer, one of the first calls I made was to Ryan Ozimek, CEO of PicNet, the company that makes Soapbox Engage. Every time I talk to him, he reminds me why this all matters so much to me. There aren’t enough words to describe my respect for Ryan and the team he’s built and what they’re trying to do, penguins and all. If there was a dictionary definition of an application developer that’s in this market for all the right reasons, it would point to PicNet and call it a day.

But let’s talk favorite feature of the software. Soapbox Engage is way to take a stand alone front end for donation and event registration forms and easily get its data to Salesforce…a combination of a platform built on the open source CMS Joomla and Salesforce app. It’s part of the full Nonprofit Soapbox platform that PicNet offers, separated out for those who just want to sync data to Salesforce and don’t need the entire CMS platform.

Continue reading

Life after Common Ground: Part 3 – Causeview

This post is part 3 in a series of articles aimed at organizations on Common Ground who need to get excited about what’s next if they decide to stay on the Salesforce platform. Previously, I highlighted favorite features in Nonprofit Starter Pack and Click & Pledge, now I’m going to talk about my favorite feature in Causeview.

If what drew you to Common Ground was the sense that you were working in a single unified product supported and developed by a single company, then you’ll probably be happiest looking at Causeview. It’s a bit like buying Microsoft Office or Adobe Create Suite, rather than using Apple Mail as your email application and Microsoft Word for your word processor and Google Docs when you want to edit a spreadsheet. Best of vendor vs. best of breed. A good argument can be made in either direction.

That’s not to say you’re compromising by selecting Causeview. In fact, there’s one area of Causeview that I love, and that’s how it enriches campaigns.

Continue reading

Where to find me at Dreamforce

I’m sitting here on Tuesday morning, reflecting on the New Year and all that has gone on as 5772 has ended. I find myself with something I’m not familiar with…a few minutes of free time. I’m off today, no one is home and I’ve got nothing I absolutely have to do at the moment besides pack for Dreamforce, finish a pair of socks and rest up. I’m taking a ridiculously early flight to Dreamforce tomorrow morning. Car is picking me up at 2 am to catch a 5 am flight that will get me to San Francisco in time for Marc Benioff’s opening keyonte. Sad to have missed the first day. Hopefully it will never be a problem again.

I cut my hair very short (for me). Cathartic to leave more on the floor than my head. And here I am, blogging again and experimenting with new themes. Why all the change? As most folks in my life know, my position at Blackbaud was eliminated when the company decided to “sunset” Common Ground, the product I was working on.

My last official day of employment is next Friday, September 28. I’ll need some distance both emotionally and legally before I can talk about it here. I’m so blessed to have an amazing network of friends personally and professionally who have reached out. I’ve signed some consulting contracts that will hold me for a while while I work on settling in to the next opportunity. I’ve signed contracts so far with KELL Partners and with Lisa & Martin Kornstein. These are projects where I’ll be using my knowledge and love of Force.com to help organizations make the world a better place. These are projects where I know the people behind them are are as passionate about serving communities as I am, and they’re not in this to return a profit to disinterested investors.

This week, it’s all about Dreamforce! No time to be sad and mournful when there’s 3 days of crazy with 85,000 friends to look forward to!

I’m speaking at 2 Community-led sessions this year and last I checked, neither was completely full so not too late to add to your agenda.

Apps, Apps & More Apps: This session is being led by Rhonda Ross of Appirio. Joining us will be Mario Duff and Sarah Cooper from Rhonda’s user group. We’re going to be showing off some of our favorite apps. For my four selections, I focused on “unsung heroes.” I wanted to pick apps that I am absolutely in love with, are approachable for both nonprofits and commercial organizations and don’t necessarily have the same front-page PR that other apps have. So come join me tomorrow (Wednesday) at 1:30 pm in Moscone Center West 3009/3011 to hear me gush about Rollup Helper, Apsona (and Multi-Step Reports), Loop Document Services and CalendarAnything.

Bring Good Karma with Your Admin Skills: This is my baby. I pitched the session and got a fantastic panel joining me. Tal Frankfurt of Cloud For Good (a nonprofit-specialist consulting organization), Matt Bertuzzi of Bridge Group (who has experience volunteering his mad Force.com skills to nonprofit projects) and Carol Guttery of the Salesforce Foundation (whose job it is to help build philanthropy programs). Every year, Marc Benioff honors the nonprofits in his keynote by asking them to stand up. He then urges everyone else in the room to reach out to the nonprofits and help them. But so many don’t know how. Or they think they do and they really don’t, which is worse because you never want to push away a volunteer. How are nonprofits using Salesforce that’s different than other organizations? How do nonprofits get started (so a volunteer can help them get going)? What’s the state of nonprofit apps that might be useful to a volunteer for-profit admin? Where should they go to find out more about volunteering their tech skills? Where’s the nonprofit community? The Foundation urges folks to volunteer at Dreamforce every year doing tasks like stuffing bags, and that’s absolutely fantastic. But do these folks know where they can go to help an organization build a better process for managing their programs within their Salesforce instance? Come to our session on Thursday, September 20th at noon in Moscone Center West, 3022 and find out.

See you in San Francisco!

Salesforce, Dreamforce & Nonprofits: It always comes back to the data model

I’m back from Dreamforce 2011, trying to process everything I saw and learned.

On a personal level, this was the best Dreamforce yet. I was honored to be selected as a Salesforce MVP last March. This gave me some Dreamforce perks starting with a fantastic MVP-only Introduction to Object Oriented Programming class on Monday before the conference began.

This class was a reduced version of the full 5-day course. I’ve always had a fear of learning Apex/code. I’m not as adverse to it now. The class was structured with lessons, followed by 20 minutes or so to complete an exercise. Unlike the hands-on sessions at Dreamforce itself, the solutions weren’t handed out step-by-step like a recipe. You were expected to use what was taught to write some basic, simple lines of code that when executed didn’t produce errors and showed the desired result. I surprised myself at how quickly I picked up the concepts. During one lesson, not only did I get working code but I did it in a way that the instructor said was “elegant.” Yay me! I never want to be a developer. I just want to understand enough Apex to do simple tasks and recognize when and why something is not behaving correctly. This class was a step in the right direction and I highly encourage folks to check it out next year.

Dreamforce can be a circus. So much going on at one time. So many people (45,000 give or take this year). The Salesforce Foundation has continually struggled with how to make Dreamforce meaningful for the nonprofits who attend. This year, the Nonprofit/Foundation sessions and exhibitors were all on the lower level of the nearby Marriott Marquis. If this was my first Dreamforce, I would probably think it was fabulous idea. For me attending my 4th Dreamforce, I was disappointed that it felt a little second class.

I enjoyed presenting on Tuesday morning on the topic of Nonprofits & the AppExchange. I think it went well considering how much we rattled off in an hour without using a lot of visuals or demos.

The Salesforce Nonprofit community has become a bit fractured in the past few years. When I started in 2006, there was essentially one nonprofit experience on Salesforce. A nonprofit either used the nonprofit template or they went off on their own to custom development on the basic Enterprise edition. Now, I’ve been told that approximately 40% of active Salesforce nonprofits are using the Nonprofit Starter Pack (NPSP). That means that approximately 60% are using other applications such as Convio Common Ground or Luminate, the old template, Affinaquest, Outreach Suite or any number of combinations. It’s no longer variations on a single theme. Each direction is very different, using a different data model (see below for lots more on that) and approach. As a result of all that diversity among nonprofits, the nonprofit track sessions at Dreamforce tend to be high level and program/strategy-driven. I’d love to see sessions that take deeper dives into not just what nonprofits are doing on Salesforce, but exactly how they’re doing it. It’s hard for me to relate to case studies without understanding a bit more about what happened behind the curtain. Maybe that’s just me.

So how is it always about the data model?

Follow along with me. Salesforce was originally just a business-to-business tool. A company sales person connected with an individual at another company in order to close a deal with the company. The relationship wasn’t about the individual. If the person at the company left, the deal would remain with the company. The account is, and remains, the center of the Salesforce universe. Nonprofits typically work in a mixed environment where it has a relationship with companies, but often the relationship is solely with an individual having nothing to do with where they work.

I strongly believe that if you are going to be successful on Salesforce you must understand and appreciate the Account/Contact relationship. It doesn’t matter which application you use, or how your implementation partner has configured your customizations. I happen to think the Account/Contact model makes perfect sense, but I know it’s frustrating for new nonprofits on the platform who don’t understand why they have what they think are two records with the same information.

You also have to appreciate the notion of account ownership. A salesperson in a business doesn’t typically have access to all the accounts and deals in the business. A salesperson builds a relationship with the individual at the company they are trying to woo. A nonprofit typically has a very different ownership/sharing model. A development director wants access to all individuals to target his/her fundraising efforts. Office staff batch enters donations where that person then technically “owns” those opportunities because they created the account & contact, but they aren’t directly responsible for the “deal” or its sales process. A nonprofit Salesforce administrator has to learn to approach sharing rules with a very different mindset than their commercial counterparts. Frankly, I’d love to see a Dreamforce nonprofit track session targeted to administrators specifically on sharing models and the implications of different decisions. It’s complex and widely misunderstood. I’ve seen too many nonprofits just make everyone an Adminstrator or turn everything to “Modify All” rather than really understand what it all means.

Now Salesforce comes along with their big Social strategy. The opening day keynote was all about the Social Enterprise. The idea is that a salesperson can use social media to get to the know the individuals who make decisions about deals. They can use social media to monitor what is being said about their company and provide direct support. I think the new Chatter Now and Chatter Custom Groups will be welcome additions to a nonprofit’s Salesforce org. Before, you could only use Chatter to collaborate with people who shared your email address domain. Now you can bring in outside contacts to Chatter. So that means in-Salesforce collaboration with Board members, or key volunteers, or your organization’s largest donors. Lots of possibilities.

Unfortunately, once again I think nonprofits need to be prepared to flip the data model around. We’ve already successfully flipped around the salesperson-connects-to-organization-through-a-contact model before social media was part of the picture. Wrap your head around this: the Salesforce social enterprise sales model is about a salesperson’s one-to-one relationship with the key contacts at a business. Not organization-to-contact unless it’s about service/support or brand monitoring. How is that a challenge? Think about it. At a nonprofit, do we really care that the development staff member who batch entered those donations so they’re now the “owner” of the account is connected on Facebook to the donor? Maybe. Probably not. A nonprofit cares about how the donor is connected to the organization and those people who are influential to the organization’s mission, staff or not. Are they fans of our Facebook page? How are they connected to other key donors? Are they friends with people who are influential about our issues?

The Salesforce social enterprise push will be wonderful for development directors who want to connect to foundations and corporate sponsors. That most typically aligns with the standard Salesforce Account/Contact model. I don’t see the new social media features as they are being demo’ed as being particularly valuable to the nonprofit using the Starter Pack to engage as an organization with individual donors. I think Radian6 will be very interesting for nonprofits, provided the organization can afford it. Pricing hasn’t been announced yet.

Hopefully, the amazing developers, vendors and partners in our nonprofit community will create applications and integrations that close those gaps just as they did before. I can’t wait.

Setting up an easy welcome series in Salesforce

Now that our rebranding is off the ground, we've finally implemented something in Salesforce I've wanted to do for a long time…a welcome series of emails to new contacts.

Until recently, when someone registered through our website without donating or taking action, they got very little initial feedback from us. They just started hearing from us when we sent out email enewsletters, appeals or action alerts. Our goal is to build relationships with our constituents, not to build lists. We have a lot of information on our website that may be harder for a new visitor to find. We have services they may be interested in and not know about.

Fight_colorectal_cancer-4

Our strategy: We want to send new non-donor contacts a series of 3 short emails. One a general welcome, one highlighting our research work, one highlighting our advocacy work. Spaced a week apart.

Using email templates and workflow rules, this is super easy to set up in Salesforce. I'm surprised how many nonprofits I talk to using Salesforce don't realize how easy this is. Just click and go. Here's how (note: this tutorial assumes that you have administration rights in Salesforce for all objects mentioned):

1. Set up your email templates

Okay, a little programming knowledge may be needed. If you have never designed an HTML email before, then stop and review this fantastic presentation from Sean Powell and Shana Masterson at #NTC11 on the right way to deal with code for email. Do it now. I'll wait.

Now that you know how to code email, create the HTML. I prefer to do this in Adobe Dreamweaver. If it's new code that's never been emailed before, I highly recommend you use Email on Acid to test first. Make sure that what looks good in your email application looks right in all the others. I've tried a number of email testing services. Email on Acid is by far my favorite and very reasonably priced.

After the email template passes browser tests, you can paste it into Salesforce. Setup -> Administration Setup -> Communication Templates -> Email Templates. 

Personalize to taste. Truth be told, it takes me more time to make the text version look good than it does to deal with the HTML.

Custom_email_template_welcome_

Do one for each of the emails you plan to send. The emails we've written/designed are all pretty short and light, very focused on a patient/general public audience. Each have a bit of a low-pressure call-to-action and of course, a donate link at the bottom.

2. Add contact fields for monitoring

Unfortunately, unlike other email sent on-the-fly through Salesforce, there's no activity record left on contact records when a workflow rule sends an email. So I created 3 date fields on the contact record to show that the welcome email was sent. The fields will be automatically updated by the workflow rule. This will also help us see if they do engage with us more (donate, call, take action, etc.) and correlate that to the communications we've sent.

Welcome_contact_fields

3. Create Workflow Rules with time triggers

Here's where the fun begins.

Setup -> Create -> Workflow Rules & Approval -> Workflow Rules

First, define the criteria that will trigger the email. Since this is based new contacts and not a change in a field value, I have it set to only evaluate when the contact is created. 

For us, the criteria is based on the following:
  1. Lead Source: when a contact is converted from a lead (web-to-lead form from the website), the lead source is automatically inserted on the contact. So the rule first looks for one of the appropriate lead sources to show that it came from the website.
  2. Donor Status: Lifetime Hard Credit Count (a Convio Common Ground field) = null covers that since the communication wasn't aimed at donors.
  3. I have criteria that also makes sure the email field exists and that it's opt-in. I have a feeling the rule would just fail otherwise, but it didn't hurt to throw it in.
Then it's just a matter of setting the rule to do what needs to be done. Update the date fields by using a formula that simply sets those fields to TODAY(). All clicks, no code.

Time_triggers-1

It's that easy.

Additional Notes

Think about who you want the email to come from. I decided to have the emails come from the organization's main email account rather than me:

From_address

To change/setup organization-wide addresses, Setup -> Administration Setup -> Email Administration -> Organization-wide Addresses.

You may want to monitor your time-based workflows to make sure the future emails are going to go out as you expect, especially when the workflow rules first start. To do that, visit Setup -> Administration Setup -> Monitoring -> Time-Based Workflow. Just hit "Search" to show all scheduled outgoing emails.

Are you using workflow rules in Salesforce to better communicate with your constituents? Would love to hear about it!

Help more nonprofits go to NTC


http://farm.sproutbuilder.com/load/jQDFlo64IIrbBGDQ.swf

In 2005, I naively accepted an offer to run operations for a new nonprofit. I was always comfortable in technology, I was comfortable working with nonprofits. What else did I need to know? Ha. I didn’t have a clue.

Now, nearly 5 years later I am confident in my ability to help C3: Colorectal Cancer Coalition achieve its mission with the aid of technology. I’m proud every time someone marvels at how much we’ve been able to accomplish despite the fact that our budget is still under $1 million. I owe most of that confidence to my association with NTEN over the years. I’m forever grateful for the friends I’ve made and the technologies I’ve been exposed to. I love that I’m at the point in my career where I can pay it forward and help other nonprofit techies.

You can get a lot out of NTEN without attending their annual conference, the NTC. Attend webinars, get to know the movers & shakers through Facebook and Twitter. Participate in an affinity group. But the NTC is different. It’s really like no other conference. The collaboration and camaraderie is on a whole new level. 

Last year, I received a Convio/NTEN scholarship to attend NTC in San Francisco. This year, I consciously decided not to apply for the Atlanta NTC. I want to make sure other folks have their chance to attend when they otherwise wouldn’t be able to. I got an e-certificate from United so my flight to Atlanta cost under $100 round trip. That balances out in my mind. The money I spend on NTC pays itself back for C3. I couldn’t imagine not going at this point.

I just made a small personal donation to the fund, and I’d like to urge you to do the same. It adds up. Think of all the good that small nonprofits are doing and could be doing if they had the right tools and connections. The NTC is their chance. Help them get there.

Nonprofits: Have we had enough of “vote for me” fundraising yet?

This weekend, the winners were announced in the Chase Community Challenge. 

On paper, it seemed simple enough. Chase gives $5 million to nonprofits based solely on the votes of regular folk on Facebook. "Their money, our votes." In reality, the challenge illustrated exactly why these "vote for me" contests in the nonprofit world have got to go away. Businesses can do what they want, and while I applaud the move towards philanthropy, it's my opinion (disclaimer: and not necessarily the opinion of the nonprofit that employs me) that this is not the way to do it. Please look at the 1+1+1 model that Salesforce uses (and Google as well, I think) for a better corporate giving program.

The Chase Community Challenge started with an open nomination round. Each Facebook user, after authorizing the Chase application, got 20 votes to distribute among their favorite charities. The top 100 vote getters got $25K each, then competed for the $1 million grand prize, with 2nd-6th place getting $100K each. 

What's wrong with this picture? A lot. Beth Kanter summarizes some of what went wrong. Chase disqualified some charities without being transparent as to why. Allegations of fake profiles being created to drum up votes. I'm not going to rehash all that here. Beth does a wonderful job. Read it.

My main problem isn't necessarily about Chase. It's the whole recent crop of "vote for the king & queen of the prom" type challenges for nonprofits and is what Beth says best in her post: 

Scarcity thinking assumes no growth and heightened competition.  Contests that are designed to select winners based on popular votes only and huge dollar amounts inspire scarcity thinking. Much like throwing some fish food into a pond filled with starving Coi fish.

I hated watching our supporters eat the fins of other organization's supporters while they lobbied for votes for their favorites. Each charity had a page for comments, and those pages were filled with "use your spare vote for…" pleas. In other words, this was a contest where the success of your pet organization to make it to the top 100 was dependent on the failure of millions others. To win in round 2, your charity had to be content with 94 other charities losing. How do you decide that an organization's mission to provide help for Jewish families dealing with Autism has more or less value than an organization that fights a rare childhood disease or takes care of animals? That a local organization is more deserving than a national one?

Some organizations put incredible thought and time and resources into trying to win this contest (there goes that $25K). Time and effort that they maybe weren't spending addressing their core issues if they're really small or mostly volunteer run. It wasn't about mission, it was only about getting into larger networks and getting a click that I would argue was ultimately meaningless. That doesn't feel right to me. Will those votes translate into viable support and advocate engagement later? Does it really raise an organization's profile to be in the coi pond? I'd love to see some data a year from now.

Supporting nonprofit organizations that are working to make the world a better place isn't a Miss America contest. Shame on any corporation that thinks otherwise.

Here's a community challenge I want to see: Reward nonprofits for projects that require collaboration and networking. 

An example straight off the top of my head: A cancer support organization working with a meals-on-wheels organization and one that helps people with job skills designing and implementing a program to make sure that patients are eating right after treatment and can get back into the workforce after a long health-related absence. 

I think the possibilities are endless if we can get out of our silos long enough to consider them.

Extra points to the projects that require the most diverse organizations to actually work together towards a common goal. The general public can view and comment on the proposed programs, maybe even make suggestions of partners. Community insight and transparency is wonderful. Yet ultimately the funding decision is by a team that will evaluate based solely on the viability of the project and what will have the most benefit for the population it will serve. Not necessarily which will serve the largest population. Not necessarily which has the largest mailing list or Facebook fan page.

Nice dream. 

In the meantime, all I can do is beg corporations to think it through before the next challenge. If you sprinkle food at the top of the crowded pond, the fish aren't going to say, "you know, I've thought about it and I'm not really that hungry to fight for it." They're going to eat each other up like it's their very last meal. It's the fish's nature. It's ours. It's up to you to design your giving programs to make sure we're helping each other to the next meal and we're all being fairly judged on our own value, not purely in competition.

Dreamforce day 1 report

I could be watching a Black Crowes concert right now at the Moscone Center. Instead, I’m back in my tiny hotel room looking forward to spending the rest of the evening knitting on Laini’s sweater while watching Glee. Much better plan. Long day.

Before I kick back for the night, here’s some of my thoughts/impressions of the day.

The nonprofit Salesforce community rocks. I love spending time with these people. Consultants, fellow nonprofit staff members, vendors, Salesforce Foundation employees. Doesn’t matter. More great conversations than I can count. Thank you. Looking forward to tomorrow and Friday once the nonprofit track sessions begin. Continue reading