Questions tagged [dataextensions]

ExactTarget - A data extension is a table within the application database that contains your data.

Filter by
Sorted by
Tagged with
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'...
Rafał Wolsztyniak's user avatar
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 ...
Cameron Robert's user avatar
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 ...
etoIT's user avatar
  • 101
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 ...
M.Giorgio's user avatar
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=...
neo2049's user avatar
  • 392
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.
Tom Callahan's user avatar
  • 1,407
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 ...
Stephen Boyette's user avatar
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 ...
Daniel's user avatar
  • 1,257
-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: ...
user36636's user avatar
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 ...
Jerome Stontz's user avatar
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 ...
parkinsona's user avatar
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 ...
user60922's user avatar
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 ...
Sylvie's user avatar
  • 21
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 ...
R.Pruner's user avatar
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 ...
Axel Ekeberg's user avatar
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 { ...
victorcorey's user avatar
  • 1,808
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' /* ...
Rain's user avatar
  • 1
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 ...
Maneesh's user avatar
  • 2,164
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".
Gajendra Singh's user avatar
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 ...
Luke BDD's user avatar
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 ...
RunRabbit's user avatar
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. ...
justinPCM's user avatar
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, ...
Urke's user avatar
  • 19
-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 ...
Sean Garrett's user avatar
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?
Maneesh's user avatar
  • 2,164
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 ...
James Lamb's user avatar
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 ...
Disasterkid's user avatar
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 ...
Tom2shoes's user avatar
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?
Madan's user avatar
  • 41
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. ...
kl2's user avatar
  • 317
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 ...
StackBruce's user avatar
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 ...
Liz Gordon's user avatar
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 [...
Eliot Harper's user avatar
  • 16.3k
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 ...
Kyu's user avatar
  • 53
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 ...
Peush Prasannan's user avatar
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 ...
Volatile_volvo's user avatar
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 ...
PhilipW's user avatar
  • 61
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,...
Eliot Harper's user avatar
  • 16.3k
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 ...
Alex S.'s user avatar
  • 131
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 ...
CodeDiva's user avatar
  • 163
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?
Cameron Robert's user avatar
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 ...
Saurabh Singh's user avatar
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 ...
mattcameron's user avatar
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 ...
Lukas Lunow's user avatar
  • 20.5k
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 ...
Peush Prasannan's user avatar
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 ...
Jackson Chen's user avatar
  • 4,677
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 ...
Thomas Hockey's user avatar
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 ...
Front End Coder's user avatar
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 ...
Chandu Sarkar's user avatar
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", ...
raj's user avatar
  • 183