Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [tracking-extract]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
34 views

Tracking extract - attributes file

can someone help with including attributes in the tracking extract output? My goal is to include in the tracking extract an internal list id that corresponds with a subscribers' event. That list id is ...
PForsyth's user avatar
0 votes
1 answer
64 views

Extracting _sent data view from parent business unit via SQL query not returning all records

I am trying to extract _Sent data view records in a data extension via SQL query from the parent / enterprise business unit in SFMC. When I am running this query (expectation is that extracted data ...
kl2's user avatar
  • 343
0 votes
0 answers
69 views

Combining SFMC Job, Send and Click Tracking Extracts to create Impression Tracking by Job Report

I am trying to create a custom report in SQL to mimic following 'Impression Tracking by Job Report' in SFMC for all Jobs but currently testing with just one job ID to narrow down my testing by I am ...
Pardeep Singh's user avatar
0 votes
1 answer
77 views

How to properly join 3 Tracking Extracts to create a YTD Clicked Link Tracking Report for all types of email sends (email names)

I would like to build a YTD Click Tracking report to replicate similar but better reporting I do currently with Queries/Automations where I join the click data view with the job data view and ...
NewJackSwing4Ever's user avatar
0 votes
0 answers
31 views

Removing Duplicate Contacts from Tracking Extracts

We had a new member of our team accidentally map the wrong SubscriberKey which ended up creating ~500k duplicate contacts. We work with another vendor who ingests the tracking extracts for future ...
Lisa M's user avatar
  • 11
0 votes
0 answers
97 views

Data Conversion & date/time wildcards

I have a data conversion step in an automation that follows this file naming convention: MemberCommunication_%%Year%%%%Month%%%%Day%%%%Hour%%0000.csv I needed the timestamp to facilitate the ETL ...
PForsyth's user avatar
0 votes
1 answer
100 views

Is it possible to detect the exact location of the subscriber who click the link in email?

If subscriber clicked any link in email. How to track the exact location of the subscriber like (state) ?
Test SFMC's user avatar
1 vote
1 answer
77 views

Is it possible to replace a Data Extract file in an exported ZIP?

Creating a Tracking extract, but there are errors in the NOT SENT file. We have created a process to remove the bad data and create a new "NOTSENT.CSV" file, but is it possible to put this ...
George Rosedale's user avatar
1 vote
1 answer
109 views

The name of the file resulted from a Mobile Push Data Extract to use in SQL for file transfer

I need some help with understanding how to build an SQL from Mobile Push Extract that needs some transformation to the data like time zone, before being transferred to a AWS bucket. I have an ...
Anar Men's user avatar
0 votes
1 answer
204 views

Is there any way to extract email list data along with the rendered subject line where dynamic subject line is used

In all the email, subject line is never hardcoded and dynamic (not individual for each subscriber) but usually our audience list consist of: Customer Type 1 - subjectline 1 Customer Type 2 - ...
kl2's user avatar
  • 343
0 votes
1 answer
152 views

Data Extract not pulling unsubscribe record

I used a logunsubevent request to unsubscribe a subscriber and after that, I looked for this subscriberkey in the _unsubscribe data view. It shows up fine. I am running data extract with below steps ...
Alekhya's user avatar
0 votes
1 answer
488 views

Is it possible to automate reports in Marketing Cloud?

I need an automated solution for generating an account send summary. It would be ideal to send this data to a data extension. I tried to accomplish this using a tracking extract but it doesn't provide ...
scottola's user avatar
0 votes
1 answer
332 views

Marketing cloud tracking in Journey Builder or Automation Studio?

I have a Journey with API event as entry source and then I send emails to these customers. How can I track the open and clicks in Journey builder. Can export csv data about clicks and opens? Or should ...
Guest17's user avatar
1 vote
1 answer
7k views

What are the various reasons for "Not Sent" emails in journey builder? [closed]

I ran a tracking extract on a journey send for all those "not sent" and was curious about the possible reasons an email would receive that classification. Here are the reasons in my tracking ...
Luke Krausmann's user avatar
0 votes
1 answer
63 views

Does SendJobs extract include in progress throttled sends?

Per the help documentation here, the SendJobs extract should include jobs with a status of 'Sending.' In an account, I had a job that was throttled over two days but was only included in a SendJobs ...
Dave's user avatar
  • 191
0 votes
2 answers
876 views

Tracking Extract via SOAP API - where to find exported file?

I'm trying to perform a Tracking Extract via the SOAP API and all seems fine from the API response. However, I'm not sure where I should find the file (in this case shorttimespan.zip). Should it be in ...
Stijn Hoste's user avatar
0 votes
1 answer
316 views

How can I extract exactly the "sends" I view in tracking tab on Email Studio?

I've been really struggling trying to extract the table view "My Tracking" in Tracking, on Email Studio. I want to have the information displayed as I see in the Tracking tab. How can I ...
Ramires's user avatar
1 vote
0 answers
1k views

Data export: Views vs Tracking Extract

If we have to make a choice at this moment, on which process we are going to use to extract daily campaign data from SFMC to an external data warehouse, what would be the best (future proof) solution. ...
user6079228's user avatar
0 votes
1 answer
577 views

Perform tracking using trackPageView or EventTracking

We implemented Collect Tracking Code in our website and It's working fine. But beside collecting Page Views we need to be able to collect events triggered by an user/client during the interaction in ...
Youssef Kanso's user avatar
0 votes
0 answers
153 views

Why does my Export of Unique opens tracking data does NOT pull FullName? Though it is present in All subscriber list's attribute

I am trying to Export the unique email openers along with FirstName, as below. Verified that FirstName exists for all of the subscribers (checked in All subscriber attributes). But this does NOT ...
Vishal Kumar C V's user avatar
0 votes
1 answer
798 views

Get Send Job's name in Tracking Extracts file

We receive the JobID value in the SendJobs.csv file in our tracking extracts (generated using a Data Extract activity in Automation Studio). But is it possible to get the name of the Send (not Email) ...
Disasterkid's user avatar
1 vote
1 answer
183 views

Missing Extract Type on Data Extract Activity. Why my account is missing this feature?

Can anyone help me figure out why I am missing the "Tracking Extract" feature in my account.
Vishal Kumar C V's user avatar
1 vote
1 answer
450 views

Import Tracking Extract into DE

I'm attempting to create my own DE's of the tracking exports so that I have a consolidated view of tracking data since I can only pull 30 days at a time using the Tracking Extract (Data Extract ...
Clint Woodruff's user avatar
1 vote
0 answers
275 views

Conversion Tracking Extract empty

I am trying to do the Tracking Extract (Conversions) from Salesforce Marketing Cloud. I'm fine with the process of doing it, but when it falls into the FTP the data is empty. Has anyone else ...
Annie-Louise Bray's user avatar
0 votes
1 answer
2k views

Tracking extract with device type

Is it possible to create a Tracking Extract activity in Automation studio that includes the type of device the recipient has Opened or Clicked on? Or should this be done via an SQL Query Activity? If ...
Disasterkid's user avatar
0 votes
1 answer
632 views

Tracking Extracts not available under the Data Extracts activity

As the title explains, in Automation Studio, when I create a new Data Extract activity I do not see the option to set it to "Tracking Extract". According to the documentation, I should be able to see ...
Disasterkid's user avatar
1 vote
2 answers
891 views

Failed Import of Tracking Extract

I am trying to export tracking extracts from SFMC to FTP, and then import these tracking extracts in to data extensions for consolidation and in order to perform queries on this data. I have created ...
Kristin de Clerville's user avatar
0 votes
2 answers
2k views

Date-time stamp in sends & opens data view in marketing cloud is not in sync with local time

I'm using salesforce marketing cloud for sending emailers. Date time settings in my account are set as per IST (Indian standard time), GMT + 5:30. Though when I fetch data from "Sends" & "Opens" ...
ASHISH's user avatar
  • 556
0 votes
1 answer
2k views

Tracking who Exports Reports

Yesterday I exported a couple of reports and wanted to track these which has hit the 24hr mark. The following day I went to workbench and through Querying the EventLogFile Object and looking at the ...
Kevin's user avatar
  • 39
4 votes
2 answers
3k views

Need details on the "reason" data found in Tracking Extract NotSent file

I'm researching why several thousand of our subscriber records are not being sent emails. I've confirmed the subscribers do not have an 'unsub' or 'held' status. My next thought was to run a ...
David Devoy's user avatar
  • 2,615
1 vote
1 answer
1k views

How can I get a tracking send data extension via API?

On the tab Tracking->Send, there are an attribute called "Data Extensions". It indicates which DE is used for this send. I can get it one by one on Marketing Cloud, but on SOAP API, the "List" ...
PY Yick's user avatar
  • 201
1 vote
2 answers
3k views

Retrieve a list of all JobID done in Marketing cloud

I want to know if you can retrieve the list of all jobID via a REST or API call, I found nothing in the official doc so does anyone have a trick to get this list? There should be a way, because if you ...
Otor's user avatar
  • 354
0 votes
1 answer
463 views

Tag Email Sends

We want to analyse email sends from marketing cloud within our data warehouse, and to run an effective analysis, we plan to tag all email sends (manual/Journeys/Automation email sends) with proper ...
Michael H's user avatar
  • 549
1 vote
1 answer
240 views

Marketing Cloud - Report classifying emails sent from journeys. user initiated, or automation studio

Does anyone know if there is a system report that can be used to show all emails sent from the platform as well as classified as either being in a journey, user initiated, or from automation studio?
Mark Koh's user avatar
3 votes
1 answer
910 views

Download Marketing Cloud's Report data

I'm new at SalesForce and probably don't know enough yet to tell if this is possible or complete nonsense. I was wondering if I can extract data from a Campaign Tracking Report without the need of ...
mdKrdoso's user avatar
1 vote
0 answers
1k views

Conversion tracking in Email (Marketing Cloud) not working - Please help

When creating a button with a link in Marketing Cloud content builder there is the option to add a link URL, Title and Tracking Alias and a 'conversion tracking link' tick box. We have set up our ...
KatyFerguson's user avatar
0 votes
1 answer
518 views

Impression tracking on dynamic content block with AMPscript

I want to add Impression tracking to a dynamic content block that is added with AMPscript. So the dynamic content block looks like this in our email template: %%=ContentAreaByName("my contents\...
Trine's user avatar
  • 43
2 votes
0 answers
167 views

Behavioral Data in Mobile Push

I know we can retrieve Email Behavioral Data using Extract or SOAP API. But is there a way to retrieve the same for Push notifications ?
zeljazouli's user avatar
  • 1,088
0 votes
1 answer
2k views

Data Extract activity for SMS Sends

Newbie alert. There are no options in the Automation Studio to track SMS sends. Data Extract activity at least does not have that option. Is it possible to collect that data through an Sql activity ...
Disasterkid's user avatar
1 vote
1 answer
2k views

Extract mobile connect list of unsubscribes

I have tried to find information about how to automate the export of MobileConnect status for unsubscribes with stop-code. I've found this official documentation about querying data views as ...
Axel Ekeberg's user avatar
1 vote
0 answers
56 views

Clearing out junk tracking data from old versions of Journey Builder

Is there a way of clearing out old tracking data from Journey Builder tracking? We have taken several versions of a journey and the old entries for each send stack up beneath it. Is there any way to ...
TCassa's user avatar
  • 878
0 votes
2 answers
1k views

Export Tracking Data from Marketing

I need to export tracking data (sent, opens, bounces, etc.) in CSV file from Marketing Cloud to a Data warehouse through sFTP folder. I would use the system data extension as explained here and ...
cmbob's user avatar
  • 624
1 vote
1 answer
2k views

Query for Opens from for an email in a Journey

Is it possible to query for open data from an email in a Journey. I've been having trouble extracting that into a data extension. I'm using this query SELECT c.JobID,c.SubscriberKey FROM _Open c ...
player1's user avatar
  • 23
1 vote
0 answers
35 views

Web & Mobile analytics Track Purchase Details with AJAX Redirector Call [closed]

I want to use use ajax call to track purchase items. I found this documentation but it's not very clear in particular how compose the url to pass to the function.
Antonio Zaccardi's user avatar
0 votes
1 answer
186 views

How can we get tracking information for Sendable Data extensions?

I have a Data extension containing Student Data - Student first name, last name, course, faculty,etc. I have executed Email Sends on this Data extension. I would now like to get tracking data - for ...
Kanav Khurana's user avatar
1 vote
0 answers
541 views

Tracking sent Triggered emails

I am wondering if there is any way to track the sent triggered emails. So I would like to have a report with all subscribers that recieved the email, and what activities they did, for example if they ...
user39574's user avatar
0 votes
1 answer
229 views

Distinguishing test sends in Tracking Extract?

I see that Tracking Extracts allow you to "Include Test Sends" but the data doesn't make it possible to distinguish test sends vs. non-test sends. Am I missing something? Will I have to include this ...
Daniel's user avatar
  • 1,277
1 vote
1 answer
1k views

Data Extension Extract using API

I would like to execute a Data Extension extract using API. Went through the below documentation but it asks for Start and End Date which doesn't make sense for Data Extension extract. Any suggestions?...
Maneesh's user avatar
  • 2,176
1 vote
1 answer
3k views

Tracking Extract or Data View export?

The goal is to consume tracking data (sent, open, clicks, jobs, etc.) to an external to the Marketing Cloud database. Are there any general opinions of whether it's "better" to use tracking extracts ...
Daniel's user avatar
  • 1,277
8 votes
1 answer
4k views

Help with incomplete Tracking Extract documentation

Would anyone out there be able to provide some additional documentation for these Include Options for a Data Extract of Tracking Data? I've requested an update to the one wiki page that has most of ...
Adam Spriggs's user avatar
  • 30.7k