Help Center

Customer tags: How to add fields to customer page reports and report by group

You can add up to two custom fields, called customer tags, populated either from a connected CRM or from Google Sheets, and then report on your customer data by them.


Before you start

  • In a consolidated company, customer tags must be created at parent level only.
  • You need access to Google Sheets or a connected CRM. If you do not have access to Google Sheets and do not wish to use a connected CRM for customer tags, contact [email protected] for help with other options.

1. Create the input source

1. Open the customer tags page

  1. Go to the Load Data tab, then Customer Tags under Data Sources in the left sidebar (see below).
    Load Data sidebar with Customer Tags (Google Sheets) under Data sources highlighted

Note: For a consolidated company, remember to do this at parent level.

If you have a CRM connection, you will be asked to select Google Sheet or CRM for your data.

Configure Customer Tags Source dialog with the choice of Google Sheets or CRM

Tip: If you want to change the input source later, use the settings cog (Configure Source) at the top right of the page to reconfigure the data source.

Customer Tags page header with the settings cog highlighted at the top right

2. Choose your data source

Option 1: Select fields from your CRM

Use the CRM configuration menu to select, modify, and update the fields chosen.

  1. Go to Load Data, Connections, click the three dots on your CRM card, then Configure, and scroll down to find the Customer Tags mapping section (see below).
  2. Select the fields to use for your customer tags.
CRM connection card menu with Configure highlighted
Map your HubSpot fields to Customer Tags section in the HubSpot configuration

Option 2: Set up in Google Sheets

After selecting Google Sheets, you will see this screen to create a template in Google Sheets.

Customer Tags Add New Google Sheet with Copy Template highlighted
  1. Select Copy Template, then Make a copy.
    Google Sheets Copy document page with Make a copy highlighted

    Copied ScaleXP Customer Tags sheet with Customer Name, Tag 1 and Tag 2 columns
  2. Rename the file. You may also wish to move it to a shared drive and/or share it with other users in your company.
    Renaming the customer tags sheet in Google Sheets
  3. Return to ScaleXP Customer Tags in your browser and click Select Template. You will be asked to sign in to your Google Drive.
    Customer Tags Step 2 with Select Template highlighted
  4. Click to select the file (usually at the top left), then click the Select button.
    Selecting the template file in Google Drive

    Template file selected and connected to ScaleXP

2. Label and import your data

1. Select your field names

  1. Click Update Tag Labels and enter your tag labels. You can change the names at any time using this button.
    Active Google Sheet for your Customer Tags, with the Update Tag Labels button highlighted

    Customer Tags Labels dialog with Customer Tag 1 Label, Customer Tag 2 Label and Update labels

2. Update your data

Note: This section applies if you chose Google Sheets as your source. If your tags come from your CRM, update the mapped fields in your CRM configuration (Option 1 above) instead.

The sheet will automatically populate with your full customer list, ready for you to add up to two custom fields.

  1. Open the sheet by clicking the Open Sheet button at the right.
    Customer Tags sheet row with the Open Sheet button highlighted
  2. Add your data. The column headings will automatically reflect the names you set with the Update Tag Labels button on the Customer Tags page.
    Customer tags sheet with Customer Region and Customer Type filled in
  3. Return to the ScaleXP tab in your browser and click Import to update the tag labels and data.
    Customer Tags sheet row with the Import button highlighted

3. Report on your data

Once created, your customer tags will automatically appear as sortable columns in your Customer page report. You can further refine your reports as follows.

1. Show totals by customer tags

Use this option to quickly see splits by customer tag at the top of your Customer page reports.

  1. On the Customers tab, use Configure Report, open Display, then Show Totals By to show totals by customer tag.
    Configure Report, Display section, with the Show Totals By list open and the Customer Tags options highlighted

2. Group customer data by customer tag using analytics

On the Customers tab, go to the section called Analytics.

  1. Click New, then New report.
    ANALYTICS section with the New menu open and New report highlighted
  2. Name the report.
  3. Under Group By, select the customer tag field by which you want to group your customer data.
    New Report dialog with the Group By list showing the customer tags Industry or Sector and Company Size
  4. Create the new report.
    Analytics report grouped by a customer tag

3. Filter by customer tag

Use this option to create reports by customer tag which can be used throughout the system.

  1. On the Customers tab, create a new report (top left, under Revenue) or edit an existing one.
    REVENUE section with the New button highlighted
  2. Use Configure Report, Filters, Customer Tags to filter by customer tag.
    Configure Report, Filters section, with the Customer Tags filter open

How it works

Use customer tags for customer attributes the accounting system does not hold, such as parent/child customer, region, account manager, industry, or tier.