ODBC guide

Read email status metrics using COQL Query Builder (Emails module, v2)

Queries the Emails module via COQL for metrics such as status (bounced, opened, clicked), open/click times, bounce reason, and related fields. Zoho exposes Emails in COQL only through API v2; from v3 onward this approach does not apply. With v2, PageSize must be 200 or less. For other modules, use v7/v8 (or v3+) if you need page sizes larger than 200.

SELECT *
FROM get_module_data_coql_builder
WITH(
	  Module='Emails'
	, Version='v2' --must be v2 for Emails module , newer versions dont support Emails module in COQL
	, Select='Owner,Subject,Entity_Id,Modified_By,Created_Time,Modified_Time,Sent_To,Module,Last_Opened,Last_Clicked,Bounced_Time,First_Opened,First_Clicked,No_of_Opens,No_of_Clicks,Template_Name,Sent_On,Status,Source,Cc,Sender,Bounce_Reason,Bcc'
	--, Where='Status = ''Bounced'' and Created_Time>''2015-07-08T03:07:16-04:00''  '

  --, OrderBy='Created_Time desc'
)