• 18-19 College Green, Dublin 2
  • 01 685 9088
  • info@cunninghamwebsolutions.com
  • cunninghamwebsolutions
    Cunningham Web Solutions
    • HomeHome
    • About UsAbout Us
    • Our ServicesOur Services
      • Web Design
      • Digital Marketing
      • SEO Services
      • E-commerce Websites
      • Website Redevelopment
      • Social Media Services
    • Digital MarketingDigital Marketing
      • Adwords
      • Social Media Services
      • Email Marketing
      • Display Advertising
      • Remarketing
    • PortfolioPortfolio
    • FAQ’sFAQ’s
    • BlogBlog
    • Contact UsContact Us
    MENU CLOSE back  
    • Home
    • About Us
    • Our Services
      • back
      • Web Design
      • Digital Marketing
      • SEO Services
      • E-commerce Websites
      • Website Redevelopment
      • Social Media Services
    • Digital Marketing
      • back
      • Adwords
      • Social Media Services
      • Email Marketing
      • Display Advertising
      • Remarketing
    • Portfolio
    • FAQ’s
    • Blog
    • Contact Us

    How search data can inform larger online business decisions

    You are here:
    1. Home
    2. Digital Marketing
    3. How search data can inform larger online business decisions
    Thumbnail for 25407

    As an SEO I’m constantly utilizing keyword search volume data to help make more informed decisions about clients’ online presence. But the reality is, this data has way more use cases than anyone gives it credit for. The role of a decision maker in any online business requires the ability to gather (or be presented with), understand, and forecast with all types of data. Simple yet effective methods for identifying trends in online searches can ensure you’re getting your product or services in front of the right people at the right time. This is particularly useful if you sell a variety of seasonal products online. But the same process can be leveraged for single-focus businesses, as well. This data can then trickle down to a variety of team members, from SEO and Paid Search Account Managers, to merchandisers and content strategists. How you ask? Let’s look at some use cases:

    • As a Paid Search Manager, I want to utilize trend data to help inform when to ramp up ad spend on certain product categories.
    • As an SEO strategist, I know it can take months to see the impacts of my work. So, knowing when my customers are searching most frequently will help me to prioritize my focus leading into peak season.
    • As an ecommerce merchandiser, I want to understand how interest in our products have shifted over time. I want to be able to identify new trends gaining popularity so I can make more informed buying decisions.
    • As a content strategist, I want to ensure we are providing our customers the most appropriate user experience based on peak search times for our products. How and when should the site be updated to speak to these seasonal trends?

    And most importantly, as a business owner/key stakeholder:

    • I want to be able to challenge my own assumptions (LOL) about my customers’ needs
    • I want to know if my products are still in demand
    • I want to know if there is a segment where I could expand my business
    • I want to know if there are tangential lines of business that have some growth opportunity

    I could continue, but the point I’m trying to drive home is decision makers in their respective silos are generally unaware of the true value in the data Google really shares. And thus, it’s your job to collect and disperse this knowledge across your organization. Break down those silos, friends.

    So, you’re ready to make a name for yourself in your organization. Great. The best part is, it’s super easy to collect this data and analyze. I’m going to show you how to do it.

    The tools

    I’ll be leveraging a few different tools to capture the data I’m looking for. Specifically:

    • SEMRush for keyword research
    • Google Keyword Planner to pull the historical keyword volume data
    • Microsoft Excel to bring all that sweet, sweet data to life

    Now, you could make the argument that Keyword Planner is unnecessary, as SEMrush provides keyword trend data. However, the data is limited (past year only) and it’s formatted and exported in a rather complicated way that I’m not a huge fan of. Google Keyword Planner has its own which I’ll address a little later on. Remember, we’re using this data directionally, not as the end all be all.

    The steps

    First off, we need to start pulling together a list of relevant keywords for your brand. Depending on the size of your site and the products/services you offer, this could be a very large list, or a very small list. If I’m looking at an enterprise size ecommerce site, I like to approach this in bite size pieces rather than tackling the entire site at the same time. Focus on your priority categories and go from there. Remember, we’re trying to make our list comprehensive because we want to get the most out of our data. For this task I rely heavily on SEMrush’s Keyword Magic Tool. The tool makes it super easy to insert a “head term” and get back a ton of useful and related keywords.

    As I mentioned previously, you want to conduct your keyword research in a way that’s relevant to your site’s taxonomy. Segmenting this data now will make your life a lot easier later when you’re trying to identify trends based on categories. Fortunately, the Keyword Magic Tool makes it easy to segment keywords by specific word groupings, and they’ll neatly categorize these for you in your export.

    Note: if you don’t have access to SEMrush, there are a ton of free keyword tools out there to help you do keyword research. Greenlane has a list of some here. Your site’s own query data from Google Search Console can help you start developing your keyword list. Once you’ve conducted your in-depth keyword research, you’ll want to head over to Google Keyword Planner. Within this tool you’ll have the ability to upload your keyword list and export historical search volume metrics.

    On the historical metrics tab, you can adjust your settings to include specific countries of interest, as well as languages. Most importantly, you’ll want to adjust your timeframe to include a longer period of time, since you know, we’re looking at trends.

    Next you’ll hit Export and select the Download Option “Plan historical metrics (.csv). This will ensure the data you receive is trended by month, which is exactly what you want!

    Remember when I said that Google Keyword Planner has it’s own inefficiencies? Here’s a few things to keep in mind:

    • When reviewing Historical Metrics, Keyword Planner likes to consolidate similar keywords (example: wedding dress and wedding dresses). So you might find that your lengthy keyword list just got cut in half. That’s okay – you can either utilize what you have or try to build out your list further.
    • Keyword Planner also likes to modify keywords. So a keyword in your original list might have been modified by the tool (example: “women’s shoes” might be changed to “shoes for women”).
    • When you export you’ll get a bunch of data you don’t care about, so you’ll have to clean the sheet up a bit. I typically only leave the Keyword and the Keyword Volume Trend columns intact.

    Next, you’re going to combine your SEMrush sheet and your Google Keyword Planner export into a single Excel file. On your Keyword Planner tab you’re going to add a Group column and add a VLOOKUP so that you call pull the keyword grouping over from your SEMrush sheet. This way all your keywords are categorized based on the groupings that align with your site categories. If you don’t know how to do a VLOOKUP, look it up because it will change your life. Once everything is combined, your master sheet will look like this:

    Let’s bring all that beautiful data to life. We’re going to do this through Conditional Formatting in Excel. There are a couple of steps to get the trend visualized.

    Step 1: Highlight a single row of one year’s data. In the example below, that’s January 2017 – December 2017. Then go to Conditional Formatting < Color Scales < Green – Yellow – Red Color Scale. This will make the smallest number in the range red, the largest number green, and anything in between a blend.

    Step 2: Once you have this done, you’ll have to apply the formatting to each row of data within the same year. Highlight your range and click Format Painter. Then apply that Conditional Formatting to each row within the same year. Tip: once you have a few rows completed, you can bulk Format a larger section, so you don’t have to go row by row. See below on how to do it:

    Step 3: Implement the same conditional formatting for each year within your Excel so that you see the high and low values for each year individually.

    VOILA! Your search volume trend chart is complete. Really makes you want some Fruit Stripe gum, doesn’t it? Now you can review the data by category to answer some of those pressing questions you might have:

    • Are your seasonal assumptions about your business valid? Have those search trends changed over time?
    • Has a category gained/lost interest over time? Does this data help to validate some of the increases/decreases in your KPIs?
    • Do seasonal trends start to ramp up sooner than expected? How can you leverage different marketing channels to prime customers for peak seasonality?
    • Is your business even impacted by seasonality online?

    There is a bounty of useful data available to help you make better decisions about your online marketing. These trend charts are just one small step towards my efficient marketing.

    The post How search data can inform larger online business decisions appeared first on Marketing Land.

    From our sponsors: How search data can inform larger online business decisions

    Posted on 5th August 2020Digital Marketing
    FacebookshareTwittertweetGoogle+share

    Related posts

    Thumbnail for 25786
    The Future of CX with Larry Ellison
    19th October 2020
    20201019 ML Brief
    19th October 2020
    Must-know tips for boosting your video strategy
    19th October 2020
    20201016 ML Brief
    19th October 2020
    Thumbnail for 25769
    How to make your data sing
    13th October 2020
    NewsCred rebrands as Welcome
    13th October 2020
    Latest News
    • Archived
      22nd March 2023
    • Archived
      18th March 2023
    • Archived
      20th January 2023
    • 20201019 ML Brief
      19th October 2020
    • Thumbnail for 25788
      Handling Continuous Integration And Delivery With GitHub Actions
      19th October 2020
    • Thumbnail for 25786
      The Future of CX with Larry Ellison
      19th October 2020
    News Categories
    • Digital Marketing
    • Web Design

    Our services

    Website Design
    Digital Marketing
    SEO
    E-commerce
    Social Media Services
    Website Design
    Website Design

    A website is an important part of any business. Professional website development is an essential element of a successful online business.

    We provide website design services for every type of website imaginable. We supply brochure websites, E-commerce websites, bespoke website design, custom website development and a range of website applications. We love developing websites, come and talk to us about your project and we will tailor make a solution to match your requirements.

    You can contact us by phone, email or send us a request through our online form and we can give you a call back.

    More Information

    Digital Marketing
    Digital Marketing

    Our digital marketeers have years of experience in developing and excuting digital marketing strategies. We can help you promote your business online with the most effective methods to achieve the greatest return for your marketing budget. We offer a full service with includes the following:

    1. Social Media Marketing

    2. Email & Newsletter Advertising

    3. PPC - Pay Per Click

    4. A range of other methods are available

    More Information

    SEO
    SEO Services

    SEO is an essential part of owning an online property. The higher up the search engines that your website appears, the more visitors you will have and therefore the greater the potential for more business and increased profits.

    We offer a range of SEO services and packages. Our packages are very popular due to the expanse of on-page and off-page SEO services that they cover. Contact us to discuss your website and the SEO services that would best suit to increase your websites ranking.

    More Information

    E-commerce
    E-commerce Websites

    E-commerce is a rapidly growing area with sales online increasing year on year. A professional E-commerce store online is essential to increase sales and is a reflection of your business to potential customers. We provide professional E-commerce websites custom built to meet our clients requirements.

    Starting to sell online can be a daunting task and we are here to make that journey as smooth as possible. When you work with Cunningham Web Solutions on your E-commerce website, you will benefit from the experience of our team and every detail from the website design to stock management is carefully planned and designed with you in mind.

    More Information

    Social Media Services
    Social Media Services

    Social Media is becoming an increasingly effective method of marketing online. The opportunities that social media marketing can offer are endless and when managed correctly can bring great benefits to every business.

    Social Media Marketing is a low cost form of advertising that continues to bring a very good ROI for our clients. In conjuction with excellent website development and SEO, social media marketing should be an essential part of every digital marketing strategy.

    We offer Social Media Management packages and we also offer Social Media Training to individuals and to companies. Contact us to find out more.

    More Information

    Cunningham Web Solutions
    © Copyright 2025 | Cunningham Web Solutions
    • Home
    • Our Services
    • FAQ's
    • Account Services
    • Privacy Policy
    • Contact Us