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

Questions tagged [marketing-cloud]

The Salesforce Marketing Cloud is the leading 1:1 digital marketing platform, connecting companies with customers in entirely new ways. Platform APIs and SDKs enable developers to manage and automate marketing campaigns and extend the Marketing Cloud with integrated apps and app extensions.

0
votes
1answer
17 views

Can't Query All Fields in AllSubscribers List

I need to grab fields within the AllSubscribers list. I attempted a simple query, but I'm getting the error "Invalid column name..." for the columns that I've commented out in the screenshot below. Is ...
0
votes
1answer
26 views

Can I use AmpScript to set Subscriber Status in Marketing Cloud?

A prior developer built our microsite preference center using ampscript to grab user info from SalesForce and update the Contact/Lead info depending on the user's answers. In the case where a User ...
0
votes
1answer
20 views

SSJS to call Content Block with AMPscript

Use case: Through automation studio, a script activity is use to call and reference a content area through the "ContentAreaByName" function. That content area contains AMPscript that performs specific ...
0
votes
1answer
19 views

Collect data from form and url and insert into data extension

I need to collect data from a url and form entry and insert information into a data extension. My cloud page url is https://pub.info.example.com/unsub when my button is clicked with the following ...
0
votes
0answers
19 views

REST API - To create/update a row in Data Extension not working

I am using following URL to create REST API request to create/update a record in the data extension: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/...
0
votes
0answers
16 views

How export to excel a list date extensions with soap api .NET ? help me please

