SEO News

Data Sheet

RSS
  1. 3 Steps to Create Buyer Personas & Buyer Journeys to Kick-Start Your Content Strategy

    Have an idea of what you want to ask, but don't just read off a sheet. Now that you have the raw data, you need to put it into a way that's useful. Creating killer content won't do you any good if it's not something your users actually need.

  2. SEO, Demand Generation & Content Marketing: 5 Takeaways From Joe Pulizzi

    One sheet of paper, some picture representation, some bullet points of who that persona is. Pulizzi warns against jumping right in at the level of keywords, platforms and big data. "From the days of cave men writing on the walls, brands have been...

  3. 2 Essential Pivot Table Skills for Marketers: Summarizing Data and Calculated Fields

    You'll first need to add a new column in your data sheet, named "AvgPos x Impressions" above, the column will multiples Avg. We've previously covered a few basics for pivot tables, a powerful Excel tool which helps digital marketers organize and...

  4. SES San Francisco Keynote: Google's Matt Cutts & Patrick Thomas on Search Engine Censorship

    In Google's case, they have a cheat sheet of sorts, where they aim to ensure the results are as comprehensive as possible, removals are kept to a minimum, they rely on algorithms over manual action, they help users avoid identity theft, and they...

  5. How to Introduce a Politics-Free Prioritization Model for Analytics Reporting

    Think of this as your resource management cheat sheet. Building a center of excellence analytics practice, whether it's web analytics or data analytics, is bound to get you a lot of attention. The self-perpetuating cycle of asking business...

  6. 14 Tips on How to Become a More Efficient SEO Professional

    While sheets are grouped, anything you enter in one sheet also gets entered into the others. If you’re editing a lot of data you might need to view how changes in one area make a difference somewhere off-screen, perhaps in another worksheet tab.

  7. Recharge Your PPC Profitability: 5 Ways to Diagnose & Treat a Paid Search Slump

    To do this, pull your data from AdWords and organize it in an Excel sheet with the following columns: Geddes also shares some phenomenal insights into analyzing the data to determine the greatest opportunities for financial benefits and how to...

  8. A Comprehensive Guide to Understanding Quality Score & Tactics for Improvement

    Also, be sure to conduct ads tests to glean “creative takeaways” and stash a reference sheet that indicate which type of headlines, descriptions, CTAs, and display URLs work best for the company. The two driving major takeaways should be that...

  9. How to do Awesome SEO Keyword Research for a Standard Website

    When coming up with keyword metrics there is one golden rule: you have to be able to get all the necessary data for all your keywords in one sheet. Setup: paste a list of all the anchor text phrases used in external links to your site into a column...

  10. Facebook & Twitter Apps Exploited to Profit From Private Data

    Finally, the list is in a zipped excel format split into 12 sheets, each sheet containing roughly 100,000 email addresses with name, last name and facebook profile information separated with comma. Shopov published a post on Oct.titled, “I just...