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
24 views

Gather email feedback in a Data extension [closed]

we are trying to build a logic where at the end of each email, there is a HTML block with either a thumbs up or a thumbs down icon to measure email sentiment. Each thumb will need to lead to a cloud ...
user avatar
0 votes
2 answers
26 views

Updating an attribute in Data Extension while journey is active affects the journey decisions?

I have this journey thats sends an Email; This Email changes an image in the content with an attribute called "concierge" in the Data Extension. The journey is active, and I realize one of ...
user avatar
0 votes
1 answer
25 views

One-off import into Journey entry source

quick question re: Journey entry source. Currently I populate the entry source DE with contacts from a SQL query automation. I've got a handful of records I need to insert into that journey (in the ...
user avatar
2 votes
1 answer
37 views

Automated bulk refresh of filtered DEs - API or data filters?

I work for an organization with a very decentralized model, and we have 25-30 departments/teams sending out of SFMC. Each of these teams has their own set of filtered DEs (probably 30-50 per team), ...
user avatar
  • 21
0 votes
0 answers
8 views

Query all subscribers to find the subscriber key related to the contacts from mobile Data View

I would like to retrieve users who received sms and retrieve their salesforce ContactID. I had created a Data Extension from the template of the SMSMessageTracking DataView in a child Business Unit. ...
user avatar
0 votes
0 answers
30 views

FileReadFailure in Automation Studio Import Activity

