Questions tagged [data-views]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
67 views

SMS Status Codes in _SMSMessageTracking having 4504 FailedDueToUnknownSubscriber when Journey Builder SMS sent

I use Journey Builder SMS sent and for some small amount of subscribers I had 4504 FailedDueToUnknownSubscriber in the field SMS Status Codes in _SMSMessageTracking according to this document. Because ...
Khoa Nguyen's user avatar
0 votes
0 answers
35 views

Is there any way to distinguish subscribers in SFMC? [duplicate]

Current use-case: In SFMC, we have a parent BU + child BU where all subscribers eventually gets added to Add Subscribers list (shared among different BUs) which is no different than out of the box ...
kl2's user avatar
  • 317
0 votes
1 answer
41 views

I want to sync only those data whose first names are 'Lily' from sales/service cloud to synchronized DE in marketing cloud. Is that possible?

I want to sync only those data whose first names are 'Lily' from sales/service cloud to synchronized DE in marketing cloud. Is that possible? Basically can a filter firstName = 'Lily' be applied to ...
DS0308's user avatar
  • 1
0 votes
0 answers
33 views

Why Related Record component is displayed different with Profiles

I have 2 profiles: System Admin & Agent In Opportunity record page there is a Related Record (standard Salesforce component). The way fields display is different from 2 profiles. I've check field-...
Pam's user avatar
  • 97
0 votes
1 answer
52 views

How to get specific number of email send within a time

I want to get a list of Subscriber that has received 13+ email in July and know their aggregate unique Opens. Here is what I did but there is no result returned. SELECT se.SubscriberKey, sub....
Emily714's user avatar
0 votes
1 answer
117 views

Does SFMC automatically unsubscribe complaints?

In SFMC, one of the captured data is complaints (in reporting and data view). my understanding is the complaints in SFMC means subscribers who mark the received email in their inbox as spam, is that ...
kl2's user avatar
  • 317
1 vote
2 answers
235 views

How do we update subscribers email address in all subscribers list when contact change their email?

Contact located in Salesforce Service is added with "[email protected]" mail. Salesforce Service is connected to Marketing Cloud. Note: Subscriber Key is Salesforce Contact ID. Subscriber related ...
cameron harwood's user avatar
0 votes
1 answer
81 views

Extracting data for _sent Data View via FTP

I have multiple journey builder emails using transactional API and I want to extract daily data for sends and clicks. Using sends as an example, I have created an Automation with these steps: ...
T01's user avatar
  • 9
1 vote
2 answers
301 views

Is JobID same for daily running journeys in SFMC?

