Import contacts from Zoho Analytics - Online Help | Zoho Campaigns

Import contacts from Zoho Analytics

We have recently updated Topics in Zoho Campaigns. Please click here for the updated help document.
Zoho Campaigns integrates with Zoho Analytics to help you build your mailing lists made out of analyzed data Analytics. The integration lets you import contact data from your database tables into Zoho Campaigns. You can map custom fields in Zoho Analytics to Zoho Campaigns to maintain your contact lists the way you want.

Learn more about how to integrate your Zoho Analytics and Zoho Campaigns.

Step 1: Sync Details

  1. From the Navigation bar, select the Contacts module. Select Sync Services.
    sync services menu
  2. Click New Sync.
  3.    analytics new sync
  4. Enter the following details
    1. Sync Description: Give your sync a name.
    2. Database Name: Choose the database you want to sync with.
    3. Table Name: Select the table with necessary contact data.
  5. Choose which rows to import:
    1. All Contacts: All contacts from your Analytics table
    2. Criteria: Only contacts meeting the criteria you specify (e.g., Email isn't empty)
    3. Mailing List Details: Select the mailing list in Zoho Campaigns to which you want to import the contacts.
  6. Click Save and Continue.
    sync details

Use cases

1. I have a Zoho Analytics query table, can I sync it with a Zoho Campaigns mailing list?

Yes, you can sync a Zoho Analytics query table with your Zoho Campaigns mailing list. Query tables contain data filtered from multiple Zoho Analytics tables based on a Select query. You can import query tables data as contacts into a mailing list.
For example, you have a query table containing details of customers who have purchased your products stored in the tables Sales-2017 and Sales-2018. You can import these customers into a mailing list called "Purchased" in your Campaigns account and use this list to send them newsletters related to product updates.


2. I want to sync contacts who attended the most recent event from a Zoho Analytics table into a mailing list in Zoho Campaigns. How can I do this?

You can add criteria while creating the sync. In the Sync Details page, choose Criteria in the Sync field and add the following criteria:
Events Involved contains Event_Name
Now, only contacts match the above criteria will be synced to your mailing list.


Step 2: Map Your Fields

You can map fields of the table with your Campaign fields, choose a Analytics field and map it with the corresponding Campaign field. Mapping the email address field is mandatory. However, you can add custom fields from your table by checking the New Field option. You can edit or delete a mapped field by clicking the respective icon displayed beside the mapped field.

map fields

Use cases

I want to map the Product Category field from a table in Zoho Analytics. I cannot find it under the pre-mapped fields, how can I map it?

You can use the Map more option in the Mapping fields step during sync. Product category is not a default field in Campaigns, so you will need to add a custom field for it. You can do this from the Mapping fields page during Zoho Analytics sync.

  1. From the Navigation toolbar, select Contacts and then Sync Services .
  2. Navigate to Map Your Fields page and click Map more .
  3. Select the required field from Zoho Analytics fields and check the New Field checkbox above Select Campaign Field dropdown.
  4. A custom field is created and data is imported into that field.

Step 3: Configure sync

You decide how often data is imported from your table. The data can be retrieved just once, or you can set it to occur daily, weekly, or monthly depending on your requirements.

  1. Select a sync frequency:
    • Retrieve Data: It is for a one time import.
    • Sync Frequency: Set the import frequency to recur on a daily, weekly, or monthly basis.
  2. Select the data to be retrieved:
    • All data: Imports all contacts' data from the table.
    • After: Imports only those contacts' data that have been added/modified after the specified date and time.
  3. Click Initiate. retrieval data


Note

  • Once you set the option for import (All Contacts/Criteria), you will not be able to edit the preferences. To use different criteria, create a new sync.
  • To enable sync frequency option, there should be atleast one calander field in your table.

Use cases

1. Can I edit the details of an inactive Zoho Analytics sync?

You cannot edit sync details after saving it. Instead, create another sync implementing whatever changes you need to make in Sync Details page. You can have a maximum of 144 active Zoho Analytics syncs at once.

Sync Detail View

  1. From the Navigation bar, select the Contacts module.
  2. Select Sync Services . Then, click Active Syncs.  analytics active syncs
  3. Hover over the sync and click View Details . view sync details

Edit Field mapping

You can re-map or map more fields for your sync settings by choosing the Edit Mapping in the Edit drop down.

edit mapping

 

Edit retrieval detail

You can edit the retrieval details such as retrieve interval, data to be retrieved and sync contacts configuration by choosing the Edit Retrieval Details in the Edit drop down.

edit retrieval details

Import Details/History

Use this option to get a detailed history of the contacts synced from Zoho Analytics to Zoho Campaigns. You can see this in the detailed view of the sync.

Status

Description

Total Contacts

Contacts imported/synced in a single fetch.

New Contacts

Contacts added to the Campaigns org.

Re-added Contacts

Contacts already deleted in Campaigns account but now added again.

Duplicate Contacts

Contacts already present in Campaigns account.

Ignored Contacts

Contacts are not added to the mailing list.

Deleted Contacts

Contacts deleted in Analytics account and getting updated in Campaigns as well.

Sync details

Ignored Contacts

Contacts who are ignored during the import if they fall under one of the following group,

Status

Description

Bounced

Contacts bounced from the recipient's inbox, or email addresses do not exist.

Do-Not-Mail

Contacts unsubscribed from your org.

Group Email(s)

Contacts having a role/group email address. For e.g. info@, administrator@, careers@, service@, support@, etc.

File Duplicate(s)

Contacts present more than once in the file.

Invalid Pattern

Contacts with an invalid email address; e.g. patriciazylker.com, john@gnail.com

Empty email address

Contacts whose email address field is missing.

2. When do I need to change the Zoho Analytics authtoken in Zoho Campaigns?

ZSC key is a sensitive field. Changing your ZSC key invalidates all the existing syncs. The only two times you would need to change your ZSC key in Zoho Campaigns are:

Change Authtoken

  1. From the Navigation bar, select the Contacts module.
  2. Select Sync Services .
  3. Navigate to Zoho Contacts sync setup and click Active Syncs. active syncs
  4. Click Settings tab.
  5. Click on Edit icon, which is beside Change account details section. Change Account details
  6. Make necessary changes and click Update. update account details


        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          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 CRM Training
              Redefine the way you work
              with Zoho Workplace

                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 CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              Create. Review. Publish.

                                              Write, edit, collaborate on, and publish documents to different content management platforms.

                                              Get Started Now





                                                                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.




                                                                    Manage your brands on social media


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        Zoho Sheet Resources

                                                                         

                                                                            Zoho Forms Resources


                                                                              Secure your business
                                                                              communication with Zoho Mail


                                                                              Mail on the move with
                                                                              Zoho Mail mobile application

                                                                                Stay on top of your schedule
                                                                                at all times


                                                                                Carry your calendar with you
                                                                                Anytime, anywhere




                                                                                      Zoho Sign Resources

                                                                                        Sign, Paperless!

                                                                                        Sign and send business documents on the go!

                                                                                        Get Started Now




                                                                                                Zoho TeamInbox Resources





                                                                                                          Zoho DataPrep Demo

                                                                                                          Get a personalized demo or POC

                                                                                                          REGISTER NOW


                                                                                                            Design. Discuss. Deliver.

                                                                                                            Create visually engaging stories with Zoho Show.

                                                                                                            Get Started Now








                                                                                                                                • Related Articles

                                                                                                                                • Import contacts from Zoho Analytics - New Version

                                                                                                                                  Zoho Campaigns integrates with Zoho Analytics to help you build your mailing lists made out of analyzed data Analytics. The integration lets you import contact data from your database tables into Zoho Campaigns. You can map custom fields in Zoho ...
                                                                                                                                • Import Contacts from Zoho WorkDrive - New Version

                                                                                                                                  Zoho Campaigns lets you import contacts from different cloud storage services. You can import contacts stored in Zoho WorkDrive as contacts in Zoho Campaigns. The file to be imported should meet the following requirements, It should be in either ...
                                                                                                                                • Ecommerce Solutions FAQ

                                                                                                                                  Integrating with Shopify 1. How do I connect Zoho Campaigns to the user’s Shopify store? If the customer is subscribed to the Basic plan in Shopify, they will not be able to integrate Shopify into Zoho Campaigns. It only works when the customer ...
                                                                                                                                • Import contacts from Zoho Creator - New Version

                                                                                                                                  Zoho Creator is an online custom apps builder through which you can create different applications using drag & drop feature. Any Zoho Creator will have a form, reports and pages and in reports section, you can view the contacts and other details. ...
                                                                                                                                • Import Contacts from Dropbox

                                                                                                                                  We have recently updated Topics in Zoho Campaigns. Please click here for the updated help document. Zoho Campaigns lets you to import contacts from different cloud storage services. You can import contacts stored in Dropbox as contacts in Zoho ...
                                                                                                                                  Wherever you are is as good as
                                                                                                                                  your workplace

                                                                                                                                    Resources

                                                                                                                                    Videos

                                                                                                                                    Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                    eBooks

                                                                                                                                    Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                    Webinars

                                                                                                                                    Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                    CRM Tips

                                                                                                                                    Make the most of Zoho CRM with these useful tips.



                                                                                                                                      Zoho Show Resources