Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
117
questions
7
votes
2
answers
9k
views
Data extension values in the "Update Contact" activity in Journey Builder
I'm looking for a way to use fields from a data extension (that is the entry source for a journey) in the "Update Contact" activity.
I want to create a sort of log in a different data extension. Let'...
8
votes
2
answers
5k
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 ...
10
votes
3
answers
27k
views
Marketing Cloud REST API - GET method to Data Extensions
I'm currently using the POST and PUT methods to add and modify rows in custom data extensions (as documented here) but i don't see anywhere on the documentation nor the stackexchange a GET method to ...
0
votes
1
answer
5k
views
Query Activity for ORDER BY xxx DESC LIMIT
I'm trying to create a query activity in order to show, from a Data Extension, only the last 5 articles ids.
I tried with the formula ORDER BY xxx DESC LIMIT 0,5 as in SQL but it is not working and it ...
3
votes
1
answer
2k
views
Synchronising tracking data back to Salesforce from Marketing Cloud
The official documentation from Salesforce is to use Salesforce Data Extensions if you want to push tracking information from Marketing Cloud to Salesforce (https://help.salesforce.com/articleView?id=...
7
votes
2
answers
2k
views
Reorganizing fields in data extension
Is there a way to reorganize the fields/attributes in a data extension? I've added some extra fields that relate to other fields in that extension. I haven't found a way to regroup those fields.
1
vote
2
answers
2k
views
Removing a DE field when DE is used in a data relationship
I have a Data Extension field I'd like to delete, but that DE is used in an attribute group/set in Contact Builder. So is it really necessary to delete the data relationship first before I can remove ...
1
vote
3
answers
2k
views
AMPscript to decode HTML entity in data extension field
Has anyone attempted to decode HTML entities using AMPscript? For example, I have encoded HTML stored in a data extension:
<p>Dave is great!</p>
I need to use this value ...
-1
votes
1
answer
3k
views
Unable to Retrieve the Data Extension Fields using Soap Api
I have to Retrieve the Data Extension Fields from Data Extension object using Soap Api,But I am unable to Retrieve the Data Extension fields using Data Extension Object.
Data Extension Soap Request:
...
3
votes
2
answers
6k
views
Updating All Subscribers from Data Extension
Is there a way to update a record in the AllSubscribers List from a Data Extension Import?
I'm hoping to set up a daily automation that imports data file into a Data Extension on the subscriber key ...
3
votes
1
answer
6k
views
Exacttarget data extension - How to retrieve all rows in AMPScript
I have a landing page that needs to display a list of all the records in a data extension in real time. In the past we have done this with a subset of the data using the LookupRows function. This ...
3
votes
2
answers
1k
views
Automation Studio - Imports old file data or same data into Data extension again in file Drop automation with import activity?
Actually, I created File Drop automation to import data into Data Extension. I dropped different files into the same file location. After the completion of automation flow - it imports data of the ...
2
votes
1
answer
5k
views
How to use ampscript in order to pull user data from a second data extension?
We have several data extensions that have data relationships with each other.
How can I send an email using one data extension while pulling data from a second data extension to personalize my email ...
2
votes
2
answers
1k
views
SSJS Activities : Move Data Extentions in a Folder
I'm investigating the SSJS activities. I'm not a JavaScript programmer but I'm trying to learn. Now I have managed to create Date Extension, a Create a folder path. Now I would like to be able to ...
2
votes
1
answer
2k
views
Predictive Intelligence Code not pushing info to data extensions, why?
I have the following data extensions available;
CloudPages_DataExtension
IGO_PRODUCTATTRIBS
IGO_PRODUCTS
IGO_PROFILES
IGO_PURCHASES
IGO_VIEWS
PI_ABANDONED_CART_EVENT
PI_ABANDONED_CART_ITEMS
...
1
vote
1
answer
2k
views
Retrieve more than 2500 records from a DE using SSJS
Trying to retrieve more than 2500 records from a DE. My thought is to have a for loop (to process the recordset) within a while loop (to retrieve records).
var data;
var recordCount = 0;
do {
...
0
votes
1
answer
47
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'
/* ...
0
votes
1
answer
8k
views
Deleting from a Data Extension
Is it possible to perform a Delete from a Data Extension using Query or something?
Like we have Insert/Update option in a query, I would like to delete.
I know this can done using API but is that ...
0
votes
1
answer
4k
views
Invalid field count when uploading CSV to a data extension
I tried uploading non-English text to my Data Extensions but the system is throwing error named "Invalid Field Count".
0
votes
2
answers
1k
views
Duplicates in sendable DE for MobileConnect
If we send an SMS message to a DE that has duplicate entries for the same subscriber, will they receive multiple SMS, or does MobileConnect deduplicate sends based on the contact key?
We haven't seen ...
0
votes
1
answer
2k
views
Customize the default value in the date field
Is there a way to customize the default value for a date field in a data extension?
My data extension has a date field, and it is set to the default value to use the current system date. The data ...
0
votes
1
answer
1k
views
How to Bypass High Water-Mark in Marketing Cloud Journey Builder
I need to design my Journey in a way that the same person can re-enter it multiple times. The Contact Entry settings of my Journey is already set to "Re-entry anytime" but I still can't make it work. ...
0
votes
1
answer
408
views
One-to-many insert/upsert from landing to separate DE's
I'm bulding a preference center and having trouble with writing into two separate DE's.
We have two DE's:
Newsletter_Subscribers (EmailAddress, FirstName, LastName, OptIn, Country, IPAddress, ...
-2
votes
1
answer
2k
views
SQL query to track non openers in the last 90 days (Marketing Cloud)
Wondering if anyone would be able to help me. I need to build an sql query in Marketing Cloud that allows us to track anyone who hasn't opened an email within the last 90 days.
We have tried to use ...
11
votes
2
answers
12k
views
REST API for reading from a Data Extension
The REST API documentation doesn't have any method to read from a data extension while it has a couple of writing into it.
So is SOAP is the only API to read from a DE?
5
votes
2
answers
1k
views
Get the import filename?
I've got a Triggered/File Drop watching a folder for wildcard filename (incoming-*.csv). The first step of my automation is an import that is acting upon "%%FILENAME_FROM_TRIGGER%%". Everything's ...
5
votes
2
answers
1k
views
Changing the PK column of a data extension without completely recreating it
I just realized that the datatype of the PK column of my data extension should be of type Text instead of Number (otherwise I can not link it to the ContactId).
The data extension is rather big with ...
5
votes
2
answers
2k
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 ...
4
votes
3
answers
7k
views
How to create an auto increment field in Data Extension
Is it possible to create a field in Data Extension in ET/SFMC which is auto-incremented as the values are added to it?
4
votes
3
answers
3k
views
how to make sure update contact step in journey builder honors primary key?
I am trying to create one Data Extension that can be used to log all contacts going into multiple journeys and then use update contact event within journey to update row when a contact exist journey.
...
3
votes
2
answers
3k
views
Is there a way to get number of records in a Data Extension using API?
Is there a way to get number of records in a Data Extension using API? we tried to run data query get the counts data into a new DE, but how can we use API to call the query activity getting the ...
3
votes
1
answer
813
views
Filters/Decision Splits for specific rows in a Data Extension (when Contact/Subscriber has more than one row)
When a Contact/Subscriber has multiple rows in a Data Extension, I need to be able to filter and make decisions based on a specific row (i.e., the row that qualified them for the current entry into ...
3
votes
3
answers
2k
views
Cannot import 15 character Salesforce Ids into a Data Extension
I'm experiencing very odd behavior on Marketing Cloud Accounts that have the Marketing Cloud Connector installed.
If I create a Data Extension which contains two or more fields, for example:
number [...
3
votes
4
answers
2k
views
Exact Target - Is the Subscriber Key case sensitive?
We are running into an issue where a data extension used to send an email has a subscriber key e.g. 0003C00000Dkd3s from Salesforce but the actual send is going to another email address that has a ...
3
votes
2
answers
5k
views
What is the difference between Data Extension and Salesforce Data Extension in salesforce marketing cloud (exacttarget)?
The Documentation says that Salesforce Data extension is visible if the "Enhanced Subscriber features" is turned On. But it does not say what is "Enhanced Subscriber feature". What are the pros and ...
3
votes
2
answers
4k
views
Maximum Number of Fields in Data Extension
I couldn't find any restriction on the maximum number of fields/columns while creating a DataExtension using the SOAP API. There seems to be some restriction on the name but none on the max number of ...
3
votes
1
answer
5k
views
Using AMPScript to Pre-Populate a Smart Capture Forms in Salesforce Marketing Cloud
I'm trying to send an email to Data Extension A that will link users to a Marketing Cloud Landing Page with a Smart Capture form. The Smart Capture form is updating Data Extension B.
The form that ...
3
votes
2
answers
9k
views
How to use an Exclusion Data Extension in a Journey Builder Send Email Activity
When initiating an email Guided Send in Marketing Cloud, the Exclusion List option enables any list, group, or Data Extension to be excluded from the send.
In the Journey Builder Send Email Activity,...
3
votes
1
answer
618
views
Record Not Being Inserted into Journey
We're using the Fire Event endpoint from the REST API (https://code.exacttarget.com/app-development/journey-builder-development/how-to-fire-an-event.html) to insert contacts into a Journey. We are ...
3
votes
1
answer
2k
views
Retrive Data from Data Extension
I need to Query the Triggered Sends in the data extension folder. Can I do that?
So the Hierarchy is like this.
- Data Extension
- Triggered Sends
- Parent Folder
" Name of Data ...
3
votes
1
answer
3k
views
Change Data Extension Nullable attribute to Required
I have a data extension that has a "Nullable" field, that needs to be changed to "Required" (Not-Nullable), however the interface doesn't allow me to change it.
How can I achieve this?
3
votes
1
answer
8k
views
Synchronized Data extension
After installing Marketing Cloud connect and setting up Data stream, I can see my Salesforce object and data coming in Marketing cloud on Synchronised data extension. But I can not use the data for ...
3
votes
1
answer
7k
views
How to get list of data extension fields using SOAP API
I have reviewed https://help.exacttarget.com/en/technical_library/web_service_guide/technical_articles/ and cannot find example of how to a get list of data extension fields.
If this is possible I ...
3
votes
1
answer
1k
views
Data relationships and filters
When building a filtered data extension X, based on a data extension A with data relationships (A to B and B to C).
We can easily filter A on a field in B. We can also filter B on a field in C. We can ...
3
votes
1
answer
2k
views
Subscriber Key and Contact Key
My scenario is :- I have a person account(Member) stored in data extension with ContactId as the Subscriber key. I have another data extension(Product Interest DE) that stores the products that every ...
2
votes
2
answers
702
views
Salesforce Data as Entry Event - System Generated Data Extension is not getting updated
I have a journey that is using Salesforce Data as the entry event. SFMC automatically creates a data extension for that journey and automatically links it in Data Designer in the Sales and Service ...
2
votes
3
answers
2k
views
Data Extension - Date record written
I would like to know when each record in my Data Extension was inserted.
Is there is a system level way of doing that?
I'm aware that I can add a field to do this that will add the system date at the ...
2
votes
1
answer
2k
views
Can i update data extension with auto generated random value
I want to run an automation for adding random value into data extension field.
I have data extension with name RecordsDe which having 3 field FieldA, FieldB & PKey.
Now i want to add random ...
2
votes
1
answer
296
views
Collect codes for non-retail scenario
Can we use collect codes for non-retail scenarios especially if I wanted to track unknown visitor activity on my website and tie back that activity when a user provides an email on a sign-up page? (I ...
2
votes
1
answer
841
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",
...