Missing Links Between Campaigns, Mailing Lists, and Contacts in Zoho Campaigns Data Extraction + Source Failure in Airbyte Cloud

[Kasary45]

Description
When extracting data from Zoho Campaigns using Airbyte Cloud, we encountered frequent source failures and missing relationships between campaigns, mailing lists, and contacts**. Even when extraction succeeds, critical data is missing, preventing complete campaign analysis.

Steps to Reproduce
Configure Zoho Campaigns as the source in Airbyte Cloud.
Set MySQL as the destination.
Start the extraction process.
Observe frequent failures in the extraction job.
When extraction succeeds:
mailing_list and contacts tables contain only metadata or are empty.
mailing_list_key does not match across associated_mailing_list and campaign_details.
Contacts referenced in campaign_recipient_data are missing from contacts.
Expected Behavior
Extraction should complete without failures.
mailing_list and contacts tables should contain actual records.
mailing_list_key should be consistent across campaign_details and associated_mailing_list.
contacts should exist and be linkable to campaign engagement data.
Contact engagement scores (e.g., opens, clicks) should be available or derivable.
Actual Behavior
The source frequently fails during extraction in Airbyte Cloud.
mailing_list contains only metadata.
contacts table is completely empty.
mailing_list_key does not match between associated_mailing_list and campaign_details.
Contacts in campaign_recipient_data are missing from contacts.
No contact engagement score hierarchy is present.
Comparison of Data Extracted: Airbyte vs. FiveTran
Data Extracted via Airbyte
We attempted to extract data using Airbyte Cloud but faced missing relationships and empty datasets. We were able to fetch the following tables:

✅ Zoho_camp_report
✅ Zoho_camp_Details
✅ Zoho_camp_recipients
⚠️ mailing_list (only metadata, no records)
⚠️ contacts (completely empty)

However, the missing relationships between campaigns, mailing lists, and individual contacts prevent us from gaining the required insights.

Data Extracted via FiveTran
We then attempted to extract the same data using FiveTran, which provided a more detailed dataset, including 18 tables:

✅ advanced_campaign_detail
✅ associated_mailing_list
✅ zoho_campaigns.campaign
✅ zoho_campaigns.campaign_detail
✅ zoho_campaigns.campaign_location
✅ zoho_campaigns.campaign_reach
✅ zoho_campaigns.campaign_recipient_data
✅ zoho_campaigns.campaign_report
✅ zoho_campaigns.contact
✅ zoho_campaigns.contact_count
✅ zoho_campaigns.contact_field
✅ zoho_campaigns.list_advanced_detail
✅ zoho_campaigns.mailing_list
✅ zoho_campaigns.recent_campaign
✅ zoho_campaigns.segment
✅ zoho_campaigns.segment_info
✅ zoho_campaigns.topic
✅ zoho_campaigns.workflow

Despite extracting more tables with FiveTran, we still faced issues with mailing_list_key inconsistencies and missing links between contacts and campaign engagement scores.

Impact
Extraction failures prevent data availability for analysis.
Incomplete contact-level insights hinder customer segmentation and campaign analysis.
Campaign engagement tracking is incomplete due to missing contacts.
Campaign effectiveness cannot be fully measured due to broken relationships.
Environment
Airbyte Version: [Provide Version]
Connector: Zoho Campaigns
Deployment: Airbyte Cloud
Destination Database: MySQL

Additional Context
This issue persists despite multiple extraction attempts. We also tested FiveTran, which extracts 18 tables but still lacks proper mappings. The problem seems specific to Airbyte Cloud’s extraction process and Zoho Campaigns' data structure.