Excel 101: Track Your Affiliate Sales and Metrics In Excel
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12 students enrolled

Excel 101: Track Your Affiliate Sales and Metrics In Excel

2019 Update! Template Included For Download! Track, Report and Analyze Your Affiliate Sales and Costs In Excel
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12 students enrolled
Last updated 7/2020
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 article
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn From A Top Rated Instructor Who Has Been Teaching On Udemy Since 2013 and Taught Over 100,000 Students!
  • Template Available For Download For All Students!
  • Accurately Track Your Affiliate Sales
  • Report On Affiliate Streams
  • Create Graphs and Charts
  • Make Informed Decisions
  • Focus On Best Performers
  • Sort and Filter Data
  • And Much More!
  • Microsoft Excel or Google Sheets (free)
  • No other special tools or knowledge is required

Are You In The Business of Affiliate Marketing?

Are You Tired Of Having Multiple Sites You Have To Log Into To Check Your Results?

Do You Want One Central Location You Can Analyze Your Sales Performance and Make Decisions?

Do You Want To Normalize All Of The Performance Metrics From Different Affiliate Sites?

Do You Want To Grow Your Affiliate Business?

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

*** Updated in July 2020 with new content! ***

Enroll today and join the 100,000+ successful students I have taught as a Top Rated Udemy instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus Reason: I provide the template we build in this course for you to download at the end!

Recent Review:

Raul D. says: "I've been in affiliate marketing for a long long time and while yes I've grown my business and made money, I couldn't tell you how much, which campaigns did best, which affiliate sites did best, how much I spent on marketing, etc.  The list goes on.  I decided I need to take my business far more series and this course was the first step and really an amazing place to start.  I was able to use the template to properly start tracking results and right away I can see room for improvement.  Really psyched I took the course and to only grow my affiliate marketing business!"

Why You Should Take This Course:

As an affiliate marketer, you have to wear many hats.  I'm sure you spend the majority of your time managing your income streams while also finding new opportunities.  One which often gets ignored is having a full understanding of how much money is coming in, where its being spent, how you are growing, and what you could be doing to grow more! 

By spending a little bit of time each week to do affiliate marketing revenue tracking, setting goals and tracking your results, you'll have far greater insight into what works and what doesn't, and how to proceed.  You will also be documenting a history of your sales for you to refer to in the future. 

In this course I teach you how to build a relatively simple but VERY effective affiliate marketing and sales tracking system in Excel (or Google Sheets) to track actual results.   Take your business to the next level.

When your business grows further to needing a fully dynamic accounting system you can easily import the data you've tracked in Excel (Sheets). 

What We Learn In The Course:

  • Learn basic Excel concepts for anyone not familiar with the program

  • Learn how to create a dynamic tracking spreadsheet

  • Learn how to run reports on the data

  • Learn how to create charts and graphs

  • Learn how to make intelligent decisions and earn more

This course is not meant to be a complete introduction to accounting, instead it is for affiliate marketers who want to do basic tracking of incoming revenues and be able to make decisions using the data.

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  


About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 25 years experience in accounting, finance, financial reporting, small business and accounts receivable.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course on Udemy. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

Who this course is for:
  • Affiliate Marketers
  • Entrepreneurs
Course content
Expand all 25 lectures 02:13:17
+ Tracking Revenue
7 lectures 34:48
Introduction to Blank Workbook
Revenue Headers
Affiliate Sales Names and Lists
Affiliate Products and Lists
Sales Data
Sales and Totals
Sales Data and 4 Month Data Review
+ Tracking Costs
3 lectures 15:33
Costs Tab Setup
Costs Data 1
Costs Data 2
+ Dashboard Reports
6 lectures 23:33
Dashboard Setup 1
Dashboard Affiliate Revenue Report
Dashboard Sales REport
Dashboard Overview
Dashboard Profit and Loss
Dashboard Wrapup
+ Course Conclustion
4 lectures 23:05
Course Conclusion
2020 Update - What's New In The Business For 2020
Recommended Next Steps
Bonus Lecture: Discount On All My Other Courses