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
Results tagged with Search options user 5202

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

15 30 50 per page