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
23 views

Not create Task activity

I've created a journey with a data extension as its entry source. I'm creating Task Activities which look like this: Task > Create New > Assigned to ID, Subject, Status, Priority, and ...
Ritesh Singh's user avatar
0 votes
1 answer
44 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
-1 votes
0 answers
28 views

How to search for a subscriber key or email in all data extensions?

we use data extension as list to send out mailings via journey builder. So we have multiple data extensions with datas from our subscribers, like subscriber key (this is the contact ID from salescloud)...
Ette's user avatar
  • 1
0 votes
1 answer
37 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
-1 votes
0 answers
52 views

Remove the default value for a date field

I Created a data extension with a field with Date as data type. I set a default date for that field. Now I want to remove the default value. How to do that?
Sowmya Balajee's user avatar
2 votes
1 answer
109 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
76 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
91 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
  • 317
-1 votes
1 answer
48 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
53 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
81 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
46 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
48 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
45 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
61 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
36 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
33 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
40 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
0 votes
1 answer
36 views

Decision Split (or something else) for an AB Test in Journey Builder? Trying to find a solution

We have a project where customers are going to be purchasing products, but all products are unique. We have a certain list of products that we are going to provide an additional video within the ...
Katie Spitz's user avatar
0 votes
1 answer
46 views

Any suggestions on better or optimized approach that returns single row from multiple rows based on ROW_NUMBER in SFMC

I have a customer data extension where customer records are saved with order numbers like this: CustomerOrderDE: CustomerID OrderID OrderTotal 1 101 $100 1 102 $200 2 103 $50 3 104 $75 3 105 $60 ...
kl2's user avatar
  • 317
0 votes
0 answers
58 views

Issue with adding / updating a record into a data extension via cloud page

I am trying to add / update a test record in a data extension from a cloud page but I keep getting 500 - Internal server error I have looked at the online resources and some answers here as well ...
kl2's user avatar
  • 317
0 votes
0 answers
32 views

Marketing Cloud Journey not triggering when resyncing contacts from Salesforce (after Contact Deletion)

Background: Due to the contractual contact limit, contacts in Marketing Cloud are being deleted by the "Contact Deletion by Contact Key" API from Salesforce. A checkbox field on the contact ...
Manass Greedharry's user avatar
0 votes
0 answers
36 views

Data Extract and Fie Transfer Activity failing sometimes in Automation Studio due to an hour change

We are running two automations each automation is with 2 Data Extract activities followed by a File Transfer activity in Marketing Cloud Automation Studio. These two automations are running ...
JNC's user avatar
  • 39
0 votes
0 answers
41 views

After inserting record's into SFMC Data extension, I see some unwanted texts are inserted along with normal text

I have inserted record's into DE. But after insertion, I can see some unwanted texts are also insered into the fields. Expected: question (field) How are you I&I ? (Records) uploaded records: ...
SFMC Developer's user avatar
-1 votes
1 answer
64 views

case : check if field A exist in field B

i have a data extension with the first 3 fields : Id, Email_source1 and Email_source2. i want to create the field named X. The goal is to check if Email_source1 is in Email_source2. Does someone know ...
ayakuza91's user avatar
1 vote
0 answers
24 views

define "control policy" when creating a DE via API ("allow users to delete Data Extension")

Does anyone know if there is a way to define the "Manage control policy" fields for a data extension when creating it through SOAP API / WSProxy? I want to create Data Extensions that ...
Jonas Lamberty's user avatar
0 votes
1 answer
97 views

Can I use 2 data extensions in 1 multi-step journey builder?

I am creating a multi-step journey builder. The entry point is configured as an API event. The API event will be triggered once a week. The journey contains 2 emails. ...
T01's user avatar
  • 9
-1 votes
1 answer
80 views

Using a Salesforce Data Extension as an entry source in Journey Builder

I have a Salesforce Data Extension in Marketing Cloud that is filtering through people with a specific name. When I add someone with that name to my list they get picked up by that data extension. How ...
dw90's user avatar
  • 1
0 votes
1 answer
89 views

Journey Builder - use contact data from data extension as journey entry source in decision split

i have a DE that is a join result of two synchronized objects (campaign and campaignmembers ). it gets updated every 3 hours by a sql query that appends new records to target DE called master_DE. SQL ...
sam sfmc's user avatar
-1 votes
1 answer
67 views

Data Extension - Combine records with same value

I need to combine rows with the same CONTACTKEY and instead of having two with different "Topic" value, it should have Topic set as "Both". In the Data Extension both Email and ...
MrSkover's user avatar
0 votes
0 answers
36 views

Why would _sent dataview table have subsciberIDs not in the subsciber table?

I'm working on SFMC, been struggling to join subscriber table and sent table on subscriberID, I also tried subsciberkey. It turns out all entries in sent dataview have subscriberID (and subscriberkey) ...
Hernan's user avatar
  • 1
0 votes
0 answers
153 views

Journey builder issue with Contact Data

