I just caught wind of the new Google Visualization API, so I opened up a Google Spreadsheet (we have over 10 people using Google Apps in our company now) and all I can say is "wow!"

Just as a quick experiment, I generated a bar chart of response times for one of our hosted solutions and clicked on the newly available "publish" link to generate the image below.

If the spreadsheet is ever updated, I just re-publish the chart and all external channels referring to the image are automatically updated.

I'm extremely impressed with the mashup capabilities enabled by Google Visualization and Google Charts. If the Salesforce / Google integration observations are true, then I'll be in absolute mash-up heaven

Our new Director of Sales and Marketing, Jennifer Clark, has really hit the ground running and deployed a fantastic new website for www.CubicCompass.com.

Brian Rhinehart (of www.KineticShadows.com, a local parther) and Joe Garber, our resident Interactive Web Designer/Developer, played key roles in the transformation of our new image.

Some changes in our web site and overall strategy:

* RSS Feed Subscribers should update their feed to this URL. The old Blog RSS feed will continue to redirect for a few more weeks.

* www.i-dialogue.com now redirects to our main corporate website at www.cubiccompass.com. i-Dialogue continues to be the brand of our hosted suite eMarketing and Customer Experience Management solutions.

* i-Dialogue is now available in 4 editions to serve a variety of CEM needs.

Nicholas Carr advises his readers to put their ears to the ground as Microsoft prepares to announce further details about their "computing in the cloud" strategy.

Some facts and observations I've made:

• Ray Ozzie, Bill Gates heir apparent, is a smart guy and has been under the radar for over 2 years working on something (presumably).
• Microsoft has been building, acquiring, and deploying datacenters at an alarming rate. But the utilization math doesn't quite add up. There's a lot of untapped, unused computing power owned by Microsoft.
• In my recent discussions with various Microsoft employees, there is a much more open and humble acknowledgment that they are in the canonical Innovators Dilemma and must branch out into hosted services while still retaining the Windows OS/Office cash cow.

It will be interesting to see how similar this new strategy is to Microsoft's Hailstorm platform, which was announced 7 years ago. Ironically enough, the Architect of Hailstorm, Mark Lukovsky, left Microsoft and joined Google to ultimately implement and fulfill this vision.

Microsoft clearly has the Engineering resources and talent to compete with Google, Yahoo!, and Salesforce.com in Internet delivered services. It makes one wonder what exactly is preventing them from tapping their true potential? 

Per Nicholas' advice, my ear is firmly planted to the ground...

Traditional web design and development are rooted in the concept of a Multi-Page Layout, or MPL. Contemporary web design and content management systems have transitioned towards a Single Page Layout, or SPL.

MPL web sites store their content in individual web pages. Adding more content requires adding additional pages. SPL web sites use a single web page template that derive their content from a database. Salesforce.com makes a great database for managing both content and Leads/site members.

Many organizations gradually wade into developing unique landing pages for Google AdWords or publishing products and services. At first, the MPL approach provides the path to least resistance since initial development and deployment costs are fairly low. The cost of change remains fairly linear at first as each new page is cloned from an existing page and modified to suit the campaigns needs. But over time the cost of change begins to increase. It takes longer to provision new pages and development becomes much slower.

A form of "technical debt" is accrued whereby a developer must eventually externalize common UI elements to server side include (SSI) files, such as headers, logos, navigation, and footers. Even with SSI best practices in place, a developer/programmer still remains in the critical path for each new campaign and the skills required for ongoing maintenance remain high.

SPL templates may take 3-5 times longer to initially implement, but successive pages may be easily provisioned by business users, such as Marketing and Support admins. The time to provision a new page remains linear over time as each new page is defined in a database and immediately available for use in PPC campaigns.

SPL page templates are actually very simple to develop. They may look slightly cryptic when opened in a common web page designer because they contain "merge tags" to be replaced by the database when the page is displayed. The URL typically contains some kind of unique ID to give the page context as to which content to display.

i-Dialogue 8 now supports a new scripting language called Dialogue Script that removes the need for a physical page template. The SPL template can be created directly in a web browser and the merge tags can define any Salesforce object or field.

The Professional Services group at Cubic Compass Software has extensive experience with SPL design and hosting. Contact me for more information. I'd be happy to help.

Which Super Bowl ads made an honest attempt at initiating a two-way dialogue? Here's my scorecard.

The Scorecard

Compelling Call To Action: Did the ad provide a memorable URL and call to action?
Continuity: When I go the URL, is the message in the context of the TV ad?
Fulfillment: Does the website answer my questions or deliver on any promises made?

The Winners

Based on the scores, Tide and Jack in the Box come out on top. As far as most functional campaign, SalesGenie.com is the most likely to get visitors to self-identify and enable an ongoing dialogue.

Interesting that in such a consumer driven B2C Internet world that a B2B site would have such strong positioning in the Super Bowl.

Dialogue Script (or DScript for short) provides a simple scripting language for developing interactive web pages, forms, and applications integrated with Salesforce.com. In this series of articles, I'll cover some basic scripting concepts to address the most common use cases.

