Search Results
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 |
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 …
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
…
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 …
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 …
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 …
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 …
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]
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 …
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. …
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 …
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 …
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 …
-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 …
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 …
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 …