CiviCRM Community Forums (archive)

The project social media integration with CiviCRM is of practical importance to the goal of CiviCRM which is to better manage organization’s audience (Constituent Relationship Management).

This project involves ensuring that the platform of CiviCRM should be able to interact with social media platforms and ease or increase the effectiveness of the way an organization manages its constituent relationships.
Since CiviCRM aims at sustaining relationships with supporters over time, the social media integration project will help the organization to use CiviCRM to sustain supporters relationships by doing the following;

integrate with social media platform logins such as Facebook, twitter, and Instagram for quick and easy petition signing or event registration and to get authorized access to petition-signers' social graphs, pull in contacts from social media & match to CiviCRM contacts based on available information, import into CiviCRM data about who is re-tweeting, sharing, writing on your wall, establish ways to determine highly active users based on their social media activity, Add social media feed dashlet to see 'what's going on right now', Add ability to automatically publish/tweet about events, certain types of activities, possibly progress towards fundraising goals.

 Key deliverables of this project include the following; scope and specification document of the project, a UML model document of the project, Social media integration with CiviCRM to pull in contacts from social media and match to CiviCRM contacts base, Social media integration with CiviCRM to enable social media login, Social media integration with CiviCRM to import into CiviCRM data about who is re-tweeting, sharing, writing on your wall, Social media integration with CiviCRM to establish ways to determine highly active users based on their social media activity, Social media integration with CiviCRM to add social media dash-let to see ‘what’s going on right now’, Social media integration with CiviCRM module to add ability to automatically publish/tweet about events, certain types of activities, possibly progress towards fundraising goals,  development and user manual of the project.

Something else to reiterate.  Most orgs who are interested about social integration are already using it (or should be.) so they have a twitter /FB account with followers, mentioners, etc.  Your proposal talks about capturing "public" info.  I assume you will have the org specify their accounts/pages and pull all follower, activities, etc. all of which are avail from the org's accounts(s)?

Also don't forget about rich media.  IMO it is often an afterthought but very important for user experience.  Assets like profile pics, event photos, and other media on social networks can really spice-up the civicrm content.

Two things come to mind for me:  there may be privacy concerns about "pulling' info from one platform into the database without notifying the person who has generated this content (I'm in BC, Canada, we have very stringent privacy laws) that it is being stored, and what it might be used for.
Secondly, this is a great idea - we are just now working on having participants in our closed facebook support groups identified in CiviCRM as contacts belonging to these groups.  In CiviCRM, the group transforms into a special kind of online 'event', which group members 'register' for.

In terms of scoping this part of the project, this is how far we are gone. Feed back at this point will help greatly.

Social Media Integration with CiviCRM II Scoping

Information to be gotten from Facebook

        Match the Civi contact with the Facebook account
   Check if the user likes the organization on Facebook
   Check if the user is writing on the organization wall and what they are writing
   Check if a user is liking or commenting on the organization’s post and their comments
   Get the number of friends for that organization on Facebook


Information to send to Facebook

   Post to a user’s wall automatically.


Information to be gotten from twitter


   Matching a user’s profile to its CiviCRM contact
   Check if a user is following the organization on twitter
   Check if a user is tweeting at the organization and possibly get the tweets
   Check if a user is sending direct messages to an organization on twitter and possibly getting the messages
   Check if a user is retweeting at the organization
   Get the number of followers the organization has on twitter
Information to be sent to twitter
   Automatic tweets to user about an event or fund raising goal or status

Other information to display at the Civi end
   The total number of followers or friends of the organization
   Highly active users

I'm not sure you can pull anything out of FB without the consent of the person, eg. without the user allowing our app to access her data.

For sure, and each platform will have its own (changing) rules about permissions, about what data (if any) we are permitted to store locally, and how it should be treated. Eg Facebook Platform Policy.

Worth reading through that list; some of the requirements will have implications for us (eg Only use friend data (including friends list) in the person’s experience in your app. - I wonder how this has been interpreted in other CRM platforms which implement network graphs based on Twitter/FB data? - and Don’t proxy, request or collect Facebook usernames or passwords., the username part of which surprised me).

@JoeMurray, I expect that contact matching will be much like CiviCRM's existing approach to start with. NationBuilder seems to import all SM "friends" and then treat them as contacts, deduping as best it can. With SM profiles there is additional information available, eg if I have your email and want to match against a likely Twitter profile, I can perhaps compare your email's gravatar(s) and Twitter avatar to confirm additional match. (TASK NOT IN CURRENT SCOPE!)

Not sure if you're still on the planning part of the project or whether the scope is already fixed, but one of my clients indicated that linking Civi Events with FB events so that FB RSVPs of known contacts are recorded in Civi would be, quote, an "key feature".

Project State

We started this project off by scoping the project from the initial GSoC proposal submitted and came out with the manageble scope above. According this scope, the whole of this part of the project depends on what information that we can get from Facebook and Twitter so we can use any as a matching criteria for the civi friends to the civi contact.

We started off with Facebook looking at the API and the Facebook SDK v4 for php, more practically the Graph API and a lot has change from version 1 to version two of the Graph API in terms of permissions allowed to get data about a user's friends from facebook

The idea we were trying to implement was to get the emails of a user's friend (CiviCRM user)via the graph API and match with the emails of the civi contact table because we believe the email is unique and we may have a match keeping in mind the case that a friend of Civi may not use the same email for facebook and in CiviCRM.

Now according to the new developments on the API and Privacy policies in the Facebook platform, For us to get information about any CiviCRM friend such as the primary email, our app must request the user's permission and it is granted the permission before it can get that information. Also based on the friend's privacy settings, Facebook will allow you to get available data.

The only information that can be gotten by our extension (the app) that does not require the friends' permission is the user_id, name, and picture via the /me/taggable_friends(https://developers.facebook.com/docs/graph-api/reference/v2.0/user/taggable_friends) endpoint, and only can be used after a review of your app by Facebook.

With user permissions, we can get the following; public_profile, email, and the user _friends

Question: what will be the experience or interaction flow of the extension if we have to request the permission of a user before get his information that we can use to match his contact to his profile to the civi contact?

What we are doing now

we have written the srcipt that uses the API and the SDK to get friends ID, name, picture as per /me/taggable_friends(https://developers.facebook.com/docs/graph-api/reference/v2.0/user/taggable_friends) endpoint, and will submit for Facebook review today, so we can use it to get those information though we do not know how helpfull it will be in matching while awaiting suggestions from the community.

Our next step which will start by the end of today will be to request the user's permission to get their emails so we hope to get feedback from the community today so we could move forward.

suggestions will be helpful