I am trying to fetch "Email Insights" from the platform using API to analyze the KPI's like Click to Open Rate, Unsubscribe Rate, by type of the email (newsletter,email marketing etc).
I went through the documentation, however I didn't find any endpoint from which I can fetch the same.
You should move the thread to Products to continue (that's the space for Marketo product support -- this is for non-product-specific discush).
At any rate, there's no endpoint for canned reports. When using the API the idea is you'll get the raw data and use/write your own reporting tools.
Can you please tell me from which endpoint I can get this raw data, I was searching for Click to Open Rate, Unsubscribe Rate for Email's in Assets but didn't found any.
You can't get the rates, that's my point. The Activity API exposes the timeseries data. You compute the statistics.
I tend to use NodeJS or Java (the latter if I'm in an integration platform like Camel) but you can use anything you're comfy with.
You could even use a batch/shell script and the cURL.exe command line app.
The new Bulk Extract API is very easy to use. The annoyance is you need to use a poll-and-retry approach. Because it's a 4-part process (define - run - poll (and poll and poll) - download) with no notification when the download is ready, it's the waiting that's the hardest part.