Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

1
vote
0answers
3 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 ...
0
votes
0answers
10 views

Marketing Cloud Automation Best Practices

We have an increasing number of automations in Marketing Cloud and I wanted to get some advice on how to organize/clean them up. A little background, we have found the ideal time to send out our ...
0
votes
0answers
6 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
1answer
10 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
20 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
21 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
10 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
39 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
17 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
11 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
28 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
37 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
36 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 ...
1
vote
1answer
23 views

Two automations using the same file drop

Has anyone been successful in triggering two automations from one file drop? I'm testing it and it seems to be corrupting something on the back end. As soon as I try to create a second automation ...
1
vote
2answers
49 views

Updating All Subscribers from Data Extension

Is there a way to update a record in the AllSubscribers List from a Data Extension Import? I'm hoping to set up a daily automation that imports data file into a Data Extension on the subscriber key ...
0
votes
0answers
35 views

Ampscript lookup not working as expected

I'm adding quotes to the fields I need matching against because I had to add quotes in order to import it. Then looking for the URL that is in the same row and nothing. There are no empty attributes. ...
0
votes
1answer
17 views

Impact of editing a DE on which a journey is running currently

I have a requirement where I need to add few columns to a Data Extension on which a journey is active and running at present with real customer data. I added few columns on a test DE and checked the ...
0
votes
1answer
28 views

can I get a list of all customers who have not opened any emails for the past 3 months in SalesForce Marketing Cloud

May I ask if you have any ideas on how can I get or pull a list of people who have not opened any emails for the past 3 months?
2
votes
1answer
26 views

What's easiest way to create data extension of subs that haven't opened email in 365 or 730 days (1-2 years)?

What's easiest way to create data extension of subs that haven't opened email in 365 or 730 days (1-2 years)? I would like to later purge this list. Data Views top out at 6 months. Is there a canned ...
0
votes
1answer
20 views

Can we export data extension records daily and upload on a 3rd party SFTP?

Can we export data extension records daily and upload on a 3rd party SFTP? I understand that file can be uploaded to marketing cloud FTP BUT in this case, file needs to be provided to 3rd party and ...
0
votes
1answer
44 views

Update DE using REST API

How do I update only some columns of my DE leaving other columns as they are using primary key with the help of REST API call?
0
votes
0answers
30 views

How to query and update a Data Extension from an external site using JQuery/Ajax?

I'm putting together an email preferences form and what I want to do is retrieve existing preferences if a record with the specified email exists and add/update a record with the customer's details on ...
0
votes
1answer
29 views

Journey Builder - Some questions about Data Extension Entry Source

I'm new in Marketing Cloud. It's my first time that i work with the Journey Builder. I read about the JB and learned to follow the steps when I like to work with a Data Extension like Entry Source in ...
0
votes
0answers
22 views

Next 7 days meetings displayed using Salesforce data in Journey Builder

I'm working with Salesforce CRM data and creating Journeys in Marketing cloud using Salesforce data as the Entry event. I'm also using Campaigns. I want to check the next 7 days' meetings for a user. ...
1
vote
3answers
43 views

Geotargeting via contact IP address - Salesforce Marketing Cloud

I'm surprised to find that SFMC doesn't seem to have geotargeting functionality -- most email marketing/marketing automation systems have this, based on the subscriber's IP address when they open ...
0
votes
1answer
24 views

Append a value to a Data Extension Field

I am trying to send SMS messages to phone numbers in MobileConnect. I need to add a "1" in front of the existing mobile numbers that I have in a Data Extension, to adhere to the proper syntax ...
0
votes
1answer
30 views

Can't able to invoke journey in SFMC based on Data entry in Data extension?

Actually I have custom landing pages to insert/Update subscriber in shared data extension and having a journey to trigger an email depends on data entry in DE. For Now, Journey has shared DE as entry ...
0
votes
1answer
39 views

UpsertDE and Insert DE not working on send

Background: Attempting to create a send log for contacts who can make multiple enquiries on different services and models, but if they already have a record logged in this sendlog data extension with ...
0
votes
1answer
24 views

How to add calculated fields in data extension in marketing cloud ?

I want to create a data extension contains where one fields contains concatenation value of 2-3 fields available in data extension. Is there any function or formula available for that ?
1
vote
0answers
32 views

Control Group inside Marketing Cloud

I need to create a control group inside Marketing Cloud. A control group would be a subgroup of a data extension to whom I would not send campaign information. Example: If I had a DE with 500 campaign ...
1
vote
0answers
20 views

How can I find if the DataExtensionField is required on an email template

Occasionally we post to send an email and it returns with a message "Missing variable". I'm trying to create some sync ability between what we can validate and send to salesforce. I can query the ...
0
votes
2answers
22 views

