Skip to main content
8 votes
Accepted

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

I believe this is one of those things you need to request from Support. Create a case for this.
Simo Sarttila's user avatar
7 votes
Accepted

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

Held and unsubscribed are both statuses subscribers can have in Marketing Cloud. Held: Three or more bounces, soft or hard, are received for the subscriber and more than 15 days have passed since the ...
zuzannamj's user avatar
  • 14.4k
4 votes

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

Unfortunately the personalized content is not stored in Marketing Cloud unless the Send Log DE is already active. For the future sends you can use SendLog future though, that's the cleanest way to ...
Ali Eroglu's user avatar
3 votes

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

The system date time for Marketing Cloud is almost always in CST. In your query you can just convert the CST time to your timezone. To adjust it by 11 hours. SELECT DATEADD(hour, 11, s.EventDate)...
Travis Naughton's user avatar
3 votes
Accepted

Retrieve a list of all JobID done in Marketing cloud

The simplest and fastest way to do this would be to combine a SQL query with your API call. Create a DE with the corresponding fields to Job View Query Job View (e.g. SELECT * FROM _Job) Use the SOAP ...
Gortonington's user avatar
  • 30.7k
2 votes
Accepted

Download Marketing Cloud's Report data

It's possible to use Automation Studio's Report Activity to automatically have a report exported to the FTP as CSV. Once it's on the FTP, you could use an Import Activity to import it into a Data ...
Christopher Carswell's user avatar
2 votes
Accepted

Data Extract activity for SMS Sends

You are right RE: Tracking SMS sends automation Studio. Generally reporting is on SMS is not as comprehensive as emails in SFMC (mainly undelivered and no deeper engagement data). It is possible to ...
0xsegfault's user avatar
  • 6,603
2 votes
Accepted

Extract mobile connect list of unsubscribes

Probably the closest thing you can get to something like a Tracking Extract Activity would be to schedule a "SMS Message Detail Report" from within Analytics Builder and schedule it to save the file ...
Macca's user avatar
  • 8,256
2 votes

Data Extension Extract using API

I know this is a late answer, but in case you haven't already solved this. Retrieveing data from a Data Extension The below sample includes a 'filter' to a specific email address, which is not ...
Gortonington's user avatar
  • 30.7k
2 votes

Help with incomplete Tracking Extract documentation

The answer is all there in the name of those two fields. Unique Clicks are uniqueness across everything. So if I click three different links in the email, I'm counted once under this. Unique Clicks ...
David Murphy's user avatar
2 votes
Accepted

Tracking extract with device type

While creating Tracking extract activity, select "Include User Agent Information" checkbox, it includes user agent data related to the open or click, such as operating system, email client, browser, ...
salesforce-user's user avatar
2 votes
Accepted

Tracking Extracts not available under the Data Extracts activity

This is explained further in documentation, under Extract Output Reference. Extract types must be provisioned for your account. Contact your Marketing Cloud representative for more information. ...
Rain's user avatar
  • 5,775
2 votes

Failed Import of Tracking Extract

Note that a tracking extract creates a zip-file containing the individual files (like sents, bounces, opens etc.). So make sure that the .zip file extension is used in the file name, otherwise the ...
fmu's user avatar
  • 62
2 votes
Accepted

Get Send Job's name in Tracking Extracts file

Email name should be the only value inside of 'Name' in 'My Tracking' inside the SFMC UI. The only way this name would be different from current emails is if you changed the name of the email after ...
Gortonington's user avatar
  • 30.7k
2 votes

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

Tracking Data Extracts initiated via SOAP API will be extracted to the default Export SFTP folder for your business unit. I haven't found a way to specify an alternate location with this object. If ...
Adam Spriggs's user avatar
  • 30.8k
1 vote

Tracking extract - attributes file

As the attribute in Tracking Extract needs to be a Subscriber attribute, it is not sufficient only to have it available as a field on the sendable data extension. What you could consider, is to use a ...
Lukas Lunow's user avatar
  • 21.7k
1 vote

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

You can extract and import Not Sent tracking data into a Not Sent Data Extension and do whatever you please with it. It's convoluted, but it should give you the flexibility to launder the data before ...
Adam Spriggs's user avatar
  • 30.8k
1 vote

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

You cannot use a report in SQL. You need to create the report first and import it into a Data Extension. Then run the SQL to pull and transform data from that DE and save it in another DE. Then, run a ...
zuzannamj's user avatar
  • 14.4k
1 vote
Accepted

Perform tracking using trackPageView or EventTracking

Your explanation is definitely clear enough. You can indeed "track" your own custom events with Collect. The trouble is, you can't report on them in any way without an engagement with ...
Macca's user avatar
  • 8,256
1 vote
Accepted

Import Tracking Extract into DE

One way to get around this is to add multiple Primary Keys to your import data extension(s). This will allow for multiple unique values per record. For example, you could set both "SubscriberKey&...
ropedog's user avatar
  • 392
1 vote
Accepted

Tracking who Exports Reports

If you haven't licensed the Event Monitoring feature, per Trailhead: Enterprise, Unlimited, and Performance Edition organizations have free access to the insecure external assets, login, and ...
cropredy's user avatar
  • 72k
1 vote

Failed Import of Tracking Extract

Step 3 is redundant. Create a File Location for when you transfer from the safehouse to this newly created location (it could be a new folder or the/Import folder. Then run the Import Activity from ...
Jackson Chen's user avatar
  • 4,725
1 vote

Tag Email Sends

There may be better ways to do this, but the approach I've previously taken is adding a "Tag" column to my sendable DEs with a default value, and additionally a "Tag" column as my SendLog, which will ...
dsn084's user avatar
  • 46
1 vote

Export Tracking Data from Marketing

You'll probably find the Tracking Extract more useful for your purposes, than Data Views, if what you'd like to do is push this data to SFTP for your DWH. These are somewhat more comprehensive than ...
Macca's user avatar
  • 8,256
1 vote

Query for Opens from for an email in a Journey

I assume you are trying to execute the query from a child Business Unit. If so, append an Ent. prefix to your Data Views: SELECT c.JobID, c.SubscriberKey FROM Ent._Open c INNER JOIN ( SELECT ...
Eliot Harper's user avatar
  • 16.6k

Only top scored, non community-wiki answers of a minimum length are eligible