Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,031
questions
0
votes
0answers
11 views
Join Subscriber Data to _Open and _Click Data view
How Can i join _Subscribers to this below query to get email address also?
Select
s.SubscriberKey,
s.JobID,
s.BatchID,
convert(char(19),s.EventDate,20) as SendDate,
c.[Click],
o.[Open]
FROM (
...
0
votes
1answer
28 views
How to make a Segment created by RANDOM Data Extension as SENDABLE?
I splitted a large DE[non-sendable] into 7 segments.
Now I want to send an email to all these 7 segments, but I notice that though I am able to change the main DE as SENDABLE.
But, I cannot change ...
0
votes
1answer
35 views
Changing data retention settings on existing data extension
Is it possible to change the data retention settings of an already-created DE? I have DE's that are automated. An automation puts data view information into these DE's but when I edit, I cant see ...
0
votes
1answer
17 views
SSJS rows.retrieve returns null
I am trying to print the JSON values from the Rows.Retrieve function of SSJS but it always returns null
var stagingDE = DataExtension.Init("DE's External Key");
var data = stagingDE.Rows.Retrieve();
...
0
votes
1answer
37 views
Confirm who is sending data to our Marketing Cloud
So I inherited a business unit in Marketing Cloud, and we have one triggered email whose data source I can't locate. Is there a way to confirm all the data sources/APIs that are connecting to a ...
1
vote
1answer
40 views
Is it possible to use data in a Related Data Extension to personalize content that is sent to the parent Data Extension?
I am trying to determine if I can use data that is set up in a related (non-sendable) Data Extension to personalize an email that I will send to a parent (sendable) data extension. I have two data ...
0
votes
0answers
9 views
Rename DE used by API
I have some Data Extensions that are being populated/used by API's and I want to update their name.
If I leave the EXTERNAL KEY as it is, can I change the name of the DE without breaking anything?
1
vote
1answer
33 views
Reporting against a column in my data extension? - Salesforce Marketing Cloud
I'm looking to create a report based on a column in my sendable Data Extension used in a deployment in Salesforce Marketing Cloud.
Ideally, I would like the report to look similar to "Email ...
0
votes
0answers
34 views
Unable to update field to required using SOAP/Wsproxy
We are using SOAP/WSProxy to update a field to required using the following Update call:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header>
...
0
votes
1answer
27 views
Concat two column values data extention
I have a data extension and it has three columns .What I am trying to do is concat the two columns and add them to third column programmatically using AMP-script or sssjs like cl1,col2 as the value ...
0
votes
0answers
36 views
I would like to give value to a field with values from a field in another table
I have two data extension, in the first one I have an empty field called codigo, to which I would like to give values that are stored in the second data extension in the IdCodigo field, with the ...
0
votes
1answer
27 views
Performing an Group By Function in SQL in Marketing Cloud Activity [closed]
I'm trying to perform a Group By function on my Click data view Data Extension, which was built from the _Click data view. (Not sure if it's necessary to have the extra layer.) I am looking to ...
1
vote
1answer
39 views
Marketing Cloud - update a Data Extension field via SOAP
I have a SOAP request and I want to replace the value in the existing field for the Data Extension Object that I have. It seems to give me a response of "OK" but I do no see that change in the field ...
0
votes
0answers
27 views
Updating a DE with no Primary Keys
This might be a stupid question but is there a way to update records (yes many records and duplicate ones) in a DE without a primary key? I am not the owner of the DE which is already structured for ...
0
votes
1answer
30 views
Replace full URL With DE Attribute in Email
I have a data extension with a filed called 'SaveDesignLink' that is the full URL I want to populate. Say the URL is: www.test.com
Here is my current code in the email:
< a href="%%...
4
votes
2answers
141 views
Subscribers currently in a Journey
What ways could you create a data extension that contains all the subscribers (SubscriberKeys) that are currently “in” a Journey (Journey Builder)?
The Journey I would like to do this for is a ...
0
votes
2answers
47 views
Primary Key combination for _Click data view
I am building replications of some system data views in order to be able to hold data that goes back further than 6 months (we are a seasonal business so want to look back at least 13 months).
I ...
0
votes
1answer
41 views
Querying sales cloud object
I am using cloud connect between Sales cloud and marketing cloud .I couldnt find information on one issue, Is it possible to use query in marketing cloud activities ,but using sales cloud lead or ...
0
votes
1answer
57 views
Look up more than one item in a data extension with ampscript in email
I understand the basics of looking up one entry from a data extension, but I have a data extension of products and I would like to display the image, name, url for three, can I do that with one ...
0
votes
0answers
39 views
Salesforce-FuelSDK Python clear all data from Data Extension
I want to delete all the records from the data extension using Saleforce FuelSDK for Python. I have found that there is a method to delete records row by row but it does not solve the problem. Below ...
0
votes
0answers
28 views
Einstein Content Selection | Sync Your Consumer Profile Data Extension
I followed Einstein Content Selection documentation provided by SFMC to understand the feature better. I created and uploaded asset catalog file.
Next I want to use customer profile attributes using ...
0
votes
1answer
28 views
Retrieve Data from a Data Extension and Update Sales cloud record
Is it possible to Retrieve Data from a Data Extension and Update Sales cloud record without using Data Sync or Sync Data extension.
If yes, what would be the approach?
0
votes
1answer
46 views
Querying when a value changed in a DE
I'm attempting to query when a value changed in a particular data e.g. when the email address for subscriber 12345 was changed, if ever. Is there a way to query this information?
-1
votes
1answer
52 views
whenever any data extension created in SFMC I would like to add this in Journey Builder as a entry source [closed]
Per my business need I have below requirement-
From an third party app user can create data extension in SFMC by any name. In SFMC I have 3-4 pre built journey created on my account.
So whenever any ...
0
votes
1answer
19 views
Credibility of data when getting time out error in an update
If my query is updating a data extension and gives a time out error, does the destination data extension suffer any changes to its data or is it exactly the same as before running the activity?
...
0
votes
0answers
18 views
How can I use in Mobile Connect a data extension created in Contact Builder?
I created in Contact Builder a data extension with the following fields, as per the documentation i read.
When I try to create a sms in Mobile connect and select Data extension as audience, I can't ...
0
votes
0answers
16 views
Repercussions of adding new field to journey entry data extension
I'd like to add a nullable field to a data extension that's used as an entry source for an active journey. I know this is possible, but what are the repercussions of adding the nullable field if the ...
0
votes
0answers
35 views
Display List of Values in Filtered Data Extensions?
We are considering using filtered data extensions for our audience build (instead of Journey Builder) and performing our segmentation / attribute assignment on the data extraction side from our data ...
3
votes
1answer
33 views
Salesforce Data Extensions help
If we don't have Sales & Service Cloud in our stack, is there still a case for using Salesforce Data Extensions over standard Data Extensions? I have read that by using Salesforce Data Extensions ...
0
votes
1answer
31 views
AMPScript to Overwrite Personalization/DE values in Content Only
We have this DE that has TrackingCode and OtherID fields. Is there a way to overwrite the %%TrackingCode%% value (this should show as TrackingCode+OtherID+DateTimeNow when the comm is sent)? Now, we ...
0
votes
0answers
14 views
Couldnt find data extract in automation studio activities [duplicate]
I was trying to extract data extention from marketing cloud but I couldnt find the data extract activity in the automation studio. Should it be opened by creating a support ticket or is there a way to ...
4
votes
0answers
40 views
Can two Update Contact activities in Journey Builder write data to the same row in a data extension?
The Update Contact activity has a limit of 5 fields that can be selected in the interface and updated in a data extension. To overcome this I tried to use two activities that insert/update a row and ...
2
votes
0answers
35 views
How to Set up Contacts in Marketing Cloud to populate records from Personalization Builder Data Extension
I worked on Personalization Builder and collected data about users based on collection codes set up on a demo webpage.
The data is in the Standard Personalization Builder Data Extension.
IGO_PROFILES
...
0
votes
1answer
35 views
Journey Builder Decision Split Using DE question
We have a journey using Salesforce Campaign Member object as the entry source. Some of the contacts entering the journey (based on the member status on entry) goes through a decision split after ...
0
votes
0answers
35 views
Exclusion Data Extensions with Salesforce data extensions
one of our client uses Content Builder Send flow (for one shot email) to send his emails.
He wanted to use a Salesforce Data Extension as target DE for his send, and a DE from the Data Extension ...
0
votes
0answers
19 views
Store multiple values from a Cloud Pages field
I'm trying to see if there is a way for someone to enter multiple values in a single input field in a custom Cloud Pages landing page to write to a data extension? what is the best way.. also, trying ...
0
votes
1answer
50 views
Ampscript “lookup” don't work for synchronized data extension “Case_Salesforce”
I am trying to extract data from synchronized data extension "Case_Salesforce" to show on an email.
Is it possible to do this? I am using lookup function to achieve.
I can get synchronized data ...
0
votes
1answer
20 views
Get DataExtension absolute url
After creating a DataExtension using SOAP API, I am able to get the details like CustomerKey/ObjectID of the data extension. I would like to get the absolute url(deep link) of the data extension, so ...
0
votes
1answer
33 views
Scheduling an email in Salesforce Marketing Cloud with a Data Extension and exclusion Data Extension
I've scheduled an email to go out in a couple of days. It's going out to a Data Extension, which I'm good with. But I also have an exclusion data extension that will be suppressed.
Now this data ...
0
votes
1answer
45 views
Identify records in data extension from CSV file [closed]
I am trying to identify a series of records in a data extension.
I have a CSV file containing all the records that I want to identify in ly data extension but I don't know to proceed to clearly ...
0
votes
1answer
52 views
Data extention - Trailhead - Clarification on DATA RETENTION
I came with a question, where in one the answer regarding the DATA RETENTION is as below [as per trailhead!!!]
You cannot remove the configured data retention settings once you configure them!
But, ...
0
votes
2answers
29 views
All Subscribers search is not showing all the attribute values from data extension ,despite data extension having values
Using SFMC-SOAP API I was able to do the following
Steps that were successfully done prior to hitting the problem:
Create a DataExtension where we had 3 distinct attributes namely Subscriber Key, ...
0
votes
1answer
50 views
Updating DE through SmartCapture in CloudPage
Consider a scenario where a mail will be sent to contacts in Data Extension. The mail contains a button that will redirect to CloudPage.
This cloud page has a smart capture that will prepopulate ...
0
votes
2answers
47 views
For loop to display data only when DE has data in it
There are few fields in the Data Extension DeptID, BusinessID, StateID. I want it to print the value only if that value is present in the DE.
Eg, if the DeptID is blank/null it should print ...
1
vote
1answer
40 views
Getting the filtered data extension associated with a send and it's corresponding definition
I am looking for a way to extract the following information programmatically:
For each job ID, what is the corresponding Data Extensions that was used for sending
For that data extension, what is ...
1
vote
1answer
53 views
Data Extension Retention Policy - Individual Records - does the period reset upon upsert/update?
I'm reading the documentation on retention policies for data extensions.
One thing is unclear - hoping someone can clarify.
If I set the retention policy to work on individual records, what happens ...
2
votes
1answer
83 views
How to fetch Marketing cloud DataExtention Metadata using API?
How can we fetch the properties of a Marketing cloud Data Extention using it's API.
For Example :- there is a Data extention named "ABC" and having feilds(properties) like name(String), age(integer), ...
0
votes
1answer
41 views
Exclusion Script with Multiple DEs
Can you use multiple DEs in an exclusion script for journey sends? I am currently using this template:
ROWCOUNT(LOOKUPROWS("DE", "Email", emailaddr))> 0
1
vote
1answer
54 views
Journey Builder is not pulling the correct data from data extension
I have a journey which is not pulling data from our data extension correctly.
The data in the data extension is correct but the email that has been sent out has a previous value.
I update the data ...
0
votes
1answer
49 views
Unable to select Filtered Data Extension as target in SQL query in Marketing Cloud
I have created 2 filtered data extension from a shared data extension using filter. I want to automate those filters so that the DE's will be auto refreshed. I realized that automating filter ...
