Making the Most of Airship and Salesforce Marketing Cloud

Why This Works

Steps to Export Static List

“Pint”,”6301b1a1–4a99–48df-b9ed-75260528d3cb”,”9a1a3481-a81f-4ee9-b2d1–6d38b463dc99"
SELECT named_user FROM SEND_EVENTS     WHERE campaigns LIKE ‘%pint%’     AND named_user > ‘’
  1. That new SQL activity
  2. Export the new DE to “Safehouse”
  3. Transfer from “Safehouse” to the new File Location

Steps to Export Attributes

SELECT SubscriberKey as named_user, EmailAddress as sf_email_address FROM _ListSubscribers

Cool Queries

SELECT min(_customobjectkey) as id, named_user, COUNT(*) as engagement_countFROM OPEN_EVENTSWHERE named_user > ‘’AND occurred >= DATEADD(day,-7, GETDATE())GROUP BY named_user
SELECT DISTINCT(named_user) as named_userFROM CUSTOM_EVENTS WHERE occurred >= DATEADD(day,-7, GETDATE())AND name=’radar_office_entered’AND named_user > ‘’
SELECT DISTINCT(id),channel,occurred,device_type,named_userFROM UNINSTALL_EVENTS WHERE named_user > ‘’AND occurred >= DATEADD(day,-30, GETDATE())

For more information about Airship, check out our website, blog or our docs!

--

--

--

Urban Airship is now Airship! Leading brands trust us to help them achieve digital growth. We make mobile moments magic. www.airship.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Making CSS Vars work with Lit Element on legacy browsers like IE-11

Chapter 10 — Numbers Matter

Scrum: A Brief History of a Long-Lived Hype

Why you should build your own computer.

Agile story points planning poker

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Airship

Airship

Urban Airship is now Airship! Leading brands trust us to help them achieve digital growth. We make mobile moments magic. www.airship.com

More from Medium

How Nextview takes Managed Services to the next level

Four Client Focus Areas For Salespeople

Marketing Cloud — End to End Triggered Email Overview