Questions tagged [dataextensions]
ExactTarget - A data extension is a table within the application database that contains your data.
0
votes
1answer
24 views
Multiple triggered send definitions using same data extension
I have 5 scenarios where I want to send a triggered email. Each scenario has 1 unique variable that will be dynamically populated. Would it be problematic to create one data extension that has the 5 ...
0
votes
3answers
55 views
Sending Messages with Dynamic Content
I'm starting with AMPscript, and I need to send a batch of email messages to my customers where each one receives a slightly different content, which should be obtained dynamically for each email
To ...
1
vote
2answers
34 views
What is the primary key in data view - sent and data view - open?
I want to create a data extension consisting of total sends, their send datetime value & total opens.
There isn't any standard report in marketing cloud which provides time of send. To fetch ...
0
votes
1answer
30 views
Data Extension synchronous Rest API where there are only primary keys
I have a data extension with 2 fields/attributes. These 2 fields are string types and primary keys.
According to documentation the request body for synchronous APIs request should be:
https://...
2
votes
1answer
28 views
Collect codes for non-retail scenario
Can we use collect codes for non-retail scenarios especially if I wanted to track unknown visitor activity on my website and tie back that activity when a user provides an email on a sign-up page? (I ...
0
votes
0answers
31 views
Exclusion Script with Salesforce Data Extension
I'm using the folowing Exclusion script ROWCOUNT(LOOKUPROWS("DE_TEST_FORCE10_FR", "CLI_AdresseEmail", emailaddr))> 0 during a one shot email and it works very well, the issue is when I move the ...
1
vote
0answers
17 views
When using mc connector, how can I calculate data storage usage amount in salescloud or marketing cloud?
I'd like to connect a salescloud and marketing cloud by using mc connector. After connecting, I will upload customer's website data into a salescloud first and then, I want to make a syncronized data ...
1
vote
0answers
12 views
Marketing Cloud Fuel SDK API : get DataExtension/List related to Email, get Contact info from those DataExtension/List
I am working on Salesforce Marketing Cloud API to extract Email Receiver Contact detail. For that I used below approach.
Step 1 : Extract List related to Email (used ET_ListSend()) using below code....
0
votes
0answers
18 views
How to get my all records with null records using SQL query in salesforce marketing cloud
I have created one 'TEST' Data extension using Email and FirstName fields which are not primary fields. In this data extension have three records one is null record. Now my requirement is how to get ...
0
votes
0answers
8 views
SOAP DataExtension retrieve - distinguish between Standard and Filtered DEs
I need help refining a retrieve call on data extensions. I need to retrieve all standard data extensions and not filtered DE's. Is is possible to distinguish between Standard and Filtered DEs? Either ...
0
votes
1answer
16 views
Using to SOAP API in SpringBoot application to get the DE data
I'm new to SF Marketing Cloud and need to use Soap API in SpringBoot application to get DataExtensions data to do some manipulations. I'm not sure where to get MC DataExtensions API/end Point as well ...
2
votes
3answers
42 views
Optimize a query that is timing out
I have two data extensions that I need to join and filter. One stores member data for a product, the other stores opt-in status for all products. The DE with opt-in status can have multiple instances ...
0
votes
1answer
32 views
Populate Multiple Data Extension trough Landing Page
I have a question about update multiple data extension trough a smart capture in landing page. To example: i have i master data extension that has the all data of my customers.
I wiill create a html ...
0
votes
1answer
24 views
Remove Special Characters SQL
I am currently trying to run an SQL qeuery that strips out special characters and then adds a '1' in front to have all numbers correctly formatted. For what ever reason my REPLACE doesn't seem to work ...
0
votes
0answers
8 views
Trying to query the _open and click tables to fill a new table with the email of the users who have opened or clicked a link in an email
I'd like a query to pull from a specific email which is in content builder. What would my query look like? Also what columns are needed for the target Data Extension?
0
votes
0answers
7 views
storing engagement info and user ID in separate DE
I am facing the following problem at the moment: I want to send out sth like an opt in message where I ask my clients to opt in by clicking on a specific link in the email.
If a user clicks the link, ...
1
vote
1answer
28 views
SQL Won't Populate Salesforce Data Extension
I am trying to dump data from a Salesforce object into a Salesforce Data Extension. I am not getting an errors but the data refuses to populate. I can't figure out what I am doing wrong! I have tried ...
0
votes
1answer
37 views
Can primary key & field mapped with SubscriberKey can be different in a data extension in marketing cloud?
We've created a custom object "Enquiry" in sales cloud which is child object of "Lead" object. (i.e. Lead represent a unique user)
We've also deployed marketing cloud which is in sync with sales ...
0
votes
1answer
29 views
How to get Data Extension ID using Journey ID
In Salesforce marketing cloud, I need to get the Data Extension ID of a journey using REST or SOAP API Call. Then this Data Extension ID will be used in further set of API calls. The challenge was to ...
0
votes
0answers
30 views
How to remove double quotes from CSV
A .csv file I have imported via FTP (too large to manually upload) is wrapping several of the contained columns values in double quotes. When I review the file in Excel the quotes don't exist and the ...
1
vote
1answer
23 views
Instant trigger email to new subscribes only in a data extension
I have a data extension in SFMC that is being populated with opt-ins from an external source. I would like to trigger an instant welcome email ONLY to anyone who is added to this data extension. How ...
2
votes
0answers
13 views
Will overwriting Data extensions cause issues in using it in journey builder through the contact data model (not journey data)?
I am in a situation where I am having to choose whether I should Add/Update or Overwrite in a Daily Batch File Import into a Data Extension which I plan to use in Decision Paths in Journey through the ...
0
votes
2answers
59 views
Load data into Salesforce object from Marketing Cloud data extension
Could you please help me to solve my problem? I have to upload the data from a Marketing Cloud data extension to a CRM object. How I can achieve this if my Marketing Cloud and CRM are integrated with ...
1
vote
1answer
32 views
Limit Records in a data extension
I created a landing for customers to sign up for an event. This smart capture add and update a data extension. Our goal is only get the first 300 records.
Is it possible that when the Data Extension ...
-1
votes
1answer
35 views
Does marketing cloud have a Database or Can we access it?
Can somebody tell me that marketing cloud have any database or if yes which database MC use to store data extension or list data.
Thank you in advance.
1
vote
1answer
42 views
Migration to Content Builder from Classic Content
I mainly use an AMPScript email to create&send emails using Triggered Send. The AMPScript email (script) loads the required information from content html files and values from the Data Extensions ...
0
votes
0answers
22 views
Is it possible to create custom tab or view for marketing cloud internal user?
I'm facing scenario to render data from particular data extension info to marketing cloud internal user like creating landing pages to get those data to render inside marketing cloud org along with ...
1
vote
1answer
53 views
Get Method Syntax to move Data Extension from SFMC via Postman
I am new to API Calls, and Postman API Scripts.
I have a Data Extension in Sandbox SFMC, which i want to move to Postman via Postman API call.
I already have a script to get the access token from ...
0
votes
1answer
43 views
Increment/Decrement Data Extension field when Cloudpage is loaded
I'm aiming to have Ampscript on a Cloudpage decrement a value in a specific data extension field whenever the page loads. Eventually there will be further logic to determine which of two values to ...
0
votes
1answer
50 views
Maximum characters of number field data extension
I have a problem when I create a Data Extension where there is a numeric field. Named "CPF". 10 characters is the maximum supported in a field in the Data Extension?
I've already tried to import ...
0
votes
1answer
23 views
Triggered Send via API sends blank email (no personalization, empty fields)
We're building a Purchase Confirmation email and we can successfully trigger an email, but the personalized content is blank - for example, Order Number, Ship Date, Product Name, etc are all blank.
...
0
votes
1answer
36 views
How to use sales cloud leads as data extesion in marketing cloud?
Marketing Clouds and Sales Cloud are connected. There are some leads in Sales Cloud. I am creating a journey in MC and want to use 'data extension' from sales cloud. How is it feasible? Is there a way ...
0
votes
1answer
14 views
Last updated date on custom data extension created in salesforce marketing cloud
I've created a data extension in marketing cloud based on sql query. I update this data extension manually on need basis (usually one or two times in a month).
Logic for data extension -
1. Data ...
0
votes
1answer
63 views
AMPscript: Pull data extension row count
I'm trying to use AMPscript to pull the number of rows (all rows, rather than matching to a specific variable) in a data extension and insert that variable into an email. However, the variable I'm ...
0
votes
1answer
41 views
Enable send logging to a data extension
I have set up a send logging DE. So far so good. On the salesforce help I see that I have to enable the send logging to a data extension option: https://help.salesforce.com/articleView?id=...
0
votes
0answers
12 views
Empty is not equal to False in Data Extension?
I launched a journey today based on a Data Extension that had a column called Sent_1st_Email.
Out of the 18K leads, there were about 2300 who had that column marked as True. The remaining records ...
1
vote
1answer
25 views
Definition of Event date in _bounce data view in salesforce marketing cloud?
This is with reference to standard system data extension in marketing cloud named _bounce.
As per standard documentation definition of EventDate is "The date the bounce took place."
Let's say, email ...
0
votes
1answer
41 views
SFMC Shared Data Extension
I have created a new data extension (New Custom DE) under Shared Data Extension section.
In journey builder, when specifying the entry source, I'm able to select the New Custom DE as the audience. ...
1
vote
1answer
34 views
Removing unengaged subscribers account wide
I have a data extension created for contacts we have deemed unengaged based on a predefined set of criteria. This data extensions updates once a week through an automation. For example one of the ...
5
votes
2answers
134 views
Allow simultaneous writes to the same Data Extension
I have a use case where I need to bring _PushAddress data from 60 Business Units back to the Global Business Unit.
For information _PushAddress has a restricted view of data available in a single ...
0
votes
0answers
60 views
How to write an sql query in marketing cloud if field name contains a reserved string?
I'm using marketing cloud for sending various marketing communication. SFMC is integrated with sales cloud. I'm facing a problem while creating a data extension which contains a field name contains ...
0
votes
1answer
40 views
Fields.Retrieve() doesn't display anything
I would like to retrieve the header of a data extension using SSJS within my Landing Page. Below is my code :
<script language="javascript" runat="server">
Platform.Load("Core", "1");
...
0
votes
1answer
28 views
Possible to request and store entire url [duplicate]
I would like to store entire url in a variable and insert into a data extension. I know you can grab specific parameters from a url but cant seem to find anything about the entire url with ampscript.
...
0
votes
1answer
56 views
Cannot change External Key for Data Extension
After creating Data Extension I cannot change External Key.
Each time I change it and click "Done", refresh page and it's still the same key.
0
votes
2answers
42 views
Synchronising tracking data back to Salesforce from Marketing Cloud
The official documentation from Salesforce is to use Salesforce Data Extensions if you want to push tracking information from Marketing Cloud to Salesforce (https://help.salesforce.com/articleView?id=...
0
votes
1answer
92 views
Ampscript works in preview and test but not in live send
I have a content block that sets an attribute from a data extension in a variable and then has several lookups based on that.
When I preview and test send it works but in live sends I'm getting a ...
0
votes
1answer
50 views
Reorganizing order of fields in data extension
I see your answer on rearranging order of fields in a Data Extension through SQL query here Reorganizing fields in data extension
May I ask you how to rearrange order of columns via SQL query to have ...
0
votes
0answers
27 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
51 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
58 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 ...
