Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,507
questions
0
votes
1
answer
58
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
237
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
43
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
87
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
57
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
798
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,231
0
votes
1
answer
213
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
398
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
1
answer
337
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 ...
- 13
0
votes
1
answer
403
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 = ...
- 155
2
votes
1
answer
489
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
1k
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 ...
- 121
0
votes
0
answers
679
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
590
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
140
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
198
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
153
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
113
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 ...
- 57
0
votes
1
answer
34
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
206
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
40
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 ...
- 17
1
vote
1
answer
614
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
2
answers
539
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
1
answer
128
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
30
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
2
answers
643
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
194
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
0
votes
1
answer
492
views
DE Manager after successful submission, the user remains on the page without redirection
How can I do that? After on external web site user submit the form (_successURL or _errorURL) he doesn't redirected to somewhere and remains on the page
<form action="http://cl.exct.net/...
0
votes
0
answers
806
views
How instantly send email when record enters to Data Extension?
Who can explain in detail how to do so that when a record enters to the Data Extension (from DE Manager form), an email is instantly sent to her? I read this article, tried to set up api events, tried ...
3
votes
1
answer
336
views
How could I find the exact row size of a data extension?
I'm trying to reduce the Data Extensions row size to 8000 bytes as Salesforce recommend but I have problems to know current exact size of a big DE I have.
Is there any way to calculate this? Through ...
- 43
1
vote
1
answer
493
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 ...
- 11
0
votes
1
answer
263
views
UpdateDE with SSJS and Multiple Conditions
I haven't seen any questions or answers that pertain to this exact type of situation, so I am hoping for a little help. I'm trying to update a bit of SSJS that I use to essentially find-and-replace ...
- 27
0
votes
1
answer
389
views
Why "User" Synchronized data extension is sendable ? as it is consuming unnecessary Marking cloud contacts licenses can we make non-sendable?
We observed Leads and Contacts Synchronized Data extensions are sendable ..can we change them from sendable to non-sendable to save marketing cloud contacts licenses ?
Also why User Synchronized DE is ...
- 27
0
votes
2
answers
102
views
Marketing Cloud - How to group DE rows with repeated values
I have a DE (DataExtension) for members, and another for members' children, which are also members but linked to the parent in question.
I would like to be able to group up sends, so I don't ...
0
votes
1
answer
122
views
Rounding a number from a Data Extension that has multiple decimals
I have a personalization field that reads from our data extension to show how many purchases have been made from the previous month. The DE I get with over 28k people doesn't shorten the decimal ...
0
votes
1
answer
91
views
Accessing data from a child business unit using SOAP
I am using the SOAP API using C# via a connected service in VS. I am authenticating using the username + password method, which means I have access to the entire SF account (this is not what I want). ...
- 1
1
vote
2
answers
308
views
Creating a DE with retention using WSProxy (Data Extension Manage Data Retention user permission error)
While trying to create a Data Extension with data retention using WSProxy, I am getting the following error:
The Data Extension Manage Data Retention user permission must be set
in order to use the ...
- 14k
0
votes
2
answers
408
views
Query Error : field "Contact Key" required for targeted DE
Good morning,
I have a Synchronized DE [Contacts_Salesforce_9] and I have to write a query to link it to a Regular DE because I need to put it as an entry data source in a Journey.
However, with the ...
1
vote
0
answers
274
views
How can I append new data rows to an existing data extension with predefined properties and columns?
There is data-extension-row-update and data-extension-row-create, but nothing like
data-extension-row-append.
Say I have an existing data extension I retrieve via
import ET_Client
myClient = ...
- 113
0
votes
1
answer
263
views
What is the difference between the Name and the CustomerKey of a data extension?
I did not understand yet what the difference between the 'Name' - argument in the data extension properties and its attribute 'CustomerKey' is:
props = {'Name': 'Test-Name', 'Description': 'Sends ...
- 113
0
votes
0
answers
299
views
SFMC - Query List ID and Push to Data Extension
We have a "List" under All Subscribers and we want to move all of the contacts in that list to a Data Extension. The reason for this is we want to have those individuals go into a Journey.
...
- 25
0
votes
2
answers
1k
views
Create a DE field that has GUID/NewId as its Default value
I am trying to add a field to existing DEs that has a non-nullable Default value that generates a random ID, similar to what the GUID() and NewId() functions do but within the Email Studio Data ...
- 32
0
votes
0
answers
107
views
Access Data Extensions in SJSS script
In this code:
if (authobj.access_token) {
var del = HTTP.Post(authobj.rest_instance_url+'contacts/v1/contacts/actions/delete?type=listReference', 'application/json', '{"deleteOperationType&...
- 113
0
votes
1
answer
308
views
Is journey builder picking up new contacts added after activation from a data extension?
I create a single send journey and selected as entry source a data extension.
I can see I have 200 contacts then I activate the journey and all those 200 contacts went through it.
However, I added ...
- 205
0
votes
0
answers
330
views
How to send MobilePush data into a data extension?
So I have a client that has been sending MobilePush data using an SDK to "All Contacts" in Contact Builder from their Mobile App.
The question that I have is whether this same MobilePush ...
0
votes
1
answer
218
views
How to merge push and email in a single journey? [closed]
We have a separate journey for wishlist email and another one for push.
We wish to merge these 2 into a single journey.
Say for example the new data extension then has below fields,
ContactKey : ...
- 29
0
votes
1
answer
52
views
Data Loss in File Convert Data Activity Extract
Has anyone experienced a loss of data from "File Convert" Data Extract Activity?
I am exporting a synchronized data extension:
Step 1: Data Extract Activity - Export DE
Step 2: Data Extract ...
1
vote
1
answer
893
views
Looking for Journey Builder Pause Clarification
We have some multi-touch journeys in salesforce marketing cloud journey builder with multiple emails and wait time and decision splits in between.
I have discovered a data issue and my concern is ...
- 173
0
votes
1
answer
333
views
Linking multiple Data Extension attributes to a single Data Extension attributes
Ideally a contact has 2 Program Acronyms assigned, and these connect to another DE with full details about those Program Acronyms.
In other words - In Data Extension #1, a single contact has two ...
1
vote
1
answer
62
views
MC query dedupes records automatically
I've noticed some quite odd behavior from running queries in automation studio.
Below is the query in question:
SELECT C.id
, CM.id
FROM ent.CampignMember_Salesforce CM
JOIN ent.Contact_Salesforce C
...
- 173