Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,413
questions
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 ...
- 485
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 ...
- 3,224
-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. ...
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 ...
- 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 ...
- 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">
...
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 ...
- 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 ...
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 ...
- 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?
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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
...
- 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, ...
- 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 = [&...
- 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 ...
- 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 ...
- 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 = ...
- 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 ...
- 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 ...
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 ...
- 1
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), ...
- 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. ...
- 33
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 ...
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 (...
- 1
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 ...
- 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 ...
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 ...
- 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 - ...
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 ...
- 1
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 ...
- 1
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 ...
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 ...
- 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" ...
- 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 (&...
- 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 ...
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 ...
- 23
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 ...
- 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 ...
- 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 ...
- 21
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 ...
- 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 ...
- 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 ...
- 17
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 ...
- 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 ...
- 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 ...
- 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, ...
- 1
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 = ...
- 156