Marketing dashboard! Sounds like a scary thing, doesn’t it? Dashboards are technical and marketing requires a degree right? False on both accounts. In fact you can setup a marketing dashboard to determine your daily profit and loss from your website traffic in only 15 minutes. In this post I will show you how.
Revenue is the amount of money received during a period, without costs deducted. Think of it is gross income.
Each webpage loaded in a browser. If you go to a website homepage, then click to an article on it, then click to another article, then go to another website, that is three pageviews.
Each individual visit to a website from a specific IP address and browser in a time period–usually 30 minutes. Going to a website and reading a dozen individual articles on different pages is still considered one user session or visit.
RPM stands for revenue per thousand impressions. The M in it stands for mil or one thousand. It is typically calculated as:
Total revenue divided by website pageviews divided by 1000 first. If your website made $500 in revenue on a date, and you had 10,000 pageviews, the formula would work out to $500/(10,000/1000) = $50 RPM.
EPMV stands for earnings per thousand visitors. It is typically calculated as:
Total revenue divided by website user sessions divided by 1000 first. If your website made $500 in revenue on a date, and you had 5,000 user sessions or visits, the formula would work out to $500/(5,000/1000) = $100 EPMV.
The first step is creating a new spreadsheet in Google Sheets. Name the tab on the sheet sometime simple–you’ll reference this name in the script you’re going to setup. I’m going to name my spreadsheet “Sample Marketing Dashboard” and my sheet in it “Raw Data”.Click on the link so you can look at it. Also, we’re going to start the data on January 1st of 2018. No worries if you want to start on January 1st, 2017 or something else but starting on January 1st keeps things simple. Remember KISS! Keep things simple stupid. When your marketing dashboard grows and grows in the future as you add breakouts for specific marketing channels like emails, Facebook, CPC traffic from Outbrain and Google, etc. you’ll be glad you starting things on January 1st and followed KISS. You don’t know frustration until when Google Sheets tells you that you hit the maximum number of cells allowed in a workbook (spreadsheet).
https://developers.google.com/analytics/solutions/articles/reporting-apps-script
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=time
I spend a lot of money on Facebook advertising for both businesses and other marketing…
I've worked as a digital marketing consultant for dozens of businesses across different industries and…
F5Bot is a free service that emails you when your selected keywords are mentioned on Reddit, Hacker…
Marketing Hackers is a new media and digital marketing consulting company that focuses on growth…
Marketers have often leveraged the internet's large platforms like social media for marketing. Nevertheless, increasing…
In Laymen's terms, Blockchain Technology can be explained as spreadsheets or ledgers which are shared…
View Comments
More coming soon!