<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Jake on Medium]]></title>
        <description><![CDATA[Stories by Jake on Medium]]></description>
        <link>https://medium.com/@jsvxc?source=rss-34213cec1081------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*CC7KwY5UAaj-FFQ7.jpg</url>
            <title>Stories by Jake on Medium</title>
            <link>https://medium.com/@jsvxc?source=rss-34213cec1081------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 16:30:01 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@jsvxc/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[45 Tips for Solopreneurs (That I Learned The Hard Way)]]></title>
            <link>https://medium.com/@jsvxc/45-tips-for-solopreneurs-that-i-learned-the-hard-way-1dfd118306e5?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/1dfd118306e5</guid>
            <category><![CDATA[online-business]]></category>
            <category><![CDATA[solopreneur]]></category>
            <category><![CDATA[entrepreneurship]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Tue, 17 Aug 2021 18:38:03 GMT</pubDate>
            <atom:updated>2021-08-23T08:23:13.738Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GYHgMJRA2mRh3BBixBqmCw.jpeg" /></figure><p>Working online can be hard. It can be even harder if you are working solo.</p><p>Over the last 5 years, I’ve worked for myself online, creating content, <a href="https://jsvxc.com/seo-services/">SEO’ing websites</a> and building assets.</p><p>Here are 45 things I learned along the way:</p><h3>1. Ask the (right) questions</h3><h3>2. Pick 3 big things to do each day.</h3><h3>3. Eliminate stuff to free up time</h3><h3>4. Find anti role models</h3><h3>5. Build rituals to trick your brain into working</h3><h3>6. Work when you want to work</h3><h3>7. Optimise your work space</h3><h3>8. Use the project management tool with least friction</h3><h3>9. Output is only as good as your inputs</h3><h3>10. Create an anti-bucket list</h3><h3>11. Beware context (context switching is the mind killer.)</h3><h3>12. Remove slack notifications and emails from your phone.</h3><h3>13. Have hobbies away from a screen. Ideas don’t happen at desks.</h3><h3>14. Automate stuff (but only once you’ve done it yourself a few times).</h3><h3>15. Talk to people who don’t work in your industry</h3><h3>16. Do your own thing</h3><h3>17. Sharing is caring</h3><h3>18. If you stare too long into the abyss, the abyss stares back</h3><h3>19. Build your own status symbols.</h3><h3>20. Enjoy the process</h3><h3>21. Shift what works in other domains and apply it elsewhere</h3><h3>22. Work in public</h3><h3>23. Knowledge gaps are normal</h3><h3>24. Stack your skills</h3><h3>25. Humans work with humans. Sprinkle your own unique brand of human onto the stuff you create.</h3><h3>26. Save ideas (because you will forget them)</h3><h3>27. <em>Life is too important to take seriously.</em></h3><h3>28. Reduce daily decisions.</h3><h3>29. Listen to different music for different types of work.</h3><h3>30. Be boring</h3><h3>31. Oooo look at that: AVOID shiny object syndrome</h3><h3>32. Get the basics right (over and over)</h3><h3>33. Being good is more about consistently getting the basics right.</h3><h3>34. Get ideas out of your head</h3><h3>35. Iterate/irritate</h3><h3>36. Too many cooks spoil the broth. But not enough equals bland food.</h3><h3>37. Be kind to others</h3><h3>38. You don’t have to care about all things all the time</h3><h3>39. Schedule me time</h3><h3>40. Build simple systems + processes</h3><h3>41. Kill open loops (unfinished tasks)</h3><h3>42. No one knows what they are doing.</h3><h3>43. If you are building a business online or following a non traditional career path: you are no better than someone working a 9–5.</h3><h3>44. <strong>Learn to shut the f*ck up.</strong></h3><h3>45. Doing &gt; talking about doing.</h3><h3>Wrapping up</h3><p>Want to read more about the tips above?</p><p>Go check out the full post here → <a href="https://jsvxc.com/tips-for-working-solo-online/"><strong>45 Tips for Solopreneurs</strong></a></p><p>The full post goes into A LOT more detail. It is a (growing) collection of thoughts, quotes and tips for working solo online and generally getting sh!t done.</p><p>Enjoy.</p><p><em>Originally published at </em><a href="https://jsvxc.com/tips-for-working-solo-online/"><em>https://jsvxc.com</em></a><em> on August 17, 2021.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1dfd118306e5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to create a (humble) online business]]></title>
            <link>https://medium.com/@jsvxc/how-to-create-a-humble-online-business-a955101d2b5d?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/a955101d2b5d</guid>
            <category><![CDATA[online-business]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[entrepreneur]]></category>
            <category><![CDATA[side-hustle]]></category>
            <category><![CDATA[entrepreneurship]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Fri, 10 Jan 2020 17:25:11 GMT</pubDate>
            <atom:updated>2020-05-04T08:38:40.208Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Uayk2vvhkdMRuoqf.jpg" /></figure><p>Like a lot of people: I want to create an online side business.</p><p>There are lots of articles &amp; resources about how to create one. But I’ve got two things rattling around my brain:</p><ol><li>I don’t know much about running solo businesses.</li><li>I don’t want to grow and scale an obnoxiously large company.</li></ol><p>Solving #1 is pretty easy: get experience. Observe and learn from others who do have experience. Give things a go, fail, learn, repeat.</p><p>But #2 is trickier. I thought such a thing didn’t exist until I saw the term <strong>humble business</strong> nestled away in a Twitter bio.</p><h3>What is a humble business?</h3><p>As described (coined by?) <a href="https://twitter.com/iannuttall">Ian Nuttall</a>, humble businesses are:</p><blockquote><em>Simply built, simply run and generate dependable revenue and profit.</em></blockquote><p>Sound’s like the exact thing I was looking for (+ the antidote to HUSTLE culture).</p><p>So with that in mind, I began thinking about one of my goals I keep putting off:</p><p><strong>Create a simple, small and sustainable business to improve my current skills, learn new skills and generate some predictable income.</strong></p><p>While I don’t buy into New Years being a fresh start and a dramatic shift from the previous year, there’s no denying that it make’s for a good starting point. A clean slate.</p><h3>Getting started</h3><p>A few ideas I’ve been tossing around is creating and selling a digital product to supplement my (tiny) <a href="https://jsvxc.com/seo-services/">SEO business</a>.</p><p>So I did what all aspiring wantrepreneurs/entrepreneurs do:</p><p><strong>I aimlessly browsed Twitter.</strong></p><p>For all it’s nonsense, <a href="https://jsvxc.com/self-funded-businesses/">Twitter sometimes has some cool stuff</a> on there and even some pearls of wisdom.</p><p>Like this:</p><blockquote><em>Instead of focusing on some hazy definition of a market, create products that meet at the intersection of your skills and experience, what people want, and what they are willing to pay for.</em></blockquote><blockquote><em>- Ian Nuttall (@iannuttall) </em><a href="https://twitter.com/iannuttall/status/1210873324068364290?ref_src=twsrc%5Etfw"><em>December 28, 2019</em></a></blockquote><p>Which got me thinking: this is a the perfect framework for deciding what humble business to work on.</p><p>Like a year 9 maths test, let me show my working:</p><h3>Starting an online business.</h3><p>I’m going to show my thought process here because writing things down helps to declutter my brain, organise my thoughts and I had a few too many coffees this morning and got carried away.</p><p><strong>My goals:</strong></p><ul><li>I want to create something scalable that doesn’t involve hiring loads of people.</li><li>Leverage (and improve upon) my existing skillset.</li><li>Keep stress levels low + be in control of my own time.</li></ul><p>I’m dumbing this down, but income that isn’t tied to manpower is the holy grail IMHO.</p><p>And one of the best ways to divorce yourself from manpower is to sell a product. Build a thing once. Then continue to sell that thing many times over.</p><p>Creating a digital product to sell seems like the closest you can get to passive income.</p><p>Back to the tweet.</p><p>Ian’s one of those business owners who actually does stuff. He’s not building a brand, he’s building a business. I always try to find and learn from those people who are <em>doing</em> stuff (vs those that are trying to sell stuff).</p><p>Anyway, enough <em>internet-arse-kissing</em>, let’s breakdown Ian’s tweet into a framework:</p><p><strong>You need to create products that meet at the intersection of:</strong></p><ul><li>your skills and experience</li><li>what people want</li><li>what they are willing to pay for.</li></ul><h3>Applying the framework</h3><p>I think this is a useful framework to think about when trying to settle on an idea for a humble real-life business.</p><p>But like frameworks, it is more useful if you actually apply it.</p><p>So, because I’m sad not-sad, I’ve created a spreadsheet template to help walk through it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*t9hT7hv7J2RMKuMG.png" /></figure><h3>Using the spreadsheet</h3><p>Ok, so first up: this is pretty basic and dumbed down. I wanted this to be a tool that would help prevent procrastination and analysis paralysis, not actively encourage it.</p><p>There’s space for 10 ideas to work through at a time. Sure you can add more. But spending too long thinking of business ideas at this point vs actually testing &amp; validating ideas is not a good use of time. I should know, I’m a master-procraster.</p><p>For the scoring, you can use your own thinking. Here’s how I approached it:</p><ul><li><strong>Your skills and experience</strong> — what do I know/can I do to create something of value (if I need to spend any length of time learning something new, this isn’t the place for it).</li><li><strong>What people want</strong> — what can I see people asking for online (that I could realistically create)</li><li><strong>What they are willing to pay for</strong> — what are people paying for and can I actually create something of equal (or greater) value.</li></ul><p>Here’s a walkthrough of my thought process using Ian’s framework + a spreadsheet:</p><h3>1) Your skills and experience</h3><p>Building a small software tool and selling it as a company of one is more than doable. The <a href="https://www.indiehackers.com/">Indiehackers</a> community is a testament to that.</p><p>Software/SaaS tools are great for generating monthly revenue. At least they would be but I don’t know how to code.</p><p>I can mess around in cPanel, write some basic SQL queries and make some pretty beasty spreadsheet formulas, but creating usable software? Nope. Can’t do that.</p><p>Could I learn to code? Sure, probably, maybe. I could follow this great <a href="https://www.ryanckulp.com/learn-to-code/">learn how to code guide</a> by Ryan Kulp and spend the next year learning a new skill. Then hopefully build and sell something.</p><p>But that’s going to take time.</p><p>Leveraging an existing skill to make money now will generate income quicker.</p><p>So what skills?</p><p>Easiest place to start is: what is your current job? How are you currently making money? For me, I’ve worked in marketing for the past few years. Specifically SEO. So let’s run with that.</p><p>Spreadsheet time:</p><p><strong>✍️ Update [Your skills &amp; experience] in the sheet:</strong></p><p>First you want to list the skills and work experience you have. Ideally these will be things you are actually decent at, and even better, things you’ve earned money doing.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/516/0*qC65Fp8_OHL1CT2m.png" /></figure><p><em>(I’ve added some dud ideas. You’ll see what happens if you try to build a business around something you have no or little experience in later on)</em></p><p>Give yourself a score between 1–5.</p><p><strong>1 = okay at it. 5 = pretty great.</strong></p><p>If you aren’t good at a thing, it’s probably not good to base a business around it until you’ve got better at it.</p><h3>2) What people want</h3><p>Ok, so let’s ignore software tools. What are some things I can build myself, using the skills &amp; knowledge I already have?</p><p>Also, no point re-inventing the wheel here, what are people already spending money on?</p><p>Once you narrow that down you are left with a shortlist.</p><p><strong>Types of digital products (that people are willing to pay for):</strong></p><ul><li>ebooks</li><li>pre-templates</li><li>membership sites</li><li>exclusive content (à la paid newsletters, communities ect)</li><li>courses</li></ul><p>So one thing that jumps out of this list is learning and selling knowledge via a course.</p><p>Knowing SEO is great. It’s an in demand skill:</p><p>So when it comes to turning skills and experience into something people want, online courses seem like the perfect fit.</p><p>According to <a href="https://elearningindustry.com/top-elearning-statistics-2019">stats</a>,</p><blockquote><strong>The Global eLearning Market Will Reach $325 Billion By 2025</strong></blockquote><p>Awesome. The obvious choice is an SEO course then? Maybe not:</p><blockquote><em>If I created an SEO course based off my experience working with brands like<br> Zillow, NYT, Dribbble, IHG, and many more, would you buy it?</em></blockquote><blockquote><em>- JOHN DOHΞRTY 🤓 Denver entrepreneur (@dohertyjf) </em><a href="https://twitter.com/dohertyjf/status/1179787961690251264?ref_src=twsrc%5Etfw"><em>October 3, 2019</em></a></blockquote><p>Moral of the story: check what people want before building something.</p><p>Head back to the spreadsheet:</p><p><strong>✍️ Update [What people want] in the sheet:</strong></p><p>Now you need to figure out if the skill you have matches up with what people want.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/510/0*8d93FSXZL6BfIo4P.png" /></figure><p>Do some keyword research to see what things people are searching for. Check places like Reddit, Quora and online communities to get a sense of what kind of things people are asking.</p><p>If you are part of the community (or know someone who is) you’ll find it easier to understand the problems you can solve.</p><p>Give yourself a score based on how well you can meet that need.</p><p>For example, people (business owners) want their accounting simplified. Great, I’ll do that… Only I know very little about bookkeeping.</p><p>Whereas people want to find the right keywords to target and this is something I can help with, and have experience with doing.</p><h3>3) What they are willing to pay for</h3><p>You don’t need to go re-inventing the wheel here.</p><p>Keeping the framework in mind, if you know what you are good at and what people want, all you need to do is check whether people are willing to pay for it.</p><p>A few years ago, I spent ages trying to build an automated reporting service. The idea was to have agencies sign up for a monthly fee and let me handle their reporting. I could practically smell the MRR.</p><p>Only I didn’t check if people would pay for this (aka I didn’t validate this idea before wasting time). And boy did I waste time.</p><p>Turns out most agencies just use things like Google Sheets or Data Studio to handle reporting. And they handle this in-house. And they create a template once and automate it. Not much help having a third party subscription service when you can pay internal staff to do it or a freelancer can knock up a dashboard in an afternoon.</p><p>Moral: check that people will part with their money for what you are offering.</p><p>Here’s some real examples of digital products (that people are actually buying):</p><p>These are all examples of digital businesses ran by solo owners or a few people.</p><p>Back to the spreadsheet:</p><p><strong>✍️ Update [What people are willing to pay for] in the sheet:</strong></p><p>Now list out the things people are already paying for (that you can provide).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/512/0*vA0p9XPtOJBi5WFO.png" /></figure><p>Reminder: don’t re-invent the wheel here. Look for a need not being met or is being underserved (easier said than done).</p><p>If you have no idea what people are willing to pay for and you can’t find any evidence, you’ve either found the best underserved niche in the world, or <a href="https://www.youtube.com/watch?v=RNO1mb6NkEI">you’ve got the dud</a>.</p><p>I tried to score this on things people ACTUALLY want that I can provide.</p><p>But that’s not always possible.</p><p>Example: people are paying for lots for SEO tools every month. Can I build an SEO tool in the next month? Big fat nope.</p><p>So could I create a course teaching SEO? I could but there’s so many of them + I don’t feel qualified to do so. Like at all.</p><h3>Outcome (Overall score in the spreadsheet)</h3><p>Once you’ve filled in all the scores, you’ll get an average overall score:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*QQpmiUx3jAFfPJne.png" /></figure><p>This gives you a top down view of skills you have that match up with what people want and what they are paying for.</p><p>From the example above, a done-for-you keyword research service scored highest. So that is something to be researched more.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/921/0*mNLYNPDU1d7qeHk8.png" /></figure><p>Despite the fact my omelette cooking skills are high, there’s no real demand for it online and people aren’t prepared to pay for it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/920/0*sJ2R7F_BlBBQ2zND.png" /></figure><p>Although this is a silly example, it highlights a trap I’ve fallen into before:</p><p>Just because you are good at something, doesn’t mean people will pay you for it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/498/0*th5OEbdVkTcGv8y0.gif" /></figure><p><em>(It’s not really the same, but I like the quote.)</em></p><h3>Summary</h3><p>It felt good to get this out my brain and written down. Go use the <a href="https://docs.google.com/spreadsheets/d/1x67eYiXjXsbjIr4Zd5ukT6SmdKiT8cWUo_D8Two2ZLA/copy">spreadsheet</a> and apply the framework. If you end up creating anything with it or you just want to chat, you can find me on twitter <a href="https://twitter.com/jsvxc">here</a>.</p><p>But you should really go checkout <a href="https://ian.is/">Ian</a> (and his business partner <a href="https://twitter.com/ryangibsonuk">Ryan</a>).</p><p>This rambling article was inspired by their work. Go check them out. They are busy doing stuff, not busy talking about doing stuff.</p><p><strong>PS. If you liked this article, give me at least a dozen <em>humble</em> claps for good luck 👏</strong></p><p><em>Originally published at </em><a href="https://jsvxc.com/humble-business/"><em>jsvxc.com</em></a><em> on January 10, 2020.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a955101d2b5d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[10 Store Locator Pages For Design Inspiration]]></title>
            <link>https://medium.com/@jsvxc/10-store-locator-pages-for-design-inspiration-a857998d15c?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/a857998d15c</guid>
            <category><![CDATA[web-design]]></category>
            <category><![CDATA[retail-marketing]]></category>
            <category><![CDATA[local-business]]></category>
            <category><![CDATA[local-seo]]></category>
            <category><![CDATA[ecommerce]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Tue, 12 Nov 2019 18:07:09 GMT</pubDate>
            <atom:updated>2019-12-05T13:14:57.600Z</atom:updated>
            <content:encoded><![CDATA[<h4>Originally published on the <a href="https://www.storemapper.com/blog/store-locator-examples/">Storemapper</a> blog.</h4><p>Run a business with a physical premises?</p><p>Then you need to get the people who are visiting your website to visit your store in <em>‘real life’</em>.</p><p>Just, think about this <a href="https://loganix.net/local-seo-statistics/">statistic</a>:</p><p><strong><em>72% of people conducting a local search will visit a store within 5 miles.</em></strong></p><p>You need to make sure people can find your premises. This can be a challenge, but it doesn’t have to be.</p><h3>Store Locator Pages</h3><p>With the right design, a store locator can actually help to <a href="https://www.storemapper.com/blog/increase-foot-traffic/">increase foot traffic</a> and <a href="https://www.business2community.com/seo/a-simple-local-seo-checklist-to-improve-your-small-business-or-retail-store-02239245">improve the local SEO</a> of your store.</p><p><strong>But where do you start with designing your locator?</strong></p><p>Well you could take design inspiration from these examples of store locator pages. There’s a mix of big name brands and independent retailers.</p><p>(If you want to see even more examples, go checkout the full post on the <a href="https://www.storemapper.com/blog/store-locator-examples/">Storemapper</a> blog)</p><p>Let’s jump in:</p><h3>1. Beardbrand</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Bm2jQy0mxD_RQSGx.png" /></figure><p>Beardbrand are the hub for all things beards and hair products for men. Check out the <a href="https://www.beardbrand.com/pages/our-retailers">Beardbrand store locator</a> to find products that are stocked (internationally) at authorized retailers near you.</p><h3>2. ezpz</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*HoXyf1LdhQMa9pko.png" /></figure><p>ezpz sell a range of handy silicone bowls and plates suction that to the table to capturing your child’s mess. Check out the <a href="https://ezpzfun.com/pages/stores">ezpz store locator</a> to search for stores that carry ezpz products based on your location.</p><h3>3. Rains</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wYAFgcWJi82HPHWn.png" /></figure><p>Rains is a Danish outerwear and waterproof clothing brand. Check out the <a href="https://www.uk.rains.com/pages/dealers">Rains store locator</a>.</p><h3>4. Gera Dovana</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*B3mjY934kNbmdgZq.png" /></figure><p>Gera Dovana is the largest entertainment distributor in Lithuania from original gifts to flights, massages and entertainment. Check out the <a href="https://www.geradovana.lt/apie/parduotuves">Gera Dovana store locator</a></p><h3>5. Firenza Pizza</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*A1ua6y4tBcOpaqX3.png" /></figure><p>Firenza Pizza was created by two pizza aficionados who longed to bring high quality (but affordable) pizzas to<br>the masses quickly. Check out the <a href="https://firenzapizza.getbento.com/location-store-locator/">Firenza store locator</a> for custom built pizzas near you.</p><h3>6. Grenco Science</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8A3SlzttAVhVhXJr.png" /></figure><p>Grenco Science created the G Pen — the most advanced vape pens &amp; portable vaporizers in the world. Check out the <a href="https://www.gpen.com/pages/store-locator/">Grenco Science store locator</a> to find them.</p><h3>7. Golden Krust</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*9antQ3cTff-qE9Sk.png" /></figure><p>Golden Krust Caribbean Restaurant is a fast-casual restaurant operator and manufacturer of Caribbean food. Check out the <a href="https://www.goldenkrust.com/retail-locations/">Golden Krust store locator</a> to find authentic Jamaican dishes near you.</p><h3>8. Untuck It</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*fHdmIsj4u4gFNpbc.png" /></figure><p>Untick It provide casual men’s shirts designed to be worn untucked. Check out the <a href="https://www.untuckit.com/blogs/store-locations">Untuck It store locator</a>.</p><h3>9. Bulletproof</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*V_W48SPoen2Mhh4-.png" /></figure><p>Bulletproof sell a range of science-based nutrition and wellness products to help people perform better, think faster, live better. Check out the <a href="https://shop.bulletproof.com/pages/product-locator">Bulletproof store locator</a> to find products near you.</p><h3>10. SureSwift Capital</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wZ_KIIWmQbGfYwxC.png" /></figure><p>SureSwift Capital invests in (and holds on to) emerging media and SaaS properties. Check out the <a href="https://www.sureswiftcapital.com/meet-our-team/">Sureswift Capital store/people locator</a> to see how their team of 80 remote individuals is distributed.</p><h3>11. Starbucks</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*9PCiMBkeQ6CrkY0O.png" /></figure><p>Check out the <a href="https://www.starbucks.co.uk/store-locator">Starbucks store locator</a> to find your nearest coffee shop for your caffeine fix.</p><h3>12. Lego</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*kY6FKhCvsOOb6XWq.png" /></figure><p>Everyone loves Lego right? Check out the <a href="https://www.lego.com/en-gb/stores">Lego store locator</a> to find your nearest shop to get building bricks and find the perfect gift for your kid (or yourself).</p><h3>13. 7 Eleven</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*co5EdDSylKUzZPtj.png" /></figure><p>Check out the <a href="https://www.7-eleven.com/locator">7 Eleven store locator</a> to find stores in your area, as well as opening hours, directions and reviews.</p><h3>14. Nike</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*--Odt0EdwKjH8d_O.png" /></figure><p>Check out the <a href="https://www.nike.com/my/retail">Nike store locator</a> to find stores in your area, as well as opening hours, address, directions and additional services offered by the store.</p><h3>15. Ole Smoky</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*0XJCeazclo6lMMn7.png" /></figure><p>Ole Smoky is the leading distiller of premium moonshine in the U.S. Check out the <a href="https://olesmoky.com/pages/find-a-jar">Ole Smoky store locator</a>.</p><h3>16. MVMT Watches</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*qXJAweVYcRFaOekq.png" /></figure><p>Designed in LA, MVMT sell stylish (but affordable) watches. Check out the <a href="https://www.mvmtwatches.com/pages/locations">MVMT Watches store locator</a>.</p><h3>Choosing the RIGHT Store Finder Page Design</h3><p>Hopefully these store finder pages/locators have given you some design inspiration for your own business.</p><p>The key to an effective store locator page is:</p><p><strong>Understand what information your customers want, and then give it to them.</strong></p><p>Store locators are very important for retailers. With consumer shopping trends shifting to mobile (+ the reliance on digital maps for directions), the importance of having the right store finder design is only increasing.</p><p><em>Originally published at </em><a href="https://www.storemapper.com/blog/store-locator-examples/"><em>https://www.storemapper.com</em></a><em> on November 12, 2019.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a857998d15c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Fed up of manual data processing? Here’s 16 data extraction tools to help automate your workflow]]></title>
            <link>https://medium.com/@jsvxc/fed-up-of-manual-data-processing-heres-16-data-extraction-tools-to-help-automate-your-workflow-1e989b6d650d?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/1e989b6d650d</guid>
            <category><![CDATA[workflow-automation]]></category>
            <category><![CDATA[automation-tools]]></category>
            <category><![CDATA[data-extraction]]></category>
            <category><![CDATA[data-processing]]></category>
            <category><![CDATA[web-scraping]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Tue, 17 Sep 2019 14:52:15 GMT</pubDate>
            <atom:updated>2019-09-24T15:32:39.083Z</atom:updated>
            <content:encoded><![CDATA[<h3>16 data extraction tools to help automate your workflow</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OR7bg2yGSFByinAinnvuvA.jpeg" /></figure><p>The internet is an amazing resource, full of (mostly) useful information.</p><p>However, when it comes to actually getting your hands on lots of information, especially if your business relies on processing data, things can get messy.</p><p><strong>Enter </strong><a href="https://docparser.com/blog/what-is-data-extraction/"><strong>data extraction</strong></a><strong>. </strong>This is the method of getting hold of that information in a usable form.</p><p>Thankfully, there are <strong>data extraction tools</strong> available to automate the data management process, saving you time and money as well as reduce the chances of getting carpal tunnel from too much clicking.</p><p>With many tools also offering automated data entry, businesses can cut down on a lot of time-consuming manual tasks, and reduce the risk of error. In particular, small businesses can benefit from the use of data extraction tools, as they tend to have less manpower and fewer available resources for gathering data.</p><h3>16 Data Extraction Tools</h3><p>I’ve put together a list of some of the best and most useful data extraction tools on the web.</p><p>They each have various different features, so take a look and see which you think will be beneficial for your business.</p><p>Go check them out:</p><h3>#1 <a href="https://docparser.com/">DocParser</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BfcjLuMU9NNQ5blT" /></figure><p>DocParser is a subscription-based tool that allows you to extract data from everything from HR forms to scanned invoices.</p><p>It uses a customizable parsing engine, enabling it to support hundreds of different use-cases, making it an extremely versatile tool. Its ability to scrape data from sources other than web pages offers huge versatility that can save time and money in a wide range of tasks and sectors.</p><p>It is particularly useful for businesses that buy or sell stock, as it includes specific features for processing invoices, delivery notes, purchase orders, sales orders, and price lists.</p><h3>#2 <a href="https://www.import.io/">Import.io</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*atvGNPh5yP6CX5De" /></figure><p>Import.io is a web-based platform that allows you to extract data from websites without the need to write any code.</p><p>While there is a free version, the paid subscription offers a managed service, with web data integration experts taking care of the technical side of things. This means that you don’t need to build or maintain anything, making it accessible to users of all skill levels.</p><p>Import.io’s website states that, compared to manual data extraction, it offers 8x more data and 20x more accuracy, while reducing costs by 66% and increasing time to market by 60%. These stats are particularly enticing for small businesses, for whom these time and cost savings could mean a huge increase in profits.</p><h3>#3 <a href="https://www.outwit.com/">OutWit Hub</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Stw0Horppoe3HkPC" /></figure><p>OutWit Hub is a data scraping tool that allows simple data collection from the web without having to search, copy, paste and save.</p><p>It offers subscriptions that allow you to scrape different types of data, as well as tailor-made scrapers for complicated extractions or those who don’t have the time to create their own custom tool.</p><p>The program’s intuitive features, sophisticated scraping functions and data structure recognition mean that it is able to handle a broad range of tasks, from casual searches to very specific requirements. It can be used for everything from extracting contact details from websites and directories to checking for unauthorized use of your intellectual property.</p><h3>#4 <a href="https://www.octoparse.com/">Octoparse</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wQpNcHJsDOkAY85F" /></figure><p>Octoparse is described as “Easy web scraping for anyone”, offering a simple three-step process for data collection. No coding is necessary; you just point, click and extract.</p><p>Its clever features allow for scraping of any website, even those that use infinite scrolling or require login. By using automatic IP rotation, it prevents a particular IP address from being blocked, allowing you to scrape more websites for longer. You can even schedule automated scraping at specified times on a regular basis.</p><p>The simplicity of the interface means that it can be used by anyone who knows how to browse the internet, making it a tool that your whole team can use.</p><h3>#5 <a href="http://visualwebripper.com/">Visual Web Ripper</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*zo1sbO6Z12QKod3x" /></figure><p>Visual Web Ripper, as the name suggests, is a visual tool for automated web scraping and content extraction.</p><p>The software is able to crawl entire websites and collect complete content structures that cannot be extracted manually, such as entire product catalogs, or structured data that other tools struggle to extract successfully.</p><p>Users are able to simply click on the data that they wish to extract, making it simple to use, and with discounts available for multiple licensing, it is a flexible tool that can benefit many different departments in your business.</p><h3>#6 <a href="https://webscraper.io/">Web Scraper</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*bRdYZ1NnIXhW4pmH" /></figure><p>Web Scraper is another point-and-click interface for web data extraction, with the aim of making it easy and accessible for everyone.</p><p>It is built for the modern web, allowing it to extract data from sites with features that are traditionally harder to crawl, such as those with multiple levels of navigation, JavaScript, or infinite scrolling.</p><p>It’s available as a free browser extension, or in various monthly subscriptions, which offer greater functionality and multiple users. It’s a scalable platform that is built on cloud technology and is able to grow with your business, so you don’t need to switch tools if your needs increase.</p><h3>#7 <a href="http://docs.spinn3r.com/">Spinn3r</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*a3tcEtIZI0UhzB9S" /></figure><p>Spinn3r provides APIs for social media, weblogs, news, video, and live web content in any language and in large volumes.</p><p>There are various different tools within Spinn3r, allowing you to make extremely complex and detailed searches, provide labels for content based on machine learning, and more.</p><p>It’s a great tool for companies that are looking to source information on particular topics from blogs, social media and news networks, though it is more complex to use than some of the other tools and may not suit everyone.</p><h3>#8 <a href="https://webhose.io/">Webhose.io</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*nimREz7Ti4SC_iEH" /></figure><p>Webhose.io turns unstructured web content into machine-readable data feeds that can be consumed on demand.</p><p>This subscription-based service allows you to monitor and analyze media outlets, online forums and message boards, blogs, reviews and more. It pulls the data from the required sources, returning it in a clean and simple format, ready for use.</p><p>Its archived data allows businesses to feed their analysis tools with over 10 years of machine-readable historical content, providing huge amounts of data that is otherwise difficult to find.</p><h3>#9 <a href="https://mailparser.io/">Mailparser</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ZhrrNl-y8gvn5KKy" /></figure><p>MailParser saves you from manually entering masses of data by extracting it from inside emails.</p><p>Just forward emails to MailParser, and data like email addresses and contact information is extracted (based on your own custom parsing rules).</p><p>Once the data is parsed, you can download it or use over 1,500 integrations to send it directly where it needs to be for processing.</p><h3>#10 <a href="http://www.fminer.com/">Fminer</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*CZQywh3p4SGHFdiX" /></figure><p>Fminer offers visual web scraping, data extraction, screen scraping, web harvesting, web crawling and more for both Windows and Mac.</p><p>It uses a simple point-and-click function, making it easy to use, and it’s designed to work with hard-to-crawl sites like those that use JavaScript or Ajax.</p><p>Along with the data scraping features, it combines an intuitive visual project design tool that allows you to create complete data mining projects in minutes.</p><h3>#11 <a href="https://sequentum.com/">CG Enterprise (Content Grabber)</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*_3UwfDAMtlrkZ843" /></figure><p>CG Enterprise, formerly known as Content Grabber, is a web data extraction solution designed for large-scale extraction operations.</p><p>While it still uses a simple point-and-click editor, its advanced features give the user full control and allow for extensive customization, making it perfect for more complex data extraction requirements.</p><p>You can also add data extraction functionality to your own desktop apps of websites using the built-in API feature, which allows it to easily integrate with data analysis tools.</p><h3>#12 <a href="https://chrome.google.com/webstore/detail/table-capture/iebpjdmgckacbodjpijphcplhebcmeop">Table Capture</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*GXbMq8RJr1oF5dxH" /></figure><p>Table Capture is a Chrome browser extension that scrapes data from an HTML table on any website and converts it into a usable format such as Excel, Google Sheets or CSV.</p><p>This useful tool copies tables to the clipboard while preserving the essential column and row separators that allow users to make sense of the extracted data. It’s even able to capture tables that load as you scroll, multi-page tables and div-based tables.</p><p>It offers a simple and time-saving solution for data extraction that relies on table formatting, which can be extremely fiddly when done manually.</p><h3>#13 <a href="https://scrapy.org/">Scrapy</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-cy0OZG6UgLIuBfA" /></figure><p>Scrapy is an open-source and collaborative framework for extracting data from websites.</p><p>With Scrapy, you can build and run your own web spiders, designed specifically for your exact requirements. It’s written in Python, which allows for completely customizable functionality, but means that it requires a knowledge of coding to use.</p><p>Once you’ve created your crawler, it is hosted on Scrapy’s cloud server, making it easy to run, monitor and scale without taking up space on your own server.</p><h3>#14 <a href="https://tabula.technology/">Tabula</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jYdzGqCGUYF5QV87" /></figure><p>Tabula is a tool for extracting data tables from PDF files, allowing you to copy and paste the information in a usable format.</p><p>It offers a user-friendly select function, allowing you to highlight the table you wish to extract, so it’s easy to use at all levels and across departments within your business.</p><p>Once the scraped data is extracted, it can be converted into Excel spreadsheets, CSVs, and JSON files for use in analysis and database applications, making it ideal for research or creating public resources.</p><h3>#15 <a href="https://www.parsehub.com/">ParseHub</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rX6Vm1OpY8pZNuh_" /></figure><p>ParseHub is a free web scraping tool that allows you to simply click on the data that you wish to extract.</p><p>It’s able to scrape complex websites such as those that use JavaScript or Ajax, logins or infinite scrolling. The scraped data is returned in JSON, Excel or API formats so it can be used elsewhere with ease.</p><p>This software offers a lot of great functionality and compares well with many paid scraping tools.</p><h3>#16 <a href="https://dexi.io/">Dexi</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-81BNzq2JCM6Y_pH" /></figure><p>Dexi provides web scraping and automation tools that are “as capable as a human, incalculably faster.”</p><p>Its intelligent automated knowledge extraction software uses advanced robot technology to extract data with the same competency as a human but much quicker and on a vastly bigger scale.</p><p>It’s a subscription-based software and is definitely on the higher end of the price scale, but you get a lot of functionality for your money. The unlimited robot crawlers are able to gather and process data from any website, including password-protected content, eliminating inefficient manual processes.</p><h3>Data extraction tools for your business</h3><p>There you have it, lots of useful data extraction tools.</p><p>If your business has high data management requirements, such as processing a lot of information or performing data-driven research, give some of these data extraction tools a try and see how much they can help your productivity.</p><p>Or don’t and carry on w̶a̶s̶t̶i̶n̶g̶ ̶y̶o̶u̶r̶ ̶t̶i̶m̶e̶ ̶manually entering data.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1e989b6d650d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Over 50 facts about Nottingham you (probably) didn’t know]]></title>
            <link>https://medium.com/@jsvxc/over-50-facts-about-nottingham-you-probably-didnt-know-93d744079ec?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/93d744079ec</guid>
            <category><![CDATA[nottingham]]></category>
            <category><![CDATA[robin-hood]]></category>
            <category><![CDATA[uk]]></category>
            <category><![CDATA[east-midlands]]></category>
            <category><![CDATA[facts]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Tue, 27 Aug 2019 13:25:19 GMT</pubDate>
            <atom:updated>2019-09-25T19:36:13.721Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*YaObwtvz-xgRADQq.jpg" /></figure><p>Nottingham is a vibrant city with a lot of interesting history, weird facts and even weirder people.</p><p>Here are some interesting facts about Nottingham that you might not know and some you might (<strong>spoiler:</strong><em> the Cheese Riot fact is my favourite</em>).</p><h3>HISTORY</h3><ul><li>Nottingham was originally called Snotengaham. It was ruled by a Saxon chief named Snot, and the name translates to “the homestead of Snot’s people.”</li><li>There are over 700 man-made caves under the streets of Nottingham, carved from the soft sandstone on which the city was built. Over the years, the caves have had many different uses, including tanneries, pub cellars and air raid shelters. The cave passageway known as Mortimer’s Hole that runs underneath Nottingham Castle is said to be haunted by local nobleman Roger Mortimer.</li><li>It is illegal to rent out the caves in Nottingham and has been since the creation of the Nottingham Inclosure Act in 1845.</li><li>The Great Cheese Riot broke out at Nottingham’s Goose Fair in 1764 over the price of food. Large cheeses were stolen and rolled down Wheeler Gate and Peck Lane, and the Mayor was knocked down by one such cheese.</li><li>The Goose Fair is one of the UK’s largest and oldest fairs, dating back to the 13th century. Over a million people visit Nottingham’s famous fair every year but the modern funfair rides and vans selling chips with mushy peas are a far cry from the fair’s origins. Thousands of geese would be brought on foot from Lincolnshire, Cambridgeshire and Norfolk to Nottingham, travelling down Goosegate and to the Market Square to be sold for the traditional Michaelmas dish of roast goose.</li><li>Nottingham has an estimated population of just 306,000 due to its very small official city boundary. However, the wider Nottingham Urban Area has an estimated population of 733,000 (in 2019), making it the 9th largest urban area in the UK.</li></ul><h3>BOOKS</h3><ul><li>The country’s first children’s library was founded in Nottingham in 1882.</li><li>JRR Tolkein wrote his poem The Voyage Of Earendel The Evening Star while staying with his aunt, Jane Neave, at her farm in Gedling. Tolkein stayed with her at Phoenix Farm in 1914, and she is thought to have been the main inspiration for Gandalf in Lord of the Rings due to her strong presence and mystical nature.</li><li>The 1958 Alan Sillitoe novel Saturday Night and Sunday Morning is set in a working men’s club in Nottingham. It was developed into a film in 1960, and a play for the Nottingham Playhouse in 1964, with Ian McKellen playing one of his first leading roles</li></ul><h3>MUSIC</h3><ul><li>Iron Maiden singer Bruce Dickinson was born in Worksop, where he initially lived with his grandparents before moving to Sheffield with his parents when he was six years old.</li><li>The first ever gig by Paul McCartney and Wings took place at the University of Nottingham Students’ Union on February 9th 1972. Tickets cost just 40p — a bargain for Macca’s first live performance in five years.</li><li>In 1981, the Notts County Choir released the song County’s The Team For Me, which Radio One DJ Noel Edmonds described as being “the worst pop song of all time”. Despite this, it was made available on the album The Complete Notts County Songs &amp; Chants in the year 2000.</li><li>Neil Tennant of the Pet Shop Boys wrote the group’s hit 1984 song West End Girls while staying with his cousin in West Leake.</li><li>Musician Jake Bugg was born in Nottingham and grew up in Clifton, where he started playing guitar aged 12.</li></ul><h3>FAMOUS PEOPLE</h3><ul><li>Robin Hood is probably Nottingham’s most famous resident. The legendary outlaw was said to steal from the rich to give to the poor, though it’s not clear whether he was actually a real person. Many local streets, buildings and institutions reference the legend of Robin Hood, such as Maid Marian Way in the city centre.</li><li>The Sheriff of Nottingham was, and still is, a real position, although the role is now purely ceremonial.</li><li>King Edward VIII owned Grove Farm in Lenton in the early 20th century while he was still the Prince of Wales. He kept a herd of shorthorn cattle there.</li><li>There is a blue plaque at 13 Linden Grove in Beeston, where Mahatma Gandhi visited his nephew in 1931. His nephew, JV Joshi, was lodging there at the time while studying at the University of Nottingham.</li><li>Comedian Ken Dodd’s first professional performance took place in Nottingham at the Nottingham Empire Theatre of Varieties in 1954.</li><li>Comedy actress Su Pollard was born in Nottingham. Following an apprenticeship at the Arts Theatre in Nottingham, she appeared on the talent show Opportunity Knocks in 1974 singing I Cain’t Say No from the musical Oklahoma!. She came second to a singing Jack Russell.</li><li>Micky Dolenz of The Monkees lived in Winthorpe near Newark in the 1980s.</li><li>Renowned British actor and former Dr. Who Matt Smith once played for Nottingham Forest’s youth team.</li></ul><h3>SPORT</h3><ul><li>Following his experience in cricket, Hucknall-born sportsman Sam Weller Widdowson brought the use of shin guards to association football in 1874 during his time playing for Nottingham Forest.</li><li>When Nottingham Forest beat Derby to win the FA Cup in 1898, they wore their opponents’ shirts in the photos, as the photographer worried that Forest’s red shirts wouldn’t show up.</li><li>Sir David Frost was offered a contract to play for Nottingham Forest in the 1960s but turned it down because the maximum wage was £15 a week.</li><li>Former Nottingham Forest Player Peter Shilton was the first football player to make 1,000 League appearances.</li><li>Ice skaters Jayne Torvill and Christoper Dean both hail from Nottingham. Their performance to Maurice Ravel’s Boléro at the Sarajevo Olympics in 1984 earned them the accolade of being the highest scoring figure skaters of all time for a single programme, receiving twelve perfect 6.0s and six 5.9s from the judges.</li><li>Boxer Carl Froch, MBE, was born in Nottingham. He was named the best active British boxer, pound for pound, by the BBC in 2013, and his fighting record at retirement was 33 wins and 2 losses.</li></ul><h3>NATURE AND ANIMALS</h3><ul><li>Sherwood Forest is home to the Major Oak. Thought to be between 800 and 1,000 years old, it is England’s largest oak tree with a girth of 10 metres and weighing an estimated 23 tonnes. Legend has it that the Major Oak provided shelter for Robin Hood and his Merry Men.</li><li>The first earthquake ever recorded in Nottinghamshire was on April 25th 1180.</li><li>Every single Bramley apple in the world is descended from a single tree planted in Southwell. Planted by a girl called Mary Ann Brailsford in 1809, the tree unfortunately fell victim to an incurable fungal infection, and was sold to Nottingham Trent University in 2018 in a bid to preserve it for as long as possible.</li><li>The myth that lemmings commit mass suicide is said to have been started by Nottingham local Arthur Mee. Born in Stapleford and a former editor of the Nottingham Post, he included the incorrect information in an edition of his Children’s Encyclopedia, published from 1908 to 1964.</li><li>The world’s oldest guinea pig passed away in Nottingham in 1979. Named Snowball, he was 14 years and 10 months old.</li><li>Animal rights group PETA wrote to Nottingham councillors in a bid to get the city to change its name to “Not-Eating-Ham” on Christmas Day.</li></ul><h3>BUSINESSES</h3><ul><li>Raleigh Bicycle Company, one of the oldest bicycle manufacturers in the world, was founded in Raleigh Street, Nottingham in 1885.</li><li>Nottingham resident Frederick Gibson Garton created HP Brown Sauce. He came up with the recipe while living in the Royal Oak in Basford, and made the sauce in his pickling factory round the corner on Sandon Street. Garton named the sauce HP after the Houses of Parliament, as he heard that a restaurant in the Houses of Parliament had begun serving it.</li><li>Player’s Cigarettes were once manufactured in Nottingham. In 1901, they merged with other cigarette companies to form The Imperial Tobacco Company to compete with American manufacturers.</li><li>British pharmacy and beauty retailer Boots was founded in Nottingham by the Boot family. Jesse Boot took over his father’s pharmacy, The Boots Company, and turned it into a nationwide chain. He was a great supporter of the city of Nottingham and donated land for the new University College at Highfields, now the University of Nottingham, which opened in 1928.</li></ul><h3>INVENTIONS AND NEW TECHNOLOGY</h3><ul><li>Nottingham was home to the country’s first high-pressure water supply, using a water wheel to pump spring water from a reservoir in Basford. The Trent Waterworks Company opened its works near Trent Bridge in 1831.</li><li>Nottingham-born physicist Louis Essen built the first atomic clock in 1955. The clock was so accurate that it would only lose one second every 300 years.</li><li>Ibuprofen was created by the Research Department of Boots while looking to create a safer alternative to aspirin. It was discovered by Dr. Stewart Adams and patented in 1961. The original laboratory was located on Pennyfoot Street, which is now home to BioCity.</li><li>The first subscriber trunk dialling telephone call that allowed a caller to dial a number without an operator was made in 1962 from Nottingham Council House to Belfast.</li><li>The first domestic “TV recorder” in the UK was created by Nottingham locals Norman Rutherford and Michael Turner. Called Telcan, it was launched by the Nottingham Electric Valve Company in 1963. There are only two known Telcan machines currently in existence, one of which can be seen at the Nottingham Industrial Museum at Wollaton Hall. Rutherford and Turner also developed the first combined TV and VTR, as well as the first handheld camcorder.</li></ul><h3>BUILDINGS AND MONUMENTS</h3><ul><li>Unveiled on April 29th 1995, the sundial in Portland Square, Sutton-in-Ashfield, is said to be the largest sundial in Europe.</li><li>The Old Market Square in Nottingham city centre is England’s biggest market square, covering 5.5 acres.</li><li>There are three pubs in Nottingham that claim to be the oldest pub in England: Ye Olde Trip to Jerusalem, Ye Olde Salutation Inn and The Bell Inn. The Trip is thought to date back to 1189, though there is no documentation to support this. Its name comes from the belief that pilgrims or crusaders would stop at the inn on their journey to Jerusalem.</li><li>There have been several Nottingham Castles over the centuries. The first to be built on Castle Rock was a wooden structure that was built in 1068. This was replaced by an imposing stone castle during the reign of King Henry VII, which was demolished in 1649 following the English Civil War. The present ‘Ducal Mansion’ that we know as Nottingham Castle today was built by Henry Cavendish between 1674 and 1679. While it was burned down during riots in 1831, it was restored and re-opened in 1878 as Nottingham Castle Museum.</li><li>The bell in the 200-foot dome of Nottingham’s Council House that strikes the hour is called Little John. It weighs 10.5 tonnes, it has the deepest tone of any clocktower bell in Britain, and it is believed to be the loudest clock bell in the country.</li><li>A housing estate in Bulwell called Lunar Estate is home to roads named after Apollo astronauts. They include Aldrin Close, Apollo Drive and Shepard Close.</li></ul><h3>TRANSPORT</h3><ul><li>The first road in the world to be laid with Tarmac was Radcliffe Road in West Bridgford, after the British patent was obtained by County Surveyor Edgar Hooley in 1902.</li><li>Nottingham’s first number plate was AU1. It was registered by William Dowson in 1903, although the same number plate was used for Goldfinger’s Rolls-Royce in the 1964 James Bond film.</li><li>The UK’s first ever helicopter commuter service opened in July 1956, taking passengers between Lenton and Leicester. The fare was 11 shillings single or £1 return, but the service closed in November due to fuel rationing caused by the Suez Crisis.</li></ul><h3>FILM, TV AND RADIO</h3><ul><li>Ian Fleming refers to Nottingham Castle in his 1961 James Bond Novel Thunderball, calling it an “extraordinary trademark of a doll’s house”.</li><li>The UK’s first ever radio phone-in took place on February 4th 1968 on Radio Nottingham. It’s believed that the subject in question was pest control.</li><li>Lady Bay Bridge featured in the 1982 TV series Smiley’s People, which was based on the spy novel by John Le Carré and starred Sir Alec Guinness.</li><li>There are over 100 film versions of the Robin Hood story.</li></ul><p>I’m a <a href="https://jsvxc.com/seo-services/">freelance digital marketer</a> who has lived in Nottingham for a while now and I spent far too long compiling this list.</p><p><em>Originally published at </em><a href="https://jsvxc.com/nottingham-facts/"><em>jsvxc.com</em></a><em> on August 27, 2019.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=93d744079ec" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[23 Automation Tools to Grow Your Business on Autopilot]]></title>
            <link>https://medium.com/@jsvxc/23-automation-tools-to-grow-your-business-on-autopilot-d42d9821bf17?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/d42d9821bf17</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[automation-software]]></category>
            <category><![CDATA[automation-tools]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Wed, 21 Aug 2019 16:06:14 GMT</pubDate>
            <atom:updated>2019-08-22T11:54:42.216Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oneAF1ru_QWnIb775r0wmw.jpeg" /></figure><p>Running a business is hard work. But if you aren’t automating repetitive business tasks, why not?</p><p>Automation is the future.</p><p>Seriously. Did you know marketers for example are <strong>losing 10–15% of their time due to not automating simple tasks? (</strong>According to <a href="https://public.tableau.com/profile/mckinsey.analytics#!/vizhome/AutomationandUSjobs/Technicalpotentialforautomation">Harvard Business Review</a>)</p><p>Task automation exists to save you time and there are tools available which mean you don’t even need to touch a line of code to get the benefits of automating your workload.</p><p>But what kind of automation tools are out there?</p><p>I’m glad you asked:</p><h3>23 automation tools to check out 🤖</h3><p>These task automation tools are here to help you to speed up your daily to-do list:</p><h3>#1 Automate.io</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BMzOrADnzgIVV5lW" /></figure><p><a href="http://automate.io/">Automate.io</a> automates process and workflows across multiple platforms by updating one app when another app is triggered.</p><h3>#2 Mailparser</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*24sJC4b0Fy36vImL" /></figure><p><a href="http://mailparser.io/">Mailparser.io</a> automates the tedious process of extracting data from recurring emails and organizing that data into structured data like spreadsheets and CRM platforms.</p><h3>#3 Docparser</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*AlwG6IJOiQKK1GKP" /></figure><p><a href="http://docparser.com/">Docparser.com</a> automates the workflow and process of extracting data from documents like invoices and PDFs.</p><h3>#4 IFTTT</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*91C7kCOGyB4jUZZ6" /></figure><p><a href="http://ifttt.com/">IFTTT.com</a> is a free web app that updates one app when another app is updated, automating recurring processes like posting to multiple social media accounts and backing up files.</p><h3>#5 Zapier</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*S3FSCgKBFn-0pqKQ" /></figure><p><a href="http://zapier.com/">Zapier.com</a> is a hub for automation by connecting over a 1,500 apps to make more efficient workflows and processes.</p><h3>#6 Customer.io</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*o34FRhCgVn8Mj95l" /></figure><p><a href="http://customer.io/">Customer.io</a> automatically sends emails or text messages your website visitors when they perform certain actions on your website or app.</p><h3>#7 Drift</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wikB4p6fNyux9png" /></figure><p><a href="http://drift.com/">Drift.com</a> automates the support chat process with their chatbot features that include answering common questions, scheduling sales calls, and connecting customers with the right support rep.</p><h3>#8 Skeddly</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4mKDi8I95slfm_9M" /></figure><p><a href="http://skeddly.com/">Skeddly.com</a> automates the tedious tasks of managing your AWS, MS Azure, and Google Cloud platform applications.</p><h3>#9 Calendly</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ecCn_-J-pwvaS0FJ" /></figure><p><a href="http://calendly.com/">Calendly.com</a> automates the back and forth process of schedule meetings.</p><h3>#10 Automated.af</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*lXJXSw8gpAbkkcYF" /></figure><p><a href="https://automated.af/">Automted.af</a> is a sales and marketing automation resource to help teams find ideas and marketing strategies.</p><h3>#11 Google Sheets</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wb-a0aQ2oTU-23gV" /></figure><p><a href="https://www.google.com/sheets/about/">Google Sheets</a> is Google’s version of an Excel spreadsheet. Don’t forget, you can automate those boring tasks via formulas and <a href="https://sheetsformarketers.com/5-google-sheets-add-ons-for-seo/">Google Sheets add-ons</a>.</p><h3>#12 Flow</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*7pYCy68XjAqTRNFO" /></figure><p><a href="https://flow.microsoft.com/en-us/">Flow</a> by Microsoft allows you to create automated workflows between your favorite apps and services, as well as get notifications, synchronize files and more.</p><h3>#13 Process Street</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*L33wth054r3wf_Ba" /></figure><p><a href="https://www.process.st/">Process.st</a> is a workflow software for businesses to quickly create recurring checklists, workflows and SOPs (standard operating procedures).</p><h3>#14 Alfred</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rSGWEre5qVeyOrUR" /></figure><p><a href="https://www.alfredapp.com/">Alfred</a> is a productivity application for macOS, which upgrades your efficiency with hotkeys, keywords and text expansion.</p><h3>#15 Shortcat</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*_IyKdCqt3zwr1lTR" /></figure><p><a href="https://shortcatapp.com/">Shortcat</a> is a keyboard another Mac tool that lets you ‘click’ buttons and control your apps with just a few keystrokes.</p><h3>#16 Hootsuite</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*kH5DLaTyIBm6L4Zs" /></figure><p><a href="https://hootsuite.com/">Hootsuite</a> is one of the most widely used social media automation tools out there, perfect for scheduling posts across all your social channels in one place.</p><h3>#17 ActiveCampaign</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*E42_J9cfciBkZggt" /></figure><p><a href="https://www.activecampaign.com/">ActiveCampaign</a> is an email and marketing automation tool that can be used to help grow your business with sales automation.</p><h3>#18 Robotask</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*kJKQQODqdklxqlIg" /></figure><p><a href="https://robotask.com/">Robotask</a> automates repetitive tasks on your Windows PC, from simply launching applications, to checking email, backing up files, sending emails and much more.</p><h3>#19 Textexpander</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*nAvuhJKdISXLfIOa" /></figure><p><a href="https://textexpander.com/">Textexpander</a> let’s you easily insert text snippets into any application from a library of content (created by you or your team).</p><h3>#20 Woodpecker.co</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*FOQ-ygUbGPmf5Kzs" /></figure><p><a href="http://woodpecker.co/">Woodpecker</a> automates your cold emails and follow ups so no leads slip through the net.</p><h3>#21 Leadfeeder</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*zp3kGRrDJqpYJZrn" /></figure><p><a href="https://www.leadfeeder.com/">Leadfeeder</a> generates B2B sales leads by automatically grabbing data from users who have recently visited your site.</p><h3>#22 Prisync</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*7mVPk8rm7pKvDeGN" /></figure><p><a href="https://prisync.com/">Prisync</a> automatically listens in to your competition’s ecommerce prices, so you optimize your prices and maximize product revenue.</p><h3>#23 Supermetrics</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*xtuByiGPX4pC3RW-" /></figure><p><a href="https://supermetrics.com/">Supermetrics</a> allows you to easily automate your marketing reporting, by getting PPC, SEO, social and analytics data into actionable reports.</p><h3>Go forth and automate!</h3><p>Now that you know what automation tools are available, all that’s left for you to do is go and have a play around and start automating your work.</p><p>These aren’t even the only tools available. There are lots more specific tools to discover once you start digging into the ever growing world of automation.</p><p>The only question left is:</p><p>What will you do with all that extra time you have left over now?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d42d9821bf17" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Google Sheets Add-ons to help automate SEO]]></title>
            <link>https://medium.com/@jsvxc/5-google-sheets-add-ons-to-help-automate-seo-975ef300bc89?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/975ef300bc89</guid>
            <category><![CDATA[seo-tools]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[marketing-automation]]></category>
            <category><![CDATA[seo]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Tue, 23 Apr 2019 16:02:40 GMT</pubDate>
            <atom:updated>2019-10-03T11:41:01.261Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/880/0*0Blrki27jts4Yu5i.jpg" /></figure><p>Less is more when it comes to Google Sheets add-ons. Here are five of the best for SEO &amp; marketing.</p><p>It’s no secret that I love Google Sheets. As powerful and useful as they can be though, by using some add-ons, you can make your spreadsheets even better.</p><p>I could of made this into a massive list of every Google Sheets add-on that’s vaguely linked to SEO. But that’s not that useful. Also, I only realistically use a handful of them.</p><p>Installing these add-ons can help automate marketing tasks like grabbing analytics data, keyword data, organic click-through-rates, SEO reporting and even sentiment analysis.</p><h3>Getting Started with Add-ons</h3><h4>How to install google sheets add ons:</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/557/0*jS5dd02M9D9uzhDY.png" /></figure><ul><li>Open up your spreadsheet.</li><li>Click Add-ons &gt;&gt;&gt; Get add-ons.</li><li>Now you can browse the available add-ons</li><li>To install the add-on, click the <strong>‘+ Free’</strong> button.</li><li>For most add-ons, a message will appear requesting access to data that the add-on needs to work.</li></ul><h3>Google Sheets Add-ons</h3><p>Here’s a run down of the five best spreadsheet add-ons for SEO:</p><h3>#1 Google Analytics for Sheets</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BUFSwQIbfKs-IqsK.png" /></figure><p>Using google Analytics for Sheets, you can access all of your analytics data without ever leaving your spreadsheet.</p><p>The Google Analytics API (+ data manipulation in Google Sheets), let’s you:</p><ul><li>Query data from multiple views/profiles</li><li>Create custom calculations from report data.</li><li>Create dashboards (with data visualizations)</li><li>Schedule reports to run automatically</li><li>Easily control who can see data with sheet’s sharing and privacy features.</li></ul><p><a href="https://chrome.google.com/webstore/detail/google-analytics/fefimfimnhjjkomigakinmjileehfopp">Get the add-on</a></p><h3>#2 Search Analytics for Sheets</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-xsXet36td9eQuH9.png" /></figure><p>This is one of my favourite add-ons. It lets you grab Search Console data and puts right in your Google Sheet. It’s a massive time saver. There is no limit on how much data can be pulled with this add-on (other than Sheets limit of 2 million cells per spreadsheet).</p><p>Here’s some of the things Search Analytics for Sheets can do right out the box:</p><ul><li>Get query, page, clicks, impressions, CTR and average position data</li><li>Grouping and filtering data (by Query, Page, Country and Device)</li><li>Automatic data backups (daily or monthly)</li></ul><p><a href="https://chrome.google.com/webstore/detail/search-analytics-for-shee/ieciiohbljgdndgfhgmdjhjgganlbncj">Get the add-on</a></p><h3>#3 Supermetrics</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MLr4v4MM3FInsJx0.png" /></figure><p>Supermetrics turns your spreadsheet into a supercharged reporting system by connecting to over 50 different data sources.</p><p>Here’s some of the things it can do:</p><ul><li>Get metrics from multiple sources like Google Analytics, AdWords, Facebook Ads, Bing Ads, Twitter Ads and more.</li><li>Automatically refresh reports or by a click of a button.</li><li>Create professional reports using pre-made templates</li><li>Schedule automatic emailing (in PDF, Excel, CSV or HTML formats)</li></ul><p><a href="https://chrome.google.com/webstore/detail/supermetrics/bnkdidgbiidpnohlnhmkehlimlnfhgce">Get the add-on</a></p><h3>#4 Monkey Learn</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*KthmXlMZIj6de5xi.png" /></figure><p>MonkeyLearn is an AI add-on that analyze texts using Machine Learning. Use it to turn emails, support tickets, chats, social media, surveys and documents into actionable data. It can classify texts by topic, sentiment, and intent or extract specific data such as keywords, names, and companies.</p><p><a href="https://chrome.google.com/webstore/detail/monkeylearn/cedpjjdkkbclbllppflfmoacfcjpmdng">Get the add-on</a></p><h3>#5 Hunter</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*z0uh6lJlFpNkwMVh.png" /></figure><p>Hunter is a simple but effective sheets add-on. It find email addresses inside your spreadsheet.</p><p>Just create an account you you’ll get 100 free searches/month and can upgrade your account for more.</p><p>There’s two main modes of Hunter:</p><ul><li><strong>Domain Search</strong> — Enter a domain name to find all the email addresses that have public sources. All email addresses are returned with confidence scores that estimate their accuracy.</li><li><strong>Email Finder</strong> — Select the columns of the first names, last names and company names to automatically enrich the spreadsheet with email addresses and their confidence scores.</li></ul><p><a href="https://chrome.google.com/webstore/detail/hunter/eipmgjdjccabchclpfkagoefhlkdpbaj">Get the add-on</a></p><h3>Google Sheets Add-ons + SEO = 📈</h3><p>All of these add-ons (along with Sheets overall usefulness) make for a useful tool to have for everyday SEO work.</p><p>Don’t forget to checkout the directory of <a href="https://sheetsformarketers.com/google-sheets-templates/">Google Sheets templates</a> to see these add-ons in action.</p><p><em>Originally published at </em><a href="https://sheetsformarketers.com/5-google-sheets-add-ons-for-seo/"><em>https://sheetsformarketers.com</em></a><em> on April 23, 2019.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=975ef300bc89" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to be a real life blogger]]></title>
            <link>https://medium.com/@jsvxc/how-to-be-a-real-life-blogger-721d93930fbf?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/721d93930fbf</guid>
            <category><![CDATA[blogging]]></category>
            <category><![CDATA[writing-tips]]></category>
            <category><![CDATA[how-to-start-a-blog]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Thu, 04 Oct 2018 10:30:16 GMT</pubDate>
            <atom:updated>2018-10-06T15:01:01.478Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rDkdfj-xyUUuDdG0Er0ZHA.jpeg" /></figure><p>I’ve just realised something about my struggle to start blogging:</p><p>I’m not doing anything worthy of blogging about.</p><h3>Let’s take a step back.</h3><p>I can easily write (and do write) 2000 word + posts about a range of different topics.</p><p>I do a lot of <a href="https://jsvxc.com/freelance-seo/">ghost writing in the SEO/marketing space</a> and have also been known to write a few <a href="https://jsvxc.com/google-sheets-tutorials/">tutorials about Google Sheets</a>.</p><p>This is regular too.</p><p>I’m talking <strong>2000–5000 words per week</strong>.</p><p>This is not loads by some peoples standards, but it is certainly a decent amount.</p><p>It’s often planned out too. I enjoy researching, outlining and mapping keywords to content. I like putting it into a content calendar. I like looking for bits to automate and speed up my work.</p><p>Yeah, I’m sad.</p><h3>In summary: I enjoy the process.</h3><p>But when it comes to my own work and my own blog, I stumble.</p><p>And by stumble, I actually mean, I don’t do anything. Or at least not with any consistency.</p><p>I think one reason is because there isn’t an inherent reasons for a blog in the early days.</p><p>Blogs are a living thing and they grow up overtime. They start as one thing and morph into another.</p><p>But I’m not selling anything. So what’s my goal?</p><h3>Early daze</h3><p>My blog is early days so it hasn’t yet found its purpose or audience. It doesn’t really have a point.</p><p>I think this is the roadblock for me.</p><p>Writing for others is easy by comparison.</p><p>They have goals. Increase email signups, get more customers, increase traffic, rank for buyer intent keywords etc. I know what to write.</p><p>Everything I need to write has been plugged into a calendar.</p><p>But my blog doesn’t have a clearly defined goal yet.</p><ul><li>Do I want to be a big name in the SEO industry? Nope, not really.</li><li>Do I want to rank for those big SEO keywords and get juicy leads? Nah, I’ll leave those kind of leads to big deal Neil.</li><li>Do I even know what I want from my blog? No. Hence this.</li></ul><p>I don’t want to write myself into a corner. This is a personal blog after all. It equally, it needs to be about something.</p><h3>Stealing from others</h3><p>So I took the advice of one of my favourite bloggers, Nat Eliason and started a <a href="https://www.nateliason.com/blog/no-niche">niche-less blog</a> so I wouldn’t be confined to a single narrowly defined niche.</p><p>I could write about anything. Which is a advantage wrapped in a disadvantage.</p><p>I quickly realised that I needed to narrow down. So I did. I decided to write about two distinct topics. Things I liked &amp; things I wanted to get better at. Sometimes topics fell into both categories.</p><p>Here’s some of the thing’s I want to write about:</p><ul><li>SEO, keyword research and content</li><li>Hacking my own Google Sheet based tools</li><li>Rock climbing</li><li>Trail running</li><li>Learning more technical marketing</li><li>Physical fitness</li><li>Philosophy</li></ul><p>I could go on.</p><p>So I’m not short on ideas. But yet I’ve only written a few sporadic posts.</p><h3>Obvious = 💩</h3><p>I’m hesitant to write the obvious.</p><p>The internet doesn’t need anymore recycled SEO articles. It doesn’t need more generalised fitness articles written by armchair trainers and keyboard warriors. And it definitely doesn’t need more gurus.</p><p>There are some great articles that offer a unique angle on something or a specific tactic. But there are more that just say the same thing.</p><p>I get it. Coming back to the SEO world, a lot of SEO content is to generate leads. But I don’t wanna write that kind of content.</p><p>I want to write content that I find interesting. That I would want to read.</p><p>And now we are back to the start.</p><p>How do I write content people want to read when I haven’t got a focus aka something to sell?</p><p>I guess by being authentic.</p><p>By writing about things I have done. Things I have observed. And the processes I have used.</p><h3>Then it hit me.</h3><p>Like a sledgehammer to a watermelon.</p><p>The fruity innards drop to the floor and show me the truth:</p><p><strong>I had no interesting angle to go at because I haven’t done anything interesting.</strong></p><p>The smashed watermelon has spoken.</p><p>It’s like that saying about eating healthy: garbage in, garbage out.</p><p>I haven’t done anything interesting in terms of the topics I want to write about, therefore I have nothing to write about.</p><h3>Now what?</h3><p>So the solution is simple:</p><p><strong>Do more stuff. Then write about that stuff.</strong></p><p>It sounds so obvious now.</p><p>It just took a bit of time (and a smashed imaginary watermelon) to realise it.</p><p><em>Originally published at </em><a href="https://jsvxc.com/how-to-be-a-real-life-blogger/"><em>jsvxc.com</em></a><em> on October 4, 2018.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=721d93930fbf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to find + fill content gaps with Google Sheets]]></title>
            <link>https://medium.com/@jsvxc/how-to-find-fill-content-gaps-with-google-sheets-343919f79683?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/343919f79683</guid>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[content-marketing]]></category>
            <category><![CDATA[seo-tips]]></category>
            <category><![CDATA[content-strategy]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Fri, 10 Aug 2018 12:43:03 GMT</pubDate>
            <atom:updated>2019-09-30T20:31:01.488Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*XYsiShIUeLpiHvpV.png" /></figure><p>Ever lost something down the sofa?</p><p>Annoying isn’t it.</p><p>Well, content gaps are rankings that have fallen down the sofa.</p><p>Want to find them? (and dust off the fluff)</p><h3>How to find content gaps</h3><p>In this article I’ll walk you through how to use APIs + spreadsheets to find content gaps you can fill in with, well… content.</p><p>Let’s go:</p><h3>What are content gaps?</h3><p>As defined by me, content gaps are keywords you rank for past page 3 (Avg. Position 20–100 and beyond).</p><p>These are probably going to be topics that are related and relevant to your site, but are not being targeted with content. Or maybe they and could just do with better on-page optimisation.</p><p>The point is, these are pages that are already ranking, just not as well as they could be.</p><p>These are the angsty teenagers of the keyword world, skulking in the background not reaching their potential.</p><p>So give them a nudge.</p><h3>Eh, is this just content gap analysis?</h3><p>Good question. Kind of, but not really.</p><p>Content gap analysis, in the traditional sense, is where you look at which keywords your competitors are ranking for and you are not.</p><p>This tool doesn’t do this.</p><p>( I say “tool”, it’s really a <a href="https://sheetsformarketers.com/google-sheets-templates/content/">content marketing spreadsheet</a>.)</p><p>If you want to do that, go check out Ahrefs or SEMRush, they both do content gap analysis straight out the box.</p><p>So I guess this tool could be better described as an internal content gap finder.</p><h3>How do I find content gaps?</h3><p>By searching each one of your keywords in Google manually, then writing the ranking position down in a leather bound book that slowly starts to gather dust and weighs you down as your never ending task consumes your life, Googling forever and draining your laptop and your mental energy.</p><p>Of you could hire a <a href="https://jsvxc.com/seo-services/">freelance SEO</a> to find them for you.</p><p>Or you could just use my <strong>Content Gap Finder</strong> tool I built in Google Sheets. It’s a bit quicker.</p><p>👉<a href="https://docs.google.com/spreadsheets/d/18HlTRXlez8QVxQxtDIU7RgMjG6uijc-_VYW7PpX4PBM/edit?usp=sharing"><strong>Get yourself a copy of the content gap finder sheet here.</strong></a>👈</p><h3>How it works &amp; setup instructions</h3><p>Analyses gsc data to look for keywords ranking position 20 and beyond</p><p><strong>1) Install this add-on to pull in SC data:</strong></p><p>searchanalyticsforsheets.com</p><p><strong>2) Configure the add-on:</strong></p><p>Authorize your sheet</p><p>Go to Add-ons &gt;&gt;&gt; Search Analytics for Sheets &gt;&gt;&gt; Open Sidebar</p><p>⚠️Make sure your Google account is authorized to use the Search Console property you want to back up!⚠️</p><p>Authorize.</p><p>Choose site.</p><p>Add Query &amp; Page to the Group By box.</p><p><strong>3) Choose Data Destination</strong></p><p>In Results Sheet, select ‘RAW DATA’</p><p>Request data.</p><p>Any existing data in the RAW DATA tab will be overwritten.</p><p>This will fill the tab with data.</p><p><strong>4) Add search volumes for your keywords.</strong></p><p>The quickest way to get a rough idea of search volumes is to use <a href="https://keywordseverywhere.com/">Keywords Everywhere</a>.</p><p>It’s a free chrome plugin that that allows you to bulk look up keywords. It’s awesome. Go get it.</p><p>Once you’ve added it, click on the KE icon &amp; bulk upload:</p><p>Copy + paste in your keywords. Click Get Metrics</p><p>Now hit Copy:</p><p>Go to the Search Volumes tab.</p><p>Click in cell A1 and paste in your keywords.</p><p><strong>4) Go look at your Content Gaps!</strong> 👍</p><p>The CONTENT GAPS tab will show you</p><h3>How to fill in content gaps</h3><p>So now you’ve got a nice list of pages and keywords to go optimize. But what kind of ways can you fill in your content gaps?</p><h4>Add content</h4><p>Look at the keywords you don’t have pages for… and then create pages for them.</p><p>If you are lucky (or unlucky depending how you look at it) the tool will give you a list of new pages you should really have on your site.</p><p>Go create them, optimize, get them indexed and start tracking.</p><p>That doesn’t mean you should just start creating loads of pages obviously</p><p>Group your keywords together where it makes sense for<a href="https://webris.org/topical-research-seo/"> strong topical relevance</a>.</p><p>It’s a lot more effective to have one large authority pages targeting multiple keywords than individual pages for each.</p><h4>Go after the long tail</h4><p>Long tail keywords are queries that are made up of at least 3 words.</p><p>They are more specific so have a stronger search intent, help in targeting niche audiences (vs mass audiences) and are more focused.</p><p>I guess the biggest advantage is that they are generally less competitive to rank for.</p><p>Long-tail keywords are used to target niche demographics rather than mass audiences. In other words, they’re more specific and often less competitive than generic keyword terms.</p><p>In order to find find longtail variations of your keywords, use tools like:</p><h4>Update old content</h4><p>You don’t always have to create brand new content, you could just look at old content and improve it.</p><p>Trying to target more keywords (providing it makes logical sense to do so) could be a better idea than building a page from scratch.</p><p>When refreshing new content, just make sure to <a href="https://twitter.com/JohnMu/status/991598952419069952?ref_src=twsrc%5Etfw%7Ctwcamp%5Etweetembed%7Ctwterm%5E991598952419069952&amp;ref_url=https%3A%2F%2Fwww.seroundtable.com%2Fgoogle-url-change-old-new-content-25675.html">keep the URL the same</a> otherwise you are losing your advantage.</p><h4>Repurpose</h4><p>Repurposing content saves time (sometimes).</p><p>It might be that your content isn’t engaging and could work better in a different format. Or maybe it would just be more useful in a different medium.</p><p>Here’s a couple of guides to help you along with repurposing content:</p><h4>Re-focus</h4><p>Maybe you are not quite addressing the searchers query.</p><p>Refocusing you page content to answer what a user actually wants to know can be all it takes.</p><p>Do some keyword research, look at the UX of your page and use Google Analytics data and make some tweaks .</p><h3>Building on content that works</h3><p>The crux of this tool is to show you what content is already working, so you can build upon them (just like with <a href="https://jsvxc.com/quick-win-keywords/">quick win keywords</a>)..</p><p>Sometimes starting from scratch is leaving quick wins on the table.</p><p><strong>Hint: </strong>sort by Clicks and filter to only show CTR 20% or over.</p><p>Sometimes you’ll notice a recurring theme that performs well in your niche. Create more content around this or even re-purpose existing content.</p><p>All that’s left is to go get yourself a copy of the <a href="https://docs.google.com/spreadsheets/d/18HlTRXlez8QVxQxtDIU7RgMjG6uijc-_VYW7PpX4PBM/edit?usp=sharing">Content Gap Finder</a> and starting plugging in those gaps.</p><p><em>Originally published at </em><a href="https://jsvxc.com/content-gaps/"><em>https://jsvxc.com</em></a><em> on August 10, 2018.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=343919f79683" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Find quick win keywords to improve rankings with Google Sheets]]></title>
            <link>https://medium.com/@jsvxc/find-quick-win-keywords-to-improve-rankings-with-google-sheets-7cd57d72ee?source=rss-34213cec1081------2</link>
            <guid isPermaLink="false">https://medium.com/p/7cd57d72ee</guid>
            <category><![CDATA[keywords]]></category>
            <category><![CDATA[seo-tips]]></category>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[rankings]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Jake]]></dc:creator>
            <pubDate>Thu, 26 Jul 2018 13:44:23 GMT</pubDate>
            <atom:updated>2019-09-25T19:28:24.974Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2pAcV7phkAau0TEU.png" /></figure><p>What’s better than a win?</p><p>A quick win.</p><p>Combine this with SEO and you’ve got yourself some quick win keywords.</p><h3>How to find quick win keywords</h3><p>In this article I’ll walk you through how to use APIs + spreadsheets to find keywords you can results from FAST.</p><p>But first:</p><h3>WTF are quick win keywords?</h3><p>Sometimes they are referred to as low hanging fruit keywords or even striking distance keywords.</p><p>But the point remains the same:</p><p>Keywords you can make a few tweaks to and see noticeable improvements quickly. Hence the name.</p><p>I’ve classed quick win keywords as terms you rank on the first/second page for (average position of 5–20) but not within the top positions.</p><h3>So how do I find them?</h3><p>By analysing the keywords you are ranking for.</p><p>You want to look for keywords hovering between the bottom of the first page and top of second page of the SERPs. Like I’ve said, keywords with an average position of between 5–20.</p><p>Basically any rankings not within the top positions.</p><p>Now there’s a couple of ways you could get this info:</p><ul><li>You could filter by position in Ahrefs, SEMRush, Serpstat etc.</li><li>You could export your rankings from a rank tracker and analyse your positions.</li><li>You could comb through Search Console data.</li></ul><p>Or, you can just make a copy of my spreadsheet and let it do the work for you:</p><p>👉 <a href="https://docs.google.com/spreadsheets/d/17mVt94Mk-QBxaeVxTu4azcDhXSYVBxuXYjp54_zdY8k/copy">Get yourself a copy of the quick wins keyword sheet here.</a> 👈</p><h3>Yeah yeah, but what about the results?</h3><p>Okay, I can hear you:</p><p>This tool/google sheets thingy sounds great, but does it actually get results?</p><p>Yes. Yes it does.</p><p>Working as a <a href="https://jsvxc.com/seo-services/">digital marketing consultant</a>, when starting to work on new sites for the first time, I always like to check for quick wins.</p><p>Here’s some results:</p><h4>Client Results #1</h4><p>B2C &amp; B2B client targeting competitive London keywords:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/709/0*SgfUmNf9a_0eIK3U.png" /></figure><h4>Client Results #2</h4><p>B2C Client targeting buyer-intent keywords:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/711/0*5be-jIShVDGpP5CJ.png" /></figure><h4>Client Results #3</h4><p>B2B client targeting really niche keywords:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/712/0*5xgq_u6zuE1LErBH.png" /></figure><h3>How it works &amp; setup instructions</h3><p>First things first:</p><p>Go grab yourself a copy here.</p><p>To get it working, you only need 3 things to get the tool setup:</p><ul><li>Google Sheets</li><li>Search Console Add-on</li><li>And a website (with GCS setup obviously*)</li></ul><p>*If you haven’t setup Google Search Console for your site, why not? Go and <a href="https://www.youtube.com/watch?v=UdMkesQ_PDo">watch this GSC Setup guide </a>then come back.</p><p>There’s two ways to use this tool:</p><ul><li><strong>Automated via Search Console</strong> — This method uses an API to pull in GSC data and then wrangles it in an easy to understand sheet</li><li><strong>Manually via a rank tracker</strong> — This method allows you to copy and paste existing rankings in and find your quick wins. Particularly useful for projects where you perhaps don’t have access to a client’s Search Console.*</li></ul><p>* <strong>SIDE NOTE:</strong> Funny story. I once requested access to Search Console for a clients site back when it was called Webmaster Tools. The client refused me access because and I quote “ <em>We pay you to do SEO, we aren’t paying you to be a webmaster as well.</em> “ 🤔🤷‍♂️ But I digress.</p><p>Pick which method you’d like use, and follow along below:</p><h4>Automated via Search Console</h4><p>1) Install this add-on to pull in Search Console data:<a href="http://searchanalyticsforsheets.com/"> searchanalyticsforsheets.com</a></p><p>2) Authorize your sheet by going to Add-ons &gt;&gt;&gt; Search Analytics for Sheets &gt;&gt;&gt; Open Sidebar</p><p>⚠️Make sure your Google account is authorized to use the Search Console property you want to back up!⚠️</p><p>3) Choose your site. Make sure to add Query &amp; Page to the Group By box:</p><p>4) In Results Sheet, select ‘RAW DATA’ (If you don’t select the RAW DATA tab, it won’t work. 👎)</p><p>5) Now request data. This will get the spreadsheet goblins working and you should see your quick win keywords! 👍</p><h4>Manual via Rank Tracker of your choosing</h4><p>1) Export your rankings from your tool of choice.</p><p>2) Tidy up your export: you only want 3 columns of data: Keyword, URL and Rank.</p><p>3) Paste these 3 columns into the MANUAL tab.</p><p>4) Once you’ve pasted your keywords, your data will populate in Quick Wins [Manual] 👍</p><p>Go forth and tweak…</p><h3>But what kind of tweaks?</h3><p>So you’ve got your list of quick win keywords. But now what?</p><p>Often, getting results from quick win keywords is just a matter of either improving a page or updating a page.</p><p>Here’s a few things you can try:</p><h4>Do more (or better) keyword research</h4><p>Going after the right keywords can make or break an SEO campaign.</p><p>So sometimes it’s worth a refresh.</p><p>It’s far beyond the scope of this article to tell you how to improve your keyword research, so here’s some useful guides you should read to up your keyword research game.</p><h4>On-page SEO</h4><p>Make sure your pages are optimised. If you know what keywords you are going after (see previous section) this is easy.</p><p>You’ll want to make sure your keyword are in:</p><ul><li>Your title tag</li><li>Your URL</li><li>In Your H1 tag</li><li>And variations of keyword used throughout your page.</li></ul><p>Sometimes a page won’t be ranking as well as it could be simply because it is not targeting a specific keyword effectively.</p><p>Just make sure to get the balance right between optimized for a search engine vs optimized for a user.</p><h4>Improve content</h4><p>With quick win keywords, you don’t necessarily have to create brand new content.</p><p>It can be a case of reworking what is there, rewriting sections or adding in additional sections. Relevancy is key here.</p><p>As the the 21st century philosopher Missy of Elliot proposed:</p><p><em>“Is it worth it? Let me work it. I put my thing down, flip it and reverse it”</em></p><p>Either write it yourself or <a href="https://jsvxc.com/freelance-seo/">hire a content marketer</a>. It doesn’t really matter which, just produce useful and topically relevant content.</p><p>If you want a heads start in content marketing, go read anything by Jimmy Daly @ Animalz, but start here with his awesome post about <a href="https://www.animalz.co/blog/core-concepts/">core content marketing concepts</a>.</p><h4>Internal links</h4><p>Grab a list of the most linked pages of your site (HINT: in Search Console).</p><p>Add links on those pages back to the pages you want to rank higher. Make sure to take care with your anchor texts.</p><p><strong>Site:websitehere.com “keyword”</strong></p><p>To find internal link targets, use this search operator:</p><p>Keep anchor text, amount of links and the actual pages you link to in check. Don’t over do it. Oh, and go read this <a href="https://www.hobo-web.co.uk/optimize-website-navigation/">internal linking guide</a>.</p><h4>Link building</h4><p>Link links links.</p><p>Some people have pretty strong feelings about linkbuilding. Instead of overthinking it, I like to just go build them.</p><p>Point them at the URLs you want to rank higher. Don’t overdo it with exact match anchors and try to be natural with it.</p><p>There’s loads of ways to build links. Some are scaleable, some aren’t. Some will work for a long time, some will be out of date next week.</p><p>Use your noggin and build links that make sense for your website.</p><h3>Wrapping up</h3><p>SEO is all about ROI.</p><p>If you are spending too much time and money on getting the right traffic to your site, you’re not going to have a good time.</p><p>I’ve always subscribed to the <em>‘do more of what is working’ </em>school of thought.</p><p>I call it lazy efficiency.</p><p>That’s why I built this tool. To speed up SEO &amp; keyword prioritization for me.</p><p>(There’s actually loads more <a href="https://sheetsformarketers.com/google-sheets-templates/">Google Sheets templates</a> out there to use for SEO &amp; marketing.)</p><p>Less time spent analyzing and prioritising keywords means more time spent creating content, building links and getting away from a screen. All important parts of an SEO campaign IMHO.</p><p>That’s it. Get yourself a copy of the <a href="https://docs.google.com/spreadsheets/d/17mVt94Mk-QBxaeVxTu4azcDhXSYVBxuXYjp54_zdY8k/copy">Quick Win Keyword Finder</a> and optimize away.</p><p><em>Originally published at </em><a href="https://jsvxc.com/quick-win-keywords/"><em>https://jsvxc.com</em></a><em> on July 26, 2018.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7cd57d72ee" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>