Import Usage Data to CRM from Analytics tools
To export your usage data report from your Analytics tool, use the respective guides: Google Analytics/MixPanel.
After export, go to the Zoho CRM page and follow the steps below on how to import the usage data into the CRM.
1. Click the More (•••) option in the top bar and click +Create New Module at the bottom.
2. Name the module and the layout.
3. Create the three mandatory fields that would map to the following field types during Event Mapping: Event name (Single line), Who Initiated the Event (Lookup), and Event Time (Date or Date/Time).
|
Field Type
|
Data types
|
Description
|
Sample data
|
|
Event Name
|
Single line
Multi-line
Picklist
Lookup
|
The name of the user's action captured
|
|
|
Who Initiated the Event
|
Lookup
|
The entity that initiated the event on your website or app helps identify the user
|
|
Event Timestamp
|
Date
Date/Time
|
The exact date and time of the event occurrence provides temporal context and allowing time-based analysis
|
|
4. For the lookup field type, choose the exact lookup module where your customers' identity data is stored.
5. Click Save.
6. Create other fields. Following are the non-mandatory field types which can also be mapped to your CRM fields for more accurate data insights by Zia. Creating some or all of these fields is optional.
|
Field Type
|
Data types
|
Description
|
Sample data
|
|
Event Type
|
Single line
Multi-line
Picklist
Lookup
Multi-select
|
The type of event that took place helps categorize and analyze different types of user actions.
|
|
| Event Duration |
Single line
Number
Formula
|
The duration of time the event lasted, to understand user engagement levels and behavior patterns. The field can store minutes or seconds, or hours for all records.
|
|
|
Event Location
|
Single line
Multi-line
Picklist
Lookup
Multi-select
URL
|
The geographical location or region from where the event originated, providing insights into geographic trends and user demographics.
|
|
|
User Attributes
|
Single line
Multi-line
Picklist
Lookup
Multi-select
|
Attributes or characteristics of the user initiating the event that aid in personalization and segmentation analysis.
|
|
|
Event Context
|
Single line
Multiline
Picklist
Lookup
Multi-select
|
Understanding the specific item, product, service, or entity on which the event was initiated, allowing for targeted analysis and correlations.
|
|
Device Information
|
|
Specifies the type of device and/or mobile device model |
|
7. Import data from any source in supported file formats. Let's say, you have exported the data as a CSV file. Go to the custom module you have created and click Import [Module name].
8. Map the import fields with the Zoho CRM module fields. Remember to map the three mandatory module fields that you created in step 2 with the appropriate import fields and click Next.
9. In the next page that follows, configure the assignments as required and click Finish.
Your import is now scheduled, and the data will soon be displayed in the respective module.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho CPaaS?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Zia Usage Data Mapping of Events
This guide helps you with the mapping of events of your usage data under Zia. Before getting into greater detail, let's quickly revise the important terms. What is mapping of events? Event mapping is a technique for the system to learn usage data, ...Data Analytics - An Overview
Zoho CRM enables fully customizable reports in all the modules with flexible options, such as cross-linking modules, 3-level column grouping, scheduling reports generation and delivering to the intended users including non-Zoho CRM users through ...FAQ: Canvas in Zoho CRM
What is Canvas in Zoho CRM and why is it useful? Canvas is Zoho CRM's intuitive, no-code design tool that enables you to create custom layouts for record detail pages, list views, and data entry forms. Using its drag-and-drop builder, you can ...Admin Tools for Configuration Management
Purpose and Scope CRM Administration is a challenging ride that primarily involves mapping your organization's problems to CRM solutions, followed by efficient execution or "configuration" of those chosen solutions. At this point, a key factor to ...Data Administration - An Overview
The purpose of the Zoho CRM data administration tools are to guide the CRM Administrator in creating, verifying and ensuring data integrity by maintaining relationships and implementing access controls throughout the databases. Based on the ...
New to Zoho LandingPage?
Zoho LandingPage Resources