Export your search results

Sometimes you need to get data out of Lexer and into another tool, so you can cut it up your own way, here’s how.

The export feature allows a user to get their hands on the data behind the charts, streams of content, and tables. Using export will prepare a file specific to your search, and return it to you as a CSV file, which is a common format for importing into other programs such as Microsoft Excel, or Google Sheets.

  1. Search Using Your Deep Dive
  2. Find Mentions Using the Live Stream
  3. Export Your Results to CSV

Each export is unique to the search you’re running. Be sure to configure your deep dive to include the content you’re trying to export. To export social content that relates to your search, head to the live stream page. Use the down arrow in the top right corner of the “MATCHES” table, and select “Export to CSV”.

Exports appear on most charts, providing different data for each. Exports are made apparent with the presence of the down arrow in the top right corner of each chart. Charts will generate an export for the data they represent.

Some examples of different exports are:

Data To export Location of Export
Social Media Content Export from the mentions table in Listen.
Influencer Lists Export from the top authors chart in Listen.
Geo Location of Customers Export from the heat map in the location page in Listen.
Every Interaction Your Agents Have Had Export from the SLA report in Activity.
Every Start to Finish Conversation Your agents Have Had Export from the Cases report in Activity.

Why are the dates wrong on my export?

Lexer’s native timezone is UTC. UTC is generally in sync with GMT, so it’s good to use this as a guide.

Any exported data is automatically converted to UTC. So if you’re based in Melbourne, for example, the time will appear to be out by +10 hours.

Simply adjust the time accordingly with a formula, and you’ll have the time and dates converted to your local time.

To apply this, create a new column in your spreadsheet alongside that which contains the current timestamps. Then apply the below formula (assuming cell A2 on your spreadsheet is the date/time) to the first cell, and drag down to apply to the whole column:

=A2+TIME(10,0,0)

This formula doesn’t account for Daylight Savings Time, so it’s best to look up the current difference between UTC/GMT and your local time.