Written by Eric Barnes in

How We Use Live Lookup

Equipping your agents with all the information they need to answer support is important. This not only includes seeing customers past requests, but also being able to view items like their co-workers, purchase history, and even the company they work for.

The information your agents need varies by industry and HelpSpot includes a feature called Live Lookup that is flexible enough to cover almost any need. It can be used to query your CRM, an external database, or any other type of system where you store customer information.

Live Lookup can be utilized in a lot of different ways and in this post we will take a look at how it works and how we use it at UserScape.

Introduction to Live Lookup

On the basic level, Live Lookup is a way for HelpSpot to communicate with a service and show the results right inside your help desk. In order to implement it, you will need a script which takes different customer parameters and then returns an XML result.

Here is the basic workflow:

  • An agent clicks the Live Lookup tab found above the Customer Information box on the request page.
    • Note, this can also be automated via a Trigger so that the customer data is automatically populated with no agent interaction required.
  • HelpSpot sends all available customer information and custom field values to a script written by an Administrator (or other technical resource).
  • The script will look up the customer information and compare it to what is stored in the pre-defined system/database. (Examples: Active Directory, SalesForce, Highrise).
  • Customer information is returned and HelpSpot displays the results in an embedded window. If multiple matches are found, a list will be returned to the User for selecting the correct result.
  • With the correct customer is selected, their information (and any specified custom fields) can be inserted into HelpSpot.

Here is a screenshot of a result returned from the lookup:

live-lookup-single

With the basics covered, let’s dig into our Live Lookup setup.

How we implemented Live Lookup

For UserScape, we need to connect to our store to find out all the details about the customer and, in our case, this is a completely different server.

To do this, we set up two different sources in the Live Lookup settings. This can be found in Admin -> Settings -> Live Lookup. Our first service searches for any users that match the requester details. For example, it does a search like this:

Find all users who’s first name is "John" and last name is "Doe"

Because this is a pretty vague match, sometimes it returns more results than needed, and other times it doesn’t find anyone. So to combat those scenarios, we have a second live lookup search. This one takes the email address and removes anything before the @ symbol. This gives us a search like the following:

Find all users where email is like "domain.com"

By having both ways of searching when one doesn’t find anything, the agent can easily select the other source.

The Live Lookup Results

As mentioned previously, the results can be customized to what matters for your company. Here is a screen shot of our results:

live-lookup-results

As you can see, we want to see the customer id, organization name, the number of licenses, and when their support ends.

These fields can be customized by adjusting the “columns” in the first element in your XML file:

<livelookup version="1.0" columns="customer_id,licensee_organization,licenses,has_support_until">

Then once you click into a record, you will see all the details about the customer:

live-lookup-single

In our results, we show if their support is expired, the number of licenses, users on the account, and finally, a list of links that are commonly needed when answering requests. These links make it very fast for the support team to give the customer the proper link for their situation.

Implement the Live Lookup

If you’d like to learn more about this feature and how to implement it in HelpSpot, please see our Live Lookup guide.

Presented by HelpSpot

Hit the restart button on your customer service. HelpSpot has everything your support team needs to make your customer service sing.

Don't miss our next post

We publish new posts each week. Get them in your inbox.

Write a guest post

Interested in writing for the HelpSpot blog? We love adding new voices.

About the author

Eric Barnes of

Eric is an engineer on HelpSpot and runs the popular Laravel News website..

Topics