Questions tagged [data-views]
The data-views tag has no usage guidance.
184
questions
-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 ...
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 ...
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 ...
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-...
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....
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 ...
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 ...
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:
...
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 ...
-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 ...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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.
**...
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?
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, ...
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'...
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 ...
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)
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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
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
...
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?
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
...
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 (...
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 ...
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. ...
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 ...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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. ...
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 ...
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 ...
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
...
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 ...
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 ...