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
1answer
32 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
41 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
29 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
23 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 ...
0
votes
1answer
14 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
32 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
23 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
25 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
25 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
49 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 ...
-3
votes
0answers
24 views

Display Message if Data Extension Exists on CloudPage or Smart Capture form [duplicate]

I'm using a Smart Capture form on a CloudPage to add users to a DE. Currently, if a user submits this form and is a new subscriber (no record exists in DE), then a journey kicks off sending this user ...
0
votes
1answer
41 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
53 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
46 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
45 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
26 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
40 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 ...
1
vote
1answer
39 views

Filtering by Date (Last 7 days) while editing data extension filter

My data extension has a date field stamped at a certain point in a journey and I need to filter it weekly to see who has been stamped in the last 7 days. I have tried a number of ways to configure the ...
1
vote
2answers
49 views

Joining SendLog and Click Data View does not return any results

I want pull out the list of customers that did not click on the mail we sent. We maintain a SendLog in which we have additional attributes logged (Example: emailname, subject etc.) I understand that ...
1
vote
1answer
41 views

DataExtension.Init doesn't work

Good day, friends! I have created DE in my BU (this is child BU). I can see it, it is available, I can add rows into it. But when I tried to use it in the script, it returns null rows. When I try: ...
0
votes
1answer
45 views

Automation SQL - get random value for each record [closed]

I need to populate some Data Extension using another Data Extension that contains all the accounts data. I want to attach a new column and the value for that column should be randomized from another ...
1
vote
1answer
26 views

Deleting contacts in data extension - Automation Studio

I was wondering if anyone has had any experience in using Automation Studio to delete contacts in a DE? Or, know of a better way? Essentially what I'm looking to do, is collect data using a Cloud Page ...
0
votes
2answers
41 views

Random Data Extensions: Need to split larger audience into 20 different DEs

As part of IP warming - I need to segment a Data Extension of 5 million users into roughly 20 segments, some of different values as we slowly warm the IP across the fist send through the user base. ...
3
votes
1answer
45 views

Can you change SFMC Subscriber Key w/o SF Support?

Do you need SFMC Support to change the current subscriber id field from one existing field to another, no data migration or changes. And if so, is this still considered a rekey? Context: We are ...
0
votes
1answer
26 views

Can we have more than 1 Sendlog DE for one of the triggered send email only?

We have a SendLog DE to which the data gets logged for all of the emails (triggered + user initiated). But I wish to create another sendlog DE only for one of the triggered send. Is it possible to ...
0
votes
1answer
27 views

Data Extension Caching - Ampscript personalisation storing test email addresses

Using AMPscript in one on my email campaigns, I'm pulling data together (from a DE) based on if a family/ single person share the same Policy Number. I then pull their SubscriberKey (ID), Relationship ...
0
votes
1answer
36 views

How to unsubscribe with a script activity in an automation?

