Relationships Overview

Please note this article only applies if you are subscribed to Salestracker’s CRM functionality, as the process described in this article cannot be followed if you are subscribed to the data-only version of Salestracker.

This article describes relationships in general. If you want to know how to create or update a relationship, read this dedicated article.

Relationships allow you to track your company’s relationship with another company. They are the basis for Salestracker’s CRM functionality.

To see an overview of relationships, click on the “Relationships” link on the main navigation.

Relationships 01

This brings up the “Relationships Summary” page. Much like the Tasks Manager, this page is split into two parts:

  • The top of the page features filters you can apply to filter down your relationships.
  • The lower half of the page features the relationship details themselves.

Relationships 02

Filtering

You can apply any of the filters at the top of the page and click “Filter” to reduce down your results. To show all results and remove any filters, click the “Reset” button.

The filters you can apply are as follows:

  • Main Contact – filter relationships by who is assigned as the main contact within your company.
  • Status – filter by the relationship “status” e.g. companies that are prospective customers, customers, etc. Status also includes two other options:
    • Status not set” will filter out records that have no status, but have had other relationship data assigned.
    • Status set” will only show records that have had a status set (i.e. it will filter out records with relationship data and a status set to “Raw data”).
  • Category – filter relationships by category; by default category consists of “Bronze”, “Silver”, “Gold”, etc.
  • Database – if you are subscribed to more than one of the Insight databases, this will allow you to only show records for a particular database e.g. Fenestration UK.
  • Custom 1/Custom 2 – these fields only appear if your CRM has been customised, and allow you to filter on the customised values within.
  • Order by – places the results of a filter into a particular order, either the last time the status was updated or by company name.
  • The radio buttons on the right allow you to specify a date range for relationships added/updated within a certain period of time.

The Status, Category, Custom 1 and Custom 2 fields are completely customisable, meaning you can change the values that appear within them. Find out how in this article.

Relationships Navigation

To view the details for a company, simply click on the highlighted company name to be taken to that record:

Tasks 03

Once you are on a record, the navigation buttons will then take you forward/backwards through the relationships you have filtered.

Relationships 03

Click the “back” button to return to the relationships page.

Relationships 04

Exporting Relationships

You can export your relationships data by clicking on the “Export” button.

Relationships 05

This will bring up a pop-up menu with options for exporting:

Relationships 06

The options are:

  • Standard format: one record per company, favouring primary contact.
  • Full list format: one record per contact (multiple lines per company).
  • Email list format and quick email format: one record per email address – the former has full company details and the latter has abridged details.

The export format is in CSV (Comma Separated Values), which is a common format across software. If you require an Excel Workbook, simply open the CSV file in Excel and then go to “File” and click “Save as“. You can change the format to save in to “Excel Workbook”.

Relationships 07

Please note that the procedure might be a little bit different depending on your version of MS Excel.