I want to create a Report on Tracking Data (open rate, click rate, deliverability rate) from MarketingCloud into Salesforce CRM Sales/Service Cloud. How can I achieve this?
Since you're using Marketing Cloud Connect, you already have this kind of data available in Salesforce. Here's how you can access it:
You can run a tracking report within Salesforce that shows you all the engagement data from Marketing Cloud. In Salesforce, go to Reports and under 'Select Report Type,' expand the 'Other Reports' Folder and select either 'Individual Email Results with Contact' or 'Individual Email Results with Lead'. Choose the metrics that you want to see and run the report. Read more here: https://help.salesforce.com/articleView?id=000334623&type=1&language=en_US&mode=1
Navigate to the Email Send tab in Sales or Service Cloud to access a specific Email Send record. This Marketing Cloud Connect feature provides detailed information about each send. It includes related lists with tracking information on individual email results, aggregate link-level details, and support requests that have been opened for the send. Read more here: https://help.salesforce.com/articleView?id=mc_co_email_send_record.htm&type=5