All Questions
26 questions
0
votes
1
answer
1k
views
SQL query to update field only if it is empty
I need to run a query which updates a target DE with some rows from another. There is a field called 'origin' which shows on the target data extension where the data came from.
I appreciate this may ...
CommunityBot
- 1
4
votes
3
answers
5k
views
Cannot Query Synchronized Data Extension
I have created a Query to consolidate data from 2 Synchronized Data Extensions into one Sendable DE, but upon running it I get an "Automation failed due to system error".
At first I thought my query ...
- 25.8k
3
votes
2
answers
421
views
How to delete emojis using SQL in Marketing Cloud
I have a Data Extension named "Jobs", where I keep records from dataview Job. My team started to use emojis in subject lines of the e-mails, so also in my table "Jobs", I have ...
- 193
-1
votes
1
answer
67
views
Automation for birthday adding contacts the day after instead the exact day
we're experiencing some issues with a birthday automation query.
Our query runs everyday and should filter contacts from 2 DE (contacts that are celebrating their birthday on that day) and put it in a ...
- 31.1k
0
votes
1
answer
99
views
How to get records from sendable audience who did not make it to _SENT log without hardcoding the jobid
I have a DE extension where I have saved 1 record by querying:
DE NAME: DataView_Job_DE
Select top 1
JobID
,EmailName
,CreatedDate
,JobType
,JobStatus
,Row_Number() OVER (Partition by jobid ORDER BY ...
- 10.3k
0
votes
1
answer
285
views
How to selecting value from another data extension in select statement in SFMC
I have a DE extension where I have saved 1 record by querying:
Select top 1
JobID,
EmailName,
CreatedDate,
JobType,
JobStatus
from _job
Output is saved in data extension: DataView_Job_DE
Now, I am ...
- 10.3k
0
votes
1
answer
78
views
Specific Domain SQL Query result incorrect
I am trying to pull list of emails for a particular domain (which is aproblematic domain) and somehow my results does not make a sense--meaning that I'm getting way less than expected. To further ...
- 35
0
votes
0
answers
187
views
Problem with automation and Sql Query
I have a problem with an automation:
the query inside has no error and runs correctly, but no record is extracted. If I try to run it externally (via run once and query studio) the records are ...
0
votes
1
answer
99
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 ...
- 22.2k
0
votes
1
answer
2k
views
Count the number of contacts in each Business Unit
I have 2 BUs in the Marketing Cloud and each has its own contacts.
My issue is that my client wants to retrieve the number of contacts in each BUs, because each BU has its own budget and can only ...
- 4,765
0
votes
1
answer
731
views
how to use SSJS to extract all distinct values (may require looping) and push it to sql query in marketing cloud?
I am new to SSJS and have not used it yet.
I have a use case where I need to extract JobID and Data Extention Name from SendLog Data Extension.
I use JobID and DE_Name in SQL query but right now I ...
- 353
1
vote
1
answer
1k
views
Identify automation populating a Data Extension
I need to know which Automation is filling in a Data Extension (DE), the only way I know is to open the Automation one by one and see if it fills in my DE.
Is there a faster way to search for it?
Are ...
- 4,453
0
votes
1
answer
971
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. ...
- 10.3k
0
votes
2
answers
300
views
Duplicate data from a synchronized data extension- Can't see the Syn DE in Automation studio
i'm working in Automation Studio in order to duplicate the data of synchronized DE into a new sendable DE. The problem I have is that I see the synchronized DE in Contact Builder but I can't find it ...
- 13
1
vote
3
answers
4k
views
SFMC Find and Replace via SQL query
I have a data extension where values are imported via an Import Activity. One of those values is a URL ending in .biz. I'm trying to write a query that finds all instances of .biz with .com but ...
- 191
0
votes
2
answers
10k
views
Automation Query Error in Marketing Cloud
I am running the Query using Automation with the help of Data Extension, it is showing error like
String or binary data would be truncated.
But i have the Maximum field length also, what ever i ...
- 97
0
votes
1
answer
211
views
Using query to populate target data extension for resending automated mail
Every week we send out a mail on tuesdays.
This mail is named so it always contains this: "TOBERESENT".
Every saturday an automation sends out a mail that is an altered version of the tuesday mail. ...
- 56
0
votes
0
answers
76
views
Pulling new Unsubscribes into an existing DE - results in duplicate key error
Trying to create an automation that finds all new unsubscribes and adds them to a data extension. Writing the Query to pull all the records via an Overwrite works great, but we need to ensure we are ...
- 1,040
0
votes
1
answer
428
views
I need to run query in Automation through soap api
I need to run query in Automation through soap api its Automation creating but Activity not Created when i click on that its showing Error like automation no longer exists this is my code
<...
- 152
0
votes
1
answer
503
views
Activity details unavailable. The activity used in this automation no longer exists. Automation activity error
I Configure Automation with activity query through soap api. When i click
query in automation showing Error.****Activity details unavailable. The
activity used in this automation no ...
- 2,850
0
votes
1
answer
797
views
ExactTarget Drip Campaign based on email opens
I'm attempting to set up a drip campaign that will push recipients forward in the process dependent on whether or not they open an email. Essentially there will be three tiers of emails. Each tier ...
CommunityBot
- 1
0
votes
1
answer
228
views
I need an email sent on a specific date/time. Query needs to pop data ext. 1 day before date/time
I need an email sent on a specific date, my current query populates a data extension from the difference of days since the users received a particular "email id". What would be the best way to have ...
- 31.1k
2
votes
1
answer
880
views
Exact Target SQL- LIKE condition does not return anything
New to ET and have written a query in the automation studio. I have two tables I am looking through and am trying to return what matches my LIKE condition. The LIKE is looking for emails from TableA ...
- 25
0
votes
1
answer
168
views
SQL Query Script to Pull Automation Data
How can I write a SQL query to pull a list of all recipients and their email addresses of an email in an automation?
- 31.1k
0
votes
3
answers
784
views
Query for Engagement Campaign
I'm trying to confirm that the query I have written is correct. I'm trying to pull back people from the 3 lists in the query that have not opened an email within the last 6 months to start a re-...
- 2,615
1
vote
1
answer
4k
views
In ExactTarget How to Query and compare records with all data extension?
I am trying to check the data from particular data extension whether they exist in any other data extension. How can we compare a data from particular data extension with all other data extensions in ...
- 31.1k