Recently we’ve had the pleasure to be working with the good people over at Sound Approach. We were approached to help by Sound Approach and Paul Morton to help them fulfil a ambition they’d had for quite awhile. To share, spread and inform people about the joys of Birding in Dorset.
Poole harbour and in particular Brownsea Lagoon is an area of unrivalled natural beauty and bird life. What Sound Approach and Paul Morton wanted to do was to share this privileged and exclusive environment with everyone, via their wonderful website and a live webcam.
Check out their website, the interactive map of poole and the DWT webcam now!
I love using Excel for managing data, but occasionally getting clean (when I say clean I mean pristine, shiny, perfect) domains is difficult.
So I finally found a simple function that achieved this and here it is:
Simply replace A1 with the cell containing the long version of the domain and you’ll have a beautiful, clean url. I like to put a IFERROR function in just to make it cleaner if something does go wrong.
Rather than messing around with a MID function this is the simplest way. Enjoy!
For more great Excel functions for SEO’s check out John Doherty’s Eight Excel Functions for SEO.
Here at Beetleweb we like to help our clients understand why and what we do. For this reason recently we’ve been working on producing interactive informative articles for our various processes and tools. Which we’ve entitled A Client’s Guide To.
So to start this series of Content and as an elaborate answer to a question on Quora, here is our Guide to how Infographic work. Click the image to see How Infographics Work
Want this infographic on your site? Simply copy and paste the below embed code to share on your own site!
<p><a href="http://www.beetleweb.com/how-to-use-info-graphics"><img src="http://blog.beetleweb.com/wp-content/uploads/2013/02/how-to-use-infographics.jpg" alt="how to use infographics" width="610" height="857" class="aligncenter size-full wp-image-1138" /></a></p>
<p>A client's Guide to <a href="http://www.beetleweb.com/how-to-use-info-graphics">How Infographics Work</a> by <a href="http://www.Beetleweb.com/">Beetleweb</a></p>
PLEASE NOTE: DUE TO THE IMPLEMENTATION OF THE CAPTCHA ON UBERSUGGEST THIS TOOL NO LONGER WORKS. SORRY
As an SEO I like to use Ubersuggest to get variations for keyword research. Rather than having to do this manually it’s useful to scrap ubersuggest using a Google Document. So I made one that I thought’d I’d share.
Click the link below to download it:
Here’s how to use it:
- Open The Google Document
- Select File > Make A Copy
- Enter the Search Query you want Ubersuggests for
- Select English UK or English USA or French or German
- See you Ubersuggest results
Let me know if you have any suggestions or if you need any help with it!
Notes: I’ve now changed it so that it has additional French/German options.
When using SagePay, you will need to need to test your transactions using SagePay. Below are test transaction card details that you can use to do so:
|Visa Electron UK Debit
|Japan Credit Bureau
So, you’ve made a sale on your Magento store and you’re seeing it in the backend BUT when you go to set the order status, there’s only one (maybe two) choices? If you’re like one of our clients recently, they wanted the option to have custom order status flags.
Can it be done? ‘YES’
If you’re in your Magento admin panel, choose
System -> Order Statuses
Once you’re here, it seems quite straight forward but there are a few hurdles and confusing parts.
So to begin, choose ‘Create New Status‘ add in a ‘status code’ (identifier), ‘Status Label’ (Readable) and you also have the option to set ‘Store Specific Labels’. Great, hit save.
Next up, you should now see your new status in the list. Only thing is it hasn’t been assigned to a state. Click ‘Assign Status to State‘. Choose the status the ‘Status’ you just created and then at which state this label should be an option. Save that.
There you have it! If you now go to Sales -> Orders, select your order and you should be able to choose your new status if the order is in the state you assigned.
Recently I’ve been analysing Google Results inside a Google Doc Dashboard combining two of my favourite things, Spreadsheets and Search. Using Google Docs Importxml functionally you can pull in classes from any URL. For more information check out Distilled’s Excellent Guide
But I couldn’t find an easy to understand resource except for Yoast PDF cheat sheet on Google’s URL Search Parameters. So I thought I’d share what I had learnt:
This is what your URL becomes if you search Google.co.uk for ‘christmas’
Here’s what this actually means:
Here are these parameters explained
hl= Human Interface Language. In this case this is set a ‘en’ which is English.
safe= Whether Safe Search is enabled ‘on’ or disable ‘off’
tbo= Whether or not to display search tools in the left sidebar (not very important for Importxml scraping)
site= This specifies you are doing a site search.
source= This is Google’s navigation parameter specifying where you came from. (hp= homepage)
oq= Original Query. If you originally search for something then amended your search using Google Suggest, this should display the previous term you were entering.
Personalised Info. Not important
Additional Terms it’s useful to know
gl= Geo-Location. For scraping I tend to use ‘UK’
I hope it helps. Let me know in the comments if you’d like me to add detail on any other of Google’s URL Parameters. I’ll be uploading a copy of my Google Results Scraper shortly.
Additional resources can be found here: http://www.rankpanel.com/blog/google-search-parameters/ & http://www.seomoz.org/ugc/the-ultimate-guide-to-the-google-search-parameters
Recently I had been contemplating how Google’s push towards paid search had been changing the shape of the SERPs (Search Engine Results Pages).
Over the years Rand Fishkin had mentioned that organic search gets 80% of the clicks and presented an image like this:
This was a marker that I stood by and generally used to justify Organic Search strategies for our Magento Developers page as well as for our clients.
However my assumption was that this has decreased with the increase in Paid Search. Thus I was surprised when an Infographic recently released by the Search Agents seems to rebuke my assumptions.
After further investigation I found the source of their data to be the good people over at Search Engine Watch. But disappointing the source of their stats come from a study in June 2011 by eConsultancy, where paid Search wasn’t as dominate as it is now.
This leaves me with two questions:
1) What is an accurate organic click rate now, in 2012?
I stand by my belief that organic search still gets a leading majority, but that it is in decline. I wouldn’t be surprised by 76% rather than 80%
2) What percentage of average Google users now know which of the SERP is organic and which is Paid results?
I surmise that nowadays with more real estate is given to paid search, that users are less consciously aware of which is which
Let me know what you think, i’m putting together some research to try and answer both questions.
Here’s the infographic if you are interested:
As Magento Developers we work on a lot of Magento Sites. Magento Table Rates are something which often tends to confuse our clients. With the range of complex magento country codes, region codes and no example format easily downloadable, it can be a little more difficult than necessary.
So we have created an Easy to Use Magento Table Rate Creator to create a Magento table rate CSV’s . Click the images to download below:
Here’s How to to use it:
- Download the Magento Table Rate Creator
- Open the Excel Document
- Be Sure to enable Macros (See slide for more info if necessary)
- Select the Country you’d like to ship to from the dropdown menu
- Select the Region from the dropdown
- Enter Order Subtotal
- If you’d like to match Postcodes, enter all the postcodes you’d like to match. One below each other in the postcodes section
- Enter the Shipping Cost for this Country, Region, Order Subtotal & Postcodes
- Click Populate
- Repeat until you have all the shipping config required.
- Copy and paste from the Output tab into the Magento Sample Table Rate CSV.
- Save this file
- Upload into your Magento Admin. (found at Admin > System > Configuration > Shipping Methods > Table rates ). If the upload option is not available change the Current Configuration Scope to Main Website
Or view the below slideshows for step by step instructions:
If you have any issues or need any help with this, just let us know in the comments below.