Questions tagged [dataextensions]

ExactTarget - A data extension is a table within the application database that contains your data.

Filter by
Sorted by
Tagged with
-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. ...

1
2 3 4 5
24