Skip to content
Book a demoStart free
Connectors

Zoho Campaigns connector

Set up the Zoho Campaigns connector in Kaivo: authentication, configuration, the 10 BigQuery tables it syncs, and answers to common questions.

Zoho Campaigns connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Zoho Campaigns data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your Zoho Campaigns data into BigQuery with Kaivo to measure email campaigns and audience growth.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Zoho Campaigns connector

Section titled “Getting started with the Zoho Campaigns connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Zoho Campaigns account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Zoho Campaigns credentials. You provide:

Field Description
Client Secret
The Client Secret of your Zoho Campaigns developer application.

| | Refresh Token |

The refresh token obtained after completing the OAuth authorization flow.

|

Prerequisites

Zoho Campaigns only supports OAuth, so you need your own Zoho developer application:

  1. Go to the Zoho API Console, create a Server-based Application, and note your Client ID and Client Secret.
  2. Authorize the app and complete the OAuth flow once to obtain a Refresh Token with the required Campaigns API scopes.

Then enter those values below.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Client ID
The Client ID of your Zoho Campaigns developer application.

| | Data Center |

The data center where your Zoho Campaigns account is hosted.

|

Tables and columns synced from Zoho Campaigns

Section titled “Tables and columns synced from Zoho Campaigns”

Kaivo syncs 10 tables from Zoho Campaigns into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

all_tags (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_169443000000020045__is_crm_tag STRING
_169443000000020045__tag_color STRING
_169443000000020045__tag_created_time STRING
_169443000000020045__tag_desc STRING
_169443000000020045__tag_modified_time STRING
_169443000000020045__tag_name STRING
_169443000000020045__tagged_contact_count STRING
_169443000000020045__tagowner STRING
_169443000000020045__zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaign_details (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
advance_type_string STRING
campaign_key STRING
campaign_name STRING
campaign_preview STRING
campaigntype STRING
created_date_string STRING
created_time STRING
created_time_gmt STRING
email_from STRING
email_options STRING
email_subject STRING
email_type STRING
encode_name STRING
folder_id STRING
is_ga_config STRING
is_reply_tracking_enabled STRING
is_to_name_config STRING
is_wistia STRING
is_advance STRING
is_hybrid STRING
modified_time STRING
modified_time_gmt STRING
modifieddate STRING
preheader STRING
reply_to STRING
schedule_type STRING
sender_name STRING
sent_date_string STRING
sent_time STRING
sent_time_gmt STRING
sent_time_zone STRING
sent_time_zone_short STRING
topic_id STRING
topic_name STRING
updated_date_string STRING
updated_time STRING
updated_time_gmt STRING
web_auto_status STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaign_recipients (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
city STRING
companyname STRING
contactemailaddress STRING
contactfn STRING
contactid STRING
contactln STRING
contactstatus STRING
country STRING
facebook_handle STRING
jobtitle STRING
linkedin_handle STRING
mobile STRING
note STRING
phone STRING
secondary_email STRING
sent_time STRING
sentdate STRING
state STRING
timezone STRING
title STRING
twitter_handle STRING
website STRING
zipcode STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaign_reports (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
autoreply_count STRING
bounce_percent STRING
bounces_count STRING
campaign_id STRING
campaign_name STRING
clicksperopenrate STRING
complaints_count STRING
complaints_percent STRING
delivered_count STRING
delivered_percent STRING
emails_sent_count STRING
forward_percent STRING
forwards_count STRING
hardbounce_count STRING
open_percent STRING
opens_count STRING
softbounce_count STRING
spam_percent STRING
spams_count STRING
unique_clicked_percent STRING
unique_clicks_count STRING
unopened STRING
unopened_percent STRING
unsent_count STRING
unsent_percent STRING
unsub_count STRING
unsubscribe_percent STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
mailing_lists (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_time STRING
created_time_gmt STRING
date STRING
deletable STRING
editable STRING
is_public STRING
issmart STRING
list_campaigns_count STRING
list_created_date STRING
list_created_time STRING
listdesc STRING
listdgs STRING
listkey STRING
listname STRING
listnotifications STRING
listtype STRING
listunino STRING
lockstatus STRING
noofbouncecnt STRING
noofcontacts STRING
noofunsubcnt STRING
otherslist STRING
owner STRING
sentcnt STRING
servicetype STRING
sno STRING
updated_time_gmt STRING
zuid STRING
zx STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recent_campaigns (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_key STRING
campaign_name STRING
campaign_preview STRING
campaign_status STRING
campaigntype STRING
created_date_string STRING
created_time STRING
created_time_gmt STRING
folder_id STRING
from_email STRING
is_hybrid STRING
reply_to STRING
sent_date_string STRING
sent_time STRING
sent_time_gmt STRING
sent_time_zone STRING
subject STRING
updated_date_string STRING
updated_time STRING
updated_time_gmt STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recent_sent_campaigns (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_key STRING
campaign_name STRING
campaign_status STRING
campaignid STRING
campaigntype STRING
created_date_string STRING
created_time STRING
created_time_gmt STRING
folder_id STRING
from_name STRING
is_hybrid STRING
previewtype STRING
sent_date_string STRING
sent_time STRING
sent_time_gmt STRING
sent_time_zone STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscribers (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
added_time STRING
companyname STRING
contact_email STRING
firstname STRING
lastname STRING
phone STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
topics (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
primary_list FLOAT64
topic_desc STRING
topic_id STRING
topic_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
totalcontacts (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
code STRING
uri STRING
message STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Zoho Campaigns supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Zoho Campaigns?

Section titled “How long does the initial sync take for Zoho Campaigns?”

It depends on how much history is in your Zoho Campaigns account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Zoho Campaigns’s schema changes?

Section titled “What happens when Zoho Campaigns’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Zoho Campaigns, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Zoho Campaigns instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Zoho Campaigns connector in Kaivo and all of its synced data is deleted with it.

Use recent_campaigns and campaign_reports to track email results over time.

Use subscribers and mailing_lists to see how your audience grows.

Join campaign_recipients with campaign_reports to understand engagement.

Use Zoho Campaigns data in your AI and BI tools

Section titled “Use Zoho Campaigns data in your AI and BI tools”

Once Zoho Campaigns data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Zoho Campaigns data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Zoho Campaigns connector pricing and plan details.