Importing lead and trial data into ChartMogul lets you benefit from our Leads and Conversion charts and ChartMogul CRM.

Here’s what we cover in this article:

• An overview of leads and trials in ChartMogul
• Adding a custom data source
• Importing lead and trial data
• Merging customer records

Resources and further reading:

• Customer & Subscription Statuses
• Make trial-to-paid conversion rates more meaningful with cohorts
• Does ChartMogul display non-paying trial customers?

Before you begin

Please review the following details before completing the steps we outline in this article.

• Define exactly what a lead is for your business. For example, is it any individual or company that interacts with your business? Only those who download specific content? Attend a webinar? Join your email list? Start a trial? Answering this question is central to defining when an individual or company enters the top of your sales funnel and, therefore, becomes a potential new customer worth pursuing.
• Familiarize yourself with the methods and locations your business uses to track leads and trials. For example, your website, your own database, free trials in your product, or CSV.
• To use ChartMogul CRM, review the setup guide to familiarize yourself with importing leads and contacts.
• Familiarize yourself with the options available for importing lead and trial data into ChartMogul, and decide which option works best for you.
• We highly recommend importing the date an individual or company becomes a lead and the date they start a trial into ChartMogul as soon as these occur so that you have the most accurate and up-to-date Trial-to-Paid Conversion Rate and Average Sales Cycle Length metrics.

Leads and trials in ChartMogul

Each potential future customer begins their relationship with your business as a lead. They may evaluate your product/service by starting a trial before signing up for a subscription.

Leads

A lead is an individual or organization who shows interest in your product/service and has the potential to become a subscriber. Not all leads will complete a trial, nor will all leads become subscribers. When a lead is imported, ChartMogul creates a customer record.

Tracking leads in ChartMogul enables you to use the Leads and Average Sales Cycle Length charts. These charts work once you’ve populated the Lead created at date field in customer records.

A customer with a Lead created at date is classified as a lead and included in the Leads and Average Sales Cycle Length charts. Customers who have a lead status and do not have a Lead created at date do not contribute to these charts.

Trials

A trial is the period when a lead evaluates your product/service before becoming a paying subscriber. Not all leads complete a trial, and some begin their trial long after they become a lead.

Tracking trials in ChartMogul enables you to use the Free Trials and Trial-to-Paid Conversion Rate charts. These charts work once you’ve populated the Free trial started at date field in customer records.

Lead and trial data imported by ChartMogul

If you use one of the supported billing systems listed below, ChartMogul imports lead and trial data automatically. Review your integration guide for more information. To import lead and trial data from outside your billing system (e.g., your own database, free trials in your product, CSV), follow the steps below.

• App Store Connect
• Braintree
• Chargebee
• GoCardless (lead data only)
• Google Play
• Recurly
• Stripe

Step 1 — Add a custom data source

Start by creating a new, custom data source for the lead and trial data you’ll import:

1. Navigate to Data Platform > Sources and click ADD A SOURCE.
2. Select Custom Data Source.
3. Enter a unique name.
4. Click NEXT.

Step 2 — Import lead and trial data

There are several ways to import lead and trial data into ChartMogul, depending on the amount of data you have and your technical expertise.

To import a large volume of lead and trial data, and have this data stay up-to-date automatically, use the following method:

• Build a custom integration using the Import API

To import a smaller volume of lead and trial data, use one of the following manual methods:

• Upload customer data using CSV
• Add data manually using ChartMogul’s Data Platform 
• Import data using Google Sheets

Step 3 — Merge customer records

When a lead converts to a paid subscriber, you may end up with two records for the same customer: one as a Lead in your custom data source and another as Active in your billing system’s source. For accurate metrics, consolidate these records by merging them in app or using our Import API. Learn more about merging customers.

To merge customers in app:

1. Navigate to Customers and find the duplicate customer created as part of uploading your lead and trial data. You can also find these customers using the Customers tab of the custom data source.
2. Click MERGE.
3. Choose the customer ChartMogul imported from your billing system.
4. Click NEXT.
5. Click Confirm and merge to proceed.

Next Steps

Add individuals with a current or past relationship with your business as contacts.