Is once a quarter enough for a tech audit? Keeping on top of problems or inefficiencies on your site is not just good practice for SEO, it’s just a good idea for your users in general — and that’s where a tech SEO audit comes in. Users and search engines are discouraged by things like […]
Good question. There’s probably no one set of skills that defines what a digital marketing consultant looks like, but in general, it’s someone who can look at all or most of your online activity and give you some tips on how to improve, or solve your existing problems. This will typically come with some experience
In my previous post about ongoing SEO vs “SEO-ready” sites I only had a short-ish section about why SEO is a task that is never really over (the exception being perhaps if you are doing SEO for marketing campaigns, more on that another time). Here I’m going to add a bit more detail on why
Ongoing SEO: 6 Areas Where Sustained SEO Leads To Success Read More »
The New York Times recently reported some of the commotion around Google Magi and the tech giant’s attempt to catch up with some of the developments by Microsoft who introduced AI to their Bing search engine. Naturally anything to do with big changes to search gets the SEO/PPC community whipped up into a bit of
Google Magi: what chatbot AI/powered search means for SEO/PPC Read More »
Introduction (Edit: I recently posted in more detail about ongoing SEO as I’ve noticed more and more small businesses hoping that there is a “one-off” way to fix search engine visibility.) Search engine optimisation is generally seen as the process of optimising a website’s content and structure to increase its visibility and ranking on search
Why make a list of SQL tips? This is going to be an ever-growing list of SQL tips, shortcuts that I find useful day-to-day. I don’t claim to be the best at SQL but I figure if I keep track of some useful techniques and ideas here then it won’t hurt! The idea originally came
This snippet was handy for to remove duplicate rows in SQL. These had crept into a Postgres database table as a result of a dodgy join. This is sort of a note to self, really. There are probably more than a couple of ways of doing this but the best example I came up with
How to remove duplicate rows in SQL (works with Postgres) Read More »
I’ve been toying with the idea of creating an app that helps with a weekly review for a while. I first came across the idea when reading about Getting Things Done and the massive list of ‘triggers’ that comes with that. To be honest I found it a bit daunting and didn’t need to check
Pretty niche audience for this one, but posting it for my own benefit as much as anything. Thanks to the original link at Ubuntu Forums for the following hints: [fn]+[return]= Insert [fn]+[UPARROW]= Pg Up [fn]+[DOWNARROW]= Pg Down
Insert Key (or equivalent) on Ubuntu using a Mac keyboard Read More »
This is a really simple (i.e. probably even the most basic possible) example of using the built in aggregate() function in R, basically a sumif in R. Given a set of data where column a is the values and column b contains the data by which you wish to group (in this example categorical data