Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 83851

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
Accepted

Ampscript-Populate first Thursday of month in email marketing cloud

You missed a '%' symbol at the start of AMPscript, it is %% and use @Firstthrusday(without a space). Your output will result as 6/4/2020 10:38:05 PM. You need to format date using AMPscript FormatDate …
Akash R's user avatar
  • 171
0 votes

Multiple Random Selections Using Union- erroring

Instead of using ORDER BY, use the following - ROW_NUMBER() OVER (PARTITION BY Contact_Key, c.Account_Number ORDER BY c.Account_Number ASC) AS Row Query - select top 31500 Contact_Key …
Akash R's user avatar
  • 171
1 vote

Shifting from Sandbox to Production in Salesforce

Yes, you have to disconnect the integration from MC which is connected to your sandbox. Then, you have to configure the MC Connect app again in Prod in the similar way. You cannot connect a single BU …
Akash R's user avatar
  • 171
0 votes

Salesforce data extension

While creating Import definitions using 'Salesforce Objects and Reports', the DE is always created under the DE folder of that specific business unit and not the shared DE. This is the expected behavi …
Akash R's user avatar
  • 171
0 votes

MC Connect / disconnect the integration

If the integrated data has not been used in SFMC yet, then you can proceed with disconnect. If used, then you have to pause all automations/Journeys which involves Queries, Import Definitions,Salesfor …
Akash R's user avatar
  • 171
3 votes
Accepted

How to know the if ContactKey entered in a Journey Builder Path - Task Activity

Apart from using the filters in the Journey History, there isn't much you can do about it. Also, it is not possible to export the contact data from Journey Builder. Considering your scenario, the bes …
Akash R's user avatar
  • 171
2 votes

Contact Builder | Exporting Mobile List | Empty File

Workaround - Create a DE with the required fields and then write a query something similar to this - SELECT Field1,Field2 from [Filtered List Name]
Akash R's user avatar
  • 171
0 votes
Accepted

Compare current time (hours) with time range in Transaction SQL

In order to achieve this using Queries, you will have to divide these into multiple steps as following - Create a DE, say Test_DE and include the following fields - Add a dummy value to the Counter …
Akash R's user avatar
  • 171
1 vote

SSJS Platform.Response.Redirect() throws unknown error: Error in Application

Refer to the SSJS Redirect function syntax. Try the below code - <script runat="server" language="javascript"> Platform.Load("core", "1.1.1"); // Load core library try { Redirect("http://www. …
Akash R's user avatar
  • 171
0 votes

Is there any way to schedule Journey more flexible in Salesforce Marketing Cloud

You would have to use additional queries and Journey, within the Automation Studio. After every hour, capture the current time and verify if it is within the given time range. Follow the steps mentio …
Akash R's user avatar
  • 171
0 votes

Create an automation without a PK

For any update operation that you perform, the DE should have a primary key in order to identify the records. If you do not have a primary key then only add & overwrite operations are possible. Worka …
Akash R's user avatar
  • 171
0 votes
Accepted

MobileConnect queueMO API not re-opting in a "Not Opted In" / Opted Out contact

Option #1- Create a opt-in keyword and ask your subscribers to opt-in using that keyword. Option #2- For the MobileConnect contacts, there are 2 parts to it - MobileConnect Demographics(under attri …
Akash R's user avatar
  • 171
-1 votes

Assign multiple users to business unit

As per the documentation, there is no business unit related field that can be utilized in an import file. You can try the SSJS core library function which can be used to do this task easily. Please r …
Akash R's user avatar
  • 171
1 vote
Accepted

SQL Case Statement

Try this - SELECT CASE WHEN SubscriberKey IS NULL THEN [Email ID] ELSE SubscriberKey END AS SubscriberKey, [Email ID] FROM (SELECT de2.SubscriberKey, de1.[Email ID] FROM [TABLE1] de1 LEFT JOIN [TABL …
Akash R's user avatar
  • 171
0 votes

Why does my conditional average query return 0 in MC Query?

Below query will give you the expected results - SELECT ((CAST((count(case when message <> '' then 1 else NULL end)) AS DECIMAL(2,1))) / (CAST((count(event)) AS DECIMAL(2,1)))) as average, COUNT(*) as …
Akash R's user avatar
  • 171

15 30 50 per page