Hello I am looking for solutions to export data from Exact Target which would eventually be fed into a dashboarding tool. Here are the set of questions that I have related to this data integration:
I would like to capture - List of all the emails sent for the accounts, • Time Sent Unique Opens Total Opens, Unique Clicks, Total Clicks,Delivered Rate,Hard Bounce Rate,Soft Bounce Rate,Block Bounce Rate,Links Clicked,Unsubscribes. I know there are a bunch of reports that provide Email summary in the Email Studio reports, the closest I got was when I ran the report called 'Recent Email Sending Summary' but only got few metrics, not all metrics are available. Is there a better way to capture these metrics using Email Studio or any other means and to build a report out of it ?
Once I get these metrics, I need to send the above reports as attachments via recurring emails, say for example emails with .csv attachments containing metrics are sent every week/month in an automated manner from exact target.Any way to achieve this ?
I cam across few ways, like Data EXtraction uploading file to FTP but it has a limit of just 30 days or so since I want all data until now. Also, looked at Query in Exact Target but it again has a data limit of upto 60 days. Any help would be really appreciated. Thanks !