Importing Conversations from a Spreadsheet

Conversations that happened somewhere else, a paper form, another system, an event, can be brought into Echo as a CSV so they appear in reporting alongside everything else.

2 minute read

Not every conversation a ministry has starts in Echo. Somebody fills in a card at an event, a partner sends a spreadsheet, an older system holds a year of history. Imports is how that gets in, so it counts in reporting alongside everything else.

Where to find it

In the admin menu, click Imports.

The Imports screen, with a Create Import button and a table of previous imports.
The import screen, and every import run before it.

Running an import

  1. Click Create Import.
  2. Choose the External Referrer — the source these conversations should be filed under.
  3. Choose the Outcome to record against them.
  4. Click Choose File and pick your CSV. The limit is 50MB.
  5. Click Submit to start the import.

The External Referrer list only contains sources of the External kind. If yours is not there, create it as an external source first — see the External Integrations article.

Reading the results

Every run is listed under Previous Imports with five numbers.

ColumnWhat it counts
StatusWhere the run got to.
Created ConversationsConversations that did not exist before.
Created MessagesMessages added inside them.
Updated ConversationsConversations Echo matched to something already there.
Updated MessagesMessages changed rather than added.
Imported AtWhen the run happened.

The created and updated split is the number to read. A file you expected to be all new arriving mostly as updated means Echo matched rows to people already on the account — which is usually right, and occasionally means your file has the wrong identifier column in it.

Import a handful of rows first and read the counts before importing the whole file. An import writes conversations into your reporting, and unpicking a bad one is far more work than running a small one twice.

What the terms mean

TermWhat it means
External referrerA source representing something that happened outside Echo — a form, an event, another system.
OutcomeThe result recorded against every conversation in this file.
Import recordOne run, and the counts it produced.

Did this answer your question?

  1. Conversations Report

    The new Conversation Report in Echo's analytics tab provides comprehensive tools for analyzing your conversation data.

  2. Echo CRM 3.0

    CRM or Client Management is where your client information is stored in Echo.

  3. External Integrations

    You may have had a conversation with someone outside of Echo that you want to capture the details and store them inside your Echo account for tracking purposes.

Still stuck?

Send us your Echo address and a screenshot of what you are seeing, and it goes to somebody who can look at your account.