ExactTarget - A data extension is a table within the application database that contains your data.
0
votes
1answer
6 views
How are bounces / unsubscribed handled?
How do unsubscribes and bounces get handled with email sends using data extension? Are unsubscribers removed from future email sends? What about hard bounces?
0
votes
1answer
31 views
Violation of PRIMARY KEY constraint. Cannot insert duplicate key
Getting error on the query and is below.
Email_Master primary key is 'Email Address' and thee target Data Extension primary key is also 'Email Address'. Can you help/advise what is the issue on the ...
2
votes
1answer
39 views
Not Opened Measure not returning records
I want to use Measures to return Subscribers that did not open a specific email.
I sent the email to 4 Subscribers and one of the Subscribers opened the email. I can see this in the tracking view:
...
1
vote
2answers
29 views
exporting Google sheets into SF Data Extension
my newsletter briefing is managed in google sheets (Links, prices etc.) and I would like to export these data directly into the data extension (UTF8) without c&p, converting and importing.
...
0
votes
1answer
24 views
Within a Journey, insert a record for the Contact into another DataExtension based on a Decision Split
I would like to insert a record for a Contact into another DataExtension based on a Decision Split within a Journey.
I do not see any documentation stating this is possible, and I havent found any ...
4
votes
0answers
34 views
Custom Activity on Marketing Cloud absolutely dynamic
I'm doing a custom activity and would need to be able to get the value of any field of the data extension input in the journey.
At this moment my custom activity is prepared to receive the value of ...
0
votes
1answer
23 views
javascript:void(0) when using %%view_email_url%% for view email link
We ran into an issue when sending out emails. Previously this function used to work fine and now we are experiencing issues with the %%view_email_url%% function.
Before it succesfully rendered the ...
1
vote
0answers
14 views
Setting non-nullable fields on Synchronized Data Extensions
I need to do an attribute-to-attribute comparison as part of a Decision Split (Journey Builder). One of the attributes happens to be from a Synchronized Data Extension (Sales Cloud source). Apparently ...
0
votes
1answer
24 views
SOAP API, Create Data Extension in a specific Business Unit
I am able to create a data extension using PHP, but only in the parent account. I know how to target different folders, but I need to create the data extension in a specific Business Unit. How can ...
1
vote
1answer
22 views
Access list of bounced and undeliverable in Data Extension
In SFMC Email Studio I have Master Data Extension used to construct many other data extensions. When I open details for my Master DE and select Tracking tab I see the pie chart with four categories: ...
0
votes
1answer
19 views
How would I cleanly pull data from a second Data Extension that doesn;t use subscriber ID?
We're developing several automated sends that are going to use copy that's populated to certain criteria. The user data is indicated in the main sendable Data Extension, but based on a pre sale or ...
1
vote
1answer
36 views
Duplicates in Marketing cloud API (POST /interaction/v1/events)
Hi I am triggering a journey using Marketing Cloud "Fire the Event" API. As this API adds data into the data extension which eventually triggers the configured journeys.
If my primary key is unique, ...
1
vote
0answers
29 views
Data Extension Import CSV Error
I have been having issues lately getting a CSV File to import into a Data Extension. The initial error was that the Array Index was out of bounds - like the field counts were off.
So, I created a ...
1
vote
1answer
105 views
How to write a SQL query with dynamic fields?
For example, I have a DE table(DE_A) with field a, b, c, d. The client may add e,f,g in the future due to their needs.
My current SQL Query activity is :
SELECT CONCAT("prefix", a) AS a, CONCAT(b, "...
0
votes
0answers
30 views
The Data Extension name for a LookupOrderedRows function call is invalid. A Data Extension of this name does not exist
I got this error:
The Data Extension name for a LookupOrderedRows function call is invalid. A Data Extension of this name does not exist.
Data Extension Name: ProductSale_POC
Function Call: ...
0
votes
1answer
29 views
Journey Builder Activity behaving different based upon Entry Event
I have an package in Marketing Cloud that adds a custom Activity to Journey Builder. Upon notification to my Activity that a contact has enter the step, my App reaches back out to Marketing Cloud to ...
0
votes
1answer
37 views
Can I pull DISTINCT customers with SQL based on most recent row record only?
So, I have a data extension where data is being saved.
My data extension (CustomerSourceDE) looks something like this:
Id (text) NULLABLE
Email (Email) NULLABLE
Customer_FirstName (Text) NULLABLE
...
0
votes
1answer
45 views
SSJS Functions in Automation Studio
I am trying to create a Data Extension using SSJS Script through Automation Studio.
My script is as follows:
<script runat="server">
platform.load("core","1.1");
var deObj = {
...
0
votes
1answer
46 views
AMPScript : A Data Extension of this name does not exist
I want to retrieve informations in a Data Extension synchronised with an event (object) on a preprod environnement to make custom fields on an email :
and my targets for the email are like this :
I ...
0
votes
1answer
38 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
1answer
14 views
Import adding quotes around address value
I've imported a file into a data extension and one of the fields is for ADDRESS in the file there are no quotes but when I import and look at the data extension the output reads ("123 N Main St.")
...
1
vote
1answer
43 views
How do I update 1 DE based on data in 2nd DE?
I'm fairly new with SQL. I have 2 data extensions. DE1 is a list of email addresses and changes each day. DE2 is for counting how many times each address appears in DE1.
So, my question is, how ...
0
votes
1answer
55 views
Inserting rows to a DataExtension via API
I've been trying for the last couple of hours to insert some rows into one of my Data Extensions in Marketing Cloud, which looks like this:
According to the documentation, I would just have to call ...
0
votes
1answer
95 views
Issues with Email Send on a DE, says 0 Emails Sent
I am trying an Email Send through Email Studio on a Sendable DE which has 2 sample records. My email send completes successfully and when I check the status under tracking, it says Completed but "0 ...
0
votes
1answer
85 views
Marketing Cloud - Can I pull in data from a data extension other than the one I'm sending to?
I have two data extensions.
Data extension A has a record for each quote created via our website in the last 24 hours. There may be multiple records per email address, if the user has elected to ...
0
votes
1answer
39 views
Triggered Send Data Extension doesn't populate
I'm trying to populate the Triggered Send Data Extension with more than just SubscriberKey, EmailAddress, SObject and RecordId.
My AmpScript looks like this:
%%[
/* Retrieves Fields from ...
0
votes
2answers
70 views
Marketing Cloud - why is this SSJS failing to insert a data extension?
Basically I am trying to write some SSJS that can clone the structure of DEs which is necessary in my role as a consultant and when I'm attempting to pull data out of a synchronized DE.
I've got the ...
1
vote
1answer
32 views
Counting records by sql query and saving the all counts in one data extensions in different columns
So, I have two data extensions and I want to calculate count in 3rd data extension in each individual column.
My DE 1 (included all Emails of customers)
My DE 2 (included all Emails and Status of ...
-1
votes
1answer
47 views
Parse XML values from a column in the DE?
I'm new with XML in SFMC, and I'm not sure if someone tried to execute the type of scenario, but I'm stuck with understanding the process of parse an XML payload form inside the SMFC. Is it even ...
1
vote
0answers
34 views
Retrieve the list of tracking on a Data Extension via REST
I'm trying to make an API call to, if possible, have the JobID of all sends done on this Data Extension. Is there a way to get the list of tracking on a data extension via REST API ? When you are on ...
0
votes
1answer
83 views
Journey Builder Entry Event update is not working
My web application is communicating with Salesforce Cloud databases.
In Exact target, I've created one Journey Builder with actions as created and updated.
When lead gets created in SFDC, Exact ...
1
vote
1answer
27 views
Activate journey after DE get new records
How can I activatee a journey each time my DE has new records? I already built something like this using the schedule time, but on this time I will need the run the journey immediatly each time my DE ...
0
votes
0answers
18 views
Deleting data extensions over multiple BUs using SOAP
I want to delete several DEs using this SOAP request. However, the DEs are spread over multiple business units. Is that possible to do using the SOAP request?
1
vote
1answer
46 views
What's the relationship between Sendable Data Extension and billable contact count?
If a Data extension in Marketing Cloud is marked as Sendable Data Extension, does this mean all the records within this sendable data extension will be calculated as billable contacts?
1
vote
1answer
24 views
Filtering the email tracking dashboard based on value in DE
I am sending out one email template in different languages to my subscribers (the language is based on a "Language" Field in a DE, and with some simple AmpScript logic I display the correct language ...
0
votes
0answers
46 views
Concurrency violation: the UpdateCommand affected 0 of the expected 1 records
I have developed a Rails app with FuelSDK-Ruby gem which will create / update the Data Extension records in Marketing Cloud.
On updating the records in Data Extension, Marketing Cloud responds with ...
0
votes
1answer
32 views
How I can insert my HTML textbox value in marketing cloud data extension
I have to save the Kaltura Video current time embed in landing page to marketing cloud data extension. I can fetch the current time through Evaluate function while closing the window like below but ...
0
votes
1answer
28 views
Data Views Data Extension Copy
Is there a way to replicate the system data views as standard data extensions? I'd rather not build each one of these. Use case is that I need to keep this data longer than the 6 months data ...
1
vote
1answer
67 views
Exclusion List in Journey Builder
I've set up a journey in Journey Builder however I want to exclude a list of customers. When sending an email from Content Builder it allows me to exclude and suppress lists but this option is not ...
1
vote
0answers
11 views
Import Activity locking file before import starts
I have created an automation that has an Import Activity from my SFTP. What we have noticed is that the automation seems to have been writing over the file prior to the automation running (it's set to ...
0
votes
1answer
36 views
How to clone a Synchronised DE
I am syncing a bunch of objects from our SF instance into our SFMC instance in the top level BU using MC connect. I now need to clone these Synchronised DE's into the child BU's so that I can provide ...
2
votes
1answer
31 views
Finding MIN(1) date in a data extension - error message about aggregate functions
I'm currently trying to find a list of email Addresses with a particular date in a data extension. The data extension can contain multiple instances of the same email address, but with different dates ...
0
votes
1answer
37 views
Marketing Cloud - Synchronization [closed]
ow to know if how long does Marketing Cloud unsubscribe status change for a specific contact? Is there a settings wherein we can input synchronization of the data from Salesforce to Marketing Cloud?
0
votes
1answer
31 views
In journey builder add contacts to data extension when clicking
I am using journey builder, and ideally want those users that click on a link within my email to be dropped into another data extension that can then be using as the audience for a new journey.
Is ...
0
votes
1answer
44 views
Why is my UpdateDE function in AMPscript not working?
I'm sending a mail using automation studio. In the mail content I included this line of AMPscript:
UpdateDE('Orders',1,'FactSalesHeaderSurrkey',FactSalesHeaderSurrkey,'InvoiceSentDate',NOW())
After ...
0
votes
1answer
48 views
Is it possible to create a Data Extension in a custom Activity?
I'm a beginner in marketing cloud and Journey Builder dev, so sorry if the question seems stupid but I'm struggling on a little problem, I would like to know if in a custom activity, running with ...
3
votes
0answers
45 views
Journey Data Configuration Questions [closed]
I am helping a client address a few journey optimization issues, and would like some guidance on 2 items I'm working through.
SFDC Triggered Entry Journey DE: I understand with SFDC triggered ...
-1
votes
1answer
35 views
MK Cloud - Limit Records - SQL Activity
I will need to send a quantity of emails each day and for this I'm trying to use LIMIT or ROWNUM function but none of this seems works in my SQL activity. Any suggestion how I can get only e.g 5 ...
0
votes
1answer
29 views
Marketing Cloud - Contact Delete - does SFMC remember?
In January my company had a subscriber purge by getting rid of lots of subscribers we no longer email/unsubscribed long ago.
Most of our data is held primarily in a SAS platform and we receive ...
1
vote
2answers
57 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 ...
