Importing custom attributes and tags using Google Sheets

Add custom attributes to your customer records using the Google Sheets app to gain deeper insights with segmentation.

Contents

Installing the Google Sheets app

Open a Google Sheet, navigate to Extensions > Add-ons > Get add-ons, and search for ChartMogul.

Or, install the app directly from the Google Workspace Marketplace.

Setting up the Google Sheets app

  1. To send data from Google Sheets to ChartMogul, Admins will need to create a new read & write API key.
  2. Open the ChartMogul Google Sheets app.
  3. Copy your API key and paste it into the ChartMogul API Key field. Click Save key.
  4. Select Enrichment.

Formatting your data

Open the app by creating a new Google Sheet and navigating to Extensions > ChartMogul Google Sheets integration > Open app. Google opens the app in the sidebar.

Click Insert template to insert a new sheet with example data in the required format.

See here for an interactive example:

The template has four columns:

  1. Column A (Email or External ID) should include the customer's email address or external ID as it appears in ChartMogul.
  2. Column B (Attribute) is the name of the attribute you want to create or the existing field you want to update. Lead created at, Free trial started at, and Tag fields are default in all customer records. New attributes will be created in the Custom Attributes section in the customer's record.
  3. Column C (Value) is what you would like the custom attribute to be. For example, the NPS score or the name of the sales representative.
  4. Column D (Type) is the type of attribute you want to add. The type determines which filtering options are available. You can see a list of the different types below.

Format

All fields are required.

Column name Value
Email or External ID Your customer's email or external ID in ChartMogul.
Attribute

The name of the customer's attribute.

For example, "Marketing campaign." It can be any combination of characters.

Value

The values permitted in this column depend on the Type in each row.

If the type for this row is "String," the value can be any combination of characters, for example, "#123ABC".

If the type for this row is "Timestamp," the value can only be in the format: YYYY-MM-DD, for example, 2015-01-24.

If the type for this row is "Integer," the value can only be a number, for example, 1234, not A1 or #2.

If the type for this row is "Boolean," the value can only be "TRUE" or "FALSE" (without quotes).

Type Can be a "String" or "Tag" (all characters), an "Integer" (just numbers), a "Timestamp" or a "lead_created_at" or "free_trial_started_at" (date, e.g. 2015-01-24), or a "Boolean" ('true' or 'false').

Attribute Types

You can add seven different types of attributes with Google Sheets:

Type Description Filtering Good for
String A sequence of letters, numbers, or symbols Add filter > attribute name > is / is not / contains / does not contain / is not present Account manager, Marketing campaign
Integer Whole number Add filter > attribute name > equals / does not equal / is less than / is more than / is less than or equal to / is more than or equal to / is not present NPS score, CSAT score, Number of emails opened, Number of site visits
Timestamp Date and time Add filter > attribute name > is on / is after / is before / is on or after / is on or before / is within / is not present First visit date, Date of support ticket, Date of upgrade from free plan

Boolean

True or False Add filter > attribute name > is true / is false / is not present Signed up for newsletter, Contacted support, Contacted regarding upsell
Tag A sequence of letters, numbers, or symbols listed in the tags section of a customer record Add filter > Tags > has at least one of / has none of / has all of / is not present

Top account, At risk

Tags offer a simple string that can be added through the UI as well as Google Sheets. As tags are filtered through the tags section, having a long list of tags can be less useful than creating separate custom attributes.

lead_created_at The date a customer became a lead Add filter > Lead created at > is on / is after / is before / is on or after / is on or before / is within / is not present Customers with a lead created at date will contribute to the Leads chart and the Average sales cycle length.
free_trial_started_at The date a customer started a free trial Add filter > Free trial started at > is on / is after / is before / is on or after / is on or before / is within / is not present Customers with a free trial started at date will contribute to the Trials chart and the Trial-to-paid conversion rate.

Importing data

Click Send attributes to ChartMogul to update your customer records in ChartMogul.

The import can take some time, and please note that closing the app or the Google Sheet will cancel the import.

Successfully imported rows will be highlighted in green. If data has not been successfully imported, the rows will be highlighted in red. When possible, you will receive information about why your data did not import successfully.

Check if your attributes have been imported successfully by navigating to Customers and viewing the record of one of your customers.

Google’s API will time out after around 1000 lines. Therefore, for larger data sets, it is recommended to break uploads into groups of 1000.

Examples

You can add custom attribute filters to charts, cohorts, maps, and customer lists. For example, by adding an integer attribute for Net Promoter Score (NPS), you can identify all of your customers with a low score.

You can gain deeper insights by filtering for multiple attributes. In this example, we are looking for customers with a low NPS who have contacted support:

Tags are simple strings that can also be added directly in ChartMogul. In this example, we are looking at the MRR generated by customers tagged with managed_accounts:

Was this article helpful?

We’re sorry to hear that. Would you like to share more feedback?


Thanks for your feedback!