I tried the below, nut no it did not work and I receive no return data. I would like to have the file downloaded. public static void ExtractDataExtension(SoapClient soapClient, string ...
1
vote
3answers
51 views

REST API Call Journey through Postman

I'm trying to make an API call through POSTMAN to trigger a journey, but when I doing that I am getting Error: 596 Service Not Found PostMan Call: Host: https://************.rest....
0
votes
1answer
26 views

SQL Statement to merge two tables with multiple records

I'm trying to merge two objects using Automation Studio in Marketing Cloud so a customers opportunities/or no opportunities are all in the one table. I think this spreadsheet i created will make ...
0
votes
1answer
9 views

Dynamic content within journey builder using Live Data

I'd like to use the Lookup function (Lookup(1,2,3,4,[5a,5b]...) ) within an email while in Journey builder to generate dynamic content. Is there a way to name the data extension (field '1' in the ...
1
vote
1answer
29 views

Data view for A/B Tests?

I'm trying to export our Job data to a data warehouse and it'd be helpful to know which of the jobs we're exporting are associated with AB tests. I can definitely see that Marketing Cloud has some ...
0
votes
1answer
25 views

Inserting a value into a field in a Data Extension where records match on a key in Salesforce Marketing Cloud

Please excuse my ignorance, as this seems like a simple thing. I'm just new to to SQL and am having trouble working it out. I have a data extension of records with a blank Variable field. I have a ...
0
votes
0answers
22 views

How Can we create a dynamic Data Extract activity

How Can we create a dynamic Data Extract activity where the Data extension in the Data Extract Activity will be dynamic and also the file that is going to be generated from it will have a dynamic ...
0
votes
1answer
28 views

SQL Query Error - Violation of Primary Key constraint

I am trying to take my information from a Data Extension which contains new customer emails and put them in another Data Extension which severs as our companies master list. I am able to populate ...
2
votes
0answers
29 views

Register symbol and parenthesis causing error in outlook

when using a sender profile with "xyz® (abc) communications" for the from name, the part in parenthesis is being kicked out when sent to outlook so i just have "xyz® communications" I have tried ...
0
votes
0answers
36 views

How to check if a field is populated? [on hold]

Context: I'm trying to check whether an attribute inside a Data Extension has been populated or not. Question: Is there a way to check weather a date field has been populated repeatedly in SFMC ...
0
votes
0answers
16 views

Linked Data Extensions in Attribute Groups not appearing in Contact Attributes

I seem to only be able to see the first data extension in a linked set of data extensions in attribute groups show up in the contact profile. I have 3 data extensions linked together in the ...
0
votes
0answers
19 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 ...
-1
votes
1answer
29 views

how to create custom activity in Marketing cloud [on hold]

I want to create a custom activity in Marketing cloud so how can I create it ? please suggest me . Thanks & Regards Rajan Gupta
0
votes
1answer
30 views

Amp script multiple fields

In plain english: IF (messages >=1 AND reviews >=1) display both IF (Messages >=1 AND reviews <1) display messages IF (messages <1 and reviews>=1) display reviews note, at least 1 of these two ...
0
votes
1answer
39 views

SQL Query is not retrieving data

I am trying to run below query, which successfully run but it does not retrieving any data. I am 100% confident it should retrieve the data as I have manually checked. What could be the reasons its ...
1
vote
1answer
40 views

Unsubscribe process on external page with update to _Unsubscribe dataview

What I would like to achieve is an email unsubscribe process that is secure, performant and on an external page with the ability to update the internal system table (dataview) _Unsubscribe. How I ...
0
votes
1answer
29 views

How to get data from Marketing Cloud standard data views using REST API

I have a requirement where I have to get the data from Pre-defined data views eg: Send, Click etc. using REST API. I am not able to find a solution for the same. Has anyone tried to do the same thing?...
0
votes
1answer
28 views

Display Error Message - AMP Script

I would like to display an error message in login page, if the credentials are wrong or invalid. error message like "Invalid Username / Password" should be displayed next to the login button how ...
1
vote
0answers
25 views

Ampscript Attribute from Contact Model

i have searched the documentation with no luck. In an email i want to use a value that is from an attribute that has been configured through Attribute Groups within the Contact Builder Data Designer....
0
votes
1answer
19 views

Login Page Validation - AMP Script

I have a requirement to validate the credentials in the login page for the data in one the DE that I have for the client. I have created a login page in cloud pages/ landing pages ( salesforce ...
0
votes
0answers
18 views

Marketing cloud: Help with query to avoid duplicate records in data extension and getting the last opportunity unless a particular stage [on hold]

What I am trying to do, is to bring all the opportunity contacts roles for the last opportunity. However, if the account has an oportunity in a particular stage, then only use the opportunity with ...
0
votes
1answer
24 views

MCC for Sales cloud

We are going live with MCC in a few Days. During Installing the Package we need to Perform this step 'After login, select who to install the package for.' https://help.salesforce.com/articleView?id=...
0
votes
0answers
20 views

could use some advice on how to nest ampscript functions within guide template language

I am pulling content from JSON into an email using Guide template language. I need to manipulate the content so it is usable in the email. field in the JSON is {{name}} the below set statment is ...
0
votes
1answer
48 views

Salesforce Marketing Cloud cloud pages favicon

Is there a chance that I can put a favicon to my cloud pages?
1
vote
0answers
15 views

'Add Image' Dialogue Custom 'Block' in Marketing Cloud Content builder

I am working on Custom Blocks for Content Builder E-Mails and I wonder if it is possible to choose Image Assets from the Salesforce System like in the 'Image Block'. Sadly I didn't find anything ...
-3
votes
0answers
24 views

salesforce Marketing cloud cloud pages [closed]

Hi I have Requirement like first step has to create Registration by mail ,after completing Registration successfully customer will redirect to login page & by using credentials he logged in later ...
1
vote
1answer
29 views

RaiseError() - additional arguments

Wondering if anyone can shed light on ordinals #3-5 for the RaiseError() function? Particularly interested in #5. Ref: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-...
1
vote
0answers
17 views

GTL - Can't use inside a content block?

I created a code snippet that contains AMPscript and GTL: %%[ /*API Subscriber Config*/ ContentBlockByName("Content Builder\_EmailAssets\Code Snippets\API Subscriptions\API Subscriber Config") SET @...
0
votes
1answer
39 views

Configure a MC Journey with decision splits evaluated against a field from SFDC

What is the best way to configure a MC Journey with decision splits evaluated against a field from SFDC? As the value of the field changes over time the decision split should evaluate against the ...
1
vote
1answer
36 views

3rd Party load CSV into Marketing Cloud

I'm looking into a solution to allow a 3rd party to load a CSV into Marketing cloud. The solution we're converging on is building a page, with a browse-save file dialog. The 3rd part can manually ...
0
votes
1answer
24 views

Query Subscribers with No Opens from Publication List

I'm trying to select subscribers who haven't opened any email sent to a publication list over the last 6 months. Below is what I've tried, but it returns subscribers who didn't open from a single send,...
0
votes
0answers
31 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 ...
3
votes
0answers
48 views

SOAP API Connection with Access Token

I am trying to connect to the SFMC SOAP API using an access token that I've successfully retrieved. (I have successfully made REST API request using same token.) I've been struggling with this for a ...
0
votes
0answers
30 views

Retrieve the subscribers from each business unit

Starting from the All Subscribers list of the parent business unit, I'm trying to know which subscribers are being part of each child business unit. As it is not defined any Subscriber Filter, how ...
0
votes
0answers
18 views

I have the problem with the integration of the fuelSDK with .net

NameValueCollection parameters = new NameValueCollection(); parameters.Add("authEndPoint", "https://auth.exacttargetapis.com/v1/requestToken?legacy=1"); parameters.Add("clientId", "####...
1
vote
1answer
39 views

How to de-duplicate SQL query using ROW_NUMBER

I try to de-deduplicate my SQL Query but it gives this error: An error occurred while checking the query syntax. Errors: An error occurred while checking the query syntax. Errors: Invalid column ...
0
votes
1answer
26 views

creating Cloud page web app

Hi New to Marketing cloud, started building cloud page web app with forms and post processing. I have started using Amp scripting/SSJS. My first questions is about Securing cloud Pages. I realise ...
0
votes
1answer
30 views

Marketing Cloud AMPScript date output question

We have an email in marketing cloud that has a date of 28 Feb 2019 however this needs to be dynamic based on the following criteria. When we get to 1 March 2019 the dates year needs to change to 28 ...
0
votes
0answers
20 views

Export Subset of Columns from Data Extension

I have an automation job set up to extract a data extension and push it to the safehouse. Everything works. The data extension that I'm trying to extract has too many columns. Is there any easy way ...
0
votes
1answer
24 views

Difference between HTML gear and Salesforce Lead form gear on Cloud Pages?

I'm trying to figure out the difference between the HTML gear and Salesforce Lead Form gear on Cloud Pages. Both gears drop an empty HTML box where you paste HTML code in. I pasted the web-to-lead ...
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?
1
vote
1answer
20 views

Resubscribe to Publication List

I have an automation that extracts a specific set of records, daily, with the end goal of having their status in a publication list updated from 'Unsubscribed' to 'Active.' All steps of the automation ...
0
votes
1answer
57 views

Prepopulate HTML Text Area using AmpScript

I'm trying to Prefill a form in the cloud page by querying against salesforce campaigns and campaign members. I was able to set values for input fields just fine using amp script variables. For Text ...
1
vote
1answer
23 views

Update Data Extension via WSProxy

I've built a CloudPage which runs SQL queries quickly without having to use automation studio. The SSJS that runs the query works perfectly, but I'm also trying to use this function to also update a ...
0
votes
1answer
24 views

How can I render different content in a marketing cloud email based on the device type?

In the email body I have different content I want to show based on whether the device is android or iOS, is there an attribute available to create dynamic content for this logic?