From the category archives:

CRM

Again, a little peak at what I’ve been up to, reading, and thinking about. You can also see what I’ve been reading by looking at my shared items on my google profile.

{ 1 comment }

So while I’ve been off twitter, I’ve had time to research social CRM (funny, that.) And what I’ve found is pretty interesting.

CRM stands for “Customer Relationship Management” (not to be confused with “Cause Related Marketing”- it came from the for-profit space. In the nonprofit world we use this acronym to mean “Constituent Relationship Management”, generally. From Wikipedia:

Customer relationship management is a broadly recognized, widely-implemented strategy for managing and nurturing a company’s interactions with clients and sales prospects. It involves using technology to organize, automate, and synchronize business processes—principally sales activities, but also those for marketing, customer service, and technical support. The overall goals are to find, attract, and win new clients, nurture and retain those the company already has, entice former clients back into the fold, and reduce the costs of marketing and client service.

Now we could easily translate that into “managing and nurturing an organizations’ interactions with donors and constituents.” and “overall goals are to find, attract and win new donors, nurture and retain those donors the organization already has, entice former donors back into the fold, and reduce the costs of fundraising.” (I’ve never been convinced that CRM and Donation management are very different beasts, even though many argue differently.)

Anyway, you all know this stuff, and know the tools we all use to do this – Salesforce, CiviCRM, Raiser’s Edge, etc. And these tools are great at doing CRM with the standard communications methods – email, phone, snail mail, in person contact. But what about social media as another form of communication? That was the question I cam to this issue with.

There are good arguments for why social media will radically change standard CRM practices. You should definitely read the report I mentioned in my earlier post. But in the Social CRM space, there seems to be a lot more attention paid to what I would call “metrics”  - useful for attracting new donors, and understanding the “emotional state of conversations” rather than relationships that are trackable to “nurture and retain those donors the organization already has.”

I don’t mean to downplay metrics – metrics are hugely important – but I think mixing up metrics and CRM might make it harder to really do either well.

Example – in Jeremiah Owyang’s report, of the 18 use cases for Social CRM he uses, 7 or 8 of them are really use cases for metrics. Example “Social Campaign Tracking” and “Social Sales Insights.”

In this series, I’m going to talk a fair bit about both, although I’m going to lean  more heavily on the CRM side of things than the Metrics side, since that’s more my bailiwick anyway. And I welcome any comments.

{ 0 comments }

Social CRM, part 1

April 11, 2010

This blog series is all Beth Kanter’s fault. We (the two partners of OpenIssue) shared a cab from the Atlanta airport to the hotel when we arrived for the 2010 Nonprofit Technology Conference. We were chatting with her about what kind of work we do, and she asked “do you do social CRM?” She might not have seen the blank stares on our faces since we were in a dark cab, but I’m sure she heard the pregnant, confused silence.

As you know, I don’t blog much about social media. I use it all the time, but there are much better sources of good information on that – I’ve been sticking to writing what I know best. But I have to admit, this idea of social CRM piqued my interest. More than that. The truth is, if @kanter asks me about something that is related to social media, it must be important, so I’d better figure it out. And, of course, I’m at least a year behind the curve on this – there has been a lot going on in this space, although, frankly, in my research so far, I haven’t found a lot in the technology sphere that would immediately be helpful to nonprofits (especially small to medium-sized ones.) There’s some, and I’ll talk about that in the next posts in this series.

Beth pointed us in the direction of Jeremiah Owyang, who I’d been reading a little for a while, but had lost track of, since I don’t follow the social media space carefully. He has a great post on the use cases for Social CRM. It’s a really solid post, with an information-packed report attached, as well as some resources. This is a bit high level for me – my job in life is generally to make use cases real using technology. I’m hoping that someone (hint, hint) will write the blog post or report taking off on this work, and articulate the major nonprofit use cases for Social CRM. The report does include some technologies to look at, and I’ll be delving into those in future posts.

I’m going to take a little chunk off of this, though, and ask some leading questions. And then, I’ll do my best over the course of the next few weeks to answer how these would get accomplished via the technological tools that most nonprofits use  or can get access to.

  1. How do you know which of your Facebook fans/Causes members are also a donors (separate from donations through Causes)?
  2. How do you know how many of your twitter followers are also donors?
  3. How do you know what percentage of your donors or constituents are on social media at all (twitter, facebook, myspace, linkedin?)
  4. Can you follow the trail from tweet (or facebook status) to a donation? A tweet to a specific action (like a petition?)

If you’ve got more questions you’d like to see me address, or you’ve got some examples of how your nonprofit has answered these questions, please feel free to comment on this post.

{ 1 comment }

Drupal and Salesforce

December 31, 2009

It’s taken me a while to write this blog post, mostly because I have been working hard at various things (like building a business and building new websites.) This is the last installment in my CRM/CMS integration series, that started almost a year ago (wow!) And I’m skipping Joomla/Salesforce Integration because there isn’t any publicly available documentation or code about the integration that PICnet did with Joomla and Salesforce, called J!Salesforce.  [update: see Ryan's comment below.]

So what is the state of Drupal/Salesforce Integration? It’s not as mature as the Plone/Salesforce integration, for sure, but it is coming along nicely. There are several contributed modules:

  • salesforce – main module, with API, node, and user integration possibilities. This module provides the basic salesforce API connection (via SOAP), and includes field mapping, and basic import/export
  • sf_webform – Makes integration with webforms in Drupal fairly easy. Web-to-lead is quite nice and flexible with this module.
  • uc_salesforce – Provides integration with ubercart orders
  • parser-salesforce – Integration with FeedAPI – pulling data from salesforce into drupal nodes via FeedAPI  (I hope to start maintaining this module)
  • sf_import – Import Salesforce objects into Drupal nodes (will be folded into the main salesforce module)

All of these modules are in alpha or beta, although I know for a fact that some of them (or versions of them) are working in production sites. There are a fair number of bugs that need to be fixed before there is a stable release. There are a bunch of outstanding issues that need a lot of work (like caching, for instance). There are two other modules that are related, but don’t use the main salesforce api module – one for ubercart, and one for web-to-lead (called salesforcewebform). That module has a stable release, but only provides the ability to integrate between Webforms and leads, not other objects.

Right now, the salesforce module allows for integration of contact, lead and campaign objects only. so that’s another big area that could use some work.

There is a good screencast done by one of the folks (Jeff Miccolis from Development Seed) who has worked a lot on this project.

I’d say that in a year, we’ll have a good solid module release, providing lots of features for integration between Drupal and Salesforce.com.

{ 4 comments }

Open Mobile Camp report

October 25, 2009

Yesterday, I spent the day in Manhattan, at the UNICEF building, with a bunch of folks passionate about the technology in mobile phones, and the ways to use that technology for good. I’ve been a very long time cell phone user (had one since 1998), but I haven’t been involved in implementing a mobile system for an organization, so I had a lot to learn.

The place to find reports on what happend is on the wiki. Also, check out the twitter stream for the #omc09 hashtag.

I was especially interested in the issue of mobile data collection. (I was so interested, I facilitated a session.) And, even more specifically, I’m interested in how to leverage CiviCRM and mobile devices for a range of interesting applications. There are a number of ways to get data from mobile phones into a CRM – and all have advantages and disadvantages, depending on a lot of things.

  • Globally, what you can basically depend on is SMS. Smartphones haven’t made it into most of the developing world, nor have 3G networks. So how do you get SMS data into a database system like CiviCRM? You need an SMS gateway, and systems such as RapidSMS to gather data
  • Use J2ME to write applications for mobile phones, and send the data via SMS to a central database.
  • A tool such as EpiCollect, which is an Android app.
  • A slimmed-down, simplified webform to be used on mobile browsers.

One thing that would facilitate this would be a more robust API system in CiviCRM – access to the data via REST or JSON, which would allow CiviCRM to talk with some of the tools out there like Mesh4X.

I learned a ton. Thanks to MobileActive.org and the Open Mobile Consortium for a fabulous event.

{ 3 comments }

I got to spend one day at CiviCRM developer camp this week. Unfortunately, it came after 4 long days of conferencing, after many exhausting days of work, so I wasn’t at my peak. But I learned a lot, and thought I’d share some of what I took away from that day.

First, the core team shared some of the new stuff coming out in version 2.3, and it is awe-some. One of the major reasons CiviCRM gets dinged as a CRM/DMS is that it doesn’t have reports. Well, that problem is about to go away with the release of CiviReport in 2.3. There will be a number of canned reports, and some really nice ways to create reports. Plus charts! Yay! There were some pie charts, and regular bar charts. I don’t have the new svn trunk of CiviCRM installed, otherwise, I’d show some screenshots, but it looked really nice. (I’ll be installing CiviCRM from svn in the next week, and I’ll probably blog more as 2.3 develops.)

There are some really nice usability improvements coming up in 2.3 as well – to make the basic contact pages much easier to navigate. And there is a new menu system, which will make things a lot easier. And, for Drupal users, some sweet Views 2 and CCK integration.

CiviEvent is getting waiting lists, registration approval, and user-modifiable registrations, and some other improvements.

The Alpha of 2.3 should be out by July.

I also learned about CiviCase, which is actually present in 2.2. I saw the example of it used for the Physician Health Program in Canada. It’s quite good, and there are some useful docs to see it at work on the CiviCRM wiki. I’d love to find an organization, such as a small human services organization, in need of case management software, that could use CiviCase – it would be a great, and relatively inexpensive alternative to current offerings out there. And more organizations using CiviCRM for case management would help CiviCase get even better.

I also dug into some of the internals and code of CiviCRM, and feel better equipped to start contributing more than ideas and feedback to the project.

{ 1 comment }

Third to last in my series on CMS and CRM integration (next up, Joomla and Salesforce, followed by Drupal and Salesforce) is using web forms.

I wanted to talk about this because it is arguably the most common form of “integration” between CRM and CMS that’s out there (besides the manual kind). You’ve got a CMS, and you’ve got a CRM somewhere else, and you need some way for data from users to make it to your CRM. Of course, it’s not really integration – there is no sharing of data between the CMS and the CRM in any useful way. But webforms can really help you get things done. Here are some examples of things I’ve done and seen done:

  • A custom donation page that’s sitting on a service like Network for Good that is linked from the website, or framed within it
  • The HTML for a “Web to Lead” form from Salesforce.com pasted into a CMS page
  • The HTML for a event registration form or donation form that goes to a hosted service

In the first option, the form isn’t hosted at all on your site. In this option you have the least control over look and feel – the vendor controls the look and the behavior. An example of this I’ve run into is when an organization uses Blackbaud’s Raiser’s Edge, and wants to have online donations via NetSolutions, their older (and much cheaper) “integration” tool. They provide a page, which hooks directly into the users RE installation. But you can’t customize the page in any useful way, so if you’ve just designed a brand-spanking new site, this page is gonna look like crap. (Luckily, at least Network For Good’s donation pages look snappy and nice, but are going to look a lot different than your website.)

The other options are much better for look and feel – you can take the HTML, and, in most instances, style it to look like your site. You can even sometimes include Javascript for validation or other functionality. But this is still strictly one-way communication – the form data goes directly to the service (and does not pass go.) You don’t get any of it.

This is a great start to integration, if your budget doesn’t allow for true, deep, two-way integration between CRM and CMS. And it’s a great way to get your feet wet in thinking about what you might want to do with CRM and CMS. And, in some instances, depending on both CRM and CMS, it might be your only option.

{ 2 comments }

Blackbaud announced, just in time for AFP, their new product, called BlackbaudNow, in partnership with PayPal. It is a curious service. It is an extremely low-end, low-cost online website/online donation package from a vendor that spends most of its time on the very high-end of the scale.

It is simple. An organization can sign up for a free account, get a 5 page website, including a donation page, about page, etc. Editing a page is basically point and click – it highlights the part of the page you can edit it, and you edit it with a WYSIWYG editor. It’s decently AJAXy, but no, it’s not shiny – at least not my definition of shiny. You have a small number of templates to choose from (which, frankly, aren’t so great looking – I think they dedicated more graphic design time to their branding and pages than they did to the templates.) It’s free, although Blackbaud takes a percentage off the top. People can donate to your organization via Paypal only, and you can track donations in their very simple interface. You can export your donation history into a CSV file, and you can make your reports into PDFs. There are no APIs.

This was developed by the team that Blackbaud acquired when they acquired eTapestry. And, it’s designed to make migration to eTapestry easy – therein, I suspect, is the key. I’m betting this is a loss-leader – a product designed to get people in the door, and when they are chomping at the bit for more (which they will be in about 2 days after they set up their site,) there is a more costly (and profitable) product waiting right around the bend for them.

Small nonprofits – especially those with few or no staff, are always in a particularly challenging place when it comes to finding the best solution for a web presence and online donations. But I don’t think that a tool like this is going to serve very many nonprofits for very long, given its limitations. Of course, people like me, who make our living building websites, and helping facilitate the web presences of organizations, look askance at tools like this, so take what I say with a grain of salt. But I have to admit that this seems to me a bit too much like a gateway drug – get them hooked on free, then move them slowly but surely to much more expensive systems. And in the end, won’t a modest investment  (say, $2K or so) on the part of an organization in getting a better web presence going to serve them better in the long run? Heck, I think a Wordpress.com site attached to a Network for Good donation page will serve them better. At least they’ll have a lot more well-designed templates to choose from, and a real CMS engine.

Honestly, I’m underwhelmed by this service, and, in addition, I have a bone to pick with Blackbaud. The online help for BlackbaudNow is powered by the open source software MediaWiki. It is well hidden, but a somewhat savvy MediaWiki user will notice the telltale signs (the URLs are one giveaway.) Of course, proprietary software makers use open source software all the time, that’s not the problem. The problem I have is that they hid it. Why hide the fact that they are using an open source tool to build their online documentation? Not even a small mention on the About page. Did they do any modification to the code to make it work like they wanted to? Did they contribute anything back to the MediaWiki community? At the very least, they could have given credit where credit is due.

{ 1 comment }

I have some exciting news. For the last few months, I have been working on a new collaboration called OpenIssue, which is a growing, diverse, self-reflective and constantly-learning team. We are focused on delivering quality web technology solutions to nonprofit organizations and social enterprises.

As you know, I have built a long-time expertise in open source software and web applications, particularly Content Management Systems (CMS) and online database systems, including CRM. Thomas Groden, my new business partner, has expertise in Software-as-a-Service Constituent Relationship Management Systems (CRM), as well as much more broad expertise in technology infrastructure.

All technology implementors have to choose their tools (unless they run a very large shop) and we have decided to focus on implementation of both Salesforce.com and CiviCRM as CRMs, and Drupal as a CMS. We are keenly interested in building on our expertise to integrate these open platforms in really rich ways, to allow organizations to create great online applications.

I’m excited to be a part of a team – I’ve been a soloist for a while, and it’s nice to build collaborations, and work together with people with shared ideals on larger projects than I’d be able to take on alone. And I’m really excited by the set of technologies we’re working on, and the kinds of applications we’ll be building with these technologies.

And you can follow us on twitter.

{ 1 comment }

Today, I was reading up on what the Plone community has done with integrating their CMS with Salesforce.com. I am thinking that this might be a good model for how we can do it with Drupal, but that’s a subject for another post.

(from Plone/SF Integration group)

There’s a good overview of the integration on the developerforce wiki. There are 5 components to the integration:

  • a couple of toolkits that provide the basic back-and-forth between Plone and Salesforce.com (they talk to Python and Zope)
  • an auth plug-in that allows for Salesforce.com objects to be Plone users, credential checking, caching of user data, and syncing of data from Salesforce.com and Plone
  • an integration of PloneFormGen with Salesforce.com for web-to-lead forms, etc.
  • an event management product that connects with Salesforce.com
  • A PayPal integration product

This is a pretty robust set of channels for data to move back and forth from Salesforce.com to Plone. There is a Plone/Salesforce.com Integration group, that keeps working on this, and a number of organization, including ONE/Northwest, have invested huge amounts of time and resources to working on this integration.

This is, for sure, one of the most robust open source CMS to CRM integrations out there, and one that seems to be getting pretty close to providing very powerful integration “out-of-the-box” – instead of having to piece things together and do customized code, which is more common than not.

I haven’t gotten my hands on this to try (not being a Plone person, I doubt I will), but folks might want to talk in comments about how straightforward the integration is, given differences in data for different instances of Salesforce.com. I don’t know how much code tweaking is required to really get this going. But in any event, it’s great that it exists, and it’s a great benchmark for CMS/CRM integration.

{ 3 comments }