How to Get Granular Email Click Data by Day in Creatio?

Hi,

I’m currently working with email campaigns in Creatio and facing a challenge. I need to generate more granular reports on email interactions for my client. Specifically, I’m looking for a way to track the number of clicks and email opens on a daily basis or within a specific time frame during the campaign. For example, if a campaign runs for several months, we need to see how many emails were opened and how many clicks occurred on specific days or within a given month.

I’ve been using the [AdCampaign] object that integrates with Google Ads and Meta Ads. It provides a granular view of daily data, such as clicks and impressions, through the [Ad campaign Daily Insights] child object. My client would like a similar capability for email data—being able to filter by specific date ranges to view detailed interaction data (opens, clicks, etc.).

Is there an existing table or method in Creatio that allows me to capture and report email interactions in such a granular format? Additionally, would it be possible to combine this email interaction data with the social media data (from Google Ads and Meta Ads) into a unified report that shows all interactions (clicks, opens, etc.) within the same time period?

I would appreciate any guidance or suggestions on how to achieve this, ideally within the marketing module of Creatio.