When we send one-off emails from marketing cloud, JobID can be used to identify the email deployment as it is unique. When it comes to journeys (in use-case where audience is entering the journey ...
kl2's user avatar
  • 317
-1 votes
1 answer
445 views

Using REST API to fetch data from SFMC Data View

I have seen various answers by Lukas Lunow (Is there any way of retrieving all records from a data extension via REST API for Marketing Cloud?) and Gortonington on the usage of undocumented REST API ...
Sam's user avatar
  • 21
0 votes
1 answer
92 views

Marketing Cloud Engagement - Can Data View retention periods be shortened?

My understanding is that the default retention period for data views is 6 months. Is there an option to reduce or extend this retention period? I am looking to minimise the amount of SMS message ...
ra-work's user avatar
0 votes
1 answer
74 views

I don't understand why my query result counts my email click wrong

Yes that looks better. There was still another issue. When clicking in an email it multiply the sends. This was because of the extra records in the clicks data view. I fixed it with the following ...
Martijn e's user avatar
  • 145
0 votes
1 answer
188 views

How to extract List of all journey only last version with sql

My goal is to create a Data Extension with SQL that will contain a report of all Journeys existing in production BU (except for those deleted), but I need the latest version. I managed to extract all ...
MEN's user avatar
  • 1
0 votes
1 answer
95 views

query received same email multiple times

I have a data issue where we have duplicate emails under different Subscriberkey. I'm trying to build a query now to check how many of this duplicate emails have received the same email multiple times....
Duicug's user avatar
  • 457
0 votes
1 answer
134 views

Adding device OptIn field to SQL query in Mark. Cloud

I have SQL running from a Data extension where I have all marketing opted in contacts, now I need to add a field to the SQL with the device level Opt in and Out options as I will further use these in ...
Anar Men's user avatar
0 votes
1 answer
48 views

Automation to create separate data extensions of bounced contacts for each of our Business Units (Marketing Cloud)

I want to run a _Bounce data view in our Enterprise BU (Marketing Cloud), and then filter the data by Business Unit for each of our 120 Business Units. Is there a way to automate it to create one ...
DigitalColl's user avatar
0 votes
1 answer
250 views

MC - Dataview - activity ID = activity name mapping

I want to know message results per journey. I'm using a 3rd party app for messaging, and the results are only shown as activity ID not activity name, so I can't define which message result this is. **...
Luna's user avatar
  • 21
0 votes
0 answers
142 views

Creating a last modified date for a data extension copy of a data view

Can I have a created date and last modified date as field names in a DE where the last modified date of a record should change when the automation gets new data from the data view for that record?
richard.tate's user avatar
0 votes
1 answer
107 views

How to limit Send of an email to 1000 subscriber only using ampscript

I am trying to limit my email send to 1000 users in the last 24 hours means if my email has been sent 1000 times or 1000 users in single day then it should not do any further send. To implement this, ...
RKNauhwar's user avatar
2 votes
0 answers
48 views

How to create Test record in _Complaint Data view for Outlook?

I have a use case where I need to create a test record in the Complaint data view to test the extract. I have created an automation that extracts data from the complaint data view, due to our company'...
Harish 's user avatar
  • 111
0 votes
1 answer
132 views

Help creating a query to pull all email data from MC into a DE

I want to pull my email data from MC into Market Intelligence (Datorama) by subscriber ID and include enterprise attributes. The best way I have found thus far is to create a DE with the needed info ...
Karen McRight's user avatar
0 votes
1 answer
165 views

What are the value will stored in "Sendtype" in job dataview?

In Job Dataview,what are values we will get under "Sendtype". (Sendtype - The type of send used in the job)
Test SFMC's user avatar
0 votes
2 answers
447 views

Any recommendation on what can be the primary key while extracting send, open and click data views

In my use-case, I need to define a primary key in the data view extracts from sent, open & click I have tried different combination of fields as primary key but somehow getting duplicate values ...
kl2's user avatar
  • 317
0 votes
0 answers
202 views

Is there any other way to store SFMC historical tracking data'(sends, open, clicks) other than using data view & tracking data extract

I want to store historical SFMC tracking data beyond 6 months. We can opt for data view export or tracking data extract to accomplish this. Do we have any other way in marketing cloud to store/fetch ...
SFMCuser's user avatar
2 votes
1 answer
175 views

Automation Studio Data Views - typos or something else in the column names in Salesforce documentation

I'm checking new Data Views _AutomationInstance and _AutomationActivityInstance. In the first of them I found a typo in Salesforce documentation. On the page we can see ...
Maciej Barnaś's user avatar
0 votes
1 answer
557 views

SQL Query return is different in Data Extension and Query Studio return - Marketing Cloud

I'm trying to create an automation that calls a sql query and saves the return in a data extension, But for some reason the data doesn't arrive in the data extension, not as it appears in Query Studio....
Thais Carolyne Souza's user avatar
0 votes
1 answer
401 views

How to get information about unsent emails in Journey Builder?

I have a Journey Builder, in which there are exceptional situations where an email, in general, is not sent and these people are not counted in the Contact Count. They are also not in the Data View ...
HOLTONx's user avatar
1 vote
1 answer
557 views

Update status in all sub with the master DE

I have a question about the unsusbcribe in the all subscriber. When my customer decided to optout in the website of my client, the information of this unsubscribe goes up in service cloud, then in the ...
Valentine C's user avatar
0 votes
1 answer
573 views

Will _Subscribers Dataview retrieve only recent 6 months data?

I need to retrieve 1 year data from parent Bu i used the following query. Select EmailAddress from _Subscribers But i got only 6 months data
SFMC's user avatar
  • 21
0 votes
1 answer
933 views

How to pull Hard bounce Emails from Data extension to exclude it from sending Emails

This is my Query. But its not working as expected.Count of Hard bounce list retrieved using Query is different from tracking report hard bounce list : select E.[Email] from Test_DE E inner join ...
SFMC's user avatar
  • 21
0 votes
1 answer
208 views

How SendLog can capture sent event date?

I am looking into the current SentLog and not seeing any date like Send date. How can I get / capture sent event date in send log?
kl2's user avatar
  • 317
0 votes
1 answer
75 views

Unique Opens no working

select d.envios, x.aberturas, d.data_envio, d.nome_email, d.jobid, pct_abertura = cast((x.aberturas*100/d.envios) as decimal(5,2)) from DE_BK_CV_DASHBOARD_JORNADA_FOPA d left join ( select ...
Thiago Coutinho's user avatar
0 votes
1 answer
38 views

Need help with a SQL query to marry Click and Subscriber data

I'm trying to run a query that will return all of the clicks from a specific email send including alias and email. I need to then marry that data with a custom attribute in our subscriber data (...
TravisNeedsSQLHelp's user avatar
2 votes
1 answer
3k views

Different subscriber status between All Subscriber list and _Subscriber data view

A bit of context: I am building an automation that retrieves all subscribers that have a mismatch between their subscriber status in the All Subscriber list and the hasOptedOutOfEmail field on the CRM ...
robruf's user avatar
  • 362
0 votes
1 answer
121 views

Query all subscribers to find the subscriber key related to the contacts from mobile Data View

I would like to retrieve users who received sms and retrieve their salesforce ContactID. I had created a Data Extension from the template of the SMSMessageTracking DataView in a child Business Unit. ...
Lamia Hafid's user avatar
0 votes
1 answer
579 views

Query to Combine Data from 3 different Data View Tables

I've pulled the last 30 days of data from 3 data view tables (Job, Open, and Click) into 3 different data extensions. I'm attempting to run a query to dump data from my 3 different data extensions ...
rubblerubble's user avatar
0 votes
1 answer
359 views

_Open.IsUnique is TRUE for two records with the same JobId and SubscriberKey - Why?

From my understanding, the first "open" that's recorded for a particular JobId will have their IsUnique attribute as TRUE. Any subsequent opens AFTER that will still be recorded, but with ...
Mike Marks's user avatar
0 votes
2 answers
294 views

Why does selecting from _Sent and LEFT JOIN _Job return null values from _Job

When I select from _Sent and LEFT JOIN _Job it returns null values for fields selected from _Job. I'm querying from the Parent BU so this shouldn't be the BU specific issue. SELECT s.SubscriberKey, j....
MJB's user avatar
  • 21
0 votes
1 answer
347 views

Replace double quotes in dataview Bounce

I'm trying to replace double quotes in "SMTPMessage" field of Bounce dataview in Marketing Cloud. But I've entered in several ways, but the quotes do not disappear. What I did so far is this ...
Daniel Tazinaffo's user avatar
0 votes
1 answer
442 views

_Job data view and viewing dynamic subject lines, impossible?

Logically speaking, I believe it's pretty much impossible for the _Job data view to be able to record VARYING subject lines (based on dynamic rules and whatnot) with the same JobId - correct ...
Mike Marks's user avatar
0 votes
1 answer
334 views

Record not in unsubscribe data view when the LogUnsubEvent API request is made

I have added a subscriber via the update API with a status of "Active" to the all subscribers list, and then the logunsubevent request is made for that subscriber. After that, I looked for ...
Alekhya's user avatar
5 votes
1 answer
660 views

SMSMessageTracking Data View - Differences Between Undelivered and Delivered Fields

We are trying to reterive data from the _SMSMessageTracking data view in order to populate another DE with undelivered and delivered statuses. We've found there is a difference between Undelivered and ...
Barak's user avatar
  • 133
0 votes
1 answer
230 views

SSJS WSProxy Create BounceEvent

I am Adding new subscriber to marketing cloud from another system. Some of the subscriber are hard bounced and have a number of bouncecount. I can create subscriber with Active , Held and Unsubscribe. ...
Chandrashekhar Dautpure's user avatar
4 votes
0 answers
391 views

how data in _open data view is recorded in SFMC

As of now, our understanding of data views is that data is mostly real-time. But is this true for all data views or only specific data views? if specific, then which ones? Recently, we noticed that we ...
kl2's user avatar
  • 317
0 votes
1 answer
693 views

SELECT from _sent dataview - duplicate value error occuring

I am trying to create an Automation to update sent dataview records daily. The code I've tried is the one below, but it kept showing error messages with "Violation of PRIMARY KEY constraint. ...
Lilyn's user avatar
  • 15
0 votes
0 answers
121 views

Measuring Email Send Speed

The Trailblazer "Email Send Speed Optimization" section does a fine job explaining WHAT send speed is and what to consider, but it doesn't explain HOW to measure send speed. Is the speed ...
Daniel's user avatar
  • 1,257
0 votes
1 answer
666 views

Count of no clicks on last 3 emails using data views in marketing cloud

I am trying to write a query in SFMC where i want create a data extension with people who have not clicked any emails and we have sent them at least 3 emails. I have the below query but i am getting 0 ...
rtys's user avatar
  • 29
0 votes
0 answers
426 views

How to get Date only from data view _Sent?

I am using this query SELECT Convert(date,s.EventDate) as s.EventDate, s.JobId, s.SubscriberKey, s.TriggererSendDefinitionObjectID, s.SubscriberID, su.EmailAddress FROM _Sent s ...
Buratchute's user avatar
0 votes
0 answers
176 views

Record count for sent data view object is different in query editor & tracking extract

We are using tracking extract API to extract data views from the Marketing cloud. We get ~382 records when we extract sent object using this. However, when same object is queried we get ~25k records ...
Akshay's user avatar
  • 77
2 votes
1 answer
287 views

SMS MobileConnect Bounce Reason Code

Is there a way to get the reason for an SMS bounce? I see that the "Undeliverable SMS" data view shows if a subscriber has bounced, but it doesn't show the reason for the bounce. I'd ...
Stephanie Hammar's user avatar