Exact Target - Data Integration

Question

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:

1. 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 ?

2. 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 ?

3. 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 !

Answer 1

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

1. List of all the emails sent for the accounts - Extract Send Job Option (you can see CLientID,SendID,EmailName,SentTime etc..)

2. Time Sent -- This field is obtained from Extract Send Job Option (SentTime)

3. Unique Opens-- Include Unique Opens Option

4. Total Opens -- Extract Opens Option

5. Unique Clicks-- Include Unique Clicks option

6. Total Clicks -- Extract Clicks Option

7. Delivered Rate -- Not sure

8. Hard Bounce Rate - Extract Bounce option ( Bounce Category shows the type of bounce)

9. Soft Bounce Rate - Extract Bounce option ( Bounce Category shows the type of bounce)

10. Block Bounce Rate - Extract Bounce option ( Bounce Category shows the type of bounce)

11. Links Clicked -- In the Extract Clicks Option you have the field URL it shows the link clicked by particluar subscriber for particular send

12. 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!