Tag Archives: smart digital spending

Online Media Analyst Qualifications

SDS mini logo

Top 5 Qualities to look for in an Online Media Analyst

The primary function of an Online Media Analyst is to assess an advertiser’s campaign performance in order to identify ways to eliminate media waste and increase online conversions. The Online Media Analyst position (also referred to as Online Marketing Analyst or Internet Analyst) is roughly a new kind of role in the advertising industry. A good experienced Analyst will possess 4 of the 5 qualities that I will share with you in a moment. However, before we look at these qualities, let’s make sure we understand what an Online Media Analyst is NOT.

Agencies that use Free SDS Advertising data analysis tutorials

Online Marketing Analyst

Online Marketing Analyst

An Online Marketing Analyst is NOT a Research Analyst or Database Manager. The primary role of a Research Analyst is to design or assist in the development of questionnaires, identify competitors and research changes in the industry that may affect sales. The primary role of a Database Manager is to create and distribute reports. They will likely have experience with SQL, Access, web site analytics tools and Business Objects. So if you are interviewing candidates for an experienced Online Media Analyst position, how do you know if the candidate has the right skills for the job?

Interview question to ask a candidate for a senior Online Media Analyst position – Quality #5

If you are interviewing candidates for a senior level Online Marketing Analyst position, it is first best to confirm they have an online analytics or digital analyst background. Here is one question you can ask the candidate – “if a client wanted to increase paid search weekly spend by 30%, how would you determine or predict the number of sales they’d expect to generate as a result of the increased media activity?”

A candidate with an Online Marketing Analyst (Analytics) background should be able to answer this question which results in quality #5, the ability to assess the problem and determine how to go about finding the proper solution. If they cannot answer this question, this candidate is likely not qualified for a senior Online Marketing Analyst role. (If you want to know the answer to this question, please send me an email).

Quality #4 – Intermediate to Advance Expertise with Excel

An analyst must be able to process and analyze data very quickly and this is where good Excel skills come in. An experienced analyst will know how to use Vlookups, Pivot Tables and Solver. If they have some experience with Access and VBA Modeling, even better!

To find the best jobs for Marketing Analysts, Web Analysts and Research Analysts, click here.

Quality #3 – Had a Great Mentor

A good mentor guides, critiques and helps improve an employee’s performance in every way possible. When I was a Media Planner years ago, I was very fortunate to work under Greg March, Media Director at Wieden + Kennedy. Greg had began his career with Beyond Interactive (now Beyond Interaction) back in the 1990’s and taught me a great deal, everything from trafficking banner ads to developing innovative ways on how to work with ad networks.

As an analyst, I worked under Jennifer Zola, Director of Strategy and Insights for GroupM Search and MECi. Jennifer’s background in data analysis and statistical modeling served not only as valuable experience for me, but also for clients and media teams. I owe both Greg and Jennifer a great deal of gratitude for I believe I worked alongside two of the best and most experienced minds in the online industry!

So ask for references and find out if they had a good mentor because if they did, it is likely they are better than what their resume entails.

Agencies that use Free SDS Advertising data analysis tutorials

Quality #2 – Had Previous Experience as a Media Planner/Buyer

With the internet, there is a virtually unlimited amount of online data at our fingertips. This is great for analyst since there is so much information that can be pulled from this data. However, analyzing all this data will often lead to a waste of time. What is the purpose of spending two weeks analyzing data and finding out some interesting, but useless information?

Before looking at data and performing any analysis, an analyst should ask him/herself this one question – “Will the conclusion or strategic finding possibly change the way I plan or buy my media?” This is why I think the 2nd best quality an Online Media Analyst can have is to have a media planning background. Otherwise, they can easily waste a great deal of time analyzing data that will not lead to optimization recommendations.

Quality #1 – Cares About Performance

A person who cares about performance will get the job done, simple as that. An analyst who cares about his/her client’s campaign will find a way to optimize and doesn’t mind working late or weekends because it is very likely they like what they do. And if this person likes what they do, they will likely be good at it!

To find the best jobs for Marketing Analysts, Web Analysts and Research Analysts, click here.

If you have any comments or thoughts, please share. Thanks.

Eric Melchor

www.smartdigitalspending.com

Follow us on Twitter!

Follow us on Twitter!

Facebook Us!

Facebook Us!

Online Marketing and Data Analysis

SDS mini logo


