Questions tagged [data-views]
The data-views tag has no usage guidance.
97
questions
0
votes
1answer
30 views
Marketing Cloud Data View Question - Query returns 0 records
Query
select
s.Emailaddress as 'Email_Address'
, s.SubscriberID
, s.subscriberkey
FROM _Subscribers s
JOIN _Sent se ON s.Subscriberkey = se.Subscriberkey
is anything wrong with it? or is this a ...
1
vote
2answers
26 views
Journey Data View
I just wanted to ask, if I have a journey that was created 6 months back, but I created a new version of the journey within 6 months, will the data view of journey give me the data for this journey or ...
2
votes
1answer
34 views
Why is my click data view query not delivering the results I expect?
I'm working on a setup of individual journeys triggered by clicks on certain furniture aliases.
At the moment I have journeys starting when either of these aliases;
'WeLove_AlbaSidetable',
'...
0
votes
0answers
33 views
Marketing Cloud data views for Journeys that do not send emails
Background
My customer would like to create non-sending journey to get a better sense of the data coming into a journey, and decision logic we plan to use. We are experiencing lots of bad/dirty data, ...
0
votes
1answer
34 views
Query: Deduplicate results (from _Click data view query)
I'm trying to add click on a certain alias to a data extension for segmentation purposes, but I find my query erroring with the 'Violation of PRIMARY KEY constraint. Cannot insert duplicate key.' ...
0
votes
1answer
35 views
Multi-part specification SQL error
I am trying to pull bounce information for subscribers of a particular data extension using the following SQL:
Select
o.JobID,
o.SubscriberKey,
o.EventDate,
o.BounceCategory,
o.SMTPCode,
o....
0
votes
0answers
16 views
Get list of unique emails from a single journey send
I remember in email studio i was able to download a list of emails for unique opens and clicks but I understand that it is now "old" and that the new reports tool is contacts-analytics builder.
Am ...
0
votes
1answer
39 views
Record not in unsubscribe data view
When I query _Subscribers I can see a record with a status "unsubscribed"
There is nothing related in the _Unsubscribe data view though (I've checked all Business units in the multi org structure)
...
0
votes
0answers
18 views
Update subscription details in MarketingCloud (MobileConnect)
I'm fairly new to Marketing cloud and trying to solve an issue.
How can we update the opt-in and opt-out fields in marketing cloud to reflect the changes from a custom preference center? We have a ...
1
vote
0answers
43 views
Have to Track the Campaign ID and Description using DataViews
Currently, I'm tracking the email sent details using data views and storing in a DE, I need to track campaign ID and Description in the same DE. Is there a way to track it using Data Views?
In my ...
0
votes
1answer
23 views
How to Update _Subscribers DE with Records from Email Send Data Extensions
I recently setup the following:
Created an Email SendLog using Template
Added 3 unique customer identifiers to the Email SendLog
Added BusinessUnitID and the same 3 unique customer identifiers in ...
0
votes
1answer
35 views
Marketing Cloud Data Views status and documentation [closed]
What is the current status of Data Views on Salesforce Marketing Cloud?
The official documentation at here returns a 404 error.
Is the functionality being phased out? Or is that an error on SF ...
0
votes
1answer
22 views
Join Subscriber Data to _Open and _Click Data view
How Can i join _Subscribers to this below query to get email address also?
Select
s.SubscriberKey,
s.JobID,
s.BatchID,
convert(char(19),s.EventDate,20) as SendDate,
c.[Click],
o.[Open]
FROM (
...
1
vote
0answers
25 views
How can I get the timestamp when a Contact enters a journey? [duplicate]
I am building reporting using SQL Activities. SQL is bucketing success events into tranches that represent the time window for a communication to claim success- i.e. email 1 is from 0 to 24 hours, ...
0
votes
1answer
42 views
Get subscribers who have opened one or more email in last 5 email deliveries [closed]
I have a requirement where i need to fetch subscribers who have opened at least one email in the last 5 emails delivered to them. Is there any way to achieve this.
I have tried Data Views like ...
0
votes
1answer
33 views
SMSMesssageTracking Data View Field - ResponseToMobileMessageTrackingID
Is there an example of what populates for 'ResponseToMobileMessageTrackingID' on the SMSMessageTracking Data View? I'm relatively new to MobileConnect in SFMC and read the field description found here(...
1
vote
0answers
32 views
SendSplitID values missing in SMSMessageTracking
I'm trying to find a way to get full, concatenated text messages from the data available in Marketing Cloud. This was not possible before, but since then the SMSMessageTracking has become available ...
2
votes
1answer
90 views
Journey, tracking subscribers in WAIT state
I have a question about Journeys, can I track subscribers that are in a state of WAIT inside a journey?
I tried to track with Data View: Journey Activity but the column JourneyActivityObjectID is ...
0
votes
1answer
49 views
Unable to fetch values from _EnterpriseAttribute Data view
I want to import the members of the List to a Data extension.
The required fields are EmailAddress, SubscriberKey and FirstName.
I was able to get the EmailAddress and SubscriberKey from the ...
0
votes
0answers
54 views
GROUP BY in Marketing Cloud to get aggregate opens
We have queried _Sent and _Open data views to get the openers / non-openers for the last 30 days. In the second step, we would like to inner join it with _Job data view to get emailname and emailid. ...
2
votes
2answers
124 views
Einstein Engagement Frequency - How important are unsubscribes to this feature?
We are about to get Einstein Engagement Frequency and I can see one potential hiccup with us using it.
We have Salesforce CRM and the Marketing Cloud Connector configured. Our source of truth for ...
2
votes
2answers
45 views
dynamic subject line extraction
We sent an email which has a dynamic subject line using Ampscript logic. is there a way to find out how may people opened subject line A vS subject line b?
when checking the job table it just shows ...
2
votes
1answer
340 views
What exactly the “BatchID” is in tracking Data Views?
Lately, I have been trying to figure out the most generic query for getting tracking data into one table. As suggested in the SQL Reference, I have been using this join:
...
FROM _Sent s LEFT JOIN ...
0
votes
0answers
14 views
Excluding test sends from Email Open Data View query [duplicate]
we set up sth. like a custom lead scoring in Marketing Cloud by using web webtracking and data views. We are gathering everyone who e.g. opens/clicks an email, visits a specific page on the website ...
1
vote
0answers
38 views
Client MID is now a PARENT MID, but Data Views do not recognize this
We recently added a BU under an existing MID, so now the MID is the "parent" to the newly created BU's MID. However, when we run a simple query and add ent. as a prefix the system does not recognize ...
0
votes
0answers
24 views
Customer Key Of The _PushTag Data View [duplicate]
Is there a customer key to the "_PushTag" data view? I need it for API uses and SSJS development.
0
votes
1answer
97 views
Getting subscriber opens and clicks from journey emails
We would like to get subscriber opens and clicks for all emails from all versions of our journey in the last 6 months (I know that's the limit for data views). I've found the official SQL query but I ...
0
votes
2answers
70 views
Data View: Only count the JobID without TestSend
Is there a way to count with SQL the sents excluding the jobid from test sent?
My sintax below:
SELECT
DATEPART(yyyy,GETDATE()) AS [Year],
'BU1' AS [Business Unit],
COUNT(*) AS JobID,
DATEPART(m,...
1
vote
0answers
26 views
How to query Failed Email Sends over each business unit?
I have a request asking to send out an email with the failed send JobId's (lookback last 2 days) - I would like to automate this process by logging the failed send data to triggered send data ...
1
vote
0answers
46 views
Why is my _subscribers data view returning different results for email address?
I have both MC and SC connected together using the MC Connector. I have noticed a data inconsistency issue when creating an automation to update Email Addresses in my All Subscribers list.
When I the ...
0
votes
1answer
55 views
How to query data views in Child Business Unit?
Can someone please help me on this?
I have a scenario where I need to query the child business unit data views from child business unit.
When I'm trying to query on _open or _click data views it ...
0
votes
1answer
45 views
What does OptOut really mean in the SMSMessageTracking Data View?
Per the docs:
https://help.salesforce.com/articleView?id=mc_as_data_view_sms_message_tracking.htm&type=5
Whether the subscriber has opened out of SMS messages (1 = true, 0 = false)
Is ...
1
vote
1answer
263 views
SQL query to group EventDates by day of week
I'm trying to write a query in Marketing Cloud that will filter for an event (specifically a unique open) that took place on a specific day of the week. So for example, my query would answer the ...
-4
votes
1answer
123 views
Data view schema in marketing cloud [closed]
How all data views are connected to each other in salesforce marketing cloud?
0
votes
0answers
92 views
Marketing Cloud Tracking Exports to Data Extensions
I have a multi-business unit marketing cloud setup and I am trying to extract individual email send data to an external website.
I tried to look up querying this data from within automation builder ...
0
votes
1answer
35 views
Journey Goals based on email metrics
Is it possible to establish a Goal in a Journey based on the % of Open / Clicks / etc of an email within the journey?
I see a Goal can be only set based on Contact Data, so I was thinking in create a ...
0
votes
1answer
65 views
_Open Data View General Inquiry
I am planning on using the _Open data view in my queries in automation studio, but I am not entirely sure how data gets stored there. I will phrase my question in the following scenario: I sent 2 ...
0
votes
1answer
57 views
SQL Querying subscribers older than 6 months
I am trying to query data from an existing data extension into a new data extension and filter out the subscribers that were added within the last six months. The existing data extension does not have ...
0
votes
0answers
98 views
Marketing Cloud: Write “View As Web Page” link and subject of email in Data Extension
For our call center agents it is important to see the emails and its contents a subscriber has received. My idea is to provide our crm system with a file containing the subscriber id, the email ...
0
votes
1answer
128 views
How to eliminate bot clicks with query in Marketing Cloud?
we are querying several data views such as the click of specified links (via web collect) and email opens and email clicks.
In the target Data Extensions that stores all (unique) clicks we experienced ...
0
votes
0answers
28 views
SQL - I want only one row in the data extension per jobId counting all Sents,opens,clicks and unsubscribes for a specifc jobid/Emailsubject
SELECT
F.Emailsubject AS [Email Subject],
a.JobID AS [JobID],
(
SELECT COUNT(DISTINCT d.EventDate)
FROM _Click d
WHERE a.JobId = d.JobId
GROUP BY jobId
) AS Clicks,
(
SELECT COUNT(DISTINCT ...
0
votes
0answers
48 views
Can I query the Email customer key or retrieve via AmpScript?
I need to get the Email (Content Builder) Customer Key, this isn't available in the email send context as a personalisation string and the the _job table only gives back the Asset ID.
Any other way ...
0
votes
2answers
130 views
How to get email address against email id in Job data view?
Job data view provides the status of an email if it was delivered or not but it provides only Job Id and Email Id. This email id is a numeric number and not the email address.
How to get Email ...
0
votes
0answers
175 views
Marketing Cloud API for data views
I have a nice integration setup for salesforce using the simple-salesforce Python package. I can easily insert, extract and describe objects across Salesforce.
I would like something similar in order ...
1
vote
1answer
88 views
Querying for Content Views
in Marketing Cloud, I try to query for contacts who clicked on a specific link on a website and is hence stored in Content Views Data Extension.
We want to use that for a kind of scoring, however ...
0
votes
0answers
185 views
How to query “Last Application Open” & “Last Send” from _PushAddress or other relevant data view?
I can query the system attributes from the _PushAddress data view as listed here:
Attributes in _PushAddress and _PushTag Data Views
But I am unable to fetch the "Last Application Open" & "Last ...
2
votes
1answer
236 views
Is there a Data View of Email Content Tied to the Job Data View?
The Data View for Job has an EmailID as one of the columns. Is there a Data View for Email that can be associated with the job using that EmailID column? Documentation of Data Views doesn't have ...
0
votes
1answer
74 views
SQL Query on _Sent Data View for Suppression List (5 sends in 7 days)
I'm working in a new org where we don't have any send data. I need to set up a suppression list for any subscriber that received 5 emails in the last 7 days. I am not 100% sure if my code below will ...
5
votes
1answer
162 views
Get bounce reason into Sales Cloud
I'm trying to get information about bounce reason from Marketing Cloud to integrated Sales Cloud (I'd like to have this information on Individual Email Result record). Is there any way to do this ...
0
votes
2answers
502 views
Mapping between Contact Key and Contact ID
I have found this article which outlines the data available within mobilpush data views.
Attributes in _PushAddress and _PushTag Data Views
However i have not been able to find a way to retrieve the ...
