Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,485
questions
0
votes
0
answers
31
views
Marketing Cloud Email Studio Total Email Sent is Less Than Data Extension Created [duplicate]
We created a Salesforce Data Extension that contained 12,855 unique email addresses and SF ID's. Once the email was deployed through Email Studio, the total sent was only to 12,023..6.5% of my list ...
- 1
-2
votes
1
answer
43
views
Contacts without channel addresses deletion
I have extracted the contacts without channel adresses in Marketing Cloud and while trying to delete them (over 2 million), the deletion couldn't be processed as the maximum contact that could be ...
- 5
0
votes
3
answers
40
views
Building an email from JSON Payload that is over 4000 characters (SFMC)
I have been testing using GTL in SFMC to build an email from a JSON payload stored in an email. The reason for this is that there is often multiple products the customer can purchase, and they want to ...
- 3
0
votes
1
answer
56
views
Question around duplicate email in Journey Builder
I have a question around this - I have a filtered data extension with product ID as primary key. The relationship is set to subscriber_key relates to subscribers on subscriber key.
Product ID
...
- 17
0
votes
0
answers
23
views
How to use Salesforce Data Extension to update back into Sales Cloud [duplicate]
we need to update 1 million records on Salesforce CRM from SFMC.
Can you please suggest me any other ways than :
UpdateSingleSalesforceObject
Profile Attributes mapping
Journey Sales Cloud Activity
...
0
votes
1
answer
32
views
All Subscribers attributes vs. DE attributes
When sending to a DE, do All Subs attributes get pulled in by default?
For example, DE and All Subs both have a record with the same Subscriber Key but DE has First Name 'Mike' whereas All Subs has ...
- 19
0
votes
1
answer
32
views
Swapping images out using AMPscript
I'm looking to swap out an image based on the Gender field I'm using in SFMC.
Essentially, I'd like to have a female image as default, then if the field Gender equals male, I'd like to swap them out ...
- 15
-2
votes
0
answers
39
views
Use triggered send DE in a journey entry source [closed]
I have a triggered send DE where Im injecting records via API call and I want them to send a Triggered send real time email, after this email, I would like to impact them with a serie of activities ...
- 97
0
votes
1
answer
32
views
Package manager - Triggered Send Data Extension
I'm wondering how to solve the deployment of a lot of "triggered send data extension" with Deployment manager of Marketing Cloud.
The system show me this warning:
Data Extension Template &...
- 201
-1
votes
0
answers
35
views
Plus Sign Emails not Sending
I am working in Marketing Cloud to send a test email a test Data Extension. The Data Extension I am sending to has records like austin+test@email.com, where the real email address is austin@email.com.
...
0
votes
0
answers
27
views
Is it possible to edit an import activity after it's configured to add a field?
I have an import activity that imports a Salesforce report into a DE in SFMC and I've recently added a field to the report itself as well as edited the target DE to add the same field but when I run ...
- 1
0
votes
1
answer
48
views
Marketing Cloud Query and SSJS Performance
I have to implement a Marketing Cloud Solution that will have millions of records in a single Data Extension (DE). Most DEs will have 20-30 million records with some DEs going over 100 M. I know how ...
- 133
0
votes
0
answers
35
views
Question about inserting specific DE fields via AMPScript
I am working on an email where the DE in question will have anywhere between 3-6 rows associated with each person receiving it. On each of those rows, there is one field with a unique image URL, ...
0
votes
1
answer
52
views
Retrieving all rows a data extension through AMPscript
I've run into an issue where I'm trying to pull all rows from an existing data extension using AMPscript in an email. I've been able to get a single row of the de, but I'm hitting a wall, when trying ...
0
votes
1
answer
70
views
Deleting big amount of records from a large sendable data extension
I have a big sendable data extension (hundreds of millions records) in marketing cloud that has multiple primary keys. The DE is live, and new records are being written constantly.
I need to delete ...
- 3
0
votes
0
answers
47
views
Creating a last modified date for a data extension copy of a data view
Can I have a created date and last modified date as field names in a DE where the last modified date of a record should change when the automation gets new data from the data view for that record?
0
votes
1
answer
33
views
Ampscript condition else/if, how do we show a multiple list condition with 2 same values but different last word?
I have DE lists like this for "Fruits" category:
"Apple", "Apple Ba", "Apple 2", "Apple red", "Apple green", "Apple CA", "...
- 7
0
votes
1
answer
32
views
Can CONCAT & LOOKUP function calls be stored in a data extension
I'm working on a POC to significantly reduce the lines of repetitive and lengthy Ampscript code for folks in my company that build our very complex emails which have tons of dynamic data, multi-...
- 3
0
votes
1
answer
59
views
Merging Data from 4 SFMC Data Sources into 1 DE
I'm trying to merge various fields from our synced data sources in SFMC.
For Account_Salesforce, Contact_Salesforce, and Program_Roster__c_Salesforce, the relationship is the account ID, but they are ...
0
votes
0
answers
38
views
Salesforce Marketing Cloud File Organization
I'm trying to think if there is anything in SFMC where if I start moving things around and folders around, it could break existing automated emails. I inherited a SFMC platform that is chaos. While it ...
- 9
1
vote
0
answers
54
views
Journey Builder Re-Entry Only After Exiting for One Product Only?
I want to send a dynamic email to customers that expressed interest to a product. And I want to accomplish the below:
If a contact shows interest in Product A, he will receive the journey email, then ...
- 15
0
votes
1
answer
55
views
Combining Data from Two Synchronized Data Extensions into One New DE
I've just created two synchronized data extensions in Contact Builder and then discovered that both data extension have fields the other does not have. The first synced DE is Account_Salesforce and ...
1
vote
1
answer
107
views
Junk Characters || SSJS Fire Entry || The Japanese characters show Junk when stored in DataExtension
I am using a simple SSJS code from here.
I have updated the Fire Entry API end point as below.
/*=== SFMC REST API === */
var payload = { "ContactKey": Account_ID,
...
- 1,829
0
votes
1
answer
124
views
API for Data extension update in sfmc salesforce marketing cloud
I need to push some data on daily basis from ERP to SFMC
The package is already created on marketing cloud (read, write on Data extension).
I created a first POST request :
Body :
{
"...
-3
votes
1
answer
35
views
is there an smsMessageTracking to capture email information?
good afternoon team!
I'm building dataviews to get shipping information through automation for a DE
I managed to create the smsMessageTracking but I would like a model that does the same but to ...
0
votes
0
answers
16
views
Retrieve more than 2500 records in ssjs [duplicate]
in ssjs data extensions how do I retrieve more than 2500 records?
-1
votes
1
answer
39
views
Marketing Cloud - Select MAX value from multiple columns [closed]
for each row I need to select highest value from 3 columns, somethings like below. However, for some reason I can't do this. Please help.
SELECT
SubscriberKey,
MAX(VALUE(Clicks_Syria),
VALUE(...
- 1
0
votes
1
answer
40
views
For loop in ssjs not working
why this code is not working?
<script runat="server" language="JavaScript">
Platform.Load("Core", "1");
var couponsDE = DataExtension.Init("...
0
votes
2
answers
66
views
Data Extension Default Value Length
appears to be 100 characters, is there a way either through Admin/Setup or Support to increase that?
- 19
1
vote
1
answer
74
views
Update a Data Extension via SOAP API
I'm having a hard time finding sample code that will allow me to update a record on a DE. I was able to successfully add new records with 3 fields: email (primary key), fname, lname. However, when I ...
- 11
0
votes
1
answer
88
views
AMPscript InsertDE is inserting an empty row
I have a code on client-side that is using JavaScript to create an object called "data" that contains several variables such as "matricula", "scheduled", "...
- 15
0
votes
0
answers
52
views
Salesforce Data Loader for SFMC to import a CSV file
I came across something called salesforce data loader - https://marcloudconsulting.com/sf-basics/salesforce-data-loader. But I cannout find this in AppExchnage. I had a few questions-
Have anyone of ...
0
votes
2
answers
123
views
When someone submits the Cloud page form sending OTP. when subscriber submits OTP displaying success or failure message
I have created a cloud page with fields like firstname, email, and one field as OTP.
If someone submits the form I am storing all data in a data extension and creating a 4-digit random number using a ...
- 1
0
votes
1
answer
37
views
ELSEIF Statements not being evaluated
I am having issue with the script below.
I have a DE that includes a column "Days Since Last Login". I want specific language to display based upon what the numeric value is in that column ...
- 1
0
votes
0
answers
47
views
Best practices around fixed data extensions versus constantly adding fields using in the data / contact model
In terms of performance (data optimization and segmenting data using queries) - what kind of data extension schema is recommended in SFMC (or considered as best practice)?
Tall tables with more ...
- 169
0
votes
1
answer
26
views
Marketing Cloud - combine results from 3 tables
I need to combine results from three different Data Extensions that contains the same set of columns. For each SubscriberKey I'd like to see the Clicks_[Country] and Rating_[Country] even if they have ...
- 1
0
votes
2
answers
59
views
Marketing Cloud - Create a Data Extension by filtering out Subscribers
big Marketing Cloud Noob here!
I have inherited the admin Role in the Company in Marketing Cloud and I cannot make ends meet.
My Company regularly sends emails to their subscribers and professionals ...
0
votes
0
answers
67
views
Marketing Cloud Contact Clean Up - SQL / Script - How to test # of contacts without deleting?
We are trying to cleanup our contacts in Marketing Cloud. I have created Data Extensions for capture the contacts below:
Contacts to Delete (capture subscribers in our database for 30 days and have ...
- 1
0
votes
0
answers
72
views
How to clear records of Shared Data Extension using WSproxy
I am using the below script for a particular testing scenario to clear ALL [x] or a specific [y]
Data extension. However, I am unable to use this script to CLEAR records of Shared Data extension :(
I ...
- 1,829
0
votes
0
answers
49
views
Which Data Extensions to use?
I'm new to Marketing Cloud and want to understand the difference between Salesforce Data, Salesforce Campaign, and Synchronized Data Sources.
I want to build a process when a Lead is created and joins ...
0
votes
1
answer
62
views
Why do I get the same results in all fields?
I have a SQL query that needs to count the sent, Opened, Clicked and Bounced of a certain emails. I try to join this with our sendlog because there is all the additional information (the X1, X2, X3, ...
- 117
0
votes
0
answers
43
views
How to use wait by attribute when having multiple keys in journey builder
We are having hard time figuring out to solve this issue regarding journey builder and using wait by attribute with multiple primary keys. What we would like to achieve:
A sendble DE has 2 primary ...
- 173
0
votes
1
answer
49
views
Consequences for changing field name in data extension that is referenced by a SQL query?
I have a data extension that is being updated with a SQL query.
The data extension is already populated with data and I would like to change the field name for one of the fields.
I have already tested ...
- 137
0
votes
1
answer
84
views
Profile attributes relationship with Data Extensions
Recently i've working with the profile attributes. But i created 2 new Attributes but somehow a trigger process we have start having issues. The Data extension we have contains the same field as the ...
- 1
0
votes
0
answers
26
views
SFMC SOAP API - Handling Rate Limiting - 500 Response
I am currently extracting all records from a DE that has close to 1 million subscribers in it. About half-way through I run into a 500 response after dozens of successful 200's. I believe it's due to ...
- 11
0
votes
1
answer
88
views
Using MC Data Extension to update HTML on Landing Page [closed]
Is it possible to pass HTML code through a Data Extension value to set the HTML for an AmpScript Landing Page?
- 1
1
vote
0
answers
39
views
Data Migration in BUs [closed]
I am trying to move all data (sendable /non sendable)related to particular market from existing BU to new BU created.I have already moved the structure using Package Manager.
How the data can be moved?...
- 11
0
votes
0
answers
41
views
How do I put a DATE type value in a String field in a Marketing Cloud data extension
I'm trying to do this sql query, but I'm getting an error when converting the type date to string.... I've tried using CAST/ CONVERT/ TRYCAST .. but I must be doing something around because Marketing ...
0
votes
0
answers
70
views
Journey Builder Salesforce data entry with upsert setting in the DE?
We have a journey using Salesforce data entry source with the contact entry setting is Re-entry anytime and Entry criteria is is updated, we are using Case object.
We want to leverage this journey DE ...
- 1,266
0
votes
1
answer
118
views
UpsertDE function not working on Shared Data Extension using SSJS from child BU even though used ENT
I want to use UpsertDE function on Shared Data Extension using SSJS from child BU. Even I tried ENT. before DE name, I have received 500 error in cloud page and script activity is getting errored in ...
- 3