Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,512
questions
0
votes
0
answers
16
views
Salesforce Marketing Cloud - Email with Voucher Code
We have a cloud page with 4 different vendor name fields and separate voucher DEs for each vendor. If a user selects Vendor1, then he will receive an email with a voucher code from Vender1 voucher DE, ...
- 1
0
votes
0
answers
11
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 (...
- 1,810
2
votes
2
answers
166
views
Multiple voucher codes on 1 DE
I have 1 data extension, with 4 sets of unique voucher codes. Each set has 5k vouchers (so 20k all together), and there is a voucher code type next to each unique code. e.g. 10% off, 20% off, 30% off ...
- 1
0
votes
1
answer
952
views
How to retrieve a record from a data extension field in SFMC using SSJS
In my SSJS, I am using this approach to retrieve the value / record from a data extension field.
Data extension name is Test_QResult
Data extension field name from where i want to retrieve value is ...
CommunityBot
- 1
0
votes
0
answers
25
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
...
- 1
0
votes
1
answer
48
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,810
-1
votes
0
answers
12
views
SQL using ENT.Contact_Salesforce_1 - want to add Contact Created Date
I have a SFMC query that uses Salesforce contact data. ENT.Contact_Salesforce_1
I want to bring contact created date and created by. Is this possible?
-1
votes
1
answer
39
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....
2
votes
1
answer
848
views
How to dedupe contacts in email sends when using Journey Builder
I'm setting up a customer journey where an email is being sent to some of our new customers. When manually sending an email, there's a 'deduplicate subscribers' checkbox you can click. This checkbox ...
CommunityBot
- 1
0
votes
2
answers
5k
views
whats the difference between Audience Builder Vs Filtered data extension?
On going through documentation, it seems that what is been done through Audience Builder can also be done through Filtered Data Extensions. Kindly clarify use cases where Audience Builder is used vs ...
CommunityBot
- 1
0
votes
2
answers
983
views
Contact Deletion
How could i proceed in order to delete all Contacts with Contact Deletion (about 17 million contacts)?
Using random data extensions I would have limits related to the number of data extensions.
Do you ...
CommunityBot
- 1
1
vote
1
answer
911
views
Looking for Journey Builder Pause Clarification
We have some multi-touch journeys in salesforce marketing cloud journey builder with multiple emails and wait time and decision splits in between.
I have discovered a data issue and my concern is ...
CommunityBot
- 1
1
vote
0
answers
46
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?...
- 29.6k
0
votes
0
answers
28
views
SFMC import failure
I have a file drop import automation that has recently started throwing a "Data Extension not found" error, but the import worked fine before and since. The automation has run successfully ...
- 19
0
votes
0
answers
27
views
Send data from Webikeo to a Data Extension in Marketing Cloud (API)
I red the documentation (https://segment.com/docs/connections/destinations/catalog/actions-salesforce-marketing-cloud/) and it seems that I have to create an API package directly in Marketing Cloud. I ...
0
votes
1
answer
47
views
Fixing email address discrepancies between Salesforce and All Subscribers
I'm looking to do this automatically using SQL, data extract and import activities in an automation that runs hourly.
My query looks like this:
SELECT
C.Id as SubscriberKey,
C.Email as ...
0
votes
0
answers
25
views
I want to change the status of subscriber from active to held, Is It posible? [duplicate]
A partener make a change in the subscribers status from held to unsubcribe and from unsuscribe to active with ssjs.
Now i need to change the active to held, is possible?
- 19.5k
0
votes
2
answers
47
views
Ampscript condition else/if to show the default link and conditional issue
I have DE lists like this for "Fruits" category:
"Apple", "Apple A", "Apple 2", "Apple red", "Apple green", "Apple CA", "...
0
votes
1
answer
36
views
Unable to update a second column value in data extension using wsproxy
I want to pull a data extension DE1 where it has two columns I used wsproxy to copy these column values to another data extension where one of the two column is encrypted and another column needs to ...
- 51
0
votes
1
answer
35
views
Update Data Extension Record Using API Event Entry
I have a data extension that gets added to via the API Entry Event with 3 fields: email, subscriberkey and Status.
'Email' is the only primary key on the data extension.
Adding new records to the data ...
- 1,810
0
votes
1
answer
790
views
Rendering Image using data in my Data Extension
I have a Data Extension in which I have the path a different path for each image in the row. I am trying to pull this data in my email using an image block. How can I do it?
Should I be using image ...
CommunityBot
- 1
0
votes
0
answers
24
views
Using Data from different 2 data extension
I have 2 different DE lists like this:
First DE have information with FruitsType and FruitsExpirationDate
Second DE have information for the links
I'm wondering if we can use different DE to get those ...
- 7
0
votes
0
answers
35
views
Authorize special caracters in data extension from a cloud page formular response
I created a cloud page, a landing page with a smart capture and a data extension so as to collect all the answers from the formular.
I saw that i had some response with special caracters.
Does someone ...
0
votes
0
answers
54
views
Writing 100k deletes SSJS in DE and applied filter to column SCD_FLG and value D. Below code got failed in automation. Any leads will be appreciated
<script runat="server">
Platform.Load("core", "1.1.1");
var config = {
name: "91D16891-FEEC-4C5C-A6E9-729D7E612B5A",
cols: ["OFFER_DK"]...
- 1,851
2
votes
2
answers
1k
views
Two Email Fields in Data Extension?
I have Data Extension where for some reason there are two emails (Email1 data type is text, Email2 data type is EmailAddress, DE imported from salesforce report, whereas in the salesforce both the ...
0
votes
1
answer
40
views
Using ampscript check if value exists in data extension
I have a customer_data_extension that consists of customers with their customer_id.
I'm creating an email with conditional content, so IF customer exists in customer_data_extension then show this ...
- 14k
0
votes
1
answer
46
views
ampscript lookup to pull in all rows of data
I am trying to use the LookUpRows function to display specific attributes associated with the 2 members in my Data Extension.
The attributes are MEMBER_NAME, MEMBER_NUMBER, CUSTOMER_TYPE & ...
- 14k
0
votes
1
answer
796
views
Add ReCaptcha to SmartCapture Form in Cloud Pages
We are trying to implement Google Recaptcha v2 into our Smart Capture form within a Cloud Page. Here's what we've done so far:
Created a Data Extension
Created Cloud Pages Collection
Added Cloud ...
CommunityBot
- 1
0
votes
0
answers
28
views
Adding new fields to DE stuck on 'saving fields'
I have a Salesforce DE that is being used as source DE for many filtered DEs. Now if i want to add new fields to the source DE, the interface will just stuck on this 'Saving Fields' screen.
i've ...
4
votes
2
answers
758
views
SFMC: Query Based Data Extension Help
We have a synchronized data extension from Sales Cloud coming into our SFMC instance. In the Opportunities table, it is possible for a single customer to have multiple Opportunities in various stages, ...
CommunityBot
- 1
-3
votes
1
answer
32
views
SFMC Overwrite target data extension
I want to use query studio activity to write a query between two tables using a join. So lets say there is table1 and table2. I want to delete the data in table2 based on all the data in table1. So if ...
- 789
0
votes
1
answer
11k
views
Using Automation Studio to Export a Data Extension
I am working with a client to try to create an automated subscriber list export process.
Is there a way use Exact Target's Automation Studio to export data from a Data Extension to either FTP or sent ...
0
votes
1
answer
31
views
Why is my query counting an open for a send
I have the following query:
SELECT
sl.randomAB,
sl.JobID,
COUNT(DISTINCT sl.SubscriberKey) AS TotalSent,
COUNT(DISTINCT o.SubscriberKey) AS TotalOpened,
COUNT(DISTINCT c.SubscriberKey) AS ...
- 14k
0
votes
1
answer
35
views
Add copy to email if boolean field in data extension is true
I want to add some copy into an email only if the boolean (@CPD) in my data extension is TRUE.
Can someone provide me with an example of code to do this? Can I have the copy in the AMPscript of the ...
- 646
0
votes
1
answer
88
views
How to create a priority logic for email in SFMC based on data
Current Use-case:
We have a data extension with the following fields:
CustomerID
Customer_EmailAddress
Customer_Category
1
john@test.com
Category_101
1
john@test.com
Category_202
2
lee@test.com
...
- 789
0
votes
1
answer
61
views
How to use domain exclusion DE via SQL
I have de created out of domain exclusion template and de contains only one field 'domain', and have inconsistent values like 'gmail.com' '@hotmail.com' '%yahoo%'.
I would like to use in SQL as ...
- 1,810
1
vote
1
answer
3k
views
Upserts a data extension row using Rest Api
When I am try to insert data into a data extension using REST API I'm getting an error.
Api Doc:
https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/...
CommunityBot
- 1
1
vote
1
answer
88
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 ...
- 789
0
votes
1
answer
48
views
How to establish a data relationship between the Contact and Campaigns using the campaign members in Contact builder in Marketing cloud
I am very new to SFMC and I have pretty much silly questions.
My goal: I have contacts as synchronized data extensions and I have Campaigns and Campaign members also synced as synchronized data ...
- 789
1
vote
1
answer
66
views
How to establish the relationship between the synchronized data extensions in the Marketing cloud
I have a contact and account coming to MC from Sales cloud. I want to establish the relationship between these two so that I can access the account Id in the journey builder using the contact and use ...
- 789
0
votes
1
answer
56
views
HTML conditionnal List
I have a Data Extension with 3 variables/columns.
In my email, i want to display the content of these 3 columns as follow :
Your products :
○ %%ID_Product_A%%
○ %%ID_Product_B%%
○ %%ID_Product_C%%
My ...
- 789
-1
votes
1
answer
49
views
How to fetch data from html tag that stored in Salesforce marketing cloud data extension? [closed]
Example :
I have stored below html tag as one field in data extension. I need to retrieve the href url from this. How to retrieve this ? and also How to retrieve "Visit google.com!" from ...
- 13
1
vote
1
answer
35
views
Duplicate contacts (Pricing problem) when I convert synchronized data extension to sendable data extension
I am planning to Convert the synchronized data extension (Contacts) to Sendable Data extension. Now when I populate the data extension with contact data will this be counted as a contact and will I be ...
- 1,810
1
vote
1
answer
42
views
Use of Filter contacts in the data extension entry source with Jouney builder
What is the use of Filter contacts in the Journey builder under the entry source as data extension.
I have a different fields in the data extension and if i filter using the different field in ...
- 14k
11
votes
2
answers
1k
views
Setting non-nullable fields on Synchronized Data Extensions
I need to do an attribute-to-attribute comparison as part of a Decision Split (Journey Builder). One of the attributes happens to be from a Synchronized Data Extension (Sales Cloud source). Apparently ...
CommunityBot
- 1
0
votes
0
answers
32
views
How to identify the link that was clicked in the email in the Journey builder's jouney?
I have multiple links in the email which I am utilizing and sending to the end users in the Journey builder. I have to track the links clicked by the contact in the journey itself. The engagement ...
- 444
0
votes
1
answer
1k
views
Use multiple data extensions for dynamic content in Email Studio
My marketing users have an existing data extension that they want to continue using when creating emails. We are implementing a new integration that will provide 15 new data points. It's my feeling ...
CommunityBot
- 1
1
vote
1
answer
84
views
Create list of Data Extensions that are being used in Data Extension Extracts in Marketing Cloud
I need to create a list of Data Extensions being used in the Data Extension Extract Activities. I tried using the ExtractDefintion but I haven't managed to make it work.
https://developer.salesforce....
- 29.6k
1
vote
1
answer
2k
views
Using AMPScript for a dynamic URL
This is my first post but I thought I would ask the community for feedback.
Some background: I am creating an email for a client that would then take over uploading data extensions and sending the ...
CommunityBot
- 1
1
vote
0
answers
42
views
Data extention REST API fails during inserting
Lets say we've got followed code
var createDE = createDE(dataExtensionName,fieldNamesArray);
// TODO check for correct response value
if(createDE.Status == "OK")
{
var deObjectID = ...
- 91.1k