MC Snippets SQL Mode

About me

My name is Pato Sapir, I'm a 4 x Salesforce Marketing Cloud certified consultant, Marketing Champion and Salesforce MVP.

I started my journey as a software developer back in 2003 and got into Salesforce Marketing Cloud (or Exact Target at the time) in 2012.

In 2015, I decided to take a big leap and start my own Salesforce Marketing Cloud consultancy called Devs United with the goal to provide specialized digital marketing services on the Salesforce platform.

While I went through many different roles throughout my career, my passion has always been to design and build creative software solutions for different challenges.

I'm born and raised in Argentina, but now live in Cleveland Ohio with my wife and two kids.

I hope you enjoy MC Snippets and please reach out to me with any questions, ideas or just to say hi!

Contact Me

Welcome to MC Snippets!

MC Snippets allows Salesforce Marketing Cloud trailblazers to test, experiment and share AMPScript, Server Side Javascript and now SQL snippets without having to login to a Salesforce Marketing Cloud account!

This new version of MC Snippets allows you to run and play with SQL Queries against the 28 System Data Views (included the 2 undocumented Data Views _PushAddress and _PushTags).

If you are new to MC Snippets, I suggest you watch this quick introduction video to get started.

Send me your ideas or feedback!

Don't show this again

Step 1. Define your data

Define the data structure that will be used in your snippet.
Step 2. Code your snippet

Use our powerful editor with syntax highlighting and intellisense function support AMPScript, SSJS and SQL.
Step 3. Preview

Click the Save & Run button to preview your snippets. If your code had scripting issues, errors will be shown!
Step 4. Share with friends

Share the unique snippet link with others (snippet will be editable) or use the Embed button to include a read-only version of the snippet on your website.
Wondering about privacy? Read our Privacy Policy.

Data

* Data Extension Name

Generate a new Data Extension Name every time you run the snippet

Data Extension Definition

Column Name	Customer Key	Field Type	Max Length	Required	Primary Key
ContactKey	ContactKey	Text	255	false	false

Values

Paste sample JSON

Query

Learn about System Data Views

/* Welcome to MC Snippets SQL Mode! Run SQL Queries against all the available Data views, share with friends and have fun! Data Views reference: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_views.htm&type=5 */ SELECT j.jobid, j.emailname, j.deliveredtime AS 'SendTime', o.eventdate AS 'OpenTime', s.emailaddress, s.subscriberkey FROM [_job] AS j INNER JOIN [_open] AS o ON j.jobid = o.jobid INNER JOIN [_subscribers] AS s ON o.subscriberid = s.subscriberid WHERE o.isunique = 1