Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,394
questions
0
votes
0
answers
24
views
Gather email feedback in a Data extension [closed]
we are trying to build a logic where at the end of each email, there is a HTML block with either a thumbs up or a thumbs down icon to measure email sentiment. Each thumb will need to lead to a cloud ...
- 11
0
votes
2
answers
26
views
Updating an attribute in Data Extension while journey is active affects the journey decisions?
I have this journey thats sends an Email; This Email changes an image in the content with an attribute called "concierge" in the Data Extension. The journey is active, and I realize one of ...
0
votes
1
answer
25
views
One-off import into Journey entry source
quick question re: Journey entry source.
Currently I populate the entry source DE with contacts from a SQL query automation.
I've got a handful of records I need to insert into that journey (in the ...
- 1
2
votes
1
answer
37
views
Automated bulk refresh of filtered DEs - API or data filters?
I work for an organization with a very decentralized model, and we have 25-30 departments/teams sending out of SFMC. Each of these teams has their own set of filtered DEs (probably 30-50 per team), ...
- 21
0
votes
0
answers
8
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. ...
- 33
0
votes
0
answers
30
views
FileReadFailure in Automation Studio Import Activity
We have a simple workflow in Automation Studio that triggers when a file with a certain name pattern + %%Year%%%%Month%%%%Day%% is dropped in the "import" FTP folder.
We are having problems ...
0
votes
1
answer
57
views
Contact count is much higher than number of emailable contacts
Our contact count in SFMC is being reported at twice the number of actual contacts we are syncing over two sendable synchronized data extensions (contact and lead). I've checked everywhere I can (...
- 1
0
votes
1
answer
66
views
Data retention policy doesn't apply to existing records in data extension?
I have a data extension which includes a few records. It was not set up a data retention policy in the first place. I have reconfigured the data retention through Contact builder so that individual ...
- 146
0
votes
1
answer
38
views
ampscript lookup to limit number of rows to display if there are more than 5 records
hello currently working on an email that has table and the records are coming from another DE so im using LookupRows using contactId, I want to limit the number of records to be displayed to 5 however ...
0
votes
0
answers
52
views
Data Extension Entry Source Filter Doesn't Work
Journey is having a super simple filter i.e.CREATED_DTE is not null. Somehow the journey doesn't admit any record. EMAIL_ADDR_TXT relates to subscriber on Subscriber key. Any thought/help is ...
- 6,161
0
votes
1
answer
53
views
Moving over 2000+ old Data Extensions to new folder for review/delete
I am trying to move multiple old DEs into a new folder. And, with my limited experience with SFMC Objects & WSProxy/SSJS, I dug deep into multiple resources & samples codes like (Zuzanna - ...
0
votes
1
answer
38
views
How to create a data extension from a Mobile List?
We have created a filtered list in Contact Builder:
Contact Key not null AND
Email Address null AND
Mobile Number null AND
Device ID null AND
CUSTOMER_ID null
This lit identifies the subscribers that ...
- 1
0
votes
0
answers
88
views
Download Data Extension to csv or Excel file via Cloud Pages (Marketing Cloud)
a team in our company needs to be able to download a data extension, and they would prefer to go to a Cloud Page address and just click a download button to download a file in their browser instead of ...
- 1
0
votes
1
answer
19
views
Missing records after Marketing Cloud FTP Export in my local file
Today I did an Enhanced FTP export from a Data Extension that was holding 8,498,752 records with 166 MB.
In the Enhanced FTP directory, a file for it was generated with the size of 203,632 KB.
I ...
0
votes
1
answer
39
views
How to optimize the email AMPscript code that has a lot of lookups?
I have built a dynamic email template. This email template pulls the data from the Data Extension based on email name ( example: subject line, pre-header, content area, headers etc).
For each field ...
- 5
0
votes
1
answer
39
views
Pass the value from email to a content block using AMPscript
In my email, I am calling a Content Block. The content block uses a lookup to pull out content from a Data Extension.
Example code in content block:
set @SourceDE = "DE_NAME" ...
- 5
0
votes
2
answers
33
views
Can you populate SendLog DE with a different value than the one in target DE matching field?
At send-time, data is written to the SendLog and when fields in the Sending Data Extension match the Field name of the SendLog Data Extension, that value is written in the SendLog. But in a field (&...
- 5
0
votes
1
answer
21
views
Is it possible to gather the percent of who gets each email from a random split and put in a DE? [closed]
Right now I am trying to create a report that gathers as much info i can get from journeys and would like to know if its possible to do it with the percent of random splits. We have been using the ...
2
votes
1
answer
57
views
Want to perform Website tracking (only Website visits) through Collect tracking code
Client wants to track known visitors on there website and they are not into e-commerce business.
so we have updated content catalog in email recommendation section and this account doesn't has Web ...
- 23
0
votes
1
answer
40
views
How to reproduce unique record based on a field value (date, account code) on data extension [closed]
Lets say I have rows of sends on contacts on a data extension. These contacts can have the same value on the column Event Date, name and account code
This data extension would be like that :
Contact ...
- 27
0
votes
1
answer
28
views
Retrieve data from synchronised data extension to a sendlog data extension
I would like to retrieve the sends and some data from Synchronised Data Extension in a sendlog data extension. Indeed, more than the sends I would like to retrieve :
the contacts ID who have received ...
- 27
1
vote
1
answer
34
views
Running a script on row update or addition in marketing cloud
I have a DE in marketing cloud which has fields for marketing permission.The permission should be sent to an external database using an api whenever a new row is added or updated.I have to use server ...
- 21
0
votes
1
answer
60
views
Setting existing field as Primary Key on Marketing Cloud Data Extension
We have a data extension which doesn't have any primary key set. Can't we back it up, clear all records and then set an existing field(EmailAddress field we have) as the primary key?
The reason behind ...
- 6,161
0
votes
1
answer
34
views
How to convert the String to a ampscript code in email?
I am storing the email content in the google sheet and then importing it into the data extension. The email is dynamic & is fetching data from the data extension.
For one of the fields i,E URL , I ...
- 3
0
votes
1
answer
71
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 ...
- 17
0
votes
0
answers
42
views
Can I use a publication list to honor opt-outs to guided sends, or must I use a suppression list?
Official documentation wasn't clear to me, and my Salesforce support case didn't give me the level of clarification I needed. I'm trying to transition from using publication lists for internal use ...
- 9
0
votes
0
answers
78
views
Update boolean value in data extension from false to true with Ampscript?
I have a form on a landing page that uses the UpsertData function to add or update rows in a data extension.
In this data extension I have a checkbox with a boolean value.
I am doing a ...
- 11
0
votes
1
answer
54
views
How to update salesforce custom object (Customer__c) OptIn field value from Marketing cloud (Customer DE) OptIn attribute value using AMP script
I have a scenario, 1 DE (Customer DE with SubscriberKey, OptIn, Status, OptInDate attributes) with some records. I want to update the salesforce Customer__c object records OptIn (Yes/No) if ...
- 3
0
votes
0
answers
39
views
Marketing Cloud Journey 'Hard Error' to Same Contact Key
I've encountered a 'Hard Error' without any further details. The journey takes in new records from the Data Extension, and then sends out the email to the Contact associated with it.
In this scenario, ...
- 1
0
votes
1
answer
70
views
Retrieve fields from dynamic data extention in Custom activity?
I am having little issue :
in my js script I am trying to push some data dynamically :
/**
* Save settings
*/
function save() {
//if($form.valid()) {
payload['metaData'].isConfigured = ...
- 159
2
votes
1
answer
121
views
how to get the owner name of a data extension in marketing cloud [closed]
Is there any way to get the owner of a DE through API or Query?, Currently we have a SOAP API but this is not bringing us the Owner, this would be the only attribute that does not call
- 33
1
vote
1
answer
124
views
How can I combine the _SMSMessagetracking data view with another DE without having duplicates in Salesforce Markteting Cloud?
Great feedback. How ever, I still don't get the result I want. This is what I have with the outcome and what I expect:
SMS Tracking view
I created the SMS tracking DE with all the fields from the SMS ...
- 103
0
votes
0
answers
33
views
Send email from a Journey when record data was changed
I have a Data Extension that has multiple boolean fields. Records get into this Data Extension through api requests, and the data in them can also change through api requests.
If the first field is ...
- 13
0
votes
0
answers
119
views
How to link created data extension to my custom form in cloud landing page
I'm new to Salesforce and I having confused about how to link my data extension with the cloud landing page created if I would like to build a custom form.
Here is the situation,
I have created my ...
- 1
0
votes
1
answer
126
views
SSJS Lookup All Rows from Data Extension Column as Array
So I have a "Master" Data Extension that has a ton of columns and rows (millions), and one column needs to have some changes made for specific rows based on Customer_ID. I have a ...
- 27
0
votes
1
answer
52
views
Is it possible automatically to save content builder published urls into a DE?
I have 3 images (imagine: logo, img1, img2) uploaded and published in Content Builder.
I want to add thos published URLs to a DE, so in logo's line I add url from logo image.
If there a just 3, its ...
0
votes
0
answers
53
views
SSJS Array.prototype throws jintException when used with DataExtension.Retrieve value of test
I have stumbled across another interesting case with SSJS and Salesforce Marketing Cloud and hope for some ideas on why this occur and furthermore, how I may can prevent this from happening.
On a ...
- 466
1
vote
1
answer
64
views
Cannot create a Data Extension using SSJS in CloudPage but same code works in Automation Studio
I have created a HTML landing page like below, which takes the input from the user for Data Extension name
<html>
<body>
<h1>
Create a new Data Extension
</h1>
...
- 11
0
votes
0
answers
48
views
Issue when creating a Data Extension within shared folder using SSJS
I could create a Data Extension successfully within any folder inside Data Extension parent folder using the below code. But when I do it for Shared Data Extension, I am not successful, could anyone ...
- 55
0
votes
1
answer
31
views
Data Extension with Logos
I am trying to finalize an email and have run into an issue. The email needs to be dynamic in terms of the logo, as it should swap out based on the company that the audience member is associated with. ...
0
votes
2
answers
57
views
Equally Split a DE by segment
I have a DE with about 4m records. I am looking to do a 50/50 split for testing but by a specific column. So within that DE, every record has a "Segment". So there might be 500k customers, ...
- 23
0
votes
0
answers
48
views
Creating a report based on Data Extension attribute?
My company has a Data Extension which gets updated daily and it consists of for example below:
Name
Product
Product ID
Weight
Jason
Banana
11111111
1kg
Kim
Apple
22222222
2kg
There will be new ...
0
votes
0
answers
30
views
Beginners question about Send Relationship [duplicate]
I'm studying for the certification for email specialist but slightly confused by send relationship and how this is defined. I've always been under the impression that Subscriber key = Contact key.
For ...
0
votes
0
answers
16
views
How to push people from a Salesforce Campaign to Date Extention in Marketing Cloud
How to push people from a Salesforce Campaign to Date Extention in Marketing Cloud. We have a campaign with weekly updates members. We would like to be able easily push them to a data extention in ...
1
vote
1
answer
102
views
How to get UpsertData function to insert data into the data extension?
On the landing page I have a form that is submitting and gathering all the RequestParameter values. When it gets to the UpsertData function it doesn't fire even the few values I have in the function ...
- 11
0
votes
0
answers
13
views
Rest API Search for Entry in Data Extension [duplicate]
I have been trying to search my data extension table to see if a record exists. But I am not able to unless the record has a Contract entry.
I have been using the /contacts/v1/contacts/search endpoint ...
- 111
0
votes
1
answer
80
views
Messages sent from journey aren't being received and Email doesn't delivers to outlook
Hope you're having a good time.
Recently, I've been facing an issue with journeys. I created a journey taking a data extension as an entry source to test email and messages send via journey. Emails ...
0
votes
0
answers
78
views
Importing CSV with null values for phone into SFMC
I have a data extension where I have a field called telephone with a type phone. I have also set it to not required. The CSV which I'm using to import the data has no values in the telephone column. I ...
- 382
0
votes
0
answers
10
views
Rows.Retrieve() returning an empty array using SSJS? [duplicate]
EDIT
Answer found here
I am trying to just retrieve data from data extension
According to this, I have to just use the Retrieve function without any filter
My DE has 11 rows
but all I get is an ...
- 159
0
votes
1
answer
33
views
Error Creating a row in an existing Data Extension in Sales Force Marketing Cloud through SOAP API
I want to add a new row into an existing data extension in SFMC using an API call, I tried using SOAP API, Following are the Error and API request message:
Error : 400 Bad Request.
Request URL : https:...
