Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
1,159
questions
-1
votes
1answer
32 views
Advantages & Disadvantages of Using 'Salesforce Data' vs 'Data Extension' for Journey entry source
I'm struggling to understand the use cases for these two entry source types.
Why not just always use Data Extensions?
Is there a huge latency difference between the two?
I've read people recommending ...
0
votes
0answers
20 views
IGO_Views Error
We recently installed Collect Tracking Code and I have turned on the Data Extensions to populate the data but not all of the IGO_VIEW skus are being populated.
You can see below that the Track Item ...
0
votes
0answers
16 views
Is it possible to use AMPscript to output data extension row information in a mobile push message?
The use case for this is bundling as many likes/follows/replies etc into a single Push message.
For example, "you have 8 unread replies, 2 new follows and 3 new likes".
I've done this sort ...
0
votes
1answer
24 views
marketing cloud Deployment Manager Error while deploying shared data extensions from one BU to another BU
I am trying to deploy marketing cloud data extensions and shared data extensions from one BU to another BU using deployment manager.
I created separate snapshot marketing cloud data extension and ...
0
votes
2answers
47 views
joining two tables [closed]
I'm trying to join two tables(to get the OrderLines) and I'm geetting 0 records even if I manually checked if there is matching records and there is multiple records for each customerID that are ...
0
votes
1answer
46 views
Need to query 'All Subscribers' and write to Data Extension via SOAP API (Marketing Cloud) [closed]
I'd appreciate any high level assistance in how I would query "All Subscribers" list and write contents to Data Extension. I have a need to access fields in "All Subscribers" that ...
0
votes
1answer
28 views
RetrieveSalesforceObjects Function / AMPscript works inside Email Studio (in Preview and Test) - but not in Journey Builder
I have an email in Marketing Cloud in which I want to get the contact owner's name to show up at the bottom in the signature. First I used the Lookup function and when I verify and test the email it ...
0
votes
1answer
17 views
How can I created filtered rows in SFMC to get data from past week?
I'm looking to filter my DE on the basis of data added.
For instance, today is 9 September. I want to filter all data that was added from 1 September to 8 September (i.e., last week), what are the ...
0
votes
1answer
25 views
Is there a function or an Api that allows me to remove a user from all existing Data extensions?
According to Habeas Data law, when a user wants to revoke the authorization to receive communications, we must not keep user information in any Data Extension, so we need to look for a user record in ...
0
votes
1answer
28 views
Retreive file present in ftp from cloud page
I want to know if there is any script/function where I can retrieve a csv file present in FTP from a cloud page.
Firstly the file is already present in FTP location, so some users don't have access to ...
0
votes
1answer
30 views
How to avoid null or blank value in target Data extension by using SQL Query [closed]
I have two Data extension in which we need to update some fields from the Data extension "A" to Data extension "B".
But if the any fields of A is null or Blank and that fields ...
0
votes
0answers
17 views
LookUp by Attribute Group Instead of Specific Data Extension
In Salesforce Marketing Cloud, I have the following:
Data_Extension_1
Subscriber Key (Primary Key)
Email (Email Address)
Data_Extension_2
Subscriber Key (Primary Key)
Gender (Boolean)
Fav Movie (Text)...
0
votes
0answers
19 views
Marketing Cloud sFTP .csv Import is not bringing in all the Contacts into the Data Extensions
The imported .csv file has 100k contacts but only 60k are being imported, have tried a variety of workarounds with no luck, anyone have a solution? The data extension shows only 60k records vs the ...
0
votes
1answer
32 views
Admit contact to journey via API if entry source is Data Extension
We have a Journey set up with a Data Extension as the entry source with an automation. Now we are exploring the possibilities to admit contacts to the same journey via the API on an ad-hoc basis. So ...
0
votes
0answers
21 views
AMPScript to normalize Mobile Phone fieldswithin in data extension
Our contacts are synchronized through the Marketing Cloud Connector. The MobilePhone field is formatted with 10 digits in Sales Cloud and values do not begin with a 1. In order to send SMS through ...
2
votes
1answer
73 views
SFMC JB Custom Activity | POST values from DE to endpoint that requires specific data set
I have an endpoint that is expecting data that is close to the below format (recipient object is required). I want to send this data after execution in my journey. The data is coming from my entry ...
0
votes
1answer
20 views
Marketing Cloud Manage Data Retention
I have a question about data retention policy.
If I create a data retention policy to my data extensio, the retention policy will only delete records older than 90 days.
The policy will only delete ...
0
votes
1answer
25 views
DataExtension - reorder the fields on existing Data Extension [duplicate]
This may seem silly !. But honestly I have faced this many times during our custom implementation but still unable to find a solution.
Is there a feature either on SFMC UI or using custom API, if we ...
0
votes
1answer
31 views
Creating a custom preference page that syncs to SF
We would like to develop a custom preference page to handle subscription lists for both email and mobile.
Those subscription lists for each subscriber should be synced to SF lead/contact record as ...
0
votes
1answer
40 views
Handling an 'Error: Generic Exception' in Marketing Cloud
How would you solve this issue?
When I try filtering my data extension holding all my subscribers using a StoreID to filter for subscribers relating to a specific store I get the Error: Generic ...
0
votes
1answer
38 views
Multiple LookUps Based on Values in an Array
I have two Data Extensions one is a Sendable DE with contacts and an array of the products they have. The second is a NonSendable DE with the product information on it.
I want to pull in a list of ...
0
votes
1answer
49 views
API Contacts are not injecting into Journey
I have a DE which is getting data via API. Whenever user fill out the form the API triggers and send data to Newsletter DE.
In a Journey builder I setup a campaign using entry source as API event then ...
0
votes
0answers
24 views
Creating a Default Value for a Primary Key Cell in Marketing Cloud
Is there a way to create a data extension that has a primary key with a blank value, and when a new row is added, to autopopulate that primary key field with a unique number in a sequence? E.g. Rows ...
0
votes
2answers
51 views
Unopened Query confusion
I am trying to query for unopen email subscribers in the last 180 using the _subscribers and _open data views.
Due to the open view being limited to showing only opens and not unopens. I am querying ...
0
votes
1answer
27 views
Triggered Send EmailAddress variable
I've inherited a triggered send for which the payload looks like this:
{
"To": {
"Address":"x@gmail.com",
"SubscriberKey":"x@gmail.com&...
0
votes
2answers
45 views
How to iterate on more than 2500 records in a DE with SSJS?
I'm facing an issue about a server side Javascript code that I put in place to deal with data management of a column.
I have one data extension which contains 3 columns : ID_global, Tech_contact_id, ...
0
votes
1answer
46 views
How to recover deleted data extensions from Marketing Cloud?
Data extensions are mistakenly deleted from our Marketing Cloud instance. Is there any way to recover it? Thanks.
0
votes
0answers
19 views
How to Identify unusable assets in Marketing cloud
Is there any way by which we can identify unusable assets(email , content , DE, filter,automation,journey) in marketing cloud BU using SSJS or query ? Any other way to get this data ?
We need to ...
0
votes
1answer
61 views
SFMC JB Custom Activity | Extract values from DE directly into custom activity config?
I have a simple question that needs a definitive answer.
I've created a DE with 3 fields. SubscriberKey, FirstName, LastName
I want to bring these fields into my config.json and post them to my ...
0
votes
1answer
61 views
Insert form fields in a data extension with AMP Script
I'm very new to AMP script and I'm having trouble setting up an HTML form in cloud pages that can pull all the record information in a DE. I also then want to use the DE to trigger an email.
The form ...
0
votes
1answer
41 views
Data Extension shows 0 records after importing from Salesforce
My Marketing Cloud connected to a Salesforce instance and I want to retrieve data from a report in Salesforce into a Data Extension. And that DE shows 0 records (even the report has 1 record) after ...
0
votes
1answer
44 views
What is the best way to query ALL subscribers?
We're using an enterprise 2.0 account, and are querying from the parent BU.
What we're confused about is which data view should we query to receive an accurate report on ALL the 'Subscribers' in our ...
0
votes
0answers
24 views
How to fetch unused Data extension and User name who last modified the DE
) I have list of DE in Folder . I want to know if a particular DE has been used or not in any email , send ,Journey,automation. Or something like that . Basically we are trying to identify unused DEs ...
0
votes
0answers
35 views
REST API to add data into a data extension leads to error 20002
I am using a REST API to add data into a data extension and I receive the following error:
{
"message": "Insufficient privileges to complete this action.",
"errorcode": ...
0
votes
2answers
58 views
Modified date of Records in Data extension using SSJS
I want to fetch the date when a data extension record was modified . I want to exclude all the records modified in last 15 days or DE itself if any of its record has been modified in last 15 days. I ...
0
votes
0answers
31 views
De-duping filtered data extension
I want to create two filtered data extensions:
Filtered data extension that only pulls records that signed up 'in the past one week'
Filtered data extension that de-dupes records on the basis of ...
0
votes
0answers
25 views
What is the SQL for linking the _DeviceId field in _PushAddress to the SubscriberKey in _Subscribers
We have configured our App to register for mobile push using the SubscriberKey value that exists in Marketing Cloud. When we view Contact in the Mobile Push channel of All Contacts I can see the ...
1
vote
1answer
28 views
Using Overwrite for SQL Query Activity on DE for Journey Builder
If a DE is used as the entry for Journey Builder, and that DE is updated daily using an SQL Query in Automation Studio, using the Overwrite option, upon refresh will existing contacts keep re-entering ...
0
votes
1answer
17 views
Use single DE for Journey Builder or Email Sends (with Tracking email Tracking Saved to Sales Cloud)
I hope that I'm wrong but my current understanding is that I need to create 2 sets of DE for my clients, one for when they want to use Journey Builder (in the normal Data Extensions folder), and ...
0
votes
1answer
23 views
What happens when Send Throttling a Journey and the DE is overwritten before the original audience is completely sent?
Say we have a list of 100,000 records and for deliverability sake we throttle the send to 10,000 records a day... this would take 10 days for the email to deploy, which is fine.
However, on day 7 a ...
0
votes
1answer
38 views
How do I automatically send an email every time a person fills out a form in Marketing Cloud?
I have the following problem. I created a landing page using the standard Cloud Capture data extension because it was the only way to get the form to send data to the extension. But I needed an email ...
0
votes
2answers
133 views
Automate Data Extension Deletion in Salesforce marketing cloud [closed]
We have multiple Data extension which are no longer required for use. I want to delete all the data extension inside a folder in SFMC. is there any way to achieve this using automation or SSJS? I don'...
0
votes
2answers
46 views
Is there a way to log specific rows with bad data from an Import Activity in Marketing Cloud?
So I have an import activity, bringing in approximately 72 rows into a table. When I run the automation with "Skip rows with bad data" checked, I import 70 out of the 72 rows. I can manually ...
0
votes
2answers
27 views
Salesforce data extension
I have created two import definitions to import reports and object info from the Sales cloud.
but I am not able to see those data extensions in the Salesforce data extension folder. they are appearing ...
0
votes
0answers
19 views
Using synchronized DEs in decision split in journey
We are using Salesforce data as the entry event in our journeys. As we have some latency between a record gets injected into the journey, till certain data attributes is updated, we have been using ...
0
votes
1answer
26 views
SQL Query returning null values for Boolean fields from Data Extension
I have 2 Standard Data Extensions and an automation written to get values from one DE to other. The issue I am facing is Boolean values from one DE is not copying exactly in the other DE. False values ...
0
votes
0answers
14 views
¿how do i update a subscriber's attributes with the values i already have in some variables in ampscript?
how to update a subscriber attributes with the values I already have in some variables in ampscript
%%[
var @x
set @x=1
/* Crear el objeto del subscriptor */
set @subscriber = CreateObject( "...
0
votes
0answers
23 views
Update a data extension record with a smart capture
I have a DE with the following attributes: FirstName, LastName, EmailAddress and AcceptanceFlag, that is a checkbox.
I send an email to all the records in the DE that contains a link to a landing page....
0
votes
1answer
71 views
Restricting access to limited data extennsions in journey email test and preview
I have a user role that has only permission to create and edit email in email studio but can't see any data extensions or subscriber data. But, now I have to give them access to journey builder and ...
0
votes
0answers
31 views
Data Extension Fields Coming Empty in Custom Activity Journey Builder
Journey Builder Custom Activity Integrations App
Description
We are getting errors in Journey Builder custom activity. When we run journey, dynamic fields doesn't populate in the custom activity app.
...
