Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,391
questions
0
votes
1
answer
40
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
-1
votes
0
answers
36
views
Sent emails go to spam
I'm sending emails via Journey Builder to users who come to the Data Extension. A problem was discovered that most of them receive emails in spam. How can I understand what is the problem?
- 11
0
votes
1
answer
34
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 ...
- 136
0
votes
1
answer
31
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
49
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,151
0
votes
1
answer
42
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
0
answers
17
views
what are limitation of synchronised data extension and where I can use synchronized DE [closed]
I have to create a welcome journey and a birthday journey. I have a synchronized data extension for all the required objects but there are multiple limitations to synchronized data extension.
...
- 1
0
votes
1
answer
22
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
28
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
16
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
26
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
30
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
30
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
19
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
48
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
21
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
31
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,151
0
votes
1
answer
24
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
60
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
37
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
37
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
50
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
24
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
53
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 = ...
- 160
2
votes
1
answer
61
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
69
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
31
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 ...
- 11
0
votes
0
answers
59
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
79
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
45
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
45
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
52
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
36
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
29
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
46
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
36
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
29
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
15
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
55
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
46
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
59
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 ...
- 390
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 ...
- 160
0
votes
1
answer
32
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:...
0
votes
1
answer
19
views
Append SubKey to DE via Email Lookup
We are trying to figure out if this is feasible:
A vendor has a product that triggers a journey, however in their payload, they can only send the email back and the payload is unable to be modified.
...
- 25
0
votes
0
answers
45
views
data extension dependency in SFMC
Is there a way to find out dependency of data extension in a Business Unit?
example: if we are adding one additional field (primary key) to one the data extension which is used in many functionalities,...
0
votes
2
answers
90
views
Using the Marketing Cloud REST API, can a value in a row in a data extension be changed if the column is part of the primary key?
I am considering using this endpoint:
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/putDataExtensionRowByKey.html
to insert and update (UPSERT) values.
Is it possible to use ...
- 93
1
vote
2
answers
41
views
BadRequest Error Response on DataExtension Upsert API Call
I have been looking at the SYNC endpoints for data extensions and
I'm making calls to the endpoint: POST /hub/v1/dataevents/key:ET_Contact_Detail/rowset
with a body of:
[
{
"keys"...
- 111