We have a simple workflow in Automation Studio that triggers when a file with a certain name pattern + %%Year%%%%Month%%%%Day%% is dropped in the "import" FTP folder. We are having problems ...
user avatar
0 votes
1 answer
57 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 (...
user avatar
0 votes
1 answer
66 views

Data retention policy doesn't apply to existing records in data extension?

I have a data extension which includes a few records. It was not set up a data retention policy in the first place. I have reconfigured the data retention through Contact builder so that individual ...
user avatar
  • 146
0 votes
1 answer
38 views

ampscript lookup to limit number of rows to display if there are more than 5 records

hello currently working on an email that has table and the records are coming from another DE so im using LookupRows using contactId, I want to limit the number of records to be displayed to 5 however ...
user avatar
0 votes
0 answers
52 views

Data Extension Entry Source Filter Doesn't Work

Journey is having a super simple filter i.e.CREATED_DTE is not null. Somehow the journey doesn't admit any record. EMAIL_ADDR_TXT relates to subscriber on Subscriber key. Any thought/help is ...
user avatar
  • 6,161
0 votes
1 answer
53 views

Moving over 2000+ old Data Extensions to new folder for review/delete

I am trying to move multiple old DEs into a new folder. And, with my limited experience with SFMC Objects & WSProxy/SSJS, I dug deep into multiple resources & samples codes like (Zuzanna - ...
user avatar
0 votes
1 answer
38 views

How to create a data extension from a Mobile List?

We have created a filtered list in Contact Builder: Contact Key not null AND Email Address null AND Mobile Number null AND Device ID null AND CUSTOMER_ID null This lit identifies the subscribers that ...
user avatar
0 votes
0 answers
88 views

Download Data Extension to csv or Excel file via Cloud Pages (Marketing Cloud)

a team in our company needs to be able to download a data extension, and they would prefer to go to a Cloud Page address and just click a download button to download a file in their browser instead of ...
user avatar
0 votes
1 answer
19 views

Missing records after Marketing Cloud FTP Export in my local file

Today I did an Enhanced FTP export from a Data Extension that was holding 8,498,752 records with 166 MB. In the Enhanced FTP directory, a file for it was generated with the size of 203,632 KB. I ...
user avatar
0 votes
1 answer
39 views

How to optimize the email AMPscript code that has a lot of lookups?

I have built a dynamic email template. This email template pulls the data from the Data Extension based on email name ( example: subject line, pre-header, content area, headers etc). For each field ...
user avatar
  • 5
0 votes
1 answer
39 views

Pass the value from email to a content block using AMPscript

In my email, I am calling a Content Block. The content block uses a lookup to pull out content from a Data Extension. Example code in content block: set @SourceDE = "DE_NAME" ...
user avatar
  • 5
0 votes
2 answers
33 views

Can you populate SendLog DE with a different value than the one in target DE matching field?

At send-time, data is written to the SendLog and when fields in the Sending Data Extension match the Field name of the SendLog Data Extension, that value is written in the SendLog. But in a field (&...
user avatar
  • 5
0 votes
1 answer
21 views

Is it possible to gather the percent of who gets each email from a random split and put in a DE? [closed]

Right now I am trying to create a report that gathers as much info i can get from journeys and would like to know if its possible to do it with the percent of random splits. We have been using the ...
user avatar
2 votes
1 answer
57 views

Want to perform Website tracking (only Website visits) through Collect tracking code

Client wants to track known visitors on there website and they are not into e-commerce business. so we have updated content catalog in email recommendation section and this account doesn't has Web ...
user avatar
0 votes
1 answer
40 views

How to reproduce unique record based on a field value (date, account code) on data extension [closed]

Lets say I have rows of sends on contacts on a data extension. These contacts can have the same value on the column Event Date, name and account code This data extension would be like that : Contact ...
user avatar
  • 27
0 votes
1 answer
28 views

Retrieve data from synchronised data extension to a sendlog data extension

I would like to retrieve the sends and some data from Synchronised Data Extension in a sendlog data extension. Indeed, more than the sends I would like to retrieve : the contacts ID who have received ...
user avatar
  • 27
1 vote
1 answer
34 views

Running a script on row update or addition in marketing cloud

I have a DE in marketing cloud which has fields for marketing permission.The permission should be sent to an external database using an api whenever a new row is added or updated.I have to use server ...
user avatar
0 votes
1 answer
60 views

Setting existing field as Primary Key on Marketing Cloud Data Extension

We have a data extension which doesn't have any primary key set. Can't we back it up, clear all records and then set an existing field(EmailAddress field we have) as the primary key? The reason behind ...
user avatar
  • 6,161
0 votes
1 answer
34 views

How to convert the String to a ampscript code in email?

I am storing the email content in the google sheet and then importing it into the data extension. The email is dynamic & is fetching data from the data extension. For one of the fields i,E URL , I ...
user avatar
  • 3
0 votes
1 answer
71 views

Query to Combine Data from 3 different Data View Tables

I've pulled the last 30 days of data from 3 data view tables (Job, Open, and Click) into 3 different data extensions. I'm attempting to run a query to dump data from my 3 different data extensions ...
user avatar
0 votes
0 answers
42 views

Can I use a publication list to honor opt-outs to guided sends, or must I use a suppression list?

Official documentation wasn't clear to me, and my Salesforce support case didn't give me the level of clarification I needed. I'm trying to transition from using publication lists for internal use ...
user avatar
  • 9
0 votes
0 answers
78 views

Update boolean value in data extension from false to true with Ampscript?

I have a form on a landing page that uses the UpsertData function to add or update rows in a data extension. In this data extension I have a checkbox with a boolean value. I am doing a ...
user avatar
  • 11
0 votes
1 answer
54 views

How to update salesforce custom object (Customer__c) OptIn field value from Marketing cloud (Customer DE) OptIn attribute value using AMP script

I have a scenario, 1 DE (Customer DE with SubscriberKey, OptIn, Status, OptInDate attributes) with some records. I want to update the salesforce Customer__c object records OptIn (Yes/No) if ...
user avatar
  • 3
0 votes
0 answers
39 views

Marketing Cloud Journey 'Hard Error' to Same Contact Key

I've encountered a 'Hard Error' without any further details. The journey takes in new records from the Data Extension, and then sends out the email to the Contact associated with it. In this scenario, ...
user avatar
0 votes
1 answer
70 views

Retrieve fields from dynamic data extention in Custom activity?

I am having little issue : in my js script I am trying to push some data dynamically : /** * Save settings */ function save() { //if($form.valid()) { payload['metaData'].isConfigured = ...
user avatar
  • 159
2 votes
1 answer
121 views

how to get the owner name 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 a SOAP API but this is not bringing us the Owner, this would be the only attribute that does not call
user avatar
1 vote
1 answer
124 views

How can I combine the _SMSMessagetracking data view with another DE without having duplicates in Salesforce Markteting Cloud?

Great feedback. How ever, I still don't get the result I want. This is what I have with the outcome and what I expect: SMS Tracking view I created the SMS tracking DE with all the fields from the SMS ...
user avatar
  • 103
0 votes
0 answers
33 views

Send email from a Journey when record data was changed

I have a Data Extension that has multiple boolean fields. Records get into this Data Extension through api requests, and the data in them can also change through api requests. If the first field is ...
user avatar
  • 13
0 votes
0 answers
119 views

How to link created data extension to my custom form in cloud landing page

I'm new to Salesforce and I having confused about how to link my data extension with the cloud landing page created if I would like to build a custom form. Here is the situation, I have created my ...
user avatar
  • 1
0 votes
1 answer
126 views

SSJS Lookup All Rows from Data Extension Column as Array

So I have a "Master" Data Extension that has a ton of columns and rows (millions), and one column needs to have some changes made for specific rows based on Customer_ID. I have a ...
user avatar
  • 27
0 votes
1 answer
52 views

Is it possible automatically to save content builder published urls into a DE?

I have 3 images (imagine: logo, img1, img2) uploaded and published in Content Builder. I want to add thos published URLs to a DE, so in logo's line I add url from logo image. If there a just 3, its ...
user avatar
0 votes
0 answers
53 views

SSJS Array.prototype throws jintException when used with DataExtension.Retrieve value of test

I have stumbled across another interesting case with SSJS and Salesforce Marketing Cloud and hope for some ideas on why this occur and furthermore, how I may can prevent this from happening. On a ...
user avatar
  • 466
1 vote
1 answer
64 views

Cannot create a Data Extension using SSJS in CloudPage but same code works in Automation Studio

I have created a HTML landing page like below, which takes the input from the user for Data Extension name <html> <body> <h1> Create a new Data Extension </h1> ...
user avatar
  • 11
0 votes
0 answers
48 views

Issue when creating a Data Extension within shared folder using SSJS

I could create a Data Extension successfully within any folder inside Data Extension parent folder using the below code. But when I do it for Shared Data Extension, I am not successful, could anyone ...
user avatar
0 votes
1 answer
31 views

Data Extension with Logos

I am trying to finalize an email and have run into an issue. The email needs to be dynamic in terms of the logo, as it should swap out based on the company that the audience member is associated with. ...
user avatar
0 votes
2 answers
57 views

Equally Split a DE by segment

I have a DE with about 4m records. I am looking to do a 50/50 split for testing but by a specific column. So within that DE, every record has a "Segment". So there might be 500k customers, ...
user avatar
0 votes
0 answers
48 views

Creating a report based on Data Extension attribute?

My company has a Data Extension which gets updated daily and it consists of for example below: Name Product Product ID Weight Jason Banana 11111111 1kg Kim Apple 22222222 2kg There will be new ...
user avatar
0 votes
0 answers
30 views

Beginners question about Send Relationship [duplicate]

I'm studying for the certification for email specialist but slightly confused by send relationship and how this is defined. I've always been under the impression that Subscriber key = Contact key. For ...
user avatar
0 votes
0 answers
16 views

How to push people from a Salesforce Campaign to Date Extention in Marketing Cloud

How to push people from a Salesforce Campaign to Date Extention in Marketing Cloud. We have a campaign with weekly updates members. We would like to be able easily push them to a data extention in ...
user avatar
1 vote
1 answer
102 views

How to get UpsertData function to insert data into the data extension?

On the landing page I have a form that is submitting and gathering all the RequestParameter values. When it gets to the UpsertData function it doesn't fire even the few values I have in the function ...
user avatar
  • 11
0 votes
0 answers
13 views

Rest API Search for Entry in Data Extension [duplicate]

I have been trying to search my data extension table to see if a record exists. But I am not able to unless the record has a Contract entry. I have been using the /contacts/v1/contacts/search endpoint ...
user avatar
  • 111
0 votes
1 answer
80 views

Messages sent from journey aren't being received and Email doesn't delivers to outlook

Hope you're having a good time. Recently, I've been facing an issue with journeys. I created a journey taking a data extension as an entry source to test email and messages send via journey. Emails ...
user avatar
0 votes
0 answers
78 views

Importing CSV with null values for phone into SFMC

I have a data extension where I have a field called telephone with a type phone. I have also set it to not required. The CSV which I'm using to import the data has no values in the telephone column. I ...
user avatar
  • 382
0 votes
0 answers
10 views

Rows.Retrieve() returning an empty array using SSJS? [duplicate]

EDIT Answer found here I am trying to just retrieve data from data extension According to this, I have to just use the Retrieve function without any filter My DE has 11 rows but all I get is an ...
user avatar
  • 159
0 votes
1 answer
33 views

Error Creating a row in an existing Data Extension in Sales Force Marketing Cloud through SOAP API

I want to add a new row into an existing data extension in SFMC using an API call, I tried using SOAP API, Following are the Error and API request message: Error : 400 Bad Request. Request URL : https:...
user avatar

1
2 3 4 5
28