No IT system is an island. Most enterprise systems have ways of getting data in and out – some easier than others. But at CustomerGauge, we are proud of our track record in integrating with all sorts of diverse systems from mainframes to PC servers.
We have interfaced with Salesforce.com, SAP.CRM, Siebel, DigitalRiver, Magento to name a few.
Part of our ability to do this is our publicly documented and available API (Application Programming Interface) system. For those that wouldn’t know an API from your BMI, an API is an “application program interface” – it allows CustomerGauge to automatically send and retrieve data to and from any external system. And we’re proud to announce new upgrades to our set of APIs for CustomerGauge 3.0.
The updates extend the previous API system (2.0) to simply and quickly get data in and out of nearly any external system.
For the new 3.0 API, we use well known interfaces, and several standard ‘methods’. The APIs are REST-based. You can use them with XML or JSON input/output. Files can be “POSTed” to the API for improved security.
We now follow a “CRUD” scheme – you can Create, Retrieve, Update and Delete records as needed. You can read all about the differences and new capabilities on the CustomerGauge Support Site.
99 Problems (But Data Ain’t One): How CustomerGauge makes it simple to input data, and an API update
To paraphrase Mr Jay-Z: “I have encountered nearly 100 difficulties, but loading my data into CustomerGauge cannot be counted among them”. We can help you get your data in shape to measure Net Promoter.
We offer multiple ways you can format the data – starting from a simple spreadsheet to a complex XML feed.
We can take in the data in a variety of ways – from emailing it to us (fine for a small project), loading directly into CustomerGauge, or a full integration using our API.
Details are here, now conveniently in our support section.
API v1.1.7 – now with Workflow
We just updated our API documentation to include methods of extending our firefighting workflow system. This makes our workflow tool very powerful – it allows you to pull out the status of workflow (open/closed/in-progress, plus all the notes and date information), and also to remotely update the workflow.
So if you are using an external issue tracking system like Remedy or RightNow; or CRM system like Salesforce you can do a very neat tie-up with CustomerGauge.
An example might be a transaction-triggered survey in CustomerGauge, then using Remedy to solve the customer issue. All the analytics and reporting are in CustomerGauge, problem is solved in Remedy. Alternatively CustomerGauge can serve as the Net Promoter measurement tool for your helpdesk.
This API can bring Net Promoter measurement into all of your forward facing customer systems – API 1.7.1 details here.
Case Study: Melitta: How the inventor of the coffee filter is delivering a high-caffeine shot of Net Promoter excellence
Melitta is the 100 year old Minden, Germany based manufacturer of branded products. Founded by housewife Melitta Bentz, inventor of the paper coffee filter, its main activities are production and marketing in the fields of coffee, food storage and preparation, and domestic cleaning. Probably its most well-known product is its fully automated coffee machines. However, the company has a number of brands in its portfolio that enjoy leading positions across many international markets. And they are totally committed to excellent customer service.
This case study describes how their Net Promoter project was implemented for their customer relationships and customer service systems together with CustomerGauge partner in Germany J/S/W Consulting.
Highlight of the system is the automated link from the call center to the CustomerGauge system via the API (CustomerGauge Application Programming Interface). Within moments a survey is sent out to the customer, resulting in a 60% response rate.
The system has already started to make an impact. Prior to the rollout, Melitta was confident that customers had a strong emotional bond with the brand and products. But the survey result surpassed all expectations, with initial scores above NPS +50 to back up the very high response rate.
Commented Consumer Service Coordinator Christoph Sundermeier: “It’s relatively easy to nurture relationships with customers to the point where they are satisfied with your service, but it’s another thing entirely to nurture relationships to the point where customers become active promoters, so we are exceptionally pleased with the initial results.”
As coffee lovers, we are delighted to have a client with excellent customer service, and great coffee machines too. By the way, our Client Operations Manager is an absolute coffee connoisseur – and she highly recommends their machines. Praise indeed!
CustomerGauge is now available with a full range of API (Application Programming Interface) methods to connect to enterprise systems, so now it’s simple to connect to ERP, CRM, BI and e-commerce systems and measure Net Promoter® Score. It is the first fully automated Net Promoter Score platform with an enterprise level API.
Using the API, CustomerGauge clients have already been able to integrate service-request systems, IVRs and other enterprise systems to contact customers and measure NPS in real-time, feeding results directly back into corporate systems.
One client uses the API to send customer details to CustomerGauge as soon as an agent hangs up the phone, and within two minutes the same customer receives an email survey to gather a score and a comment. The results of this activity have pushed response above 50%.
Another client is using the API to push customer issues directly into Salesforce.com in order to “Close the loop” with the wider organisation.
And another client is using multiple platforms to survey, including graphically based iPad systems, all based on communicating results to CustomerGauge with our secure API.
These CustomerGauge platform integrations are simple and quick to implement, and mean that NPS can be easily rolled out across organisations by connecting with diverse IT platforms.
CustomerGauge announces integration with Salesforce.com – now you can effectively survey contacts from Salesforce and add survey results and firefighting activities right in your database.
(view our 4 minute video on CustomerGauge to Salesforce.com® integration)
As Salesforce.com users ourselves, we have long wanted to find a way to get Net Promoter® scores and comments from our own CustomerGauge surveys into the Salesforce.com system. Two years ago it seemed a little daunting with their APEX language but with the recent addition of REST to Salesforce we now have an excellent and reliable way of doing this, using their web services interface (SOAP / REST API ).
- Attach a Net Promoter Score and comment from a completed CustomerGauge survey to the right record in Salesforce.com (it adds an Activity – you can see this in the video)
- Create a “Case” containing the relevant customer comment and other information in Salesforce.com so that existing CRM workflow in your system can be used (you can also see this in the video)
- Export from Salesforce.com – Using our survey “Fire-Fighting” functionality we are able to trigger Salesforce.com to export selected records to CustomerGauge automatically (more on that in a future post)
We have added some custom fields in Salesforce to show NPS.
We would be delighted to show you how it works, and help you to try it yourself by using development accounts on Salesforce.com and CustomerGauge.
CustomerGauge announce a breakthrough in real-time display of Net Promoter® Score with the stand-alone “AnalogGauge”, an internet-connected device with a moving needles showing the score for various times and segments. Building on the success of our real-time digital signage systems which utilise a plasma or large screen, the new device is designed to sit on the CEOs desk (or the desk of any member of the company’s Net Promoter team). The production model will show customer responses in real-time from CustomerGauge and Recommendi and display the overall score for a periods or segments that can be easily set on the controlling website.
Why wait for a score?
We’d like to think this shows our commitment to showing instantaneous results from our measurement systems so our clients can make adjustments in real time. Not only can clients drill into up-to-the minute comments and scores on the CustomerGauge dashboard, but can get the results displayed, tweeted or pushed into CRM systems via our APIs. We believe there is not a comparable system on the market that show feedback in this way, or offer such flexible integration options.
We are working hard to bring the product on sale in the second half of the year – it will be available to all CustomerGauge clients as a simple plug-in, and later as a display option for other measurement providers. More details on the AnalogGauge on request.
Getting data into CustomerGauge is simple – we cover major data formats including CSV, TXT, Excel/Google Spreadsheet XLS format or XML. Transport mechanisms inlcude email, FTP, API or in-application upload. This means that we can take data from almost every CRM system, including Salesforce.com, SAP CRM, SugarCRM, Siebel and Microsoft Dynamics. Alternatively, we can take transactional data straight from popular e-commerce systems including DigitalRiver, Magento, automating the upload so it happens in the background every day.
If that doesn’t fit, our development team have almost certainly got a plug-in that can be customised to fit your application.
When you are ready to measure Net Promoter Score we are ready to assist.
Also, see more on the file details in this post: CustomerGauge In: B2C Data Import Formats
This is v1.0 of our standard CustomerGauge XML comments and Net Promoter® Score API (Application Programming Interface). We have made it as simple to use as possible for widest possible use. See also our other feed documentation on our support page.
Using the XML API
You could use this to:
- display comments on intranet or external sites
- update internal systems and dashboards
- update CRM systems with score and comment using customer number as lookup
We provide in the feed as standard:
- Net Promoter Score (0 – 10)
- Customer Comment
- Translated Comment
- Customer Reference Number
- Various segments (country, store, channel)
- Date of comment/Score
- Product SKU (if available)
- Useful plain-english description of feed source if re-used in other places
- Date of feed
- Link to comment detail page in CustomerGauge
It is available in secure mode (default) or open (no security). We are able to simply configure it depending on frequency of update and security needs.
Standard feed is secured with User Name and Password, using CURL in PHP or similar.
URL example: http://www.c1-gauge.com/sites/RSS/xxxFeedSecure.xml
Using the API – PHP example
Example using PHP:
$ch = curl_init();
$user = ‘Acme’;
$password = ‘Acme1FeedExample’;
curl_setopt($ch, CURLOPT_URL, “http://www.c1-gauge.com/sites/RSS/AcmeFeedSecure2.xml”);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_USERPWD, “$user:$password”);
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
$output = curl_exec($ch);
$info = curl_getinfo($ch);
Once configured, you can test it using a testing page:
Testing page: https://www.cg-express.com/test/CurlPassword.php
<?xml version=”1.0″ encoding=”UTF-8″ ?>
<title>CustomerGauge Comment API</title>
<description>The whole experience buying was easy & stress free. My headphones arrived swiftly & are comfortable to use. I am a great fan of Acme as I am still using the iron I was given as a wedding present in 1971. It has been in use daily & despite needing a couple of new flexes over the years has never once let me down. Well done Acme!</description>
<store>Acme Online Shop</store>
<source>Testimony for customer ID 145XXXXXXX from Acme Online Shop, powered by CustomerGauge</source>
Please contact us for details on help with setting it up and configuring.
We provide several ways to take data out of CustomerGauge and display in Real-Time.
- RSS XML feed (described below)
- Twitter Feed
- XML API (documentation coming soon)
- Real Time Display board in browser
RSS XML Feed
The RSS feed is ideal for a simple feed of customer comments for a testimonial feed, external website or intranet application. In this format only comment, score and date is given, so it can be reasonably widely published. No customer attributable data is published (unless revealed in comment box).
For more flexible feeds we recommend our XML API feed (documentation available soon).
The RSS feed file is generated each hour. It always shows 10 comments (the last 10 comments left, sorted by most recent). The number of comments can be adjusted on request.
Feed shows NPS Score, Comment, Date Comment Left
NPS score: <title>10</title>
Comment: <description>Great service. Thanks</description>
Date comment left: <pubDate>2010-04-13 08:04:26</pubDate>
Standard feed is secured with User Name and Password. You can put in a user name/password on most readers. For automated applications (intranet feeds etc) you would use CURL at your feed reader to access.
<title>CustomerGauge Comment Feed</title>
<description>Intranet Comment Feed</description>
<description>Great service. Thanks</description>
<source>Comment for customer ID xxxx from xxxxxxxxx Online Shop, powered by CustomerGauge</source>
Please send comments to API@directness.net
With Google Real-Time Search launching today, we thought it appropriate to show off the CustomerGauge Real-Time Customer Comment Feed, which works via Twitter. Ideal for customer-focused companies that like to rapidly react to feedback and issues.
It started when a client asked: “Could we put a desktop widget on the bosses desk, so that every time a new comment comes in it pops up?”. Actually we’d been thinking about this for a while, trying to find the right component.
Now we have a solution that’s super easy and flexible: we integrated CustomerGauge with Twitter. As soon as a customer makes a comment, an API connection to Twitter is made and a “Tweet” sent – and you get a real-time feed on your favourite device (PC, mobile phone etc). It is customisable, so you can filter on comments – examples: “Score 9 + 10 comments for call center staff” or “Detractors commenting in Manchester with ‘reception’ keyword”. The feed can be public (if you are proud of what your customers are saying) or private so it’s secure for selected subscribers. A link takes you to the full comment and customer details.