I have a temporary data extension (will be updated daily) with subscribers need to be unsubscribed. It looks like this: SubscriberKey, EmailAddress and Status were queried from All Subscribers list (...
0
votes
2answers
43 views

Combining multiple rows of data into one email - Marketing Cloud

I'm having an issue trying to combine multiple rows into an email. As an example, I want to take the below data (Policy Data) and combine data where the policy number is the same and display that ...
0
votes
0answers
31 views

Can NOT query a subscriber by its subscriber key

I haven't queried data from the _Subscribers data view before and faced with that issue. Please correct me if I did something in a wrong way. At first, I created a temporary data extension with these ...
3
votes
0answers
92 views

Clarification for all Data Extensions' templates

I would like to clarify several Data Extensions templates since there is almost no documentation available. To be exact, I would like to know what are the use-cases and implementation steps for those ...
2
votes
0answers
40 views

Import External Database Data into Marketing Cloud [closed]

Hello Salesforce Stack Exchange Members, Is there a way to setup an integration from an external database (custom built CRM database built in FileMaker Pro) to import data into a Marketing Cloud Data ...
0
votes
1answer
22 views

Move data from synced Data extension to custom Data extension without duplicates [closed]

I want to move all records from synced data extensions to a new custom Data extension.There are so many duplicated records in synced DE. I want to copy the actual records (without duplicates) to new ...
0
votes
1answer
27 views

Pass field data from Datatable to dynamic combobox extension to set combobox selections based on current record data

I have a datatable that shows data from a record query on a specific object, it allows edits and it also has comboboxes for the multitude of picklists. Each combobox has the correct options for the ...
0
votes
1answer
44 views

Send Log Join with _Job, _Click , _Open Need help

I am using a send log feature to store the sent email details -- like Name, EmailAddress, issueDate, CertificateNumber. The send log already has JobID, ListID, BatchID,S ubId, TriggeredSendID, ...
0
votes
0answers
22 views

Trying to insert records in contact builder data extension

I've been racking my brains for a few days trying to use SSJS to insert records into a data extension that i created to do some tests. the data extension is located at audience studio, its called ...
0
votes
1answer
28 views

Increment numerical value in Data Extension for open count

We have a problem with open rate reporting through a third party platform when we create multi-language dynamic emails, which means that because we have one HTML template for all locales, SFMC will ...
1
vote
0answers
35 views

Updating a large batch of data in a DE without primary keys

I have an issue with a client, that I would like to know if anyone could help us with some kind of alternative solution. There is a client Data Extension with over 14 million records that we need to ...
0
votes
1answer
25 views

How to check multiple fields for NULL values in a lookup for exclusion script?

I am trying to prevent a send for records with null values in multiple fields. I know how to apply exclusion for a single field: EMPTY(LOOKUP("DE", "FirstName","EmailAddress&...
1
vote
1answer
25 views

Displaying nothing or default content in the event of no row match using AMPscript

I've got a data extension I'm storing content in for templated emails, then referencing the content using AMPscript as below: %%[ SET @MEMBER_EVENTS="MEMBER_EVENTS" SET @ITEM_1="...
0
votes
0answers
31 views

Lookup function working only for the referred DE

I wanted to pull nearest store details to customers in email. I have a DE with all necessary Store details along with the customer details mapped. To display the store details in an email, I used ...
0
votes
0answers
19 views

Creating a Filtered Data Extension from Account Record Type Filed in Sales Cloud?

I need to segment audiences in Marketing Cloud based on the Account Record Type in Sales Cloud. With the Contact Object and Account Object the Account Record Type field is not available in Marketing ...
0
votes
0answers
16 views

Retrieve only some fields of Data from data extension and filter uniq

I'm trying to retrieve data for some fields from a Data Extension in Marketing Cloud by API. I have a list of values that I use to filter the response. Is there a way to specify that the key_field ...
0
votes
2answers
52 views

Marketing Cloud Customer Journey builder limitations

I have 2 journeys. One is the welcome journey, and one is the post-purchase journey. We automatically opt-in all users who checkout. Unfortunately right now new all users who checkout with us are ...
0
votes
1answer
38 views

Journey Logging for more than one entrance

I want to log the step the person is at a given moment in the journey in Journey Builder with the use of the solution using Update Contact Activity. I've created a logging DE that includes the fields ...
0
votes
0answers
33 views

Create a Data Extension report with Data View and Journey information

My goal is to create a Data Extension (DE_Journeys_Report) that will contain a report of different Journeys, extracted from different Data Extensions. I need the following fields from the **Sent Data ...
0
votes
1answer
31 views

Are non-sendable DE's counted as contacts for billing purposes?

We are in the process of deploying SFMC for our company and need to refer to minor data for our email sends (emailing parents of minors), but do not plan to actually email these minor contacts. To ...
0
votes
0answers
28 views

Having issues performing an import definition

So i'm having issues performing an import definition. I followed the directions here: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/...
0
votes
0answers
24 views

FilterPart in Python Zeep

I am trying to extract data using Python Zeep module from SF DataExtention.Can anyone please help me to write the correct dictionary for Filterpart of Retrieve request. I am trying to pass the ...
0
votes
1answer
21 views

Ingesting data in data extension using REST API in C#

Hi I need to ingest data from my backend to the SFMC Marketing cloud application data extension. While triggering from postman it is giving me different error but when I do the same using C# it gives ...
1
vote
1answer
62 views

How to populate a Data Extension with click data for the last 2 years

I'd like to query the open, click and sent data views to ultimately find who has never opened or clicked a mail (since May 2019) and how many mails they've been sent (since May 2019) I understand ...

1
2 3 4 5
27