Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
969
questions
1
vote
1answer
35 views
Update data extension filtering on WHERE function
If we're building a data extension through a SQL query and it is set to Add and Update and we also use a where function like the one below:
WHERE c.Optin__c = 'TRUE'
If the Optin__c field is changed ...
0
votes
0answers
6 views
Update all subscribers from a synchronised data extension
If we were to use a custom preference centre and synchronise the optin status of an email address and subscriber key into marketing cloud using a synchronised data extension managed in sales cloud, is ...
0
votes
1answer
30 views
Marketing Cloud - Change Field Size in UI Data Extension
While creating or editing a record in a Data Extension, the fields in Marketing Cloud UI (Contact Builder) are too small. I have some fields where I only need to put some four char code and they are ...
3
votes
1answer
44 views
How Can I Programmatically Update Multiple non-sendable DEs to be Sendable?
I have a cleanup I'm working on and hitting a wall.
We use email address as the subscriber key. I have a few hundred DEs with an "email" column that are NOT marked as sendable. I want to update them ...
0
votes
1answer
47 views
separate one column value having comma as delimiter
How can we separate one column value having comma as delimiter using Ampscript.
Example : We have
hello, world in ABC Data Extension in Column "Name"
I want to separate both of them using Ampscript.
...
2
votes
1answer
32 views
Can SQL select values in one table to match a field in another table with wildcards? (Value like %value%)
We have two tables - one is the _click table and the other is a catalog of ProductIDs and we'd like to find all the clicks from the previous day where the ProductID is in the LinkContent field.
The ...
1
vote
1answer
34 views
Failed to convert parameter value from a string to a Int32 while all values are integers
I've encountered an issue while using a LookUp function in AMPscript in an email. I get the error "Failed to convert parameter value from a string to a Int32", when trying to LookUp a value using an ...
1
vote
1answer
41 views
Report number of subscribers in Data Extension
Hope you can help.
I have my subscribers with an active consent transfered into a Data Extension in Marketing Cloud daily, and I would like to have the number of subscribers in that Data Extension ...
0
votes
1answer
36 views
How to run UpdateData and InsertData from cloudpage
I am creating a cloudpage that will use AMPscript to update data of one data extension and insert in another. I was wondering how I could make sure that these functions would run.
So created the ...
0
votes
1answer
65 views
Why are my AMPScript variables rendering in send preview, but not in test send?
I have a series of AMPScript variables and statements, that are resolving perfectly fine in the send preview.
Once the test is sent out, some of these variables do not resolve and some of them do.
...
3
votes
2answers
84 views
SFMC - Journey Builder - custom activity
I have written a custom activity to extract data from my DE and send sms through a third party sms vendor. Here is the snippet from config.json
"arguments": {
"execute": {
"inArguments": [...
0
votes
1answer
42 views
how to create a duplicate data extension from a synchronized DE without manually typing all fields for the new DE
I'm trying to create a new DE from an existing synchronized DE with all the fields prepopulated. When I create the DE I want it to copy all the fields and field types for the synchronized DE to the ...
0
votes
1answer
28 views
How to synchronize a Filter DE based of a Synchronized DE
I have created a filter from a synchronized DE.
I would like this filter DE to be automatically synchronized when new data gets added or removed.
Issues
When trying to create an automation > ...
-1
votes
1answer
46 views
Query to fill the empty column with the next available value from the Data Extension [duplicate]
I have a data extension with a customerID and 15 products assigned to them(screenshot attached)
Some of the 15 products are missing the value and I would like to write a query so if Product1 is empty ...
4
votes
1answer
45 views
Error appending a Data Extension referenced in query
I have a query in a child business unit with an action type of 'Append.'
This query contains a join, and it's targeting one of the Data Extensions referenced in the join. The query was originally ...
3
votes
1answer
45 views
Marketing Cloud Use SQL Activity to Join Multiple Data Extensions
I've recently completed an IP warming process. Contacts were being added to a new Data Extension before each send to keep track of the the separate imports throughout the migration.
Now I would like ...
0
votes
1answer
75 views
Is there a BASE64 Encoding Function using SQL in Automation Studio? [closed]
We'd like to BASE64 Encode our Email Addresses so we can send them to an external third-party (it's the third-party's requirement). We know how to do it using AMPscript, but not in SQL.
Ultimately, ...
1
vote
1answer
33 views
Filtered Data Extension bug
I have an issue when applying filters in a Data Extension for a few days ago. Basically it doesn't work.
For example, if I did a filter from a Data Extension adding the criteria 'Email is not null' ...
0
votes
1answer
29 views
Querying all contacts from DE field in SFMC
Is there a way to query all contacts based on a data extension field? IE query everyone with the last name "Johnson" and the DE field is Last Name. Thanks in advance.
1
vote
0answers
15 views
Journey Builder Ad Audience - behaviour and issues
I am doing some testing of the Ad Audience activity in Journey Builder. I'm hoping someone can confirm/clarify some behaviour for me.
Cannot Select Existing Audience
When configuring the activity, ...
1
vote
1answer
30 views
Contact in sendable Data extension not sent to
I have a sendable data extension, that is coming from a salesforce report.
There are contacts in the extension with email addresses.
The Lead ID is mapped to the Subscriber Key.
It is NOT a ...
0
votes
2answers
45 views
SQL query to find subscribers who were sent with the same Email Name
I've been using marketing cloud for almost a year now but not really exploring the SQL queries since i'm not really familiar with this. I'm also aware that my friend set up my account with lots of ...
0
votes
0answers
11 views
MC stored Opt In Status from List into Data Extensions
The problem in our sales cloud/marketing cloud construct is that the opt-in must be stored in our marketing cloud and there is no field in the sales cloud for it.
As I understand it from my research, ...
3
votes
3answers
50 views
Show dynamic content based on percentage
I want to show a certain contentblock randomized to new subscribers. We want to ask them to leave a review on a certain website (or websites).
Though, some review websites are more important than ...
0
votes
1answer
67 views
How can I add data to Dataextension for SSJS
I am trying to add data to Data Extension using SSJS Script through Automation Studio.
1.I want to HTTP GET(ThirdParty's recomend)
2.I want to catch response(JSON) and add data to Dataextension
How ...
1
vote
0answers
30 views
Transfer Smart Capture Form to Code View in Cloud Pages
Is it possible to transfer a smart capture form that was created in content builder over to a code view marketing cloud page? I essentially want to move it to custom code, but I cannot figure out how ...
0
votes
1answer
34 views
BUG: Data Extension columns are mismatched with data
The data in my data extension is landing within the right columns, however, it looks as though some columns "push" the data for other columns further out. Visually, the data does not match the columns ...
0
votes
1answer
61 views
A Data Extension for Journey logs in addition to the Entry Point
I am a Journey Builder newbie and I have noticed that the Test module of the tool is not completely reliable. Moreover, the History tab of the journey does not give a coherent view of the journey. ...
0
votes
1answer
27 views
Data Extensions across Business Units? (no shared Data Extensions)
Is it possible to create Data Extensions with Data from Different Business Units? I don´t mean a simple Shared Data Extension, I mean: One Data Extension created from two different Synchronized Data ...
1
vote
2answers
57 views
Journey Builder Immediate Data Extension Evaluation
I have a Data Extension with Customer Data that is being updated by external services constantly (via the SFMC API).
This Customer DE contains all necessary Subscriber fields including SubscriberKey (...
1
vote
1answer
33 views
Merging 2 fields in a data extension
Customer has a data extension named SMS_Sends_DE, this data extension stores SMSTracking Information. If the SMS message is greater that 160 characters, there will be 2 records in the data extension.
...
4
votes
1answer
88 views
Update Data Extension field name with SOAP API
I'm having issues trying to update a Data Extension Field Name using the SOAP API.
I've followed the documentation to Update Column Properties for a Data Extension.
I've tried different permutations ...
0
votes
1answer
74 views
REST API error: Primary key '(primarykey)' does not exists
I am trying to upsert a row into a triggered send data extension with a synchronous call, but I am receiving the following error message:
{
"message": "Primary key 'Email' does not exist.",
"...
0
votes
1answer
35 views
Transform Data Extension to Triggered Data Extension
Does anyone know whether it is possible to transform a standard DE to a triggered send DE?
1
vote
1answer
34 views
Einstein Engagement Frequency - what do the resulting data extensions look like and are they accessible?
I've been reading the documentation and watching some demos on the Einstein Engagement Frequency in Marketing Cloud (https://help.salesforce.com/articleView?id=mc_anb_eef_create_de.htm&type=5)
...
0
votes
1answer
38 views
XML to Data Extension
I am trying to find a way to automate a SOAP call and have the response which is in XML format being parsed and put into a data extension in the proper format (data to columns)
I can create the SOAP ...
0
votes
1answer
38 views
Contacts Deletion in Marketing Cloud
How can I delete the contacts that are not a part of Data Extensions or Journey Builder in marketing cloud?
I don't wanna delete any of the Data Extensions or Salesforce Data Extensions that are ...
0
votes
1answer
30 views
Can i send two seprate email to two different person using 1 journey in marketing cloud [duplicate]
I Have an cloud page with smart capture form that is pushing data to data extension.
What i want is, when user fill the form and become a subscriber will get an email and at the same time i want to ...
1
vote
0answers
39 views
Data Extension List REST API
I want to list the data extensions contained in a specific folder in SFMC using REST API.
I have already checked the documentation and I found a way to do it with SOAP API. But we need to do it with ...
1
vote
1answer
32 views
How to check all records of data extenion in marketing cloud
I have an data extension that include +1000 records. But when i check for all records it shows only 200 records. At the button it is written that Only the top 200 records are displayed.
Is there ...
0
votes
1answer
20 views
Data Extract Audience Studio Format
We are currently implementing Audience Studio, one piece needed in our project is a first-party import. My initial thought for this was to use a data extract activity in the marketing cloud to do this ...
0
votes
1answer
83 views
How to Delete a Data Extension Folder
Sorry if this sounds like a silly question, but I can't figure out how to delete or rename a folder I created under Contact Builder -> Data Extensions.
My folder is sitting under the root "Data ...
1
vote
1answer
53 views
Create an automation to fetch data from FTP and create a DE that updates every day
I want to create an automation that pulls the data from the FTP to salesforce and creates a data extension that gets updated every day.
The problem is that the folder where the data is located is ...
1
vote
1answer
40 views
Journey builder custom activity app accessing Data Extension field values dynamically
I have a query regarding marketing cloud custom journey builder app.
This question might look similar and tried but the solution ins't working might be something wrong with my execution. Please ...
0
votes
2answers
52 views
We have a SQL Query looking for _Open and _Click data that is failing because it keeps timing out
The query is intended to populate LastClick and LastOpen data in our Master Subscribers DE.
Here is the query:
SELECT
a.Email,
a.LeadUID,
MAX(o.EventDate) as LastOpenDate,
MAX(c.EventDate) as ...
2
votes
1answer
40 views
Storing Encrypted Voucher Codes in Marketing Cloud
We are using a lot of vouchers in our marketing campaigns and usually, vouchers are uniquely assigned to a specific user when they are being issued on the back-end, and therefore no other user can ...
0
votes
0answers
14 views
How to delete all rows with certain condition using Marketing Cloud Rest API
I'd like to hit a rest API and delete all rows in a data extension. The data extension doesn't have a primary key, but it has a "condition = x". For instance:
condition, value
x, 11
x, 22
x, 33
y, 44
...
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
2answers
45 views
Unable to set datetime field in data extension to null; Marketing Cloud Rest API
The field is Nullable and I'm trying to hit
/data/v1/async/dataextensions/key:DE_NAME/rows
with attached items obj
const items = [
{
'Subscriber Key': SUBSCRIBER_KEY,
'Date': null
}
]
...
0
votes
1answer
27 views
Can't create Data Extension with SSJS
I'm trying to create a proof of concept data extension with one field for each unique value in a specific column of another data extension. I am intending to do this using a SSJS script run as part of ...