Dialogue Script Articles:

1. Master Views and Lists
2. Details View
3. Web Form

What is a Master View?
"Recent News" is an example of a Master View. It is simply a list of items that are dynamically queried from Salesforce.

Here's an example Dialogue script that displays a top 5 list of the most recent press releases:

<dlog:repeater id="LatestNewsRepeater"
SOQL="SELECT TOP 5 * FROM Content__c WHERE Type__c='Press Release' ORDER BY CreatedDate DESC" runat="server">
<ItemTemplate>
<dlog:HyperLink ID="HeadlineLink" TextFieldName="Headline__c" NavigateURL="~/News.aspx={oid}" runat="Server" /><br/>
</ItemTemplate>
</dlog:repeater>

Example Output: (example links only)
ACME Corp Announces Q1 Financials
Jane Smith Joins ACME as VP of Operations
ABC Sees Record Growth After Using ACME Solution
ACME Announces 2008 Product Roadmap
Wall Street Journal: Inside Look at ACME

This example uses a Repeater control and SOQL Plus to query Salesforce and format the repeating layout of each item in the query result. Dialogue Script supports Salesforce Object Query Language (SOQL) plus adds support for tokens like "TOP", "ORDER BY", and "IN".

You can query any object in Salesforce. Master Views and Lists are a great way to provide customers with high level information and get them started in a general direction. Adding an ORDER BY CreatedDate DESC clause ensures the web page always stays up to date and displays the latest press releases, meaning you never need to update your web site when a new press release is launched. Query results can be cached to improve performance by adding a CachedDurationMinutes attribute to the Repeater.

In the next article, I'll demonstrate how to use Dialogue Script to format the actual Press release page using Salesforce data, plus some bonus script on creating a dynamic Google AdWords landing page.

Happy scripting!!!

We're formalizing a program that encourages our employees to donate time and resources towards the implementation of i-Dialogue solutions for non-profit organizations. The i-Dialogue solution will be donated and hosted for free (CMS Edition).

We're currently looking to kick start this program and donate time and services to a Non-Profit Organization meeting the following requirements:

• Already using Salesforce
• Located in or around Portland, Oregon
• NPO should have a need for an online community or interactive campaign management

Contact us at info@cubiccompass.com for more information on this program.

"It's like trying to get a scientist working with a snowboarder"

Gene Munster, Piper Jaffray & Co equities analyst, on the pending merger of Microsoft and Yahoo!

I'm still waiting for the big one. That well coordinated campaign that starts with a 30 second commercial during the super bowl that inspires consumers to continue an online dialogue. A campaign that demonstrates true ROI and actually measures the value of a $3M investment.

Last years super bowl left me wanting, but there were some success stories. Some might say GoDaddy owes it's market position exclusively to Super Bowl advertising with a call to action that brings people online (eventually) to have some presence on the Internet super highway.

SalesGenie.com, voted worst ad of last years Super Bowl, drove 25,000 visitors to their site. They'll be back again this year with 3 more ads. Did anyone else notice the timing of Mark Israelsen's departure from Salesforce.com to head up SalesGenie starting February 1st? Looks like he'll hit the ground running.

Here are some dialogue tactics/strategies I'm hoping to see this year that convert a one-way broadcast into a two-way dialogue:

• Easy to remember domain name. Here's the pitch.... go here to learn more. That's the 30 second objective. www.GetItNow.com wants "mid 6 figures" to purchase this domain (Let me know if I can help negotiate this ). What is the value of a short, easy to remember domain if your current URL will result in higher abandonment?
• Relevant Landing Page. You just paid $3M for a 30 second ad. Please make the next step in the dialogue relevant to the upstream message. Don't just drop me on your home page.
• Immediate Gratification. The super bowl is all about entertainment. Keep the online dialogue rolling. Keep it entertaining. An interactive Flash game or video perhaps.
• Keep the First Date Simple. Need to know something about me before fulfilling an offer (such as free 30 day demo)? That's fine. But keep it simple. Why do you need more than an email address and name on our "first date"? I'm not applying for a home loan. Keep the conversion forms short and incrementally ask for more information over time.
• Where in the World Is Carmen Sandiego? Keep me engaged. Continue and evolve the story. The Super Bowl ad is only the beginning. I need to go online to learn the middle..... keep the dialogue going and engage me in the ending.
• Cross Channel Boundaries. I have a mobile phone. Let me subscribe to SMS alerts as part of the dialogue. Coordinate Television, Internet, and Mobile to facilitate a dialogue.

Steve's recent post about the AppExchange delisting uncertified apps reminded me of a Wiki project I started back in July '07 named www.BackExchange.com.

The BackExchange was intended to be an open directory of unlisted AppExchange packages, but we ended up publishing our unlisted add-on apps to our knowledge base, so the www.BackExchange.com went unused..... until now.

I'm happy to turn control of this Wiki over to the general Salesforce community. The editing permissions have been modifed to allow anyone to contribute.