Skip to main content

Questions tagged [dataextensions]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 views

Get a list of Data Extensions via REST

Using REST API, I am trying to fetch the list of all Data Extensions in the Business Unit. I successfully received the Auth token, so I don't think anything is wrong there. The method I am using is ...
0 votes
2 answers
1k 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
1 answer
1k views

Contact count is much higher than number of emailable contacts

Our contact count in SFMC is being reported at twice the number of actual contacts we are syncing over two sendable synchronized data extensions (contact and lead). I've checked everywhere I can (...
1 vote
2 answers
910 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 ...
0 votes
1 answer
28 views

Marketing Cloud - SQL Query to Return all Subscribers Who've been sent an email

I want to find out how many of my subscribers (who've been sent an email) have opened an email within the last 5 years. I want to include subscribers who've been sent an email and haven't opened an ...
2 votes
3 answers
5k views

Emails not being sent

I've created a new DE based on a sync DE from SF by creating a data filter and a filter activity to create the new DE that should be used for sending emails. I can see the subscribers but when i try ...
0 votes
1 answer
64 views

Image Upload Feature on Marketing Cloud Landing Page Not Storing in Data Extension

I'm working on a project in Salesforce Marketing Cloud and need to create a landing page with an image upload feature. I have already set up a Data Extension named "ImageUploads" with the ...
1 vote
1 answer
4k views

difference between Data Extension types

Can somebody please explain the differents of: Salesforce Data Extension Shared Salesforce Data Extension? Shared Data Extension I cant find the definition on help.marketingcloud.com
-2 votes
0 answers
28 views

Is there is way to customize the subject line of Data import notification email?

We will be receiving email notifications from SFMC while importing the text or csv file in SFMC. My question is, is there is any way to customise the subject line for this email notification to ...
0 votes
1 answer
23 views

Correct syntax to reference dynamic column name with SSJS Rows.Update() function

When the column name of a Data Extension is unknown and data needs to be written to that column what is the correct syntax as the following do not seem to work, Where e.num is some dynamic value like ...
1 vote
4 answers
4k views

CaseSensitiveSalesforceID when uploading data to Marketing Cloud

I'm importing some data into a data extension via Data Extensions, and most of the data has gone in without problems. However, it's highlighted about 100 rows as being unable to import due to '...
0 votes
1 answer
1k views

Journey Builder sends not displayed in Sales Cloud

i try to track Journey sends in Sales Cloud under IER. I'am using the SFMC Connector. In SFMC i use the 18 digit ID as subscriber key. Journey data Extension is located in "Data Extension folder" ...
-1 votes
0 answers
35 views

Formula field not showing up in Data Extension

I'm creating a Data extension in Marketing Cloud, that data extension is created using Automation by running SQL query. But it's not considering formula field for data extension fields. Below is my ...
0 votes
1 answer
2k 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 ...
0 votes
0 answers
32 views

How to correlate records sent via `PUT /rows` with the error details from `GET /results`?

I'm trying to import product data into DataExtensions using the async API. Consider the example below: PUT /data/v1/async/dataextensions/key:DEX_PRODUCT_API/rows { "items": [ { &...
0 votes
1 answer
1k views

Using a Publication List with a triggered send?

There is a similar question out there that doesn't specifically answer the question I am asking. I want to know if it is possible to associate a Publication List when sending a triggered send to a ...
0 votes
0 answers
22 views

Choosing especific value from DataExtension to use on Jorney

I have an Data Extension that uses 2 primary keys. One is an identifier of the customer, the other one is the product id. I have a status on this table and I use it on a journey that informs the ...
-1 votes
1 answer
33 views

marekting cloud - can we automate to send all subscriber data to my subcriber list in marketing cloud in order to automation subs-unsub..helpplssss

I have a scenarion where I am not using connector first of all and I am sending my salescloud data account/contact to marekting cloud data extension through rest api. Now the tricky part is we have 2 ...
0 votes
2 answers
47 views

Simple Queries - Sent

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when I run the query, nothing populates in the DE and nothing ...
0 votes
1 answer
2k views

Using SQL to combine Bounces, Opens, and Clicks into one DE

I currently have two SQLs pushing data into one DE. One populates Opens, and the other populates Clicks. I then combined the SQLs to an automation with the last step being to enter a journey. The ...
0 votes
1 answer
193 views

How to unsubscribe in all subscribers from a data extension using SSJS script activity

Hello I was trying this idea from this Question. But I can't seem to make his initial idea work. Can you guys help me with this? What I am trying to do is from a data extension, i need to unsubscribe ...
1 vote
1 answer
798 views

how to get the owner of a data extension in marketing cloud [closed]

Is there any way to get the owner of a DE through API or Query?, Currently we have have a SOAP API but this is not bringing us the Owner, this would be the only attribute that does not call
-2 votes
1 answer
51 views

SFMC Newbie: Need to create a segmented email list/data extension

I accidentally sent an email out to an old large data extension, instead of the current updated list. I need to send the email out again, excluding anyone that already received it if they were ...
0 votes
1 answer
46 views

DataExtension.Init not working

I have tried to use DataExtension.Init() several times with no avail. I can see the Data extension in both parent and child business Unit (it lives in the shared data extension folder). I've also ...
2 votes
1 answer
955 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 ...
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 ...
0 votes
1 answer
1k views

Data Extension shows 0 record after successful import via Automation Studio

Background We're running an external campaign, using SFTP transfer to import file from external to Marketing Cloud FTP location. In Automation Studio, we have an "Import File" action to ...
0 votes
2 answers
6k views

SSJS Rows.Retrieve not returning any rows

I'm having an issue where I'm unable to retrieve any rows from a DE that I know is populated inside an automation. Here is my code: <script runat="server"> Platform.Load("core","1"); var ...
0 votes
2 answers
2k 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 ...
-2 votes
1 answer
37 views

Sent to a list of emails based on a subscriber

I have a customer record with mock data as a subscriber. I need to send an email based on this mock user's data to 200+ emails. What is the most straight forward way of going about this? I tried using ...
4 votes
3 answers
5k views

Cannot Query Synchronized Data Extension

I have created a Query to consolidate data from 2 Synchronized Data Extensions into one Sendable DE, but upon running it I get an "Automation failed due to system error". At first I thought my query ...
0 votes
1 answer
73 views

CloudPage InsertData() shows 500 error message if data already exists in DE

How can I get the CloudPage not to go to the 500 error page if I am using InsertData() but the data was already existing in the Data Extension? It works the first time if it doesn't exist, but it the ...
-2 votes
1 answer
93 views

How to find duplicates using Data Extensions

How can I find duplicated emails using Data Extensions or through Contact Builder? My SQL knowledge is pretty much none, and i want to know if there's a viable way to find these duplicate emails using ...
2 votes
2 answers
4k views

How to refresh synchronized data extension to see new fields?

Some new fields were added in Salesforce and I'd like to access them in an Exact Target synchronized data extension but they aren't there. Is there a way to refresh the synchronized data extension so ...
0 votes
1 answer
1k 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 ...
11 votes
3 answers
30k 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
977 views

API for Data extension update in sfmc salesforce marketing cloud

I need to push some data on daily basis from ERP to SFMC The package is already created on marketing cloud (read, write on Data extension). I created a first POST request : Body : { "...
0 votes
0 answers
48 views

Request Filter a Data Extension is using

I'm trying to retrieve the FilterDefinition a DataExtension is using but failing at it right now. I'm able to retrieve the source of a Filter via the FilterDefinition SOAP call but that only gives me ...
0 votes
1 answer
20 views

Update contact record in native DE on journey - will the update be available for later steps in journey?

I am trying to build a journey in Marketing Cloud that includes an "update contact" step as the first step in the journey (for example, update contacts who are age 50 or older by changing ...
0 votes
0 answers
36 views

Boolean Attribute Issue in Decision Split Activity in a Shared Data Extension

I'm using a boolean attribute in a shared data extension in the decision split activity in the journey. The business unit I'm using is a child business unit. However, I noticed that the boolean value ...
0 votes
1 answer
21 views

How to change/update DataExtensionField's length using ssjs?

i currently have data extension, its customerKEY, data extensionField's objectID, and a soap api call which can implement this (updation/change of data extension field's length) soapApi code: <?xml ...
0 votes
2 answers
56 views

Journey Builder sending to the wrong email address

I have a sending data extension with an ID as the subscriber key + the email address. The issue is that when sending an email via journey builder, for some reason it's not sending the email to the ...
0 votes
1 answer
55 views

Tracking extract - attributes file

can someone help with including attributes in the tracking extract output? My goal is to include in the tracking extract an internal list id that corresponds with a subscribers' event. That list id is ...
0 votes
1 answer
895 views

Adding Custom Field to Cart Page in B2B Commerce

I am trying extend the Cart Data Provider and I am having a bit of trouble. I need to pass a custom field to the Cart page. I am able to get custom fields to show up when I extend the Product Data ...
0 votes
0 answers
66 views

SQL code repeats result for first row only

I need to concatenate columns in an alphabetical order, so I used solution provided here: Marketing Cloud - SQL Contatenate columns in alphabetical order select stuff(x.c,1,1,'') as [constraint] from ...
0 votes
1 answer
69 views

Marketing Cloud - SQL Contatenate columns in alphabetical order

I need to concatenate several columns in an alphabetical order. Is that possible to be accomplish with Marketing Cloud limited SQL? Below you can find the sample structure: SELECT TOP 1 constraintl, ...
0 votes
1 answer
919 views

Minutes and seconds wildcard specifiers preventing file selection from Safehouse in automation Studio activity

Within Automation Studio we have a Data Extract activity that results in a csv file in safehouse. The issue we are experiencing is that the file naming pattern requires minutes and seconds eg ...
0 votes
1 answer
1k 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 ...
4 votes
2 answers
886 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
1 answer
2k 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 ...

1
2 3 4 5
32