How does data analysis enhance online marketing?

The beauty of internet marketing is that if properly set up, everything can be tracked. And since impressions, clicks, and conversions can be tracked, data is available for analysis.

Agencies that use Free SDS Advertising data analysis tutorials

Data analysis can provide strategic insight and answer questions like:

  • How many search conversions can we expect if we increase search spend by 50%?

free forecast tutorial

  • Should we implement a frequency cap on our display ads?
  • When running thousands of keywords, how can we optimize quickly and reduce spend?

Paid Search Tutorial

  • How does media activity in one channel impact the performance of another channel?
  • Is there a better metric to look at than CTR and CPC?

beyond CTR tutorial

Great, so how can we start using data analysis? Do we log into Google and press a ‘Data Analysis’ button?

Unfortunately it is not that easy, at least not yet. There are ‘Analytics’ people you can try and hire, but you may have a tough time since this kind of work is relatively new and there are not many experienced online marketing analyst around. Moreover, not every online analyst will be able to answer these questions. Some analysts just focus on research and know how to use tools like Comscore and Nielsen. Other analysts just do reporting and database management. The kind of analyst you need is someone who is focused primarily in digital media and has experience performing data analysis with REAL campaign data. They should at minimum know how to:

  • perform a diminishing returns model (forecast conversions based on historical spend)
  • know how to rank variables from best to worst across multiple metrics (rank mobile publishers)
  • perform an Independent T-test (so they can know which creative statistically works better)
  • do a regression analysis (understand how TV or online display impacts paid search)
  • know how to use Vlookups and pivot tables (organize data quickly and create reports)

Well I can go on and on, but these are some of the basics that an online marketing analyst should know. You can also learn how to do these in your MBA program. The stats class should cover these techniques. Or you can save money and time by just learning from the data analysis tutorials that I provide.

Sooner or later, your clients are going to start demanding accountability if they haven’t already. And data analysis is the answer.


If you have any thoughts or opinions, please share. Thanks.

Eric Melchor

Founder of Smart Digital Spending

Share

Focus on PPC or SEO?

SDS mini logo

Should a company focus their search marketing efforts on Paid Search (PPC) or Organic Search (SEO)?

Free tutorials

This question was posted on LinkedIn a few days ago and it sparked some good responses. In my experience working on different client accounts, I’ve noticed that visitor referrals arriving from organic search tend to stay on a site longer and view more pages than referrals coming in from paid search. In essence, organic visitors are more qualified traffic.

PPC vs SEO

PPC vs SEO

Jon Baer writes: PPC will give you “quick hits”. You can set up a PPC quickly and start seeing results in 48 hours. PPC is a good way to test keywords that you want to be organically optimized for.

SEO is better in the long term. It is cheaper and if you continuously update your site, you will reap the benefits for a long time.

Mary Jo Caruso writes: PPC is instant gratification (depending on your budget) you will appear on the first page of search engines immediately.

SEO is a long term strategy. It will take time to increase your rankings and there are no guarantees of search engine placement. Most people do not want to hear that they have to spend time and money on something that is not guaranteed, however, if you look at SEO over time, it usually yields a better ROI than PPC.

Bobby Duebelbeis writes: By using paid placement within search engine results, you are only starting with a 11 – 15% impression rate. Take your average 4% click-thru-rate from that, and then weed out another 4-5%  of people who actually convert from that number. Congratulations! You’ve whittled down your audience to 5 people after spending $10,000/month on PPC (This is an exaggeration but I am sure you get the point).

These are some great comments from very knowledgable people in the industry. Now if your site already ranks high in organic listings, should you still do PPC? Or, lets say you had the budget, should you pay to keep search terms in the top position versus lower positions? Feel free to read more of my blog posts for these answers.

Sukirti also gives a clear description of the difference between the SEO and PPC at Applelounge blog.

Have any thoughts or opinions? Please share. Thanks.

Eric Melchor

www.smartdigitalspending.com

Follow us on Twitter!

Follow us on Twitter!

Facebook Us!

Facebook Us!

Share

Data Analysis Tutorials for Agencies?

SDS mini logo


How I thought of the idea to offer data analysis tutorials to agencies….

Agencies that use Free SDS Advertising data analysis tutorials

While working as a Media Analyst over the past few years, I realized I was essentially performing the same kinds of analysis over and over again for different accounts. The clients and media teams may have been different, but the analyses were roughly the same.

