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 [data-views]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
42 views

_AutomationInstance data view is not returning right data

can anyone lend me a hand? I'm having trouble retrieving data about my automations using the data view _AutomationInstance. Automation Studio is returning incorrect data for certain automations in ...
Mik's user avatar
  • 3
0 votes
0 answers
30 views

Querying canceled job

received an email via Alert Manager telling me a job was canceled due to a script syntax error. Not sure which email it is but when I query the Job data view for that JobID, I get 0 results. At first ...
PForsyth's user avatar
0 votes
1 answer
35 views

How to get row number for jobid via SQL?

I am trying to extract jobids from data view bases on the emailname. How can I get the row number if I am getting back multiple jobids? I tried using ROW_NUMBER() but getting a static value of "1&...
kl2's user avatar
  • 343
0 votes
0 answers
22 views

BounceCategoryID from Bounce Dataview field doesn't return the right value to Boolean field

I have problems during SQL that it doesn't retrieve the right value to Boolean field. Now I extract Bounce DataView and if BounceCategoryID(number type) is 1002,1003 then retrieve 'true' to Spam field(...
Nicole Jung's user avatar
0 votes
1 answer
57 views

Best way to bring SFMC consolidated data views onto SFSC PersonAccount / Contact record?

We are trying to find the best way to push data from SFMC to SFSC for a given use case. The use case is the following: as a Sales Cloud user, I want to have a clear view on all the communications a ...
Alexandre Vandermeulen'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
-1 votes
1 answer
62 views

How to create a sql query in SFMC with where clause with date and time

I am trying to create a query that pulls the record from _open data view before a specific date and time, how to do that in sql? I am currently doing this for defining the date: Select * from _open ...
kl2's user avatar
  • 343
0 votes
1 answer
85 views

Query for Subscribers Click Counts and SendLog

I'm in the process of building a query that will give me a count of all links a subscriber has clicked on from recent sends. I have a query written out using the salesforce documentation, and I have ...
A S's user avatar
  • 1
0 votes
1 answer
52 views

Querying "Send Count" and "Last Send" in "Push Demographic Table"

There are a few fields that appear in the "Push Demographic Table" (Only Available in Data Designer - Contact Builder) but not on _PushAddress Dataview Table like "Send Count", &...
Khoa Nguyen's user avatar
0 votes
0 answers
71 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
0 answers
26 views

Splitting Data String in Data Extension into Separate Columns Based on Delimiter

I have a data extension that contains the "Link Content" data from querying the _click data view. It returns rows of data with the url + the parameters we have in place. After the url, there ...
SFMCInTraining's user avatar
0 votes
1 answer
309 views

Spam Complaints from Gmail

I am surprised to find zero complaints record from "gmail.com". This is from both Spam Complaints Over Time report and Complaints Data View. I also tried sending a test email and marking it ...
weliott's user avatar
  • 173
0 votes
0 answers
73 views

Linkname Alias problem

I have an issue that I cannot resolve. We create our emails based on our own templates (template based email). For a number of our emails, a URL is constructed dynamically via Ampscript. The problem ...
Martijn e's user avatar
  • 143
0 votes
0 answers
58 views

How to pull unique values from unsubscribe data view when there are duplicates?

Currently, we are pulling the data from data view _unsubscribe with this approach (where primary key is concatenation of all fields). The reason we need a primary key is to avoid adding duplicate data....
kl2's user avatar
  • 343
-1 votes
1 answer
206 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
37 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
  • 343
0 votes
1 answer
45 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
72 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
  • 107
0 votes
1 answer
63 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
362 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
  • 343
1 vote
2 answers
706 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
165 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
2 votes
2 answers
667 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
  • 343
0 votes
1 answer
1k 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
  • 33
0 votes
1 answer
156 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
87 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
  • 143
0 votes
1 answer
346 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
125 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
  • 469
0 votes
1 answer
197 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
62 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
398 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
  • 27
0 votes
1 answer
163 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
58 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
160 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
226 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
816 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
  • 343
0 votes
0 answers
261 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
205 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
665 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
509 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
773 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
688 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
1k 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
239 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
  • 343
0 votes
1 answer
90 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
42 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
4k 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
170 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
661 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
489 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