Archive for May, 2007

Salesforce / Google Announcement on June 5?

According to ZDNet, will be holding a press conference on June 5 with a “leading Internet company based in the Bay Area”. Makes sense that this would be Google.

Lots of theories exist on what the partnership/acquisition will be about. My guess is that it’s a partnership (not an acquisition) and it’ll be a deep integration of Google Enterprise apps with I think this could include:

  • Google Apps gMail: Similar to the Outlook Edition, you’ll be able to add emails to Salesforce from Google Apps gMail. Hopefully, email to case is all integrated into this too.
  • Calendar sync: I think this is the least likely of all features.
  • Docs & Spreadsheet: Create Google Docs & Spreadsheets from within Salesforce so they are auto associated with your records. Also would include the ability to upload a document and have it uploaded to Google Docs & Spreadsheet rather than just being a file in the Documents tab. When turned on, this functionality will be native in the Documents section of rather than an AppExchange application that uses all new functionality
  • Data indexing: Have Google index your data in a secure environment and replace the Salesforce search with Google Search
  • Google for Adwords tied in with Google Analytics & Campaigns
  • All of this will cost extra $$$

If it’s something like the above, I think the announcement will be a bit anti-climatic what with all the speculation about an acquisition. However, it would still be pretty cool.

My idea is all pure speculation, but its fun to think about. Applying Google technology to the platform could make for some very exciting capabilities.

Comments (2) comments feed

Fight Web to Lead Spam w/ Akismet

This functionality has been improved, runs native on and released on the AppExchange. Learn more on our website.

Back in January, I posted about a way to help combat web to lead spam. That type of solution works well, but is not scalable. Also, it is a reactive approach rather than a proactive one.

I decided to try and see if I could incorporate Akismet into the web to lead process and I was successful in doing so! I created a set of scripts for you to download if you’d like to leverage Akismet with your web to lead forms.

Akismet is the best spam tool I have ever used. When I posted in January, it had captured 7,680 spam in its existence on this blog. Less than 4 months later, the spam count is up to 23,994. Needless to stay, spam is an exponentially increasing problem and will plague your environment eventually. I feel that needs to include a spam filter in their product for web to lead (vote for it).

Until then, leveraging Akismet could help you significantly.

About the Solution

The scripts are intended to be proof of concept for you to use and apply to your own environment. The code and downloads are now being officially hosted at Arrowpointe’s Open Source Project at Google.

To use this solution, you’ll point your web to lead forms to this script rather than to the standard Salesforce Web to Lead page. The script accepts the data from your web to lead form, passes it to Akismet to determine whether it’s spam or not and then passes the data to’s web to lead page with the Akismet result appended to it.

In Salesforce, you’ll need to add checkbox field (e.g. “Akismet marked as spam”) on your Lead. If Akismet thinks it’s spam, that field will be set to TRUE. You would then need to add assignment rules or validation rules to do whatever you need. For example, you could have a lead assignment rule looking at that one checkbox field and put leads into a special queue if they are marked as spam.

The script leverages the Akismet PHP5 Class to handle the core communication with Akismet. I found this class from the Akismet Development page.

This script will only work on PHP5 and requires the cURL module to be enabled. cURL is enabled by default in most PHP installations. The PHP5 requirement is a limitation of the Akismet PHP5 Class. If you are on another platform (PHP4, Ruby, Java, etc.), I don’t see any reason why you couldn’t use these scripts and integrate a different Akismet toolkit into it. Additional toolkits are available from the Akismet Developer Page.


You’ll need a server running PHP5. If you have a server already setup, then hardware should cost you nothing.

Akismet is free for personal use, but has a small license fee for commercial use. If you will be using this in production, you should purchase an Akismet Commercial License Key. During development, I am sure you could use a personal key to make sure it works.

The scripts themselves are free and licensed under the GNU General Public License v3. I did this as a proof of concept for the betterment of data quality everywhere.

