Support

Can I import user data into GoSquared?

You can import customer data into People CRM. It will become searchable and filterable and you can build Smart Groups based upon it.

How to Import data into People CRM

To create a People profile, all you need is a user's email address. However the more information you have about each user, the better. If you have a spreadsheet full of useful attributes and custom information we can import all of that too.

1. Creating a CSV

You'll need to provide GoSquared with a CSV file. Many tools will have an option to export your data as a CSV. If not you'll need to create a spreadsheet and save it as a CSV file.

Each row in the CSV must contain a user's email address. Extra properties associated with that user should be in the same row.

The column headers in the CSV should be labelled with the name of each of the properties that you want to track.

It should look something like this:

Example CSV


2. Upload the CSV to GoSquared

If you haven't already, sign up for a GoSquared account.
You can then login to your account and upload a CSV of your customer data here.

3. Check your CSV columns match up with the appropriate GoSquared fields

Use the drop down menus to match as many columns up to the default GoSquared properties as you can. If you have any extra information that doesn't obviously match, you can create a new custom property and edit the properties name.


4. Click the 'Start data Import' button.

This will start the import process and navigate you to the People dashboard where you should see your new profiles being created.


Why do Now and Trends not support importing of data?

This is not just because we haven't got around to it yet – every analytics service tracks and processes data in different ways. GoSquared has a very advanced analytics platform with some of the most accurate metrics in the industry. As soon as you start mixing data from other services, things started getting complex and numbers become hard to compare with confidence.

You can use our API to extract data GoSquared collects in CSV or JSON format and combine that with exported data from other services to compare or combine statistics.