Are there any implications to refreshing a filtered data extension used in a current send?

Are there any implications to refreshing a filtered data extension used in a current send? For example if an email send to a filtered DE is throttled and will take 24 hours to complete, and the ...
1
vote
1answer
27 views

Setting up a double opt-in without using any Subscriber List features (publication list, etc.) and just data extension - possible?

Is there a way to set up a double opt-in without the usage of Subscriber List/Publication List? Instead of the method of linking the Data Extension to the publication list, is there a way to ...
1
vote
2answers
56 views

Dynamic From Address & From Name

I am trying to pull the FromAddress and FromName, from a data extension but am not having much luck. I have setup a sender profile that looks like this: From Name: %%=v(@fromName)=%% From Address: %%...
1
vote
1answer
27 views

Apostrophe in Data Extension comes back as gobbledygook

I have a page making an ajax call to the function below. The Description field has apostrophe's in it. They look fine in the data extension, but when ampscript grabs them from the DE, they look like ...
2
votes
2answers
42 views

What kinds of locks are used on Data Extensions and Sending?

Can someone explain how Marketing Cloud locks data in Data Extensions during certain routine operations? Case A: An email begins sending and midway through, a SQL Query gets ran which overwrites the ...
0
votes
2answers
47 views

How to set SendableSubscriberField value while creating sendable Data Extension?

What value should I use for SendableSubscriberField field? I have seen some answers. Which is suggesting, we can set either Email Address or Subscriber Key based on your salesforce configuration? ...
0
votes
2answers
40 views

Create Triggered Send Data Extension via SOAP API

I'm trying to create data extension from TriggeredSendDataExtension template. I use SOAP and develop it in java. Following example works for me: https://developer.salesforce.com/docs/atlas.en-us.mc-...
0
votes
1answer
17 views

Error when executing UpsertData in MobileConnect

I have a SMS which executes an UpsertData command to update data in DE. here is the code AMPSCRIPT %%[ SET @msg = "Vous êtes maintenant désabonné(e)" SET @rows = LookupRows("ENT.CUSTOMER_LOT_6", "...
0
votes
1answer
26 views

Merge 2 Id fields in query to use ampscript to update a salesforce object

I would like to update a custom salesforce object when a marketing cloud email is sent. I have a transaction object and once the email is sent, I would like to update the description field to “...
0
votes
0answers
23 views

any specific way to organize audience builder audience lists?

It looks like there is no option to create folders in audience builders. Can anyone share any specific way to organize audience builder audience lists? I understand that naming pattern is one way but ...
0
votes
1answer
21 views

Data extension update with journey builder

Can we update Data extension with the help of jouney builder ? Detail- I have a journey builder in which i want if email will be sent out to the subscriber the their will be check box or boolean ...
0
votes
1answer
28 views

Synchronized Data Extension marketing cloud

BackGround Marketing cloud and sales cloud connected In contact i have 141049 records which are already sync I created new record on contact object Go back to sync and refresh it . Question Why ...
0
votes
1answer
33 views

Issue with contact key

While connecting marketing cloud and sales cloud contact object contact key will be auto- generate ? If yes, so in my sync DE there is one field "_ContactKey" has been generated. Now i want to use ...
0
votes
1answer
23 views

How to find the number of emails sent to a single domain within this entire year by creating SQL Query for salesforce

I am using this below and it is not pulling the count into the data extension created once automation is complete. Only SubscriberKey and EmailAddress pulls in to the data extension, once automation ...
0
votes
2answers
91 views

SSJS functions not working for Data Extension objects

I'm trying to retrieve the CustomObjectID of a data extension that already exists, by using the External Key/CustomerKey. That didn't work, so now I'm trying to retrieve any DEs at all, and that's not ...
0
votes
0answers
38 views

Efficiently send and test a email template to different groups (data extensions)

Request for email sends are coming in daily with a specific requested sending date and a list to send to. All these emails will use the same template and every receiver within one list will have ...
0
votes
1answer
38 views

Synchronized Data Extensions

I want to use Synchronized Data Extensions as a standard data extension but i am not able to copy data extension . I Created the same fields into the standard data extension now how can we get the ...
1
vote
0answers
61 views

How to setup SSJS to create data extension from existing template?

My audience data extension has hidden data types, such as LongNumber and Decimal (set to more than 18 digits for example 20.15), these are fields that were appended from the audience attributes. Via ...
0
votes
1answer
33 views

processing error SMS updating Data Extension

Wonder if you can assist me in SMS to update Data Extension syntax. I tried all kinds of options and I’m getting process errors. If I remove the AmpScript and just add a message it go to the person no ...