Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
-1
votes
0answers
25 views
Method to return the value of the index. parameters (data extension key and column) And another method to return date of the last indece
I need to defragment this code, so that it is in 2 methods, one that returns me the value of a certain column and another one so that I return the index of the last record..
public static string ...
0
votes
0answers
21 views
Marketing Cloud Business Unit - tracking data
I have a need to bring two existing Business units into one. I have all of the standard tracking data stored in them both (Linked by a parent). I would like to be able to maintain all of the data but ...
0
votes
1answer
31 views
Compare two columns from different data extensions
I'll get right into it. - I am trying to do the following:
I have two DEs one is my send DE, the other is a lookup table.
Let's say both data extensions have a column called [STATE].
The send DE ...
0
votes
0answers
45 views
Upsert Data Extension via HTML Form block inside Email
I created an html form as an email block that I will send inside the email. I would like to add the fields of a data extension where the destination fields will have the names exactly the same as the ...
0
votes
1answer
18 views
Marketing Cloud - Picklists on data extensions
Is it possible to have a picklist in data extensions in Marketing Cloud, for example a field called City then users can filter using a drop down and select from London, Manchester or Birmingham?
0
votes
0answers
26 views
SSJS Data extension creation error
I was trying to create a data extension based on the value that i get from the sync de. Could anyone tel me what exactly the issue is, in my code. When i try to run this in the automation studio ...
0
votes
0answers
3 views
Need to get subscribed user details of specific DataExtensionName and date range using FuelSDK-PHP
I am using below way to get subscribed user details for specific list and date range but can't able to get results
//Get all Data Extensions Rows (By CustomerKey)
print_r("Get all Data ...
0
votes
0answers
31 views
Automation Studio - Imports old file data or same data into Data extension again in file Drop automation with import activity?
Actually, I created File Drop automation to import data into Data Extension. I dropped different files into the same file location. After the completion of automation flow - it imports data of the ...
0
votes
0answers
5 views
Send an Import Notification Email for a Data Extension Updated Through DEManager
We currently have a Data Extension that is updated through a DEManager form loaded directly onto our website. Currently, people use this form to sign up for an event, with the Data Extension used to ...
2
votes
2answers
67 views
Growth rate of one data extension
How could I track the growth rate of one data extension? I have a SYNC DE that forwards my users who come from CRM and another system to the respective DE for each BU i have. But would like to know ...
0
votes
0answers
9 views
Renaming Data Extension that is linked in Population
What will happen if I rename a data extension and it's external key, that is used as population in Contact Builder? Will it affect the decision rules in the active journeys?
0
votes
1answer
36 views
The better method to prepopulate a smart capture from data extension?
Whats is the better method to prepopulate a smart capture from data extension?
I have a data extension named 'CustomerA' that has the fields: name, lastname, emailaddress, idaccount, genre and date ...
0
votes
0answers
27 views
marketing Cloud all subscriber Contact Deletion via a Data Extension
So we exceeded our number of subscribers in Marketing Cloud. We currently use 100.000 subscribers via a synchronized data extension, but our "All subscribers" list is more than 300.000. How can i ...
1
vote
2answers
14 views
How to export limited rows from synchronized database from marketing cloud?
We've few synchronized databases integrated in marketing cloud from sales cloud like "Lead" , "Enquiry", "Opportunity" etc. This tables are huge and ranges around 2 GB.
I want to export only some ...
0
votes
1answer
17 views
Seeing Web & Mobile Analytics data on DEs
Is it possible to get some simple data from a webpage and putting it on a DE via Web&Mobile Analytics? Something like "How many people visit the page today" or "Which pages have been clicked most?"...
0
votes
1answer
19 views
Multiply two fields if an ID is found in a separate table
Trying to create a Data Extension where we calculate the total spend in a category, if the category exists in a list of promotional categories. The point is that we want to provide an offer when a ...
1
vote
1answer
26 views
Referencing DE Fields Not Working
I've got a triggered send which adds values to a data extension. the data extension then feeds into a journey which sends emails. each email has the following code:
%%[
VAR @futureDate, @today, @...
0
votes
1answer
50 views
Call API FireEvents: multiple records for data extension
we are calling to this method: https://www.exacttargetapis.com/interaction/v1/events
In body, raw text is this:
{
"ContactKey": "XXX",
"EventDefinitionKey": "APIEvent-XXX",
"...
-1
votes
0answers
17 views
Emailing a targeted DE attached to an email ID in Automation Studio
Is there a way to send a SQL Query activity targeted data extension attached to a particular email id in automation studio?
The query activity will run daily and the automation studio will send the ...
0
votes
1answer
29 views
Journey Builder Entry Data Extension
I have a standard Data Extension as the entry audience of the Journey.
I would like that everytime the value of a specific text field changes - the Contact will be injected into the Journey.
Is it ...
2
votes
1answer
30 views
Using Data Filters on Synchronized Data Extensions
We have created sync Data Extensions of Salesforce objects such as Contact, Transactions and store location. We would like the ability to create filtered data extensions on this data for email ...
0
votes
0answers
28 views
Populate Two different Data Extensions with a Cloud Page Smart Capture form
I'm trying to populate two separate DEs with a cloud page smart capture.
My Smartcapture form is linked to a DE and populating all the information I set up in the form to that DE.
However, I also ...
-1
votes
1answer
28 views
How to check SMS delivery date in Marketing Cloud?
I'm trying to implement the following requirement in Salesforce Marketing Cloud:
(10-15 SMS/month) before getting another SMS text.
Approach: I run a query on the _UndeliverableSms data view, but ...
1
vote
1answer
39 views
Add as Subscriber + Update Data Extension
I would like to use both Web Collect and DEManager at the same time.
All my leads currently come in via DEManager so I can kick off a journey. When the journey sends an email, these contacts are ...
1
vote
2answers
39 views
Populate one data extension from 5
I have 5 data extensions with the same fields and i would like to join in one. Query would be the best method? How i can applied a query that will get five data extensions? The fields above:
SELECT ...
1
vote
1answer
36 views
Boolean always showing True for Marketing Cloud SQL Query
I have a SQL query that is always returning true for my boolean field even though the data in SF is showing false. Incomplete_Runtime_Data__c is the boolean field, all other fields return correctly.
...
0
votes
1answer
41 views
Error when using REST API to Add Rows to Data Extension
I'm trying to use the REST API to add data to a DE, but I am getting back a validation error when I make the call:
Call:
HOST: https://www.exacttargetapis.com/data/v1/async/dataextensions/key:...
0
votes
0answers
23 views
Adding Filters to Synchronized Data Extensions
I am trying to add a filter on a synchronized data extension to filter out case records which were opened in the last 30 days.
I have a data/time field on the account which calculates the date & ...
0
votes
0answers
30 views
Update Data Extension record using REST API - Journey Builder Custom Activity
I am looking to update a Data Extension record with the REST API. However, if the record does not exist, I do not want to create a new record. Is this possible? Does anyone know of a work around for ...
0
votes
1answer
33 views
Creating master data view with multiple data views
I am trying to create one master data extension for multiple different event types like clicks, bounces, opens, and etc.
Is there any documentation that leads toward this? Or if I have to join all ...
0
votes
1answer
23 views
Is there any developer console sort of feature available to check & preview salesforce marketing cloud sql queries?
In marketing cloud while running a sql query, to check results I have to create a data extension and store results into it. I want to know if there is any alternative available through which we can ...
0
votes
1answer
38 views
Passing Entry Source DE External Key - Journey Builder Custom Activity
I am developing a custom activity for JB. Is it possible to pass the Entry Source->Data Extension->External Key into inArguments to be used by the backend server?
0
votes
1answer
24 views
How do I grab records from today using ampscript?
I am trying to check what records in a data extension are from today.
The data that is in the date field, 'localtime', looks like this:
Thursday, November 01, 2018 10:07 PM
Friday, November ...
1
vote
1answer
34 views
UpsertDE to 1 column DE not working
I'm trying to Upsert records during an email send to a 1-column de. I've tried a couple different variants but in all cases, the Email Send time out and never occurs. If I remove the Upsert the email ...
0
votes
1answer
32 views
Marketing Cloud DE Time of Update Field [closed]
Has anybody been able to implement a data extension field that marks the time of the last update of a row? We would like to make note of when a subscriber flag is updated for tracking purposes.
...
0
votes
2answers
42 views
Using Direct Mail and a CloudPage
Is it possible to use a CloudPage as an entry point for a visitor who originally receives a direct mail piece. In my scenario, I send a postcard to a Contact with an ID and a CloudPage URL. The ...
0
votes
0answers
29 views
Email Send used Data Extension via API
In a SSJS I need to know which Data Extension were used for a Send. In the Email Send Tracking UI of Email Studio, this information is present. But where I can get this information from via API.
I'm ...
0
votes
0answers
25 views
Salesforce marketing cloud - Upsert shared data extension
Is it possible to access the shared data extension using a client credential package created in a child business unit.
For authentication, I am using an access token created from rest using the ...
1
vote
2answers
48 views
Default option for LookupRows when ROWCOUNT = 0
I am trying to set a default value if a subscriber does not have a store allocated to them within our send data extension. The below works for when the store matches a value with my Store_Details data ...
1
vote
0answers
44 views
Marketing Cloud Automation studio won't update data extension
We are having trouble updating records in a data extension from an automation. It creates new records but it won't update. We have the salesforce custom object ID set up as the primary key and the ...
1
vote
2answers
32 views
How do I move a Filtered Data Extension automation based off a Synchronized DE?
So, I've created several Data Filters off our Data Extension for the purposes of segmenting our audience. I've been manually refreshing these filtered DE's whenever sending, but I'll need to automate ...
0
votes
1answer
25 views
Query to populate a field with different name in data extension
I am newbie in SQL, but i have to populate one data extension (name = TEST A) from another data extension (name = TEST B).
The fields in 'TEST B' has name like:
1. Name
2. State
3. Email Address
4. ...
0
votes
1answer
104 views
SFMC - Querying All Contacts with SQL Query Activity (System Data Views)
I am trying to create a data extension that contains all contacts from my enterprise account. I need a complete list of contacts as we are billed by SFMC per contact. Querying the data view ...
0
votes
0answers
16 views
Using Data Relationships in Marketing Cloud to filter against related data
My MC instance is connected to Sales Cloud and I would like to create a segmentation for everyone that has attended events and attended X event.
Data Extensions
Contact_Salesforce
...
1
vote
2answers
50 views
Debugging DE submission AMPScript on a landing page?
I have a landing page that is intended to collect data from a form and send it to a data extension when the form is submitted. Currently the page is not working and redirects to the stock 'internal ...
0
votes
0answers
30 views
Job ID and Data Extension
In Marketing Cloud
Is there a table or area which lists the Job ID and what Data Extension it used for the send?
Or where can i view the Job ID and Data Extension in the same place?
I am trying to ...
0
votes
1answer
18 views
E-mail send performance affected after migrating to Content Builder
So I just migrated two campaigns from Classic Content to Content Builder and a lot is happening:
The e-mail takes a lot to start being actually sent (Hours in the "In Progress" Status) for a short ...
0
votes
0answers
29 views
Can't CAST TEXT field successfully into a DECIMAL (18,2) data type
Client is looking to send a coupon for any orders over $250. However, they are passing the order value as a TEXT field, not a DECIMAL. I'm trying to run the query by using CAST, but no luck. I've ...
1
vote
1answer
47 views
Query and Update Data Extension from within Landing Page built in Code View - syntax?
I'm working on a landing page that will function as a Subscriber Preferences form for email marketing. It needs to query a particular Data Extension using a given email and populate fields ...
2
votes
1answer
57 views
How to send Form Data to DE without hitting submit button using AJAX and AMPscript
I have a HTML Form with AJAX code
<html>
<head></head>
<script src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
<script>
function ...
