
Explore web analytics by defining traffic sources, using Google Analytics to track visitor origins, and learn to diversify sources—from direct visits and Google search to paid campaigns.
Calculate cost per lead under a $1,000 budget to compare Facebook and AdWords, using clicks and lead conversion to determine which platform yields cheaper leads and why downstream value matters.
Explore how net promoter score gauges willingness to recommend, classify customers as promoters or detractors, and compute NPS by subtracting detractors from promoters using a 0–10 survey.
Learn to quantify customer touch points by adding a 'touch_points' field and counting webinar, ebook, and coupon interactions to estimate how many times a lead was touched before converting.
Calculate CLV from one-year gross profit, 75% margin, retention rate, and 10% discount rate to yield $385. Subtract acquisition cost for net CLV and guide PPC and social media decisions.
Evaluate LinkedIn and Spotify ads by analyzing costs, clicks, listens, leads, and customer acquisition costs, then plug results into a model to decide if the channels are worth it.
Set assumptions to reveal customer acquisition cost by adjusting social media salary from 50k to 55k, allocating time from 20% to 100%, and budgeting paid and organic channels like Spotify.
Model organic growth by setting Facebook and LinkedIn 8% conversions, Twitter 5%, with 73% retention, and compare 1% growth without a manager to 9% with full-time management.
Learn to project ad revenue with an Excel model that tracks new customers, churn, and retention, converts yearly revenue to monthly, and applies to AdWords campaigns.
learn to create spin buttons in Excel to make marketing budget assumptions dynamic by linking AdWords, Facebook, LinkedIn, and Spotify spend to projection cells; adjust conversion and follower growth interactively.
Learn to create two 2d line charts for the number of followers and break-even analysis, embed them in a dashboard, and present a clear, data-driven narrative from analytics.
In this big data age, knowing how to organize, synthesize, and analyze large quantities of marketing data is no longer an "good-to-have" skill. It is absolutely essential! Are you a student looking to set yourself apart from your peers? Are you looking to break into social media marketing? Do you want to become an expert in marketing analytics? If so, then this course is for you!
In this course, we'll teach you everything you need to know to become an expert in marketing analytics. No prior experience in social media marketing, statistics, or marketing required!
Our course is based on the hands-on, case-study method to learning. In other words, we'll learn by analyzing the data in a real-life scenario. The course begins with an introduction to big data, data analytics, and marketing analytics. This will allow you to feel comfortable with these terms.
Afterwards, we move on to learning the most important web, social media, digital advertising, customer, and revenue metrics in marketing. As we learn each new metric, we'll immediately apply it to the real-life case study.
We cap off the course by teaching you how to properly model out a new marketing initiative. This model will project out a campaign's revenue and expenses for 2 years and will be complete with scenario and sensitivity analyses. We then conclude by summarizing our data in a beautiful, dynamic dashboard.
We are excited to have you join us on this journey and look forward to seeing you in the course!