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 !
I had worked on similar request, but capture was limited to few activities. I had used Data Extract activity extract type was: Tracking Extract. yes the extract period is limited for 30 day window but you can create multiple extract activities for specific rolling range.
Example: if you want to pull all the data from Jan 2017 till date, we can create one data extract for each month. you can select rolling range for each month Jan : 1/1/2017 to 1/30/2017 Feb: 1/31/2017 to 2/28/2017 so on.. each data extract will produce one zip file of report.
These are some of the options available in tracking extract that corresponds to data you need
- List of all the emails sent for the accounts - Extract Send Job Option (you can see CLientID,SendID,EmailName,SentTime etc..)
Time Sent -- This field is obtained from Extract Send Job Option (SentTime)
Unique Opens-- Include Unique Opens Option
Total Opens -- Extract Opens Option
Unique Clicks-- Include Unique Clicks option
Total Clicks -- Extract Clicks Option
Delivered Rate -- Not sure
Hard Bounce Rate - Extract Bounce option ( Bounce Category shows the type of bounce)
Soft Bounce Rate - Extract Bounce option ( Bounce Category shows the type of bounce)
Block Bounce Rate - Extract Bounce option ( Bounce Category shows the type of bounce)
Links Clicked -- In the Extract Clicks Option you have the field URL it shows the link clicked by particluar subscriber for particular send
Unsubscribes. -- Extract Unsubs option and Include Unsub Reason Option
Sample data extract configuration
The resulting extract file can be transferred to desired ftp location. Hope this helps!