Make a Better Landing Page by Analysing Live Chats in the Airtable Spreadsheet App

Last updated on June 10th, 2023

Pardeep Kullar
Pardeep Kullar

Who reads your blog and signs up to your product? Company directors? Founders? Regular employees? Getting that landing page headline and key benefits right for the right people is tough. Do they understand it? Is it exciting enough? Are we focusing on the problem? We’ll show you how the Upscope home page changed over time and how to set up a better process for analysing conversations using LiveChat and Airtable.

Upscope’s landing page changes over time

This is how the Upscope home page evolved in just the last year.

  1. We first tried explain Upscope as being ‘one click from live chat’ and focused on using it for fixing problems. It’s not a bad headline but it still left people a little lost. Like an opening line of a story that leaves more confusion than excitement.


  1. We later realised that we need to use the words screen sharing so they had context even though we’re technically a new modern form of screen sharing known as co-browsing. However, we were still focused on ‘fixing problems’ which was only part of what customers really wanted.


  1. This is the current home page. In many ways, it’s not as pretty or as clean. We not only use the word screen sharing but the second line states that it’s for on-boarding and support of ‘non-tech’ customers.


We’re now getting more of the right customers who understand what the product does and a higher average conversion rate.

What did we analyse to make these changes?

We did 3 things to learn more about customers.

  1. We manually looked through chats to see what customers really said.
  1. We downloaded and analysed the job titles of customers who used our product the most.
  1. We phoned them up and spoke to them without trying to sell to them.

What did we find?

They used it for onboarding and sales as much, if not more, than support.

In fact, support overlapped with onboarding. It’s all the same game. We’re all trying to educate the customer on the product because if they understand how to use it, they’ll actually use it and not churn.

How can you analyse your chats? Try Airtable

What is Airtable?

You know Google Sheets? It’s not that.

If you’re non-tech, Google sheets is a little intimidating when you go further than basic spreadsheet use.

Airtable is a spreadsheet app built from the ground up to be friendly and help you create a big interlinked set of tables while remaining happy.

It has templates, it’s colourful, picturesque and the onboarding is great.

You can import data, link up tables and invite team members to work together on the same tables.


To analyse your chats, auto-import them to Airtable

Key steps

  1. Connect your live chat tool to Airtable using Zapier.
  2. As the chats are added to Airtable, separate out the questions.
  3. Do the actual analysis, make assumptions, make changes.

Below I’ll use LiveChat as an example. It’s a good clean live chat tool with a large base of users and has a lot of experience in the area. We’ve used LiveChat in the past on another project and we liked its focus on core features.

Connect LiveChat to Airtable using Zapier

If you don’t have LiveChat and want to test it out, look at this article on how to run it on your local machine without knowing how to code.

Also, sign up and create a new table on Airtable with a few fields including ‘Chat’, ‘Name’ and ‘Email’ before you carry on.


Set up Zapier.

  1. Within Zapier, create a new Zap and include both LiveChat and Airtable as apps.
  2. Choose ‘Finished chat’ as the LiveChat trigger that initiates an action.
  3. Choose ‘Create Record’ as the action to take in Airtable.
  4. Set the Zap to ‘On’ and test out your first chat.

This is what happens. The new chat, when finished, is placed in the ‘Chat’ column of the ‘LiveChat questions analysis’ table.

Write the key question in a separate column and sum them up

I separate out the key question from the chat and put it into the next column. That’s it. Let that be the process.


After a while, you’ll see the pattern of questions.

An interesting exercise, before you analyse it, is to write down what you think will be the most common questions and see if you’re right after the analysis. Confirmation bias is a killer.

Once you’ve added up the questions, figure out the priority actions.

If lots of people are asking about ‘security’ then maybe explain why the product is secure further down the page. Add a separate security page. Add a security white paper.

We’ve been through most of these steps and created both a security page and a white paper.

Analyse who signs up, who uses your product and why they use it

On top of analysing chats, an essential step is to know who is talking and separately, who is using it.

We’ve got this wrong time and time again by making dumb assumptions.

We found that CEOs and senior managers both read our blog, replied to emails and signed up, even on weekends and late in the evening.


So many people signing up were senior management that it made us wonder if the regular employees had better things to do ?


Did you ever imagine that the person signing up may not be the one using it?


It wasn’t to me.

I imagined all sorts of people were signing up and that gave me a general feeling that I knew who our customers were but no real evidence.

We found that a large number of founders and people in management positions tended to sign up but weren’t necessarily the end users.

Maybe it’s because founders and managers are more likely to be looking for software that cuts time or helps them makes sales. Maybe other employees don’t feel like they can go looking for that software themselves? Who knows.

If you have not done so:

  1. Download a list of your current customers and separate them out by industry.
  2. Find the job title of the person who signed up first.
  3. Find the job title of the person who uses it the most.

Below is part of the industry analysis we did. You can do the same in Airtable making it easy to link up to other tables.


We noticed a number of interesting things about who was signing up, who was using it and why they used it.

Who was signing up?

Founder / Chief Executive Officer

Director of Customer Services

Customer Support Manager

Who actually used it?

Account exec

Customer support rep

Sales rep

(and founders for smaller companies of course)

What were they using it for?

We initially assumed it was focused on support but it was also heavily used for onboarding.

There is quite an overlap between account management, sales and support in many web apps using live chat.

At the core of it, they’re educating users and visitors.

Calling them directly and asking them

On top of everything else, this is simple and effective action to take. We called new sign ups and spoke to older customers when the opportunity arose.

We discovered the overlaps of support and on-boarding. We found that some of our assumptions on the failings of old school screen sharing were spot on. We found out that they really did not generally understand what co-browsing was. This helped provide further clarity on the rest of the analysis.

For example, these are the notes from one phone call:


How does this all add up to landing page changes?

What we learned from the analysis:

  1. The initial sign ups are senior staff.
  2. The teams using it were in support, accounts, customer success, sales.
  3. They used it for onboarding, support and sales.
  4. The end users were often non-tech.
  5. They did not understand the word co-browsing, many did understand and use other screen sharing tools but found them to be a pain.

End result?

Go to our home page and you’ll notice the following.

The top title covers these points.


We go further into individual use cases and related stats.


We explain the difference between screen sharing and co-browsing


We went through a lot of dumbass mistakes to figure out the obvious through a more data driven approach, I hope this helps you.

If you’re interested in LiveChat and would like to see how it works with Upscope then see our integration page.

**Related: **If you want to learn about a tool similar (and yet different) to Airtable, read about our experiment with Coda docs.

Pardeep Kullar
Pardeep Kullar

Pardeep overlooks growth at Upscope and loves writing about SaaS companies, customer success and customer experience.