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
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. ...

1
2 3 4 5
23