Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1
vote
0answers
15 views
How do I update record of DataExtension in Marketing Cloud (ExactTarget) and trigger a push notification if certain criteria are met?
I need to understand if this is possible to implement the following flow in Marketing Cloud.
A User opens mobile app and performs some action. A new record to custom object ( I guess to custom ...
0
votes
1answer
21 views
Lookup records in a data extension and match on mailing data extension
I'm trying to write AMPscript that will take the data extension I'm mailing to and see if a record exists in a separate data ext. If it does then write to a value on one of our tables. Here's the ...
1
vote
0answers
11 views
Enhanced Segmentation - Final send volume after exclusion
I'm busy building filtered data extensions using the new enhanced segmentation features, so that we can drag and drop segments in to our sends.
So as an example I have created 2 filtered DEs, one ...
1
vote
1answer
42 views
SQL Query Activity Data Extension Values are Case Sensitive
Are Data Extension values case sensitive when querying with SQL query activity?
I found this to be the case when querying WHERE Status = 'Active' that it ignored records with a status value of "...
0
votes
0answers
18 views
Marketing Cloud Data Relation not returning value [duplicate]
I have three Data Extensions (with the properties):
Root (Id, Name, Value)
Child (Id, Name, ValueChild, IdRoot)
Grandchild (Id, Name, ValueGrandChild, IdChild)
I made Data Relations, where:
(From ...
0
votes
1answer
15 views
Using both lists and data extensions at the same time in for email and SMS sending?
So I know this isn't the best practice but is it possible to use both lists and data extensions in marketing cloud without any complications?
Use case could be like: I use lists when I want to send ...
0
votes
2answers
25 views
Create Marketing Cloud DE Using SOAP API in Postman
I haven't been having luck with using the FuelSDKs to use the Marketing Cloud APIs. So I've been trying to test the SOAP API directly in postman first to see if it works; and sadly I haven't gotten ...
4
votes
2answers
29 views
How to find query that populated a marketing cloud data extention?
I am looking at a data extension that is appended to daily. Is there an easy way to find the query that is adding that data? There are too many folders for me to dig through to find the query with the ...
1
vote
1answer
20 views
Export from Data Extension to open in Excel columns
When doing a DE export using automation studio data extension export activity, I've exported data from a DE to a file to SFMC SFTP with tab delimitation.
I've tried as .csv and and .txt but when I ...
1
vote
1answer
25 views
Fill Subscribers Custom field with fields in a Data Extension
In Marketing Cloud, I have a custom field in Subscribers that I need to fill the value from another custom field in a Data Extension.
This Data Extension have contacts that will become subscribers, ...
2
votes
1answer
25 views
Why can I no longer access Synchronized Data Extensions folder in Data Designer?
For the past six months, when creating new attribute groups in Data Designer my team and I had the ability to access the Synchronized Data Extensions folder and simply drag and drop a synchronized ...
1
vote
1answer
22 views
Load Data from Synchronized data extension to data extensions by SQL Query
I am trying to get Synchronized data extensions data to Data extensions in salesforce marketing cloud, I need a custom field from campaigns Synchronized data extensions.
I made a query as
select Id, ...
2
votes
2answers
39 views
Can I sum the total value of 3 columns in a data extension?
I have 3 Fields showing 'number of rewards' available that are decimal inputs.
Is there a way I can display a sum of the 3 columns in a field in a data extension so that number can be used in email ...
1
vote
0answers
40 views
Ampscript - Pull Data from DE1 to lookup data in DE2
I have a quick question to confirm what I’m doing is possible, or if there is a simpler way to handle it.
The goal is to upload a list, which sends an automated email with the content from the list, ...
1
vote
1answer
29 views
How can I type two If Condition?
I have two promocodes, one is for X Bank and the another one Y Bank, I have just one DE with X Bank Subscribers and Y Bank Subscribers.
I want to create one function that shows Promocode X Bank to the ...
1
vote
2answers
26 views
How can multiple entries be made in a data extension using the same email address?
I am using salesforce to capture and store data that has been entered/submitted into an online form. If a submission is made via the online form using an email address that has already been used the ...
1
vote
1answer
36 views
Content Builder - Send without Subscriber key
In Exacttarget, I want to send a test email to several of my email addresses, however these do not have a set subscriber key.
Before we used the "Classic content" and you had the option to go to "...
1
vote
1answer
44 views
Edit Synchronized data extension
I synced the Lead object of CRM to Marketing Cloud. The marketing team will have access to marketing cloud. Now if the marketing team edits the value of Lead in Contact Builder within Marketing Cloud ...
1
vote
1answer
40 views
Using SQL to compare and update data extension
I need to use SQL in an automation to compare the data from the "TemporaryDE" with the Data from the "CompareDe". If the CompanyName value from the "TemporaryDE" is not present in the "CompareDe" - to ...
2
votes
1answer
31 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, ...
0
votes
2answers
43 views
Comparing records from Data extension
I have a weird situation, I need to check a value in an Data Extension and if the value is not there, I need to update another data extension. But if the value is there, the data extension should not ...
1
vote
1answer
35 views
Is there a Mobile Push Job and App data view?
With Push Send Logging we are able to store PushJobID in a Data Extension. But is there also a Push Job data view to join and retrieve data? Same question for AppId and App data view.
Push Send ...
2
votes
1answer
59 views
SSJS Create Data Extension with Retention
I'm using following SSJS script to create a Data Extension and set the retention of 7 days at row level:
Platform.Load("core", "1.1");
var deObj = {
"CustomerKey": "my_DE",
"Name": "my DE",
...
2
votes
1answer
29 views
Unable to successfully copy/create Data Extension from source/target Business Units
I found some useful documentation/past examples of using wsproxy to copy and create a duplicate data extension.
Goal: I would like to copy a DE from a source business unit and then create a DE with ...
0
votes
0answers
47 views
How to delete columns from a data extension using SDK
For example, there is a data extension has three columns, how can I remove AGE column?
FN |LN |AGE
Jack|Johns|12
Jane|Jones|24
Luke|Smith|15
-3
votes
0answers
37 views
Auto populate values from all subscriber
How to auto populate values from all subscriber? Also, how to update the data from all subscriber to triggered send DE?
The use case which I am trying to do is-- I have to create an email which will ...
0
votes
1answer
50 views
UpdateData function in Cloud Pages
I was trying to update a data extension with suscriber data about interests, I recently added 2 new rows, as this is filled with records from a register form, I'm planning to send an email with a ...
2
votes
1answer
32 views
Delete Attribute Confirmation [duplicate]
I added a field to a data extension that was linked through the contact model. Now, I realize that I need to delete that field and add a different field.
This data extension is a primary table ...
0
votes
1answer
34 views
How do I reference a Contact's Salesforce ID using AMPscript in an SMS message?
We are running a series of SMS messages from a journey starting with an outbound message then a series of response messages using the next keyword. I have a Data Extension that triggers the journey ...
1
vote
1answer
38 views
Linking data extensions in Contact Builder
I'll use a similar example to what we have in real life. Let's say I would like to link 2 data extensions in Contact Builder which have 3 identical database fields, and a few different ones. Namely,
...
2
votes
1answer
36 views
Groups vs Data Extensions in Marketing Cloud - what's the difference?
I have created a data extension and a group in marketing cloud but not sure what is the basic difference between them? Can we use group in journey builder as entry source?
1
vote
1answer
20 views
Automatically Unsubscribe consumers from does not click “opt in” checkbox
I have a Data extension in MC that it is completed with information that comes when filling in a landing page.
The smart capture has an "opt in" checkbox. People who check the "opt in" will then ...
0
votes
2answers
30 views
Can I specify where I want a data extension to be created when using server-side javascript?
the code for creating a DE is straightforward, but I'm trying to specify where I want this to be created rather than the root DE folder.
Is such a thing possible?
thx
1
vote
1answer
27 views
Help with expected behaviour when sending to a DE that has an existing SubscriberKey (ContactId from Salesforce CRM) but different email address
need some help with understanding exactly how this works.
First, our setup:
We have Salesforce CRM and Marketing Cloud
Connector is up and running, syncing contacts over to MC
We have a "Master Send ...
0
votes
1answer
39 views
Files missing in SFTP!
So, I have a weird "bug" that happened to me.
I've set up the automation that consists of several steps: fill data extension with data, use data extract to create csv file, transfer that file to ...
2
votes
2answers
56 views
Does contact deletion in marketing cloud also removes email tracking data?
I want to delete few contact in SFMC. I know how to delete contacts but just want to know if other related data like email open rates, email sends reports will remain in the system or not.
1
vote
1answer
59 views
Custom Form information into a data extension [closed]
Is it possible to have a custom form write the results into a data extension? The form will have a Name field, an Event Type (dropdown), and a Promotion Type (Checkbox). I have a data extension setup ...
0
votes
1answer
12 views
Retrieve a Filtered Data extension with fields of both the data extension
We are using Data Relationships as a Data Filter to retrieve data from two data extensions, but the filtered data extension has fields only that of the source data extension. What must I do so that I ...
0
votes
1answer
31 views
Salesforce DE in Journey builder and Campaign Member activity
I need to use a Salesforce Data Extension in a journey builder, but Salesforce DE are no longer selectable as entry sources in JB apparently. Is there a workaround for this? I need this in order to ...
0
votes
1answer
60 views
Which API to use for DataExtension update in SFMC
What is the best way to update SFMC (dataextension) by external system in automated fashion?
We would like to push customer data and order history on daily basis from ERP to SFMC.
0
votes
1answer
24 views
Cloud Page Journey Receives Email Send Error [duplicate]
I have a CloudPage that is populating a Journey when people sign up to simply send them an email. The problem is that when they fillout the form since they are not a member of our All Subscribers list ...
1
vote
0answers
62 views
SFMC: SQL Query on Dataview objects to calculate Journey's sends, opens, and clicks
I want to calculate the sends, opens, and clicks of all journeys. Expecting the records in Date Extension consists of records in the following sequence:
JourneyActivityObjectID
VersionID
ActivityName
...
2
votes
2answers
95 views
SSJS Rows.Update function not working with variable in FOR loop
I am trying to loop through all rows of a data extension and update the name of each record. I created an SSJS script activity to run the below code and it is not erroring out, but it is not updating ...
-1
votes
1answer
37 views
Creating an email which populates an image based on Data Extension upload
I'm trying to send a survey to recipients with an image in the email. Ideally I could upload a list to Data extensions that would populate an image and some text. Each row would have an ID that would ...
0
votes
2answers
63 views
How to report on the performance of dynamic subject lines?
I have dynamic subject lines being pulled in from a Data Extension. I then have a code snippet content block that has a set of if statements which determine what row/subject line the recipient should ...
0
votes
0answers
34 views
Prevent shared Data Extensions from being updated in child
Shared Data Extensions can be hidden from specific BUs using permissions of single Shared DE folders. But can shared Data Extensions be set to read-only in any BU other than ENT? Ultimately the data ...
0
votes
1answer
40 views
Parsing Ampscript from a data extension row
I have a data extension with a 'subjectline' column with the content '%%FirstName%%, check out this great subject line'. I then have a code snippet content block that has a set of if statements which ...
0
votes
0answers
49 views
Alternative to _errorURL response for matching Email in form - DE Manager
I'm using DE Manager to create a DE when the user enters their email on the site. Essentially a web collect. I'm matching the email with the emails already established in the DE, and a repeat returns ...
1
vote
0answers
15 views
Are Filtered Data Extensions also Part of the Attribute Group
I assume, but frankly I am not sure if the filtered Data- Extension used as entry point in a Journey is also linked to the same Attribute Group as the parent one I create the filter from. (The comment ...
0
votes
1answer
51 views
SQL Query on a synchronized Data Extension doesn't work
first of all, excuse my bad english :-)
I tried to get Data from a synchronized Data Extension in Marketingcloud and store it in a new Data Extension with an SQL Query in Automation Studio.
But i don'...
