Cameron Robert steps through how to rebuild Measures using SQL and Data Views in Salesforce Marketing Cloud.
Data Views are a powerful way to segment your data, however they can be slower to run over large data sets. Recreating measures in SQL is an easy way to make your segmentation processes faster.
Key Moments:
Introduction (0:00)
What are Measures (0:23)
Why it's useful to recreate Measures in SQL (0:47)
Measures & Data Views Resources (1:27)
Creating Data Extensions & Queries for our SQL Measures results (1:49)
Total Unique Opens Last 30 Days in SQL (3:04)
Total Unique Clicks Last 30 Days in SQL (13:05)
Total Marketing Sends Last 30 Days (15:25)
Total Emails Not Opened Last 30 Days (23:05)
Summary (31:33)
🌐 Cam's Data Views Diagram: dbdiagram.io/d/5ff259ed80d742...
▶️ Introduction to Data Views: • Introduction to Data V...
Salesforce Documentation:
• Data Views: help.salesforce.com/s/article...
Trailhead Links:
• Query Data with SQL: trailhead.salesforce.com/en/c...
Community Resources:
• Data Views by Mateusz Dabrowski: mateuszdabrowski.pl/docs/conf...
• Data Views by Zuzanna Jarczynska: sfmarketing.cloud/2019/08/22/...
Contact:
/ camrobert
www.cameronrobert.com.au/
/ auscamrobert
Music: www.bensound.com
20 июл 2024