Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,545
questions
-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 ...
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 '...
-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)...
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&...
-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?
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 ...
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 ...
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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'
/* ...
-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 ...
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 ...
-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 ...
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
...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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:
...
-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 ...
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 ...
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.
...
-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 ...
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 ...
-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 ...
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) ...
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 ...
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 ...
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,...
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, ...
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 ...
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 ...
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"....
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 ...
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 ...
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;...
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 ...
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
...
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: ...
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 ...
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 (...
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
...
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 ...
-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....