There is an issue with my Journey in Marketing Cloud instance. There are 2 actions: we send SMS messages via that journey and log the answers to these SMS in Salesforce in 24h. The journey runs once ...
Slavik Kharkovskiy's user avatar
1 vote
2 answers
233 views

How do we update subscribers email address in all subscribers list when contact change their email?

Contact located in Salesforce Service is added with "[email protected]" mail. Salesforce Service is connected to Marketing Cloud. Note: Subscriber Key is Salesforce Contact ID. Subscriber related ...
cameron harwood's user avatar
0 votes
0 answers
31 views

Filtered DE Bug in Journey Builder

We used a filtered DE as an entry source in Journey Builder. The filtered DE filtered 93,733 contacts. After the journey activation and the scheduled start, you can see in the screenshot there are 11,...
Juraj Reško's user avatar
0 votes
0 answers
23 views

REST - Journey with DE as trigger

In my app i have a api call which creates a new dataextension through the soap API. When that is done I want to create a new journey with that DE as a starting source. I'm able to create the journey, ...
Kriss's user avatar
  • 1
1 vote
1 answer
92 views

Marketing Cloud Rest/Soap API Upsert into multiple Data Extensions

I know that Rest & Soap API can be used to import data into Marketing Cloud from an external system, but does any of them offer the possibility to import into multiple Data Extensions from a ...
Alex's user avatar
  • 158
0 votes
1 answer
145 views

SFMC - How to update custom object record data after it entered on journey?

I have a custom object record that is entering in a journey when created. I have a decision split to check if it's status (custom field) changed to value x (when it entered it had value y). I noticed ...
Lucas Tomé's user avatar
0 votes
2 answers
228 views

Not sent (data extract) vs bounce data view

For a specific email name, a subkey did not receive the email. I started to investigate and i saw that the subkey was in the not sent table (data extract) => field Reason equals to "Held"....
ayakuza91's user avatar
0 votes
1 answer
81 views

Is there any reason to sync Individual Email Results from Salesforce back into Marketing Cloud via Connector?

I recently joined a company as an SF/MC admin. We have Sales Cloud and Marketing Cloud and are using Marketing Cloud Connector to sync many objects (20+) over to Marketing Cloud. One of the objects ...
DBlaney's user avatar
  • 23
0 votes
0 answers
46 views

Data Views repository internally

I'm trying to build an automation that runs daily to get the data from the data views email related and store them internally so I can query for more than 6 months easily when needed. I have created ...
Duicug's user avatar
  • 457
0 votes
0 answers
21 views

Changing journey builder data extension field name

I use a custom preference center so I have to have contact id = id for the field name. However, when using Salesforce Data entry it is pulling in the object name and id for example: Appoint;...
Avril's user avatar
  • 39
0 votes
1 answer
172 views

Integrate Google Analytics with SFMC

I would like to receive data from Google Analytics in Salesforce Marketing Cloud, I know that with the integration I can receive data to create Audiences to use in Journey Builder, but what I really ...
Rutx1's user avatar
  • 109
0 votes
0 answers
38 views

SQL help to run Automation

I'm trying to add three new fields from RT_Salesforce DE to the existing data extension (CustomerRet) that I have running SQL through automation studio so that it runs every hour. The following code ...
James Kim's user avatar
0 votes
0 answers
152 views

What is an alternative option to Audience Builder in Salesforce Marketing Cloud?

Our goal is to allow users within SFMC platform to be able to create audience / segmentation with drag and drop options (even if users are non-technical and got no experience with SQL). Current state: ...
kl2's user avatar
  • 317
0 votes
0 answers
27 views

Multiple journeys on same data

here's what I'm trying to do : we have users that triggers multiple events (ie : subscription, login, add_to_cart...) I'd like to have multiple journeys based on what the user does. when they ...
Mike W's user avatar
  • 1
0 votes
1 answer
159 views

How to populate attribute value in a data extension source to a Mobile Push custom key?

I am using a data extension as a data source for a Mobile Push Inbox message type. In order to filter and categorize the subscribers, the app side would need to receive the value stored in a field (...
Duc Le's user avatar
  • 2,603
0 votes
0 answers
32 views

Problem fetching data extensions from child business units using server to server token via SOAP API

I am currently working on a solution where I can read/write to data extensions in the following folders using a user access token. Data Extensions Shared Data Extensions Salesforce Data Extensions ...
Kimkykie's user avatar
0 votes
1 answer
138 views

Retrieve value from a data extension based on the picklist value from a SmartCapture

I have created a smartcapture form in a cluoudpage which includes a picklist field that contains a set of values (e.g. product names). From the moment the user submits the form, I need to store in the ...
fromero's user avatar
  • 1,039
-1 votes
1 answer
64 views

External landing page for newsletter sign-up - how would I send a confirmation email using API event?

I have been creating an external landing page (not on Salesforce) with a form to let contact sign-up to a newsletter service. The form of this landing page will be connected to a DE in Marketing Cloud....
manuela ferrari's user avatar

1
2 3 4 5
31