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 |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Favorites |
infavorites:mine infavorites:1234 |
| 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 | |
Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis. Use Automation Studio's workflow canvas to build simple or multi-step automations.
2
votes
I think you're looking for linkName in the _Click data view. That's the alias.
answered Feb 8 '18 by Adam Spriggs
6
votes
Yes. You can also use Script Activities to alternately execute two Automations.
Automation1
(whatever automation step)
Wait - x minutes
Script Activity - Run Automation2
Automation2
(whatever a …
answered Jul 19 '16 by Adam Spriggs
0
votes
There's no file. The activity can be found in the Activity tab:
answered Oct 24 '16 by Adam Spriggs
0
votes
What you've described is typically how I've done it. You can set up an report Data Extension and use a Query Activity to populate it. Then in an email (and UI Send), you can iterate through the DE a …
answered Jul 19 '16 by Adam Spriggs
3
votes
The SQL parser in SFMC is really dumb sometimes.
I'd recommend something like what @Bo Hu suggested, but just add brackets around it:
SELECT
CUST_CODE
, [EXCLUDED_FROM_NPS]
, BIRTH_DATE
, DATEPAR …
answered Dec 6 '17 by Adam Spriggs
4
votes
You can do date math like you would in regular JS. I typically use a simple function to format the date:
<script type="text/javascript" runat="server">
Platform.Load("core", "1.1.1");
var today = …
answered Oct 25 '16 by Adam Spriggs
7
votes
Typically if Query Activities fail, it's one of these 6 things:
Primary key violation -- your query results in duplicate rows not allowed by the primary key
Inserting a null value into a non-nullabl …
answered Apr 10 '17 by Adam Spriggs
1
vote
Some device data is available via Tracking Data Extract, if you check the Include User Agent Information option. It's included in the extract of Sent data.
To use it in a Query Activity, you'd need …
answered Apr 10 '17 by Adam Spriggs
0
votes
The documentation for the new Activities can be found here under Automation Studio:
Data Extract Activity
If you hover over the step that failed in Automation Studio, it'll likely give you a clue a …
answered Apr 16 '17 by Adam Spriggs
1
vote
You'll need to handle the time portions of the dates in SFMC Query Activities.
Casting the date column as a date will set the time to 00:00.
SELECT SubscriberKey
FROM [Trip]
WHERE Date_of_Departure …
answered Jun 24 '16 by Adam Spriggs
0
votes
Sure. It'd be something like this, since SFMC doesn't support T-SQL pivot.
CREATE TABLE Table1
([SID] varchar(2), [LinkName] varchar(5))
;
INSERT INTO Table1
([SID], [LinkName])
VALUES
…
answered Sep 22 '16 by Adam Spriggs
0
votes
Technically you can do it this way, but I wouldn't recommend it.
%%[
var @CreatedDate
set @CreatedDate = AttributeValue("CreatedDate")
if DateDiff(now(), @CreatedDate, 'MI') < 4 then
…
answered Jan 10 '17 by Adam Spriggs
1
vote
You can do it with the API, but it's a considerable investment.
SFMC attempted to build their own migration tool, but now outsources it to Marketing Cloud Partners that have built API-based tools t …
answered Mar 29 '17 by Adam Spriggs
0
votes
Your not exists clause doesn't contain any connection back to your source Data Extension, so it's not surprising that it's timing out.
I'd approach it like this:
select
m.AccountID
from members m
…
answered Feb 6 by Adam Spriggs
1
vote
Casting/Converting a DateTime data type to a Date effectively removes the time portion of the DateTime value.
Doing a cast or convert on both sides of a conditional in a where-clause is very ineffici …
answered Nov 5 by Adam Spriggs
