Questions tagged [dataextensions]

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

Filter by
Sorted by
Tagged with
-1 votes
0 answers
7 views

Master Subscribers Data Field

I have a master subscriber in that we have three fields and we do have sub master subscribers for different BU's. So the three field data that is there in master subscribers is not pulling in the sub-...
Manish Kumar Singh's user avatar
0 votes
0 answers
36 views

Salesforce endpoint not retrieving all data of the data extension

I am using the undocumented endpoint: "https://{subdomain}.rest.marketingcloudapis.com/data/v1/customobjectdata/key/{data_extension_id}/rowset" to extract data from my data extensions on ...
Margarida Fernandez's user avatar
-1 votes
0 answers
21 views

How can we link DE data that store website submissions to a user in Marketing Cloud personalisation?

Is it possible to link a DE's data that contains website submissions to Marketing Cloud personalisation user? For example if we store the data in the De can that be linked to the personalization user? ...
Shreya Kaul's user avatar
0 votes
1 answer
48 views

Keep track of record edits in Salesforce Marketing Cloud

Is there a way to keep tracking of what gets edited and from who in a Data Extension on Marketing Cloud? Audit Trail doesn’t track such thing and even salesforce support isn’t able to provide such ...
robruf's user avatar
  • 362
-1 votes
0 answers
9 views

Imported Data Extension is not Syncing with Individual Email Results on SES Digital Platform

I enabled the "individual email results" feature in SES Digital Platform, and we've been using it to check if people clicked specific parts of some emails. We normally use sync'd DE or SQL-...
Alejandro Pérez Morales's user avatar
0 votes
1 answer
128 views

Summer '24: Data Extension Field Limits for "sendable fields". What is a "sendable field"?

Just read this in the release notes: https://help.salesforce.com/s/articleView?id=sf.mc_rn_2024_spring_cab_de_restriction.htm&type=5. All it says is: To improve performance when using sendable ...
Ben's user avatar
  • 892
0 votes
2 answers
44 views

Is there any downsides to using the `User_Salesforce` synchronizer in Marketing Cloud?

From my understanding in order to sync data related to a contact in using Marketing Cloud Connect, the User_Salesforce synchronizer must be added however what if Contact_Salesforce is also used? I ...
Patrick Nomad's user avatar
0 votes
1 answer
36 views

Ovewrite a data extension field in the send log

I am trying to overwrite the data that comes into the send-log from a Data Extension field on an email send. I've researched UpdateDE but I'm not trying to permanently alter the data extension. I'm ...
Jason G's user avatar
0 votes
1 answer
36 views

Updating data extension with ampscript: Invalid object property name. Object Type: System.String Property Name: Id

I have a cloud page with form where I collect some data into DE. I have to use automation to update Contact id if same email exists in SF if not I have to create contact and populate the DE. I have ...
cameron harwood's user avatar
0 votes
2 answers
71 views

Duplicate contacts with Marketing Cloud Connect (Account and Contact)

Situation: Our billable contact count is about double the count shown on each of the Account/Contact synchronized salesforce data sources. Setup: We used Account_Salesforce to create a data extension ...
Patrick Nomad's user avatar
0 votes
1 answer
59 views

Trying to convert a Data Extract file from UTF-16 to UTF-8

I'm trying to send Data Extracts to our SFTP in the UTF-8 format and I keep getting an error. I created two data extract steps. First one Extract Type: Data Extension Extract File Naming Pattern: ...
Erik B's user avatar
  • 65
0 votes
1 answer
68 views

How to unsubscribe in all subscribers from a data extension using SSJS script activity

Hello I was trying this idea from this Question. But I can't seem to make his initial idea work. Can you guys help me with this? What I am trying to do is from a data extension, i need to unsubscribe ...
Ralph J's user avatar
0 votes
0 answers
38 views

All fuelsdk archives archived, any alternate way to query/load data extensions in Python?

