Questions tagged [dataextensions]

ExactTarget - A data extension is a table within the application database that contains your data.

Filter by
Sorted by
Tagged with
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 ...
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 ...
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 ...
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-...
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 ...
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 ...
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, ...
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(...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...

1
2 3 4 5
30