Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Marketing Analytics Intermediate

Email & Social Media Marketing Metrics

Track list health and cohorts, score email campaigns, flag deliverability risks, measure engagement rates and post types, price influencer deals, report channels by UTM and build a monthly KPI report, with every cell checked as you go.

9 lessons 9 labs 2.2 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Roll Juniper Lane's subscriber list forward month by month and see why net growth shrinks even though churn stays flat.
  • Score six email campaigns on clicks, CTOR, conversion and revenue per email, and correct the open rate for machine opens.
  • Turn a cohort table of engaged subscribers into retention rates, a weighted retention curve and a monthly decay rate, then forecast June's sign-ups.
  • Build an automatic traffic light for eight sends: bounce and complaint rates, a reputation score band, and an OK / Warning / Stop action with nested IF.
  • Compare five social accounts with two engagement-rate formulas and a weighted version, and see how the ranking changes with the formula.
  • Summarise a month of posts by type with COUNTIF and AVERAGEIFS, keep boosted posts out of the comparison, and rank the post types.
  • Compare four creator offers on CPM and cost per engagement, estimate the profit each post should bring and work out a break-even fee to negotiate with.
  • Roll tagged traffic up by channel with SUMIFS, compute each channel's revenue share and revenue per session, and build a clean UTM link for the next newsletter.

About this course

A monthly marketing report should answer one question: what worked? This course builds such a report from email and social data. You track list growth, churn and bounces, then compute open rate, click rate, click-to-open rate and revenue per email for each campaign. Subscriber cohorts show how lists decay, and simple rules flag bounce, complaint and reputation issues. On the social side, you compare engagement rate by followers with engagement by reach, find the strongest post type, and price influencer deals by CPM, cost per engagement and expected value. UTM-tagged links attribute revenue to channels, and everything comes together in a KPI report with month-on-month change and targets. For marketers, social media managers and small business owners.

Curriculum

Course content

9 lessons · 9 labs · 2.2 h · final exam

  1. Email List Health: Growth, Churn and BouncesLab13 min5 checked tasks
    Unlocked when you buy the course
  2. Campaign KPIs: Open Rate, Click Rate, CTOR and Revenue per EmailLab14 min4 checked tasks
    Unlocked when you buy the course
  3. Subscriber Cohorts and List DecayLab16 min4 checked tasks
    Unlocked when you buy the course
  4. Deliverability Checks: Bounce, Complaint and Reputation Flags with IFLab15 min5 checked tasks
    Unlocked when you buy the course
  5. Social Engagement Rate: by Followers vs by ReachLab14 min4 checked tasks
    Unlocked when you buy the course
  6. Content Performance: Which Post Type Works Best?Lab15 min4 checked tasks
    Unlocked when you buy the course
  7. Influencer Deal Math: CPM, CPE and Expected ValueLab14 min4 checked tasks
    Unlocked when you buy the course
  8. UTM Link Tracking and Channel Revenue ShareLab15 min5 checked tasks
    Unlocked when you buy the course
  9. Monthly Marketing Report: KPIs, MoM Change and TargetsLab15 min4 checked tasks
    Unlocked when you buy the course
  10. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Marketing Analytics courses →
$9.99one-time payment
Buy course