Smart Digital Spending Tutorials

Smart Digital Spending Tutorials

Clients ask the SAME questions and want to know that their agency is spending their advertising dollars wisely.

  • What is the maximum amount we can spend online each week in order to maintain our cost per acquisition goal?

free forecast tutorial

  • Should we invest all our money in paid search so that we can be in the top position of search results?

Paid Search Position Tutorial

  • Besides looking at CTR and CPC, how can we measure the performance of the publishers/sites we are running on?

beyond CTR tutorial

  • Is there way to see all my media activity and campaign results in one report… like a Media Dashboard?

Different Clients…… Same Questions………Same Kinds of Analysis

Sames kinds of Analysis can be performed for any Advertiser no matter if:

  • The account is Large or Small
  • It is a branding or direct response campaign
  • The campaign has ran for several years or just a few weeks

I was performing the same kinds of analysis over and over using the same kind of data! Impressions are impressions, clicks are clicks, money spent is money spent, and conversions are conversions. Of course not every advertiser is the same, but their data is!

Analysis that help media planners evaluate publishers beyond CTR and CPC, techniques that enable search associates to quickly evaluate thousands of keyword, models that forecast conversion volume based on historical spend….. and more! These analysis are simple to perform yet very effective and can easily be learned! No need to take a statistics course, do not have to be an Excel whiz, Media Planners and Search Associates can do these on their own!

I provide you with step-by-step written, audio and video instructions! Each tutorial is based off a real world example. As shown,  written instructions also include illustrations of what to expect when working in Excel.  An Excel file with sample data comes along with each analysis along with a video that takes you from start to finish on how each analysis was completed! Your team can see how the data was organized and how formulas were calculated in Excel!

Online Marketing Tutorials

Online Marketing Tutorials

Snapshot of Excel file with sample data….

Online Data Analysis - Smart Digital Spending

Online Data Analysis - Smart Digital Spending

Snapshot of Video with Audio…

Smart Digital Spending Video Tutorial

Smart Digital Spending Video Tutorial

So why did I think of the idea of providing Online Marketers with data analysis tutorials designed to enhance campaign performance?

  • An experienced dedicated online media analyst costs too much money to hire. In addition, in today’s job market we know that employees change jobs every two years or so taking with them all that knowledge.
  • You cannot afford to waste time learning how to perform data analysis techniques on your own
  • You want to develop the skills of your media planners and search associates because the more your employees know, the better equipped they will be to solve problems, satisfy clients, and help your company grow

To see the full presentation on how I thought of the idea to provide agencies with data analysis tutorials, email me at eric@smartdigitalspending.com


Eric Melchor

Follow Eric on Twitter Twitter Logo

Follow Smart Digital Spending on Facebook!Facebook Logo

www.SmartDigitalSpending.com


Share

How a customer reacts to your tv ad

SDS mini logo
Agencies that use Free SDS Advertising data analysis tutorials
Should be arrested for running a tv ad without support of paid search!

Should be arrested for running a tv ad without support of paid search!

Eric Melchor

www.smartdigitalspending.com

Follow us on Twitter!

Follow us on Twitter!

Facebook Us!

Facebook Us!

Share

Web Analyst Qualifications

SDS mini logo


Qualities to Look for in a Web Analyst

When hiring a web analyst, it is best to hire someone who has a curious mind but also can see things from a holistic view. What do I mean exactly?

Agencies that use Free SDS Advertising data analysis tutorials

Well, if your web analytics person spends all day pulling valuable information and reports to you that people in Alaska spend 25 seconds longer on your site than the general population, how is this information going to make you change the way you buy media or modify your site?

To find the best Web Analytics jobs, click here.

Actionable web analytics

Actionable web analytics

Web Analytics an hour a day

Web Analytics an hour a day

There is so much information that can be retrieved from Omniture, Webtrends, or Google Analytics that it can lead to frustration. That is why if you are in Upper Management and are just supervising web analytics professionals, you should read Actionable Web Analytics by Jason Burby since it tells you how you can use data to make smart business decisions.

If you are a web analytics expert, then you should definitely read Web Analytics An Hour a Day by Avinash Kaushik, but you already knew that.

Smart Digital Spending is currently looking into possibly creating a Web Analytics Tutorial in the future.

To find the best Web Analytics jobs, click here.


Eric Melchor

Follow us on Twitter!

Follow us on Twitter!

Facebook Us!

Facebook Us!

Share

Best metric for measuring online success

SDS mini logo


Beyond CTR and CPC

Agencies that use Free SDS Advertising data analysis tutorials

Recently I came upon a question posted on LinkedIn asking if there were any good metrics besides CTR and CPC. While the question was already several days old, I was surprised to read the responses. Most of the respondents agreed that cost per conversion was the only metric that really matters. However, what if your client is not running a direct acquisition campaign? If your client is a service company or perhaps cannot sell their products on the web (i.e. Pharma, Consulting companies), then there is no cost per conversion metric.

Metrics not to use for measuring online success
Metrics not to use for measuring online success

Just because your ads may receive a high CTR on a certain site, this does not mean that the audience is actually navigating beyond the homepage. Even if you judge the performance of a publisher based on cost per acquisition, there are still other things you would like your visitor to perform while visiting your site.

So what metric can be applied to both branding and direct acquisition campaigns? Actually, what do I consider the best (and proven) metric for measuring online performance?

Well ideally you want your consumers to visit your key pages on your website correct? So lets imagine that you have a website where you sale tennis rackets online and in total, you have 12 different pages on this site. The primary action you want people to do on your site is buy a tennis racket. Here are a list of all the pages on your site:

  1. Homepage
  2. Selection of Rackets on Sale Page
  3. Famous quotes from John McEnroe
  4. 2009 ATP schedule
  5. Contact Us Page
  6. Learn about different tennis strings
  7. Rafael vs Federer blog – who is better?
  8. Tips from Jimmy Connors
  9. Sign up for Email Newsletter
  10. Past Grand Slam Winners
  11. Order Page
  12. Order Confirmation Thank You Page

While the John McEnroe quotes, Federer blog, and Jimmy Connors tips pages are amusing and helpful, they don’t really help sell tennis rackets on your site. However, you have an email newsletter that people can sign up for which is an important action you want your visitors to do. In addition, visitors reaching out to you are important, so the Contact Us Page is of value. Finally, you want people to go to the Selection of Rackets on Sale page from the Home page since this is where you display the rackets you are selling. Out of all these pages, there are 5 that you want your target audience to navigate to. (Order Page and Order Confirmation Thank You page being the other two).

Okay, so now what?

Cost per weighted Point Scale
Cost per weighted Point Scale

So now that we have determined the pages that we want our audience to visit, we assign a ‘weight’ to those pages. The more important the page, the higher the weight. Obviously the Order Confirmation Thank You Page is the page we value most since we know a sale took place, thus it is weighted the highest. If you are not selling any products, but have a ‘sign up for newsletter’ or ‘print coupon’ page, those pages can be weighted the highest. Now that we understand the concept of a weighted scale and have established the amount of weight we are going to apply to our most important pages, we can move on to the report we generally pull from our ad server (Atlas, DoubleClick, Zedo or whichever ad server you use as your 3rd party).

beyond CTR tutorial

Online report from ad server
Online report from ad server

A standard report will show the date, name of publisher, creative description, impressions, clicks, cost and the volume of actions that occurred on all the pages that are tagged. (actions are visits to all pages on the website). By following the Smart Digital Spending Weighted Point Scale tutorial, you will learn how to evaluate publishers on both a CPC method and a cost-per-weighted-point (CPWP) method. The written, audio and video tutorial (written instructions are 4 pages long, video is 9 minutes) will use a real-life example and take you from start to finish on how to implement the CPWP method. So easy to follow along, a caveman can do it!

Video Tutorial of CPWP
Video Tutorial of CPWP

After implementing the CPWP, you can compare the two methods of evaluation: Cost per Click versus Cost per Weighted Point. Comparing the two methods of evaluation will show you that making planning decisions based on CPC leads to media waste since we really don’t know if these publishers are driving the right people to key pages on our website. Utilizing a weighted point scale DOES show you which publishers you should drop from your campaign and which ones you should keep. Utilizing a weighted point scale leads to smarter media buying decisions!

Best Online Metric for Measuring Online Success
Best Online Metric for Measuring Online Success


Have any thoughts or opinions? Please share. Thanks.

Eric Melchor

www.smartdigitalspending.com

Follow Us on Twitter
Follow Us on Twitter
Facebook Us!
Facebook Us!

Share