Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,101
questions
0
votes
0answers
36 views
Trying to update DE, getting “403 - Forbidden: Access is denied”
I am trying to update a DE in Marketing Cloud using the below CURL request but keep getting "403 - Forbidden: Access is denied." Can someone please help and advise why might be the issue here?
$ ...
0
votes
1answer
28 views
Create an Automation that imports data to a Data Extension depending on the file name on a sftp
I am trying to upload data into a Data Extension by uploading a CSV file to the sftp. An Automation should then compare the csv name with the Data Extension name and then upload it into that Data ...
0
votes
0answers
61 views
Error: Invalid column name '_CustomObjectKey'
Using Salesforce marketing cloud REST and SOAP API's retrieved metadata corresponding to DataExtension using DataExtensionField and want to retrieve the data in that DataExtension using ...
0
votes
0answers
26 views
Data disappears from master Data Extension
We have a master DE that we use to select records and to manage subscription status for newsletters (a boolean True/False for each one)... we've seen records simply vanish from the master DE and we ...
0
votes
1answer
25 views
Working with Sales Object and Data Extension
I am working on a form to add people to a contact object in Salesforce and update a data extension. I am checking to see if the email address exists in the Contacts object and update or inserting ...
-2
votes
1answer
26 views
Is it possible to merge Data from List and Data Extension via query in Marketing Cloud? [closed]
Is it possible to merge Data from List and Data Extension via query in Marketing Cloud?
I need to create a Data Extension with SubscriberKey from the list and FirstName from the Data Extension. Which ...
0
votes
0answers
27 views
Primarykeys in Data Extension Upsert REST API
I would like to know an alternative of using the PrimaryKey attribute row value that contains a colon character, the API returns the following error:
{
"message": "Parameter {primaryKeys} is invalid....
0
votes
1answer
24 views
Starting a journey with smart capture value submition but depending on the field value submitted [closed]
I have a data extension and a smart capture landing page which submits its value to that DE. Now I would like to trigger a journey when a user fills a form but the extra step would be to check if ...
0
votes
1answer
31 views
Using AMPScript to fill SubscriberKey in Smart Capture Form in Salesforce Marketing Cloud
I know I may be asking something very basic but I can´t get it to work.
I'm trying to fill the SubscriberKey field in the SmartCapture form with no success.
What I'm trying to do is use a Concat ...
0
votes
0answers
28 views
Sendable Data Extension not visibile among Entry source Journet
I have created a Sendable data extension which I would like to use as an entry source for a journey. the issue is that I can't see it when I click on SELECT DE. It appears a list of De (ex ...
0
votes
1answer
20 views
Data type not found in Data Extension creation
in a DE including products details, I have an attribute which include the url of the image of product.
I should choose the data type url (as it is in the related synchronized DE) but I can't find .
I ...
1
vote
3answers
29 views
Column SubscriberKey into a SendLogDE doesn't populate any data
I'm new with the SendLogDE but I have searched and found (What custom fields can I include in the SFMC send log? and https://trailhead.salesforce.com/es-MX/content/learn/modules/marketing-cloud-data-...
0
votes
1answer
49 views
Writing to two or more data extensions at once
I'm quite a newby at this (green)
I'm creating custom subscription center. I have two data extensions which I need to insert/upsert data to.
Newsletter_Subscribers (EmailAddress, FirstName, ...
0
votes
1answer
27 views
Is there a way to see the last send value in sendable data extensions in SFMC?
Is there a way in SFMC to know what is the last send value for the sendable Data Extensions? We want to clean up unused or old legacy sendable DEs. Thanks!
0
votes
0answers
25 views
Query with no error in synthax doens'tgive any result
I have written this query:
SELECT Client_Id__c, Abandoned_Cart_Id__c, Status__c, Total_Amount__c
FROM Abandoned_Cart__c_Salesforce
with Overwrite option.
and the synthax is correct.
The issue is ...
0
votes
1answer
34 views
Data Extension - Define Send Relationship [closed]
i'm creating a sendable data extension for creating a journey for sending order confirmation to clients and the primary key of this DE is the OrderID.
Is it correct if I select as Send relationship ...
0
votes
0answers
31 views
Error in query with Synch DE
I have synchronized two De from sales Cloud successfully and I'm now trying to run a query using them. I get an error message which tells they are unknown.
I wonder which can be the error causing ...
0
votes
0answers
26 views
SQL for creating a sendable DE from three DE
I have to create a sendable data extension, which joins three DE:
- Contacts DE
- Abandoned cart DE
- Cart Items DE
The three DE are linked in an attribute group.
I have written the query selecting ...
0
votes
2answers
47 views
Create data extension > define location
Does anyone know how to define the location for the data extension when using SOAP api to create a data extension?
0
votes
1answer
39 views
Customers that only made one order
I'm looking to write a SQL Query to get the Customers that made only one order after the first of March. So if they ordered twice after the first of March I want to exclude them.
I have the following ...
0
votes
0answers
17 views
For loop and insertData with ssjs
Anyone experience with using for loops to insert data into a data extension dynamically? I normal javascript I would use a forEach statement.
I have the following JSON array (retrieved using HTTPGet)
...
0
votes
2answers
38 views
Automate looking up data based on subscriberkey and populating a data extension with extended info
Based on the subscribers website interaction, my guy handling our website can send me two types of data:
SubscriberKey
RoomOfPreference.
I can have him add this data to a pick-up data extension via ...
0
votes
1answer
31 views
Ascending order date for each customer [duplicate]
I'm trying to see the order date in an ascending order for each customer and also how many order dates each customer has so I know how many times a customer has ordered.
I've tried order by date but ...
0
votes
0answers
20 views
How to save multiple subscribers in a list via FuelSDK-Node or how to send data from DE to a list quickly
These are actually two questions. But for me, it's enough to solve at least one of them.
Task:
deliver subscribers to a data extension and list from a remote source.
Requirements:
use FuelSDK-...
0
votes
1answer
22 views
“Old style JOIN (ANSI JOINs) syntax” error in a simple query without subqueries and joins
Validating the following query:
SELECT
GetDate() as Valid_From,
'Lorem Ipsum' as Filler
FROM
SampleSourceDE
shows this error:
An error occurred while checking the query syntax. ...
0
votes
2answers
28 views
User CRUD permission for content builder in marketing cloud
Is it possible in Marketing cloud to have folder-based user role for CRUD operations in both Email Content Builder and Data Extention as well? So, for example a user A will only have access to create ,...
0
votes
1answer
29 views
Using AMPscript to pull XML from DE
I'm trying to create an email that pulls XML from a field in a data extension but my ampscript knowledge is very limited.
The DE field that the XML is under is a text field called 'attribute' and ...
0
votes
2answers
46 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 ...
0
votes
1answer
22 views
UpdateSingleSalesforceObject with a Data Extension value
is it possibile to use the UpdateSingleSalesforceObject function in a Marketing Cloud Email activity in Journey Builder to update a SFDC record with a dynamic value retrieved from a MC Data Extension? ...
0
votes
0answers
30 views
Import Activity Issue
I am facing a very weired issue with my import activity. My client drops a file on FTP everyday with more than 100k records on daily basis. The import was working fine, until since few days it has ...
0
votes
1answer
33 views
Ampscript to change a certain value in a dynamic field
So our data team is passing a value in a data extension that they want to display as a dollar sign, e.g. "$0.499". However, when read in our email, it displays the HTML and not '$'. Is there ...
0
votes
1answer
23 views
Best way to log Journey Builder Email sends
Use Case
I need to make sure that I send a specific email only once to a subscriber via Journey Builder.
The Problem
The email is used in different journeys and I dont know where the subscriber will ...
0
votes
0answers
28 views
MC Connect with BU : Query synchronized data extensions / Salesforce data on Data designer
This is linked to the question : Filtered Data extensions or Data extensions fed with SQL queries to duplicate Synchronized DEs from CRM to share with child BUs?
It seems that we can query the ...
0
votes
2answers
43 views
Salesforce email Ampcript/conditions to display values from data extension
Data extension field: Subscription_Status
I want to write an inline ampscript in email, to say, if 'Sub_Item' is CH+, display "XYZ" and have multiple of these i.e., if 'Sub_Item' is D+, display "ABC" ...
0
votes
1answer
19 views
How to create a new Data Extension using Queries?
My goal is to use a master data extension which has all contacts regardless of the possibility of sending emails. So I would like to use Queries to filter this Data Extension and create a new one with ...
0
votes
1answer
57 views
Trying to add a new row to a “Shared Data Extension” using SSJS
I'm trying to add a new row to a Shared Data Extension using SSJS.
When I try to run my code I got this error:
"There was an error Adding the row(s)."
In another environment of Marketing cloud, the ...
0
votes
1answer
40 views
Lookup Rows Error in email Preview and Test
I am trying to do a LookupRows call to print all the values in a row on a data extension, based on the “TriggeredSendCustomerKey” value and print the results in an email. I have the following code ...
0
votes
1answer
32 views
How to Bypass High Water-Mark in Marketing Cloud Journey Builder
I need to design my Journey in a way that the same person can re-enter it multiple times. The Contact Entry settings of my Journey is already set to "Re-entry anytime" but I still can't make it work. ...
0
votes
0answers
26 views
Data Relationship Email
I'm trying to create an email that uses information from two data extension in which only one contains an email address. I've used the below HTML and have connected the two data extension in a data ...
0
votes
0answers
25 views
What exactly is BatchID in _Sent data view? [duplicate]
I am trying to identify unique identifier for email activities? I was thinking to use combination of SubscriberKey, JobId and EventDate as unique identifier but when we looked at historical email ...
0
votes
1answer
26 views
python SDK getMoreResults() doesn't retrieve any result
I am retrieving some DE rows that for sure have more results. The code:
client = FuelSdkClient(clientId) #FuelSdkClient is a def where I am instantiating a client through a specific account
row = ...
0
votes
2answers
42 views
calculate day difference between orders [closed]
I need to calculate the day difference between orders to be able to calculate the next prediction date of this order. I'm now focusing to find the day difference between orders. My assumption was to ...
0
votes
2answers
33 views
We have 2 records with the same SubscriberKey in a DE. How to track interaction data for each record?
The send is done in a journey so we were not able to differentiate between the records based on JOBID. I am aware that Batch ID does differ, but how to I map which batchID corresponds to what records ...
0
votes
1answer
26 views
Query All Subscribers for SubKey based on email address in DE
I have email addresses in a Data Extension and am trying to query All Subscribers to pull in their Subscriber Key. I wrote my Query, it validates, ran the SQL and it returned no records. Not sure ...
0
votes
1answer
25 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"
...
0
votes
1answer
53 views
ERROR: Query failed: Timeout SFMC
Anyone knows what is the cause of the error in my Stuff SQL?
i run the query many times and keep receiving this error.
This query will get all the ProductCode based on every customer and i want to ...
1
vote
2answers
38 views
How can I remove my company's email address from a data extension?
How can I remove my company's email addresses from a data extension? and add then to a new data extension. If I'm supposed to use a SQL query, can you help me with that?
I want to remove a few ...
1
vote
0answers
27 views
Exclude domains from sends on child business unit level [duplicate]
Working as a Marketing Cloud marketeer in a franchisee setup with 170 child business units I'd like for the franchisee marketeers for every child business unit to be able to always exclude certain ...
2
votes
1answer
43 views
Why is my click data view query not delivering the results I expect?
I'm working on a setup of individual journeys triggered by clicks on certain furniture aliases.
At the moment I have journeys starting when either of these aliases;
'WeLove_AlbaSidetable',
'...
0
votes
2answers
37 views
Can I update a DE that has no primary key using SJSS? What if there is truly a unique value it's just that no primary key was set originally?
My business partners want an Anniversary journey (based on when a consumer came into our Welcome journey).
The welcome journey is based on campaign data from SF since we do have the MC connector.
...