Getting Started
  1. Add a checkbox field to your Lead Object that will hold whether Akismet thinks it’s spam or not.
  2. akismet_marked_as_spam.png

  3. Download the scripts. Three files will exist in the zip file:
    • index.php: The main script that handles the incoming data, talks to Akismet and posts the data to Web to Lead.
    • constants.php: You will need to go into this file and edit some variable values based upon your own organizational setup. See the next step.
    • Akismet.class.php: This is the Akismet PHP5 class I was talking about above.
  4. Edit the constants.php file:
    • Enter your WordPress API key where it says ENTER_WORDPRESS_API_KEY. Get a personal or commercial key if you don’t have one.
    • Enter your company URL where it says ENTER_YOUR_COMPANY_URL.
    • Enter your company’s Org ID where it says ENTER_YOUR_SALESFORCE_ORG_ID. This is actually optional. Doing this allows you to remove the OID from your public web to lead forms so spammers don’t know your Org ID. Doing this will reduce the amount of spam you actually need to process.
    • Generate a web to lead form in your Salesforce setup. Find the new Salesforce field you created in step 1 and copy the id value from the HTML form and put it in the constants.php file where it says ENTER_THE_W2L_CUSTOMFIELD_NAME. This step is required so that your Salesforce org is actually populated with the Akismet result.
    • PHP Advanced: The $Akismet_noPass array holds the names of fields that should not be included in the content passed to Akismet. Feel free to add/remove values from this array. The values in the array are referring to the names of form fields in your web to lead HTML form. I have no idea if this helps/hurts, but it seemed like a practical thing to add into the script.
  5. Upload the scripts to your web server and note the fully qualified URL for that directory (e.g.
  6. Update your web to lead forms to have them post to the location of the files from the previous step (e.g. – make sure to put the / at the end of the URL. Not sure why, but I wasn’t able to get it to work without it)
  7. Test your form to see if it works. The script acts as an intermediary between your form and Salesforce web to lead. The end-user experience should be the exactly the same with or without the scripts.
  8. Once you know it works, you should add a lead assignment rule into Salesforce as rule #1 that looks to see if this field is checked. If so, then route the lead to a “Potential Spam” queue or something of that nature. Another option is to create a validation rule that doesn’t even allow the lead into the system.
  9. Make sure your Auto Response rules don’t email a reply to leads marked as spam. If you allow this, then those spammers have an email address to try.
  10. Update some/all of your web to lead forms to post to this new page. If desired, remove the “oid” field from the HTML form for each of these since the script will pass your Org ID to Salesforce automatically.
Other Stuff

These scripts are a proof of concept. I am not officially supporting them, but am happy to help people out informally. Post comments here if you have questions/comments/criticisms.

I have only tested this with leads that were either real or very obviously spam. It worked well. From Akismet’s perspective, the data it checks looks just like a blog comment and I can attest that Akismet is amazing at identifying blog comment spam. So it should work well for web to lead.

I am going to update my existing web to lead forms on this site and see how it works and report back to you. I encourage you to do the same and let me know your experiences with it or recommendations on how to improve the scripts.


Comments (61) comments feed

Dreamforce 2007 Web Site

The Dreamforce website is up and running at or I would expect it to be as interesting as last year. At that time, we should be getting close to GA for Apex Code, which I hear is scheduled for December 2007.

The ADN session is called “Developers @ Dreamforce” and information on it can be found at

Register before July 16 and receive $100 off the conference fee. Pre-July 16, the fee is $899. Afterwards, it’s $999.

See you there!

Comments off comments feed

Want to blog the Salesforce Developer Conference?

As of this moment, I will not be able to attend the May 21 developer conference. If you will be attending and are interested in blogging about it on this blog, post a comment below or use the contact form to let me know . I’ll get in touch with you to discuss. If all goes well, I’ll set you up with an account on this blog during the conference.

I am looking for someone that can be objective in their analysis (i.e. not someone trying to promote their own products or overly promote/bash Salesforce). However, if you do it, I’m happy to introduce you on this blog and give you some space to promote what you do.

If you don’t have a Salesforce blog now or are thinking about starting one, this could be a good opportunity to get your feet wet and get yourself known by the community.

Comments (1) comments feed

Google on mashing up Google Apps &

The Google Enterprise Blog feed-icon-12x12.png has a post announcing that they will be presenting on mashing up Google Apps (Gmail, Calendar, Docs & Spreadsheets) with at the upcoming May 21 Developer Conference.

This should be pretty interesting for those interested in mashups. Google Apps is a very popular service for hosting your domain’s mail & calendar. It also includes a start page (which barely works) and access to Docs & Spreadsheets through your domain account. More services should be added in the future and the APIs will only get more comprehensive.

Google’s post can be found here.

Comments (1) comments feed

« Previous entries