SQL For Marketers – Collect, Connect and Get the data you need for deeper analysis and effective marketing - Marketing Analytics Summit Las Vegas
June 1, 2020
8:30 am - 4:30 pm
Early Bird: $1,000
Regular Price: $1,200
Pre-Event Price: $1,400
Onsite Price: $1,600

SQL For Marketers – Collect, Connect and Get the data you need for deeper analysis and effective marketing


Savvy marketers understand the value of data they have about their customer and their behavior. They use this data enhance their website, develop campaigns and marketing programs that drive positive outcomes. A key component of being data driven is the ability to quickly collect data, manipulate it and draw conclusions. However, they are often blocked by other priorities of SQL developers.   The course is developed to help Marketers become self-sufficient to extract and manipulate the data without a SQL developer.

This course will teach everything marketers and marketing need to pull and combine the data to generate deeper marketing insights.

What you will learn:

  1. Fundamentals of the relational database and table structures
  2. Query writing to pull the required data, update data, add new data and delete data
  3. Data integration from various sources such email, CRM, website logfile etc.
  4. How to export data from the databases to flat files for further analytics  in Excel or Tableau
  5. Identifying the most loyal and most profitable customers
  6. Scoring your customers based on their purchase behavior
  7. Customer categorization based on various criteria in your data sources – develop customer segments for better targeting
  8. Conducting cohort analysis
  9. Combining offline and online data to create remarketing lists in Google Ads
  10. Using data from the database to augment Google Analytics or Adobe Analytics reports – Will walk you through the process with Google Analytics

By the end of this workshop, you will:

  • Understand databases and SQL
  • Learn how to harness data from various sources to become a better marketer.
  • Write SQL queries to pull the right data from database yourself so that you don’t have to be dependent on your developers.
  • Add a valuable new skill to your arsenal that will immediately make you a better data-driven marketer, marketing analysts and growth hacker.
  • Have readymade SQL scripts and recipes that you can use right away.


Anil is a seasoned Digital Marketing and Analytics consultant with 15 years of experience. Anil has worked with companies ranging from Fortune 50 to startups and has helped their Digital channels improve business results. Anil’s customers include Microsoft, SmartMoney.com, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet.com. Anil holds a B. Tech in Electronics and Communication Engineering from India and an MBA from University of Washington, Seattle.

He has taught and trained several Digital Marketing and Analytics folks in the past 9 years of teaching at UBC, University of Washington, Bellevue College and speaking engagements at various conferences as well as his blog, http://webanalysis.blogspot.com. He also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.


Ready to attend?

Register now! Join your peers.

Register nowView agenda

Knowledge is everything!
Sign up for our newsletter to receive:

  • 10% off your ticket!
  • insights, interviews, tips, news, and much more about Marketing Analytics Summit
  • price break reminders