Glen Mazza's Weblog

https://glenmazza.net/blog/date/20221126 Saturday November 26, 2022

Creating and Using Tracking Extracts

Up until now I've used Automation Studio's Data Extract Activity for exporting data from a data extension into a file for subsequent downloading to an FTP server. The data extensions were populated via SQL Query Activities against data views for Sends, Opens, Clicks, etc. Tracking Extracts provide another variant of Data Extracts that do not require SQL Query Activities and data extensions. With tracking extracts, you select the general data desired and Marketing Cloud will provide a CSV of it in a pre-defined format. They appear to provide a slight superset of the information available in the data views, in particular, the ability to provide User Agent information (browser, OS, device, etc.) for various email actions.

Tracking extracts must be enabled first for your account by Marketing Cloud support. If enabled, you'll see "Tracking Extract" as an option under Extract Type in the Create New Data Extract Activity window.

I've seen two main usages so far for tracking extracts. In one usage, a two-step automation of a Data Extract Activity followed by File Extract Activity in order to move tracking information to an FTP server for subsequent processing by external systems. Cameron Robert provides a simple and clear video explaining that process step-by-step. A second case is for when you wish to move this data back into a data extension for subsequent SQL Query Activity querying and joining with other data views and data extensions. This process is a little more complex, involving the data first being sent to an FTP server and then re-imported back (Import Activity) into a data extension. Genetrix Technology's Donna Redmond has provided an informative video tutorial explaining this process.

Posted by Glen Mazza in Salesforce at 07:00AM Nov 26, 2022 | Tags:  marketingcloud | Comments[0]

Post a Comment:

Calendar
« February 2023
Sun Mon Tue Wed Thu Fri Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Today
About Me
Java Software Engineer
TightBlog project maintainer
Arlington, Virginia USA
glen.mazza at pm dot me
GitHub profile for Glen Mazza at Stack Overflow, Q&A for professional and enthusiast programmers
Blog Search


Blog article index
Navigation
About Blog
Blog software: TightBlog 3.7.2
Application Server: Tomcat
Database: MySQL
Hosted on: Linode
SSL Certificate: Let's Encrypt
Installation Instructions