Marketing Analytics

Technical marketers are in high demand and low supply. Being able to dive into data on your own, with no help from analysts, makes you a much better marketer.

This is why Structured Query Language (SQL) is so powerful - it allows you to see all your customers’ data and make decisions based on accurate analysis. Knowing how to use SQL is literally a marketing superpower, and that’s exactly what this course will teach you!

The concepts and queries in this course are used every day by the marketing teams at successful companies like eBay, Moz and HubSpot.

Highlights

  • Six key components of every SQL query
  • How to identify your most profitable users, and how to attract more like them
  • How to run a cohort analysis
  • How to discover the "aha" moment that turns one-off customers into loyal clients
  • Five key metrics to measure right away after learning SQL
  • Over 1.5 hours of video content
  • Downloadable databases and other resources
  • Case studies
  • Certificate of Attainment

Preview

Course Content

Course Content

Course Content

User Dashboard

Syllabus Explorer

Course Certificate

Syllabus

Section 1: Introduction

directright

Unit 1.1 - Introducing the Course

An introduction to what the course is about and why it's important

Section 2: What is SQL?

directright

Unit 2.1 - Introduction

A video introducing the importance of SQL

directright

Unit 2.2 - What, Why and How

Videos explaining what, why and how SQL works for marketers

directright

Unit 2.3 - Marketing and SQL

Modules explaining how SQL changes marketers' lives

Section 3: Writing SQL Queries

directright

Unit 3.1 - Preparing to Write a Query

A case study and some advice for writing your first query

directright

Unit 3.2 - SQL vs. Excel?

How SQL is similar and different to SQL

directright

Unit 3.3 - Writing Queries

Modules demonstrating how to write queries

Section 4: Using SQL

directright

Unit 4.1 - Querying Databases

How to query databases using SQL

directright

Unit 4.2 - Exercises

A couple of exercises to get you practicing using queries

directright

Unit 4.3 - SQL Scripting and Reporting

How to script and report using SQL

directright

Unit 4.4 - Course Conclusion

A video wrapping up the course

Section 5: Bonus Content

directright

Unit 5.1 - Chartio for Data Analysis

An video explanation of how to use Chartio to perform data analysis

directright

Unit 5.2 - Google Query Creator

A video explaining how to use the Google query creator introduced in Section 3, Unit 3

Pricing

Pricing is for 12 months access.

*The AUD price shown above is an estimate. Actual charges are based on the current exchange rate from GBP

Requirements

Software:

  • Required: none

Completion Time: 15 hours (average)

About the Author

Justin Mares

Justin formerly ran growth at developer-tools company Exceptional (acquired by Rackspace in March of 2013). At Exceptional, he was responsible for growth and revenue across three separate developers tools products - Exceptional, Airbrake and RedisToGo.

While there, he built and managed an inside sales team in Vegas, cut churn by more than 60%, tripled organic traffic, improved conversion rates through a series of A/B tests and doubled average revenue per customer. In this role selling to developers, he also taught himself how to program (poorly), use tools like SQL and R, and familiarised himself with the entire stack of web technologies.

He has also founded two other companies, one of which was acquired.

Justin is also the co-author of Traction Book, a book about how startups can get traction. For the book, he interviewed Jimmy Wales (founder of Wikipedia), Paul English (founder of Kayak), Dharmesh Shah (HubSpot founder) and pulled together an actionable framework for how startups should think about getting traction and distribution.