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
1 answer
23 views

Different datetime formats within the same data extension in Marketing Cloud

In Marketing Cloud I have a data extension that holds vouchers. When these vouchers are claimed the field ClaimedDate is updated with the date and time of the voucher being claimed using this ...
user avatar
0 votes
1 answer
35 views

Unable to delete an attribute from a Data Extension

When trying to remove the attribute, I get a pop-up with the text: You cannot delete any attributes used in existing data relationships before removing those relationships. Use Data Designer to ...
user avatar
-1 votes
0 answers
30 views

How would I add a specific URL to a Data Exchange, then have it show up in the email on Journey Builder? [closed]

I have a list of 10,000 people I want to send on through Journey Builder. And of that there are 17 different URLs between the 10,000 people. I have an excel list of the people and the respected URLs. ...
user avatar
0 votes
0 answers
20 views

How to copy contacts from Data Extension to Publication List manually?

I have a Data extension with emails and would like to use publications list with it. I tried creating a Safehouse in FTP and do transfer file activity, but it just doesn't work - saying I don't have a ...
user avatar
  • 1
0 votes
1 answer
16 views

Edit content stored into a Data Extension when journey is active

I launched a dynamic email this morning but the client notice a typo error in the content. The copy is stored in a Data Extension (that is not my entry source) and I do a lookup in my email. Can I ...
user avatar
  • 1
2 votes
1 answer
36 views

SSJS to AMPScript Failing DataExtensionRowCount

I'm having an issue, i can execute AMPscript within SSJS by placing my ampscript code within a Content Block and then using SSJS to execute it by using: <script runat="server"> ...
user avatar
1 vote
2 answers
51 views

Access shared data extension from child BU using SSJS

I am trying to access the value from a Data extension, using the below code. The code works fine if I pass the external key of the regular data extension. But when I pass the value of the shared data ...
user avatar
  • 11
0 votes
1 answer
62 views

Sending emails to the same address via Journey

I have several records which have same emails address. When I launch my journey, just only for one record email sends, for others - journey show 'error'. How can I send emails for all records with ...
user avatar
0 votes
0 answers
38 views

Issue in inserting data into Data Extension using with Rows.Add() in SSJS

I have the following string for example, var string1 = '{"name":"Annie", "age:"18"},{"name":"ben", "age":"18"}'; I want to ...
user avatar
  • 1
0 votes
1 answer
53 views

How SendLog can capture sent event date?

I am looking into the current SentLog and not seeing any date like Send date. How can I get / capture sent event date in send log?
user avatar
  • 141
0 votes
1 answer
70 views

How to display records from a data extension on a cloud page

I am trying to display some records from data extension on a cloud page. This is what I got so far but cloud page is showing nothing. Note: "LU" is a field in my data extension with value 1 ...
user avatar
  • 141
0 votes
0 answers
22 views

Send email from journey builder to specific address

I would like to know how I can send an email to a specific email address via journey builder not from single send but through multi-step. Here is an example: data from the date extension goes through ...
user avatar
  • 13
0 votes
1 answer
42 views

Journey Builder - Engagement split with dynamic link [closed]

I'm creating a journey and I wanted to use a split engagement on people who have or have not clicked on a certain link. However, the link I wanted to track is unique to the individuals and gets pulled ...
user avatar
  • 13
0 votes
0 answers
29 views

Using one data extension for journeys and contact updates via API

Would it be a good practice (looking at performance) to setup one Data Extension that stores all contacts/Subscribers (including 20 attributes) and to let this Data Extension be updated via REST API ...
user avatar
  • 1
0 votes
0 answers
20 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 ...
user avatar
  • 13
0 votes
0 answers
24 views

Track mailto links in Journey Builder [duplicate]

I'm building a journey and I wanted one of my engagement splits to be based on if someone clinks on a button which is linked using a mailto email address. But I have notice it doesn't pick that up, ...
user avatar
  • 13
0 votes
1 answer
36 views

Performing a record retrieval via WSProxy in SSJS

In my data extension, I have two fields / columns: JobID DE_NAME In this use case i want to receive the value for JobID and DE_NAME (1st row only) var queryAllAccounts = true; var cols = [&...
user avatar
  • 141
0 votes
1 answer
78 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 ...
user avatar
  • 141
1 vote
1 answer
72 views

How to get table name from another table in select query in SFMC

In my sql in SFMC i am trying to get table name from another table in SELECT query but it seems to be not working, considering declaring variables in not allowed in SFMC SQL I have tried this but no ...
user avatar
  • 141
0 votes
1 answer
61 views

How to target a retrieved data extension in a FOR LOOP while using WSProxy

Currently, I am using the following approach to define my Data Extension Platform.Load("core","1"); // instantiate the WSProxy object to make API calls var api = ...
user avatar
  • 141
0 votes
2 answers
66 views

How to add personalization string _DataSourceName to SendLog in SFMC

We have a sendlog enabled for our account to capture all sends from all BUs. In the SendLog DE, in past we added the personalization string %%emailname_%% to capture emailname as well (of course ...
user avatar
  • 141
0 votes
2 answers
50 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
28 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
49 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
20 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
45 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
114 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
113 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
  • 186
0 votes
1 answer
55 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
59 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,171
0 votes
1 answer
61 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
92 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
191 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
22 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
56 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
80 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
36 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
28 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
86 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
41 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
34 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
37 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
123 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,171
0 votes
1 answer
53 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
87 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
46 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
115 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
96 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
  • 13
0 votes
0 answers
79 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
130 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
  • 156

1
2 3 4 5
29