Factivate Blog Factivate Blog

Menu
  • Blog home
  • Templates
  • Connectors
  • Sheet Actions
  • Sign Up
  • Facebook
  • Twitter
  • LinkedIn

Factivate Marketing Analytics Blog

A Forum for All Digital Marketing Analytics, Business Intelligence, and Spreadsheets

Blog

You are here:
  • Factivate Blog
  • Marketing Analytics
  • Learn How to Become the Best Digital Marketer by Following these Simple Steps

Learn How to Become the Best Digital Marketer by Following these Simple Steps

By admin 2016-07-19 Marketing Analytics

What are the best digital marketers doing differently from you that helps them: get your clients, get promoted, or even be 10 times more effective than you. It’s not that they’re smarter than you. It’s not that they know a secret algorithm that they keep to themselves. Absolutely not. 

Here’s the secret: Typical digital marketers implement marketing tactics hoping that they work or “sticks”. Great Digital Marketers, on the other hand, follow a process founded on data that either proves or disproves a marketing strategy. It’s as simple as that. Here’s how it usually plays out.

Average Digital Marketers

  • Blindly change their website buttons to green because some article said to do so.
  • Only post on Tuesdays because some article says to do so.
  • Pay for cloud-based tools that provide data visualization because others do so.

Great Digital Marketers

  • Run continuous experiments (and measure) to see what website buttons trigger the best reactions.
  • Analyze their demographics, placement of content, messaging, and media to figure out when and where is the best to post an article.
  • Only pay for tools that they can manipulate (without programming), have little to no learning curves, can automate their KPI reporting, and helps them make better decisions within the right timeframe.

In short, great Digital Marketers approach their campaigns as small experiments before spending time/money (like a scientist would) whereas average digital marketers simply use the same old tactics used by traditional marketers.

The spray and pray methodology doesn’t work in digital and if you’re still doing that, it needs to stop. In this post, we will showcase a step by step guide to help you become a great digital marketer. You don’t need any statistical expertise or engineering background to get it done. All you need is some basic spreadsheet knowledge and the ability to stick to a process.

Approach every Marketing strategy with a systematic and scientific method

The scientific method provides a systematic way for you to solve a question by making observations and continuously experiment. The entire concept focuses on repeat experimentation in order to understand variables to ultimately lead to a predictable outcome.

You don’t need to have an engineering or scientific degree to do this. With enough practice, you can follow this simple framework and become a great digital marketer with enough practice. By applying the digital marketing scientific method, you can end up predicting which marketing tactics will be most effective by running small tests to gather data.

Once you have that information, you can make tweaks to your experiments and improve your marketing results. Here’s a summary of how you can begin approaching digital marketing with a different mindset:

scientific_method_for_marketers.jpg

 

1) Start compiling all of your marketing problems/ideas you can think of (or read) into your spreadsheet for digital marketing. In here, outline how long it will take to execute (input time) and how long it can take you to get accurate data readings from an experiment (output time).

Screen_Shot_2016-07-19_at_1.56.40_PM.png

2) Prioritize your marketing strategies based on how they fit with your goals. Then score them based on the probability of success, resources required, and impact.

Screen_Shot_2016-07-19_at_2.15.13_PM.png

Build a reporting infrastructure that will automatically update for you

3) Once you’ve identified the experiment, think of how you will measure all of your experiment KPIs based on your objective. Make sure you state your hypothesis and all of your KPIs serve to either prove or disprove your hypothesis. A good framework for this is the AARRR Pirate metrics framework on a per experiment basis. Pay particularly close attention to all of the variables that will affect your experiment and make sure you have automated the reporting correctly. When finished, your spreadsheet could end up looking something like this:

Screen_Shot_2016-07-19_at_1.50.02_PM.png

 

Add just-in-time reactions to your KPIs

4) After you’ve connected your spreadsheet to automatically update (and pull data from the third party source, i.e. Twitter), add triggers to your top KPIs in order to be alerted whenever a specific KPI changes beyond a particular parameter that could either tell you to stop or accelerate a particular experiment. Some of these can include

  • Send an email when Conversions > 100 for each campaign / channel
  • Send an email when re-tweets > 250
  • Send an email when bounce rates >50% for a landing page
  • Alert me when CPC = $20.00

5) Run your experiment(s). You should be able to validate your assumptions based on the 80/20 marketing experiment. Do this by breaking down your goal into week-to-week growth targets so that you can measure your progress.

6) Create your experiment report by documenting how you will be executing the marketing strategy. These will vary depending on your hypothesis, channel, strategy. For example, if I’m measuring social network conversions, it could look like the image below:

Screen_Shot_2016-06-08_at_8.13.00_AM.png

7) Monitor and analyze your results consistently. If you can, have the spreadsheet open in a screen in the office 24×7 so that you (or someone in your team) can always look at it. To analyze your results, simply ask yourself why the experiment worked (or didn’t work). Identify the key variables that led to the success/failure so that you can make tweaks.

8. If the experiment was a success, apply your findings, and scale the experiment in iterative steps. Continue to focus on the marketing channel until it’s not as successful.

9. Repeat again:)

 

Closing thoughts

There are thousands of marketing documents and white papers that should be used as inspiration and not as a copy/paste playbook for your business. The beauty of our spreadsheet templates is that they can be adopted and customized by almost everybody. Just be sure that you are using a systematic/scientific approach and you will instantly be on your way to become a great marketer.

 

If you would like to see the spreadsheet template that we alluded to in this blog post, you can sign up for Factivate here.

Tagged under: automated facebook reportautomated facebook spreadsheetautomated google analytics reportsautomated spreadsheetbecome a great digital marketerdigital marketing spreadsheet templateFacebook Ads KPIs spreadsheetFacebook Ads reportfacebook campaign spreadsheetfacebook insights kpisFacebook KPIs Ads spreadsheetfacebook kpis reportfacebook kpis spreadsheetfactivatefactivate automated spreadsheetsfactivate facebook spreadsheetfactivate spreadsheethow to build a facebook report spreadsheetInstagram Ads spreadsheetInstagram KPIs spreadsheetintelligent spreadsheetintelligent spreadsheet dashboardskpis to best digital marketing campaignspull facebook into spreadsheetspreadsheet pulls Facebook data automatically

Share on:

You might also be interested in these posts...

  • Should I Fire my Digital Agency? A Definitive Guide to Learning if You or Your Agency are the Problem

    March 28, 2019
  • How to Build & Track Campaign UTMs like a Master Growth Hacker in Five Simple Steps

    February 14, 2019
  • Spreadsheet action triggers – How to have your spreadsheet automatically send you a snapshot of a group of cells every week

    September 28, 2018
  • Facebook Marketing: How to Measure and prove ROI

    September 20, 2018

Post navigation

Previous Post

How to Maximize your Digital Marketing Spend to increase your Channel ROIs

Next Post

How to Set Up Your Facebook Ads Analytics KPIs in Excel Spreadsheets

About Pricing Consulting Services Blog
Contact Contact Form  
Support Guide Automating Reports Spreadsheet Actions Formulas How To
Legal Privacy Terms & Conditions

Scroll up