Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,288
questions
0
votes
0answers
17 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
26 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
22 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
14 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
17 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
44 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 ...
0
votes
1answer
28 views
Bulk insert/update Data extension using SSJS marketing cloud
I have a REST request which gives me a large volume of data in the response. I am able to Platform.Function.ParseJSON which gives me an Array list.
The array size is close to 40 odd rows. Each row has ...
0
votes
0answers
12 views
Data is not added in Data Extension using Smart Capture
I am trying to test the Smart Capture but the data is not updated in DE.
I created the DE - "Smart_Capture_Form" using the Smart capture template.
Created the Landing Page and drag the ...
0
votes
1answer
28 views
Use multiple data extensions for dynamic content in Email Studio
My marketing users have an existing data extension that they want to continue using when creating emails. We are implementing a new integration that will provide 15 new data points. It's my feeling ...
0
votes
0answers
22 views
Issue with creating a sendable data extension via fuel SDK C#
I keep getting the error, "The SendableSubscriberField field cannot be blank", even though my SendableSubscriberField is not blank
here's my code:
ETDataExtensionColumn deField = new ...
0
votes
0answers
26 views
Update contact from Salesforce Entry Data Extension
Im trying to update a Salesforce Data Extension that has composite attributes like "Lead:Id"
Im using this doc but i reviece this error
I tried to put the id like this : /hub/v1/dataevents/...
0
votes
1answer
35 views
Marketing Cloud - Failed Email Sends
I created a new Data Extension and inserted new contacts on it by importing data from a CSV file. All the data was imported correctly to the DE (300.000 contacts), but when I sent an email to that DE ...
0
votes
1answer
48 views
Can you use 2 DE's in one journey - one as the Entry Source and another to populate a dynamic content block in the email?
I am building an email journey for 10% off when you sign up on an online shop. I have 1 DE with the contacts email address, name and subscriber key and another with the unique 10% off code - which ...
0
votes
1answer
34 views
Adding a measure to a filtered data extension
I am trying to add a Measure to an existing filtered data extension, i basically want to send an email but exclude people who received 2 jobId's in Marketing Cloud. I've tried everything :(
0
votes
2answers
31 views
Specific Benefits of Using Date Column Type in Marketing Cloud
What are the pros/cons to using the Date field in Marketing Cloud opposed to just leaving it a text field? Will comparisons work the same? Will there be issues down the road if it is a text field and ...
0
votes
0answers
29 views
Contact with multiple entries in Journey Builder
I have a journey that sends an sms reminder to customers 48 hours before their appointment, using a data extension populated by an automation. The appointment information is stored on an custom ...
0
votes
1answer
38 views
Follow-up— Retrieve SFMC Data Extension Rows, by fieldname
Follow-up to a similar question. I'd like to be able to access the rows[i] by field name, and saw something similar in another example, but I couldn't get it to work. In the code below, SubscriberKey1 ...
2
votes
1answer
34 views
SQL: How to get the right SUM of two different columns from two different data extensions into one new DE
I have the following tables:
In the third table I want to combine these data with the SUM option in SQL so the total of clicks and Sends are in one field. Like this:
I created the following query:
...
0
votes
0answers
13 views
Can you help me to understand what does 'Last Refreshed' indicates in Data Extension in Contact Builder in Marketing Cloud?
What does 'Last refreshed' indicates in Data Extension in Contact Builder? Is it last time the records are updated/added to the DE or any changes made to the DE like adding new attributes?
Am having a ...
0
votes
0answers
32 views
Creating a new Child Business Unit(BU) in order to given access to shared DE for Email Developer
We have a single Business Unit (BU) for our organisation.
We are working with some external agency who design email templates for us.
We want to give them access only to 4 Data Extension and not other ...
1
vote
1answer
34 views
Send SMS messages to a Salesforce data extension
We are storing our audiences into a Salesforce DE, and we would like to use the same audiences for our SMS messages.
However, when we want to select an audience in MobileConnect, we don't have access ...
0
votes
2answers
63 views
How would I retrieve data from one data extension and add it to another Data Extension? [closed]
SourceCodes are fields we assign to each email. They correspond to the email name. I need to retrieve the SourceCodes from Data Extension One (our source DE used for sending) and append them to the ...
0
votes
1answer
56 views
Is it possible to automate reports in Marketing Cloud?
I need an automated solution for generating an account send summary. It would be ideal to send this data to a data extension. I tried to accomplish this using a tracking extract but it doesn't provide ...
0
votes
0answers
9 views
Does an Audience Refresh update the data extension?
Hi I'm new to salesforce and attempting to learn on the fly.
When I do an audience refresh on an audience list, does this also update the corresponding data extension or just the facebook audience ...
0
votes
1answer
28 views
Salesforce Data Extension Behavior
Scenario:
I created an email that displays different content based on the contact's "Mailing Country". The email is sent to a Salesforce Data Extension using a Salesforce Send Email ...
0
votes
0answers
15 views
Creating Measure and then applying it as a filter on Data Extension- for people whose last click is more than 90 days
For a DE, I want to add a filter - customer whose last click is > 90 days
Hence First I created a measure - Like in the attached image
Then added that measure as a Filters for DE- as in second ...
0
votes
0answers
17 views
Filter based on RecordTypeId (RecordTypeId not showing in fields) - Marketing cCloud
Our objective is simply to have a filter in the Root Parent BU based on RecordTypeId to copy (filter) records from the Salesforce Synced DEs to a another DE.
The result of that filtered DE will be ...
0
votes
1answer
67 views
Email Address As SubscriberKey in SFMC [closed]
Can you please tell me what are the main arguments against using Email Address as Subscriber Key in SFMC? I have been getting requests from our internal stakeholders to use the email as Subscriber Key ...
1
vote
1answer
27 views
Data Extension or Data Export log
I would like to see who has been exporting data from our data extensions in the past year but I am not sure if this functionality is available in Marketing Cloud.
I have tried with Audit Trail (I have ...
0
votes
1answer
59 views
How to store Journey Report into a Data Extension
I have a Journey through which I am sending emails. I can extract the journey report from Analytics Builder (as a Excel file). Where is this report data stored in SFMC ? Can I access this data in a ...
0
votes
1answer
43 views
Unable to get percentage value in SQL Marketing cloud
Everyone
The below query is working fine without bounce_rate condition. When I am adding the bounce_rate it is throwing an error. Anyone please suggest on this.
SELECT
j.emailname, j.emailsubject, s....
0
votes
0answers
45 views
Adding Custom Field to Cart Page in B2B Commerce
I am trying extend the Cart Data Provider and I am having a bit of trouble. I need to pass a custom field to the Cart page. I am able to get custom fields to show up when I extend the Product Data ...
0
votes
3answers
71 views
ClaimRowValue In SSJS alternative [closed]
Is there an alternative to the ClaimRowValue function in SSJS?
this code in AMPScript
%%[
var @couponRow
var @couponCode
var @CustomerID
set @CustomerID = AttributeValue("CustomerID")
set @...
0
votes
2answers
29 views
How to remove records which only have a street number and not a street name in the field of a data extension
Thank you in advance!
Wanting to know the best way in Marketing Cloud to remove records in a data extension that only have a number under the street address field rather than a number and the actual ...
2
votes
2answers
112 views
Data Extension - Date record written
I would like to know when each record in my Data Extension was inserted.
Is there is a system level way of doing that?
I'm aware that I can add a field to do this that will add the system date at the ...
0
votes
1answer
39 views
Data Extension Name vs External Key
The Name identifies the DE in the system whereas the External Key within the scope of API calls. Is there any reason to not give them the same exact value? Anything i am missing about Name vs External ...
0
votes
0answers
13 views
Seeing error when trying to run Salesforce Report import for Marketing Cloud
I'm seeing Warning (Exception: Import Exception: Could not query report id
Has anyone come across this error before? I have Marketing Cloud Connect in place and everything appears to be working ...
1
vote
2answers
54 views
Birthday Journey with no event entry source [closed]
I´m solutioning a Birthday journey and was wondering if this idea will work before running it by my client.
Entry source: DE_[Tier]_BirthdayJourney
This DE is populated by an SQL query that runs ...
1
vote
1answer
14 views
Is there a remaining duration of the profile data in the IGO_Profile?
do someone know if there is a remaining duration of the profile data in the IGO_Profile. Will the data be deleted after a certain period of time? Unfortunately, I haven't found anything.
Thank you for ...
-1
votes
1answer
29 views
I have form which takes huge texts equivalent to 4000 chars how to upload them into sfmc DE [closed]
I have a form that takes input of huge length of data equivalent to 4000 chars in both the fields, what would be the best way to insert them into a sfmc data extension ?
0
votes
1answer
21 views
Can Data Retention Settings delete only SOME records?
I have consulted this documentation and this documentation and this Trailhead material, but I can't find a concrete answer on this. If I use Data Retention, can I configure it so that it only deletes ...
1
vote
0answers
21 views
Change Marketing Cloud Import associated to a Data Extension
Background: My team has created 16 different Imports in Marketing Cloud to pull in data from 16 different Sales Cloud reports. Each report is tied to a unique SF campaign. Let's call these items v1.
...
0
votes
0answers
34 views
Use {{each}} dataobject tag inside a drag and drop content block - I get one extra set of content
I get a json array into a single field in a DE. I am then using dataobject tags to get each tag out and render it in an email.
I am using drag and drop content blocks to make it easy for end-users to ...
0
votes
1answer
85 views
ValidationErrors: Field Not Found
I am trying to upload CSV file in my DE, which have 5 fields. On successful importing I have received following mail .
The following import has completed with validation errors Friday, February 12, ...
1
vote
1answer
23 views
SQL Query to Combine Duplicates into New DE
I am having a hard time creating a query that takes duplicate leads located in the same Data Extension but are separated by the SW Tag field which breaks them into another row. I would like to combine ...
0
votes
1answer
32 views
how to extract all click counts per url or link name for specific jobs using data views?
I would like to use data view _CLICK to extract all a list of all clicked URLs along with the count (how many unique subscribers clicked on the link) for specific job ids.
Can anyone help me with the ...
1
vote
2answers
101 views
how to make sure update contact step in journey builder honors primary key?
I am trying to create one Data Extension that can be used to log all contacts going into multiple journeys and then use update contact event within journey to update row when a contact exist journey.
...
0
votes
0answers
29 views
Marketing Cloud Query not importing Contacts
I created a new campaign, added 1500 contacts. I moved into Marketing Cloud and I created a query to move data in for a single send.
SELECT
c.[ID] as [CID],
c.[Name] as [CampaignName],
cm.[FirstName] ...
1
vote
2answers
24 views
Salesforce DEs are not visible in Automation Studio when configuring an Email Send
Does anyone know what happened to Salesforce Data Extensions in Automation Studio Email Sends?
We can't find it... I've looked at a few client accounts and it seems to have disappeared? For existing ...
0
votes
1answer
72 views
Delete individual record from Data Extension through cloud page
Very pleasure for the solution.
Want to delete individual/particular records from landing page, but unable to delete.
<table width="100%" cellspacing="0" cellpadding="0&...
