This feature is available for franchise or multi-location types of business.

In addition, to the ability to manage direct messages, comments and reviews, we also provide an option to download the filtered data from the Aggregate View of Inbox.

Filter the data with the Custom view, select the social media, conversation type, dates, and click the Export button.

Depending on the filters selected (the amount of data selected), the .csv file will be prepared for download within a few seconds, depending on the filters selected (the amount of data selected). Next, you should receive an email to your account address to export the CSV file. You can save it on your computer and open it in Excel, Google Spreadsheets, etc.

How to import the file into Microsoft Excel?

Here is a step-by-step guide on how to import a TXT or CSV file into Excel, similar to Excel 2007, 2010, 2013, and 2016:

  1. Open the Excel spreadsheet where you want to save the data and click the Data tab.

  2. In the Get External Data group, click From Text.

  3. Select the TXT or CSV file you want to convert and click Import.

    Insert Button

  4. Select "Delimited". A delimiter is just a fancy way of saying that your TXT file uses tabs or your CSV file uses commas to separate and group your data.

  5. Click Next.

    Delimited Option and Next Button

  6. Select the delimiter - “Comma”. It is the standard delimiter that groups the data into individual columns in a CSV file.

7. Click Next.

8. Select "General" in the next Tab.

9. Click Finish. The Data will be shown in a table split into columns.

10. You can create any kind of Pivot tables with aggregated data per page, per workspace, per social type, etc.

Inbox Data File Structure

Column Name

Description

Example

workspace-name

Name of the Workspace

101XX - Texas

social-page-id

Internal ID of the social page

13360162845409700031

social-name

Name of the Social Page

Texas-Main (123 Cameron Road, Austin, TX, US, 78723)

social-link

The link to the social page

https://maps.google.com/maps?cid=<123>

type

Type of the conversation (rating, direct message, comment etc.)

rating_5

inquiry-message

The message sent from the user

Very busy, but nice service!

inquiry-message-created-at

Time of the message sent

2021-12-20T06:48:45+02:00

first-reply-message

Reply to the message

Thanks for the great review!

first-reply-message-created-at

Time of the reply

2021-12-06T23:07:34+02:00

conversation-is-read

Indication of whether the message was read in the system

1

conversation-is-reviewed

Indication of whether the message was checked as reviewed in the system

1

conversation-created-at

Time of conversation created in the system (mostly same as time of created message)

2021-12-20T06:48:45+02:00

conversation-updated-at

Time of conversation updated in the system

2021-12-20T06:48:45+02:00

conversation-last-response-at

Time of conversation responded in the system (mostly same as time of reply message)

2021-12-20T06:48:45+02:00

workspace-tags

Tags in the workspace

Central, Texas, John Smith

If you have any additional questions regarding your login change, please reach out to us at [email protected].

Did this answer your question?