Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,338
questions
1
vote
1answer
41 views
MC query dedupes records automatically
I've noticed some quite odd behavior from running queries in automation studio.
Below is the query in question:
SELECT C.id
, CM.id
FROM ent.CampignMember_Salesforce CM
JOIN ent.Contact_Salesforce C
...
1
vote
0answers
24 views
On what basis does 'Evaluate new records only' in Journey evaluate new records added to DE?
I have a journey and the sendable DE used for the journey looks like this,
EmailAddress
CUSTOMER_ID
Send_Date
sub_category
Unique_key - PRIMARY KEY
The automation runs everyday & appends new ...
0
votes
1answer
23 views
Are there any Salesforce Marketing Cloud logs available which show the start/end times for synchronised data extensions?
I currently have synchronised data extensions set up to pull data from Salesforce into Salesforce Marketing Cloud. I'm trying to ascertain whether I can move the sync frequency of one of those ...
0
votes
1answer
34 views
'Field Not Found' and 'Required Field' Error Importing CSV to Data Extension
I just tried importing a .CSV file to a Data Extension (there are only 3 rows as I'm doing a test), but I keep getting an error. My CSV files have the right headers that can be mapped, so I'm not sure ...
0
votes
1answer
35 views
Inserting row in Data extension using REST API
I'm unable to add data to Data extension using API. I tried multiple times from postman, however I'm getting same error. I'm I missing something here?
{
"documentation": "https://...
0
votes
1answer
13 views
Possible Bug - Business Unit Subscriber Status Data View has no records?
The BusinessUnitUnsubscribes Data View which is meant to contain the unsubscribe reason has no records.
SELECT
COUNT(*) AS count
FROM
[_BusinessUnitUnsubscribes] AS bu
Returns 0.
Is this data ...
0
votes
1answer
22 views
Considerations while using Non-English [say Chinese, Japanese] field names in Data Extension
I tried to create a DE with field with Non-English [Japanese characters]
Found NO issue creating Data Extension
Found NO issue while exporting manually from DE records tab.
Found NO issue while ...
0
votes
0answers
19 views
getting (Error 70003) "Unable to retrieve Data Extension using CustomerKey" when calling soap api
I'm trying to do an insert into a Data Extension but I'm always getting (Error 70003) "Unable to retrieve Data Extension using CustomerKey" event though the CustomerKey is correct
this is my ...
0
votes
1answer
50 views
Rows.update data extension function
What is the error in this code:
<script runat="server" language="JavaScript" executioncontexttype="get">
Platform.Load("Core", "1.1");
...
0
votes
0answers
26 views
InsertDE to UpsertDE Syntax changes help
I am not fully confident with my dev abilities and am attempting to change some code to populate a DE with UpsertDE logic instead of InsertDE.
I have the following being used for InsertDE, and need ...
0
votes
0answers
25 views
ssjs not retrieving DE records
I was able to retrieve the records from a DE in one of the SFMC account but is not working for other account.
Is there something else to be included in below ssjs code?
<script runat="server&...
0
votes
1answer
17 views
How to use encrypted subscriber_key from abandoned cart DE in journey?
Abandoned cart configuration has been setup in Marketing cloud.
Tracking code has been added in the website and all the necessary implementations are carried out on Marketing cloud end.
Behavioral ...
0
votes
1answer
37 views
New SQL activity for No Clicks or Opens
I have this task to build a new query activity for subscribers who didn't open or clicked in any of the newsletters our company have been sent.
The following SQL query is what I've written down, and ...
0
votes
1answer
39 views
how to get records from data extension with matching user's resident id in lookup platform function [closed]
I have a data extension with columns:
resident_id
preference_name
preference_value
here preference value is a boolean field.
I am using lookup function to get preference_value with matching user's ...
0
votes
0answers
17 views
SMS has sent the user ID to be written into DE
We are using cloudpage to track SMS. We use cloudpage to track which users have clicked the link in the sending SMS. If the user has clicked, we will write the user information into a new De. We use ...
0
votes
1answer
24 views
Find attribute relates to subscriber on Subscriber Key
I have been trying to find a way to get the attribute in each custom data extension that relates to subscriber on Subscriber Key.
I was trying to use SOAP API according to the code below. But, I did ...
1
vote
1answer
22 views
Can't display my rows from my data extensions?
I have two data extensions, books & subscribers
I am trying to extract the list of books as well as the name of the user assigned to each book via the id ( subscriber id )
This is my code :
<...
3
votes
1answer
53 views
Marketing Cloud - API - Data Extension - Filter by Date
I'm retrieving values from a Data Extension using the GET method on
https://[YOUR SUBDOMAIN].rest.marketingcloudapis.com/data/v1/customobjectdata/key/[EXTERNAL_KEY]/rowset
without any filter the ...
0
votes
0answers
21 views
Custom Activity - Data Extension - External Key
I'm developing a custom activity and need to get the external key of the Data Extension used as Data Source. Is there a way to do so?
At this point I'm able to get the info of the schema
connection....
1
vote
0answers
36 views
Error from Rows.Add
I have the following script that returns the array as expected. When I go to add the "Rows.Add" aspect, I get a 500 error. I am testing the script on a cloudpage with plans to move it to an ...
0
votes
1answer
41 views
Loading a nullable column with a UTF-8 formatted file
I am trying to determine how to send null data to a numeric column with a UTF-8 formatted file.
When that same column was sent across not in UTF-8 it loaded fine. Now I get an error "Invalid ...
0
votes
1answer
57 views
Unsubscribe data view Timed Out
I'm trying to get all the unsubs in MC with Unsub Data view, the query that I'm using :
select
j.JourneyName,
ja.ActivityName as 'EmailName',
su.EmailAddress,
u.SubscriberKey as 'ContactKey',
u....
1
vote
0answers
33 views
Count id in Data Extension and Upsert to another Data Extension using SSJS
This question might be a basic one but I am very new to SSJS so thank you for your understanding.
The data extension names JourneyA, JourneyB, JourneyC...infinity are the result of Journey Builder. ...
0
votes
0answers
34 views
Cannot Export a Data Extension to External SFTP Delivery Location in Marketing Cloud
I am trying to export a data extension (within Contact Builder/Email Studio) to an external SFTP site. The external SFTP site has been set up in File Locations for a long time. The only option I am ...
0
votes
1answer
34 views
SQL Joining Multiple Tables into a Data Extension [closed]
I have two Data Extensions with fields "MID" and "Total". And a third DataExtension with MID and Name. I want to make a NEW DataExtension that has these three tables joined into ...
1
vote
1answer
28 views
Journey Builder - Contact processed twice the amount more than the records in Data Extension
I have a decision split as the first action of a journey, however, I noticed that this step processed/created twice the amount of contacts than what's in the entry source data extension. Could anyone ...
0
votes
1answer
59 views
Query Activity - Merging Data Extensions with Different Column Names [closed]
I have a Data Extension called “Merged Data Extension Newsletter” that has fields called
“FirstName”, “LastName”, “Email”, and “Id”
I am using ID as the Primary Key.
I have another Data Extension ...
0
votes
1answer
41 views
Data Extension shows 0 record after successful import via Automation Studio
Background
We're running an external campaign, using SFTP transfer to import file from external to Marketing Cloud FTP location.
In Automation Studio, we have an "Import File" action to ...
2
votes
1answer
81 views
Update data extension after clicking link in SMS
I'm trying to create a cloudpage and call it into SMS through ampscript - when the user clicks the SMS link through SMS, the contact's phone number will be added to the data extension (and some other ...
3
votes
1answer
46 views
Retrieve updated data from Journey Builder EntryEvent (data Extension) in Custom Activity
We're building a Custom Activity that will send a push message to a external platform from Journey Builder. In usage of the Journey, a Emailactivity will update the Entry Event data extension, adding ...
0
votes
0answers
30 views
Can't send test emails in Journey Builder
These are the steps we are taking. We use either Lead ID or Contact ID as the Contact Key.
Email Studio > Interactions > Imports
using a report from Salesforce and importing records into a ...
1
vote
1answer
35 views
AMP Script - lookup if data extension exists in Salesforce SFDC
I have a form that after being filled in creates a data extension record. Based on data from that form I would like to trigger automation that would take an email provided in a form/DE, and check if a ...
4
votes
0answers
110 views
Adding Fields in a Data Extension leads to resetting retention policy
I am trying to add a 'CREATED_DATE' field with a default value of current date, in my existing Data extension using wsproxy. The code runs fine and the fields gets added, however the data extension ...
0
votes
1answer
44 views
SQL Query activity results with impossible records number
I have an issue with SQL Query activity / Query Studio where I am getting an incorrect number of records when I am trying to find the difference of records between 2 Data Extensions. I need to find ...
0
votes
1answer
52 views
Cross Apply in SFMC SQL Query Activity
SELECT
e.cust_id AS customer_id,
e.event_id AS event_id,
max(t.updatedON) as recent_timestamp
FROM
event_table AS e
INNER JOIN car AS c ON e.cust_id = c.cust_id and e.event_id = c.event_id
...
0
votes
1answer
94 views
Remove duplicates in Journey Builder
I was wondering if there is a way to remove duplicates in Journey Builder?
I'm looking at creating a welcome campaign via Journey Builder. Currently I have within my welcome email AMPscript which ...
1
vote
1answer
51 views
Report on User that added Contact to Marketing Cloud
I'd like to get a report/data extension/export of which Marketing Cloud user added a Contact.
I can see this on the All Subscribers interface in Email Studio ("Added By" column), but when I ...
0
votes
1answer
42 views
Disable submit button on Cloud Page using the Primary Key
Hope I can explain this right.
I would like to request assistance on how can I disable the submit button on the Cloud page form after submitting a duplicate email in which the email address is set as ...
1
vote
1answer
24 views
Update Field in All Subscribers DataView on Email Send
When we send emails to new leads that are stored inside a Data Extension, a record is created in All Subscribers with their EmailAddress and SubscriberKey. Our Data Extension contains extra fields ...
0
votes
1answer
34 views
Imported DE is not added onto All Subscriber
I have managed to import successfully the 2 records into DE (email, first name and last name). Then, I sent an email with this DE, the message indicates it successfully sent. However, the tracking ...
0
votes
1answer
25 views
Add Records button is missing in Data Extension - Records Page
The Add Records button is missing in Data Extension - Records Page. As per screenshot, there is only Import, Export and Clear Data button.
0
votes
0answers
37 views
Automate a Data Extension export and send via email
I have a team that does not have access to SFMC needing to view a DE within SFMC on a regular basis. Is there a way to automate an export of this DE on a daily basis and send to that team via email (...
0
votes
1answer
28 views
Knowing a Data Extension is Shared via the API
Does anyone know if it is possible to determine if a data extension has been shared via the API. I don't see any related properties for the Data Extension in the documentation and I don't see any ...
0
votes
2answers
112 views
500 error with insertData on CloudPages
I am trying to create a survey landing page in cloudpages that will pull data into an existing data extension with AMPscript, but I am getting a 500 server error when the AMPscript is in. I am working ...
0
votes
1answer
53 views
Create a Master DE of Subscribers in a Child BU
Hangup: We have four separate "master DE's" being imported from IT into our marketing child business unit, each segmenting customers a different way. There is overlap between the four.
Goal: ...
0
votes
1answer
61 views
How to send an email automatically to user when we enter them in DE
We want to send an email automatically to users when we enter them in DE.
We tried to do it using triggered send but unable to do like how and where should we write the logic.
0
votes
0answers
51 views
Violation of PRIMARY KEY constraint. Due to one of the DE's not including a subscriber key [duplicate]
SELECT
ob.SubscriberKey,
ob.EmailAddress,
ob.fname,
ob.Country,
ob.Language,
ob.fin_no,
dw.username,
dw.password,
fp.FirstOrderDate
FROM FP_Onboarding_Root AS ob
LEFT JOIN Active_FP_JP AS fp ON ...
0
votes
1answer
104 views
Remove subscribers from a journey data extension via an action in the journey itself
Please help me sort this issue.
Subscribers from 70 different countries are injected into a journey data extension via API originating from our Axapta ERP.
I can't control what is injected via Axapta.
...
0
votes
0answers
28 views
Ampscript in radio button [duplicate]
I want help in AMP script for below scenario:
I am using this radio button but in my Data Extension the data is not going, although the data of other fields are going except this radio button.
This is ...
1
vote
1answer
85 views
Is there an easy way to check if a specific data extension is used in journey builder, automation or trigger?
I'm looking to locate where a specific data extension is use in SFMC as I need to compile a list of journey, automation and trigger that is leveraging this DE. I don't want to have to manually open up ...