About a week ago, all the FuelSDK archives were archived (under https://github.com/salesforce-marketingcloud). Question: Does anyone know of a forthcoming replacement? And is there an expectation the ...
Levin Magruder's user avatar
0 votes
1 answer
61 views

Massively delete contacts from +1000 data extensions

I'm cleaning our Marketing Cloud instance and I have a folder containing more than 1.450 data extensions I'd like to delete. I need to delete both contacts and the data extensions. I was wondering if ...
Blanca Escalera's user avatar
-1 votes
1 answer
40 views

Automation data into data extention

I found a script for retrieving automation data on https://www.ssjsdocs.xyz/automation-studio/automations/retrieve/all.html. I still learning SSJS and can't figure out how to store this kind of ...
Martijn e's user avatar
  • 143
0 votes
0 answers
37 views

Applying communication rules and limits for journeys across multipele Businss Units (in Salesforce Marketing Cloud)

i have a question and not sure if there is a straighforward solution. We have identical customer lists in multiple business units (one for each brand). We want to set communication rules and limits to ...
sisorayi01's user avatar
0 votes
0 answers
32 views

Location of Shared Salesforce Data Extensions folder

I have two business units. We want the results of this journey to populate back to SF so I’m moving the Data Extension being used to the Salesforce Data Extensions folder. However, the automation ...
JohnDillenger's user avatar
0 votes
0 answers
25 views

Splitting Data String in Data Extension into Separate Columns Based on Delimiter

I have a data extension that contains the "Link Content" data from querying the _click data view. It returns rows of data with the url + the parameters we have in place. After the url, there ...
SFMCInTraining's user avatar
1 vote
1 answer
49 views

Log Unsub Event for Job and Not Unsubscribe from All Subscribers

Right now we send to multiple brands in a single business unit. We also use data extensions for all sending. I am looking to concept a way to log an unsubscribe event to a send job for reporting ...
Tazzy1234's user avatar
0 votes
1 answer
36 views

Add/Increment a value to the target data extension field of a query activity in Marketing Cloud

I have a Data Extension with daily sendLogs and I want to get the client_id with the EmailID=XXXX and ActivityId = XXXXXXXXX and add 1 to the field N_Ciclos of "Contadores" DE (target DE). I ...
Raas's user avatar
  • 15
2 votes
1 answer
161 views

Using SSJS to retrieve info about IsNullable for Data Extension fields

I need to copy a Data Extension using SSJS and I believe I can do everything I need to do except understanding if I need to set the fields nullable or not. I use this code to retrieve the info I need ...
Felix Sanchez's user avatar
0 votes
1 answer
60 views

Journey Builder - Automation Schedule and Entry Criteria

I have a very simple journey setup to send an initial welcome email. I am using a multi-step journey in order to utilize the no re-entry criteria, so that new subscribers will not requalify for the ...
Tazzy1234's user avatar
0 votes
0 answers
36 views

The insertdata does not prevent the error 500 primary key constraint

I have come across a scenario in the landing page, where insertdata helps in the addition of the data from cloud page in the intended data extension. But if I refresh the same landing page, I get ...
Sfmc user's user avatar
0 votes
1 answer
65 views

SSJS - Delete Row in DE based on another DE with flag

New to SSJS but based on what I've read, it looks like this could be possible. I am trying to write a script that will delete a row in a 'Secondary_DE' based on a defined 'Deleted' flag in a '...
BeezB2020's user avatar
0 votes
0 answers
44 views

Getting Invalid data extension reference. While using first name personalization token

I've used email studio to develop emails but have never had to really use AMPScript or personalization tokens. I am trying to create an email that uses a first name token but when trying to send a ...
rnkwill's user avatar
  • 15
0 votes
1 answer
72 views

How do I print the value of a specific number of records in a loop / ampscript

In a data extension if I count the value using a loop then how can I print a specific number of records? As an example - if I have 10 records in my data extension and they all are showing using a loop ...
Monowar Hossain's user avatar
0 votes
1 answer
47 views

Having issue to limit loop for data extension records

I am currently fetching data from a data extension using AMPscript where I have multiple records for a single user. So some users may 3 records and some may 8 records. Using the below code it shows ...
Monowar Hossain's user avatar
0 votes
1 answer
44 views

Error CloudPage

There is a problem with my code that is not answered by the individual. If you implement this AMPSCRIPT if you access CloudPage, you will be able to dynamically activate the number you need to find ...
Mary 's user avatar
-1 votes
1 answer
45 views

Uploading 200 pdf into MC and needing the link in a data extension [closed]

I need to upload over 200 pdfs into MC every quarter. After that I need each pdf link to be inserted into a data extension. I've been doing this by hand but is there any way to get the link into the ...
Keria Shadow's user avatar
0 votes
1 answer
66 views

Adding new DE to a new journey version

I have a journey running with a particular DE. I want to make changes to the DE and launch a new version, so it limits the records to certain criteria, so only these users to enter the new version of ...
ssisi's user avatar
  • 1
0 votes
0 answers
33 views

Send only a single email for multiple records with similar email address in salesforce marketing cloud [duplicate]

I have a data extension like below. Now when sending emails to the list it sends multiple emails to a single subscriber based on the record. As an example as - [email protected] is two times in the ...
Monowar Hossain's user avatar
1 vote
2 answers
170 views

How can I send a single email if found multiple records with same email address

I have a data extension like below. Now when sending emails to the list it sends multiple emails to a single subscriber based on the record. As an example as - [email protected] is two times in the ...
Monowar Hossain's user avatar
0 votes
0 answers
62 views

Journey Builder vs. Normal Send - Synchronized DE

I just setup Marketing Cloud Connect and am querying data from a parent account to a child BU using shared data extensions/query activities. In this instance, I am also pulling in newsletter ...
Tazzy1234's user avatar
0 votes
0 answers
25 views

Marketing Cloud : Row Fields from data extension into a single email

Some background - we have list of job vacancies that needs to go out as a part of Newsletter every fortnight. Through SQL - I was able to pull all the live vacancies from service cloud in a single ...
Sonika Jain's user avatar
0 votes
1 answer
76 views

Import File Activity Automation - Change field data type to match Data Extension

I am setting up a File Import automation to ingest a file from the Marketing Cloud FTP to a Data Extension. I am running into an issue where the csv has a field for a newsletter preference say '...
Tazzy1234's user avatar
0 votes
1 answer
54 views

Exclusion script in Marketing Cloud is getting an error

I'm trying to use multiple exclusion scripts in an email activity of a Journey and get this error: I've double checked the name of my email fields in my data extensions and they are all "Email&...
DBlaney's user avatar
  • 23
2 votes
1 answer
115 views

Removing 1 billion rows of a DE

As the title suggests, I need to figure out how I can remove ~1 billion rows of a Send Log data extension. I can't even change the data retention policy until the count is < 100 million. I thought ...
PForsyth's user avatar
0 votes
1 answer
144 views

SFMC: Is there any way to update data in Data Extension without defined primary key through SOAP or REST API?

Is there any way to update row in Data Extension without defined primary key through SOAP or REST API? I have a situation where I need to write some data in a SFMC DEs that will later be processed by ...
mradovcic's user avatar
0 votes
2 answers
134 views

Is there any way to generate a subscriberkey in combination of email and something else?

Current State: Subscribers from one of the child business units (let's call it - ChildBU_ABC) needs to be separated and we need an easy way to distinguish subscribers from this child business (so ...
kl2's user avatar
  • 325
-1 votes
1 answer
54 views

How to check JobStatus for scheduled sends with Salesforce Data Extensions

When scheduling the email with normal data extension, we will be able to see the status of email whether it's paused or scheduled. However, we can't see/check the status of email scheduled with ...
TP0505's user avatar
  • 1
0 votes
0 answers
105 views

How to use the "Update Contact" function to insert new records into another DE?

I would like to know how a contact can be introduced inside a new Data Extension after completing a Journey, without the need of having the subscriber key already inside that new Data Extension, and ...
Ferdemat's user avatar
4 votes
1 answer
86 views

URL formatting is broken in Marketing Cloud Data Extensions

We have noticed that since the latest release (08/10/2023) that Marketing Cloud has reformatted all URLs present in data extensions. Formerly, they worked - we often use links in data extensions to ...
TCassa's user avatar
  • 866
0 votes
0 answers
84 views

Salesforce Marketng Cloud Personalization - UserETL (Feed Dashboard)

I am attempting to import users into MCP using automation. Upon activation, it takes the file for processing, and approximately 1000 records are encountering an error with the message 'Value must be ...
Kritika Sharma's user avatar
0 votes
0 answers
29 views

I have a cloudpage and using InsertDE function, however it seems that it only working at one submission [duplicate]

I have a cloudpage and using InsertDE function, however it seems that it only working at first submission For example: Scenario 1: I fill up the form using a new data extension without data and then ...
Rain's user avatar
  • 1
0 votes
1 answer
75 views

I cannot insert to specific Data Extension Amp script

I have a cloudpage that is having a form and when I click submit it should have my details saved on the data extension and proceed to the confirmation page set @prospectsDE = 'Prospects' /* ...
Rain's user avatar
  • 1
-1 votes
1 answer
80 views

populate data extension with api response based on values in another data extension

we are intending on sending out an email which contains a section with information about events near the customers location/region/city. For this we are using an api from a third party website. i ...
sam sfmc's user avatar
0 votes
1 answer
107 views

Getting data extension eventDefinitionKey and Id

I'm creating a journey through the journey REST API. I want to add a data extension to that journey. To add a specific data extension, as far as I can see, I need the data extensions ...
Thor Christensen's user avatar
-1 votes
1 answer
39 views

Connected Marketing cloud connect and record got synced in 2 mins instead of 15 mins

I connected marketing cloud connect and created and synced a lead record from salesforce to marketing cloud. I chose the poll schedule as 15 mins but I checked and after 2 minutes the record was ...
DS0308's user avatar
  • 1
0 votes
1 answer
38 views

Can I send an email to one person with several row of DE in SFMC?

For example, I have a DE with some rows. And it looks like this customer_name email col1 col2 col3 abc [email protected] 1 2 3 abc [email protected] 2 5 2 abc [email protected] 3 3 4 abc [email protected] 1 4 5 ...
cown's user avatar
  • 1
0 votes
1 answer
44 views

I want to sync only those data whose first names are 'Lily' from sales/service cloud to synchronized DE in marketing cloud. Is that possible?

I want to sync only those data whose first names are 'Lily' from sales/service cloud to synchronized DE in marketing cloud. Is that possible? Basically can a filter firstName = 'Lily' be applied to ...
DS0308's user avatar
  • 1

1
2 3 4 5
32