<?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 Andertons Music on Medium]]></title>
        <description><![CDATA[Stories by Andertons Music on Medium]]></description>
        <link>https://medium.com/@andertonsmusic?source=rss-1a6f7fafd253------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*0u5s-etBnmqIX-CEyAEbgw.png</url>
            <title>Stories by Andertons Music on Medium</title>
            <link>https://medium.com/@andertonsmusic?source=rss-1a6f7fafd253------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 06:06:01 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@andertonsmusic/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[What being part of a Top 250 E-Commerce company means to us]]></title>
            <link>https://medium.com/@andertonsmusic/what-being-part-of-a-top-250-e-commerce-company-means-to-us-cf7f2467da12?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/cf7f2467da12</guid>
            <category><![CDATA[team]]></category>
            <category><![CDATA[ecommerce]]></category>
            <category><![CDATA[guitar]]></category>
            <category><![CDATA[awards]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Thu, 16 Feb 2017 00:48:23 GMT</pubDate>
            <atom:updated>2017-02-16T01:01:39.412Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eAn3EXRGMLpcJTrLIXe-vQ.jpeg" /></figure><p>We learned last week that Andertons had ranked as one of the <a href="https://blog.andertons.co.uk/andertons/andertons-rank-top-250-uk-online-retailers">Top 250 UK E-Commerce retailers</a> according to <a href="http://internetretailing.net/download-iruk500-2017-report/">Internet Retailing magazine’s 2017 report</a>.</p><p>To have got this far as ‘little old us’ is a surreal achievement. Also: <strong>F*@#ing WOOHOOOOO.</strong></p><p>I’ve been here a long time; maybe a touch too long! When I started, we had single digit subscriber numbers on YouTube, there was no Facebook page… Andertons was just another one-hick-town bricks &amp; mortar retailer who thought they should probably have an internet site.</p><p>From then to now, I’ve seen a team of ridiculously dedicated, talented people, come together to move the needle on what, to me, is stage worth singing on. That somebody thinks that Andertons is one of the UK’s top 250 e-commerce companies made me punch the air with joy.</p><p>And — I’ll stick my neck out — I think we have 10x more to give…</p><p>I can and will continue to blubber unabashedly about the digital team’s part in this. When it was just me and the dog (literally), I had no way of foreseeing Andertons turning the e-commerce e-corner it has, and no way of knowing that I’d have the privilege of working with and leading such driven, creative, funny people as those that make up my team.</p><p>But only a restaurant-sized portion of the e-commerce experience is down to the efforts of the herbal-tea desk brigade.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ojkYtWqD2hcT4sC2jgLxkA.png" /></figure><p>Every day I see a customer services team who deeply empathise with every single musician they help. We have leadership prepared to invest in capital and people, and take risks, and an administrative operation that works with the effectiveness and elegance of a steam train.</p><p>The team at ‘the magical box machine down the road’ (a.k.a. the warehouse), work at full capacity pretty much 100% of the time, and the staff in the store &amp; back-room techs form bonds with the customers who walk in, often trekking from all corners of the globe to visit… Andertons.</p><p>There’s a wonderful theme in Walter Isaacson’s book about Steve Jobs, referring to Jobs’ attitude towards his products: <em>No matter how few people see it, the insides of a machine should be just as beautiful as the outside.</em></p><p>I can’t help but think it is this quality of Andertons’ people that makes the brand what it is.</p><p>I chuckled when I realised I had sat with Lee (Mr A) in 2014 at the Internet Retailing Conference. We listened to Jérôme Cochet of Zalando explain how they mobilised a million (or something) teams of good-looking, multi-lingual superstar unicorns, quarterbacked by James Bond, to roll the Zalando brand out across the globe like the bloody Allied powers…</p><p>With the 2014 IRUK Top 500 in my lap, I wondered when anyone would care about the work that we did at Andertons. I feel now like people do!</p><p>2017 is a scary year for us. I could cite at least four big things that we’re trying to achieve that are all, individually, projects that would have been ‘too much’ to take on two or three years ago; if Andertons has ever bitten off more than it can chew, we’re just about to find out.</p><p>Maybe in the autumn, we’ll look back at the burning cinders of failure and wonder what we were thinking… But for me, it’s a thrill to carry some of that responsibility for this leap into a new era.</p><p>There are so many people busting a bollock right now (some people might even lose two) to get Andertons through this change. It’s that which gives me faith that we will emerge the other side as a tour de force!</p><p>Thank you to anybody reading this, because it’s most likely because of people like you that Andertons is the company that it is. Unless you’re one of those chaps from GAK or Red Dog Music who are spying on us on Medium (in which case thanks for keeping us on our toes).</p><p>Along with all my colleagues, I feel stupidly lucky to have landed in this business unwittingly. I only hope we can keep on being the right thing for all our customers (and the wrong thing for GAK 😉).</p><p><em>If you’re an A-Gamer who loves music, retail, digital, or all of the above, you can apply prospectively for a position at Andertons on our jobs website: </em><a href="https://jobs.andertons.co.uk/"><em>https://jobs.andertons.co.uk</em></a></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ’n’ roll music instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching nearly half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart is the daddy of the E-Commerce team at Andertons. Seven years? Eight years? Can&#39;t remember. Living for the next cup of herbal tea. Mine&#39;s the &#39;Orange Cookies&#39;. Smells amazing (the tea).<br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cf7f2467da12" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Andertons 2017 Rebrand]]></title>
            <link>https://medium.com/@andertonsmusic/andertons-2017-rebrand-1118e401d5f?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/1118e401d5f</guid>
            <category><![CDATA[design]]></category>
            <category><![CDATA[branding]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Thu, 19 Jan 2017 10:43:26 GMT</pubDate>
            <atom:updated>2017-01-19T11:01:28.356Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8CKrVVwL2HlQ2f6UTMk34g.png" /></figure><p>Every 10 years or so, in a terribly Dr Who fashion, Andertons metamorphoses and a new logo appears. Since the 1960s it’s been <strong>blue </strong>and since the 90s it’s had a big ol’ circular <strong>loop </strong>around it. But no more…</p><p>After working closely with<strong> </strong><a href="http://thepullagency.com/"><strong>The Pull Agency</strong></a> for a number of months we’re super stoked to be rolling out the biggest rebrand in our 53 year history.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*K9K2qh2ZEzErnfPF6dE1Kw.png" /><figcaption>The first iteration of the new logo type including Creative Director <a href="https://twitter.com/darrencornwall">Darren Cornwall</a>’s notes. The lighting bolt was iterated to a more compact flourish in the final logotype.</figcaption></figure><p>We asked Pull to better reflect our personality and values in our branding…</p><p>We had a number of challenges: conflicting brand identities, too corporate to be a real reflection of what people love about making music, and a feeling throughout the company that the visual branding didn’t represent the true <em>personality </em>of the company that Andertons has grown into.</p><p>Pull worked with customers and Andertons staff from all areas of the business to understand what is the <em>personality </em>of the brand? <em>What makes Andertons distinctive</em>?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Sen-sQ_xT7NpcKtbGPzaWg.jpeg" /><figcaption>The new 2016 logotype (left) besides the previous logo, first used in 2008</figcaption></figure><h4>Heritage…</h4><p>It starts off with being a family run business, founded in 1964 by Harry and Peter Anderton. So the new branding had to reflect a heritage of over 50 years. The new Logotype leans heavily on inspiration from classic hand drawn branding of the 50s and 60s but with a consideration for being used in a wide variety of contexts.</p><h4><strong>…With Modern Considerations</strong></h4><p>Pull also did something Andertons has never done before: developed an icon. Icons have become more and more important in branding as more often than not the space you have to brand a social media account or app is either a square or a circle, neither conducive to working well with a traditional logotype.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*NFNu-kl_pmgACe8dhKti_A.png" /></figure><h4>Greater differentiation for departments</h4><p>One of the challenges facing shops like Andertons is picking out branding that looks great no matter what department. The danger is if you make stuff too guitary then drummers won’t identify with it and vice verse.</p><p>The A icon was developed to be flexible enough to accommodate department specific variations, and in the future other variations for different things like our YouTube channel…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EXB5H2eRIy9bZHc7LBO28w.jpeg" /></figure><h3>Roll-out plan</h3><p>With a rebrand of this size it would have be incredibly difficult to launch everything all at once so we’ll be rolling out the new branding over 2017, and we know what you’re thinking but don’t worry… it’s not all black and white. What we’re showing you here is the core components: the logo and the icons. They’re shown in black and white not because they’ll always been in black and white but rather to show that they could actually go anywhere, on anything, in any colour (within reason!)</p><p>Stay tuned and in another post we’ll share some more detailed examples as we roll them out (including some colour!) but for now here are some other artists impressions of the new branding in context…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Jb_gjDjVShMhzOvK5slq2w.jpeg" /><figcaption>Early carrier bag concepts (we thought these were pretty cool!)</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LvMY9rhV0hn_epYLPjrnEA.jpeg" /><figcaption>Demand for t-shirts and other branded merchandise has risen over the last couple of years so it was important the new branding looked great t-shirts, hoodies etc</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OVdkLT7zDk_UKyU4RvITIg.png" /><figcaption>The rebranding isn’t just visual — a large part of the project was enhancing the shopping experience including better in store signage to help customers navigate the busy store.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zw0bUKu-oXUc5TyY2VD9oQ.png" /><figcaption>It’s not always been obvious from the previous 2008 branding that Andertons is a family run business with over 50 years of heritage, so Pull drew up concepts of including heritage touches throughout the store and website.</figcaption></figure><h3>T-Shirts featuring the new branding are available now from <a href="http://www.andertons.co.uk/tshirts">www.andertons.co.uk/tshirts</a> …</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CVdnwMNPHrlMRA7zIumxZg.jpeg" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1118e401d5f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Fun things people have searched for on Andertons.co.uk — and we have no idea why!]]></title>
            <link>https://medium.com/@andertonsmusic/fun-things-people-have-searched-for-on-andertons-co-uk-and-we-have-no-idea-why-6c77afc46caf?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/6c77afc46caf</guid>
            <category><![CDATA[music]]></category>
            <category><![CDATA[search]]></category>
            <category><![CDATA[ecommerce]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Sat, 15 Oct 2016 13:57:37 GMT</pubDate>
            <atom:updated>2016-10-15T13:57:37.686Z</atom:updated>
            <content:encoded><![CDATA[<p>Earlier in the year, I shared with you a little bit about how the Andertons website team view our internal site search experience.</p><pre><a href="https://medium.com/@andertonsmusic/your-online-sales-adviser-finding-your-perfect-guitar-in-a-catalogue-of-thousands-81f6b9616912">Part 1</a>: Helping you find your perfect guitar with EasyAsk search technology</pre><pre><a href="https://medium.com/p/ce5f324b760a">Part 2</a>: Search Laboratory - Improving search with data &amp; lab rats</pre><p>As a fun closer to my little series about search, I thought I’d compile a list…</p><p><strong>These are all real searches made by people on Andertons.co.uk.</strong> All of the data we are looking at is entirely anonymous so we know next-to nothing about these individuals who used our site, other than what they asked us when they got here.</p><p>Some of these are clearly mistakes, or maybe bots, and others are far more intentional. That’s what makes this all the more... interesting! Proceed with caution: you may find some of the searches below a little blue.</p><ul><li><em>Doctor Who</em></li><li><em>Guitar guitar for £23900 only £1000 off what a joke</em></li><li><em>Chris Sh*tlett</em></li><li><em>Image analysis algorithm for malaria</em></li><li><em>F**k Pedal</em></li><li><em>Usb aaudio ininininterininininterininininterfaininininterininininterininininterfaininininterininininterininininterface</em></li><li><em>Chappers soul? I’m suspecting you won’t have these</em></li><li>Sh*tlett</li><li><em>How to draw cartoons</em></li><li><em>Sexchanger</em></li><li><em>Why does no one like Tom?</em></li><li><em>exxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxpxxxxxxixxxxxxxxxxxxxpxxxxxxxxxxxxhxxoxxxxnxxxxexxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</em></li><li><em>What country are they made god dam it</em></li><li>Fender Chris Sh*ttlete</li><li><em>Footsh*tch </em>(followed by…)</li><li><em>Marshall footsh*tch</em></li><li><em>Ramsgate, Harbour: 1 Shag Ramsgate, West Cliff : 1 ad m Black Redstart</em></li><li><em>Hozelock 4 in 1 Porta Shower</em></li><li><em>KFC</em></li><li><em>Ultra S**t</em></li><li><em>Show me some sh*t between 100 and 200 quid</em></li><li><em>The children and the other hand is not the same thing over and over again and I don’t have a nice person but the fact is the gym</em></li><li><em>This life is crashing you down untill you suffer enough For decades and decades the mother bird puked in your mouth</em></li><li><em>How u doin gorgeous?</em></li><li><em>Yamash*t P45</em></li><li><em>Henry vacuum cleaner</em></li><li><em>Get stupid drum music</em></li><li><em>Jesus</em></li><li><em>Buttsex</em></li><li><em>Run run rudolph rip lemmy quite a cooll rock, and like it, rip lemmy i wont do it, i just keep it harm, like zztop, i dont like quasi what is money making</em></li><li><em>Fender Chris Tele </em>(phew…)</li><li><em>Lee Anderton is a knob</em></li><li><em>F#!*ING CHAPMAN</em></li></ul><p>And finally… One poor soul, desperately confused about the services Andertons provide, apparently also having a terrible search relaxation experience:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/261/1*zn3iZgrHTD4ksgSOCZg4Sw.png" /></figure><p><em>Are you now thinking about searching for something terrible or offensive on Andertons.co.uk? For once, we don’t want to know what you’re thinking, and please don’t hit “go”.</em></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ’n’ roll music instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart heads up the E-Commerce technical team at Andertons. He never searches for stupid stuff on other peoples&#39; websites. Never.<br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6c77afc46caf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Adopting Scrum Part 1: “MacroMan, the Google Sheets Superhero”]]></title>
            <link>https://medium.com/@andertonsmusic/adopting-scrum-part-1-macroman-the-google-sheets-superhero-97e06a5b138a?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/97e06a5b138a</guid>
            <category><![CDATA[scrum]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[agile]]></category>
            <category><![CDATA[to-do-list]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Wed, 10 Aug 2016 08:57:41 GMT</pubDate>
            <atom:updated>2016-08-10T08:57:41.549Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DM-9u3KmUp4Lk-BDAJaEeA.jpeg" /></figure><p><em>Over the last twelve months, we have been adapting the principals of Scrum — the agile project management framework — to improve productivity in both our web content and web projects teams. We continue to strive to make Andertons’ online store the best destination on the web for musicians to research &amp; buy their gear.</em></p><p><em>Here’s a little story about MacroMan: An ordinary projects team manager empowered by a love of spreadsheets…</em></p><p>At some point in early 2015, Andertons’ Head of Digital Marketing, Mark, entered our web content office kitted with a hi-vis and a hard hat, and triumphantly declared that the content team was going to “try Scrum”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/1*_0p7uuIMxXvDi9qgwDCDng.jpeg" /></figure><p>A split second later, I was violently brushed aside as a shipping container of post-it notes was forklifted through the door, followed by a vat of sticky-label residue remover.</p><p>The Andertons post-it-note explosion of 2015 was by far the most colourful event of my time here, except for maybe the six week period where the only biros you could hope to find in the whole company were red or green.</p><p><strong>Scrum</strong>, for those who aren’t familiar, is a set of working practices which are designed to get tasks done quickly, and in the order in which they deliver the most value. In project management, it is the antithesis of the Gantt chart, and revolves around ongoing short bursts of work (“sprints”), followed by regular regrouping meetings to reassess and make sure that the requirements of a project have not changed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ISmsT46T3ew_XzYj-Qhtrw.png" /></figure><p>Post-it notes are the suggested basis of one of the more iconic elements of the Scrum project management methodology: The <em>Scrum Board</em>.</p><p>Any time you walk into an office with a wall covered in post-it notes, there’s a good chance that those guys and girls are practicing Scrum in some form.</p><p>Either that or there’s a pop art maniac on the loose and HIDE THE KEYS TO THE STATIONERY CUPBOARD, JONATHAN. NOW!!</p><p>The Scrum Board is simple. In short, you write down everything you’re going to do during your next sprint period (e.g. the next two weeks — a substantial but not-too-long amount of time) onto post-it notes. One post-it represents one task. You stick all the post-it notes on a wall with headers like <em>To-do</em>, <em>Doing</em> and <em>Done</em>, and then throughout the sprint everybody frantically redecorates with the aim of moving all the post-it notes from one side of the office to the other.</p><p>All this I learned from <a href="https://www.amazon.co.uk/Scrum-Doing-Twice-Work-Half/dp/1847941109/">Jeff Sutherland’s Scrum book</a>, which Mark had suggested I check out. “Read the bloody book, Andrew”, he would flamboyantly evangelise, wearing his technicolour dreamcoat of post-it notes formed by rolling around in the sticky-paper chaos that the web content office had become.</p><p>I couldn’t help but think the Scrum board was great in theory, but wouldn’t work effectively for our projects team. And it wasn’t just that I had a disciplinary meeting looming over me if I did anything to mark the walls of our newly-painted office…</p><h4>The Good Ideas Book</h4><p>One of the problems of not having a good framework though, is that it makes getting cool stuff done more of a game of chance. People have good ideas all the time (even us), but it isn’t enough just to be visionaries; my team are the doers that are supposed to make ideas happen!</p><p>A few years ago, conversations would start like this:</p><blockquote>“Build me a flying car that can send a budgie to the moon.”</blockquote><p>Mr Anderton would say.</p><blockquote>“Uh uh well.. OK, yes, I’ll certainly do that when I have time.”</blockquote><p>I hopelessly responded.</p><p>After a while, Mr Anderton rightfully noticed that neither the budgie moon-mobile nor any of his other great ideas had really undergone much progress. I tried a solution: <strong>The</strong> <strong>Book of Good Ideas</strong>.<em> [fanfare]</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/1*2TxeFVhYms5qUxX__US-Lg.jpeg" /><figcaption>The now-retired <em>Book of Good Ideas</em></figcaption></figure><p>In 2014 I decided that our good ideas should be enshrined in the office as a blue, 60-page, lined A4 notebook jobby with a light bulb drawn on front (and if you don’t think that’s an achievement in itself, ask me to draw any animal).</p><p>All anyone had to do to feed an idea into the project team was to write it in the book. Everyone could write something, just so long as it was one line and they dated and initialed their idea.</p><p>But, by the summer, the book had become my place of sorrow and misery. Certainly the lightbulb was <strong>not</strong> the bright source of daily inspiration I had hoped it would be! The book probably had 250 ideas in it, and aside from the fact that I had crossed next-to-none of them off, it was becoming more and more difficult to decide what to do next.</p><p>Melancholically rifling through a bumper pack of post-it notes, I got to thinking about what I had read about <em>product management</em> in the Scrum book. I drew an analogy. You know… The website I work on every day is my ‘product’, and I am… well I’m the guy who does something about good ideas!</p><p>What if our ideas were categorised and searchable, and we had some sense of how valuable they were and how much of our resource they would take up? What if I could see them wholesale — what had been done and what hadn’t — break them down into smaller, more-manageable tasks, and build up an overview picture of our progress towards progress for all aspects of the web team?</p><p>And then I ate a macro, and I became… MacroMan.</p><h4>MacroMan</h4><p>I increasingly couldn’t get my head around achieving all this with post-it notes, but I <em>do </em>like spreadsheets. A lot. In fact it’s wholly troubling just how excited I get about spreadsheets. I’m even writing this article <em>about </em>them in my own spare time.</p><p>You might be thinking at this point that there’s nothing less “Guitar Hero” than a spreadsheet, but let me tell you that… MacroMan disagrees.</p><p>So, who is MacroMan? It’s time for a confession — and I’m really not lying: At age 17 I had the nickname, “<strong>MacroMan” </strong>as an I.C.T. student in college.</p><p>Laugh it up.</p><p>It was owing to my mere competence at making Microsoft Excel do something terminally boring and altogether not-that-clever by running a macro when you clicked a grey button.</p><p>I’ve carried the psychological devastation of all that through to my twenties, but having the macro mindset has generally been bloody useful. (About as useful as knowing a small amount of VBScript has <em>not.</em>)</p><p>Daily, I demonically dice data and solve problems that you couldn’t solve without Excel and a gnarly SQL query.</p><h4>Managing Good Ideas</h4><p>So naturally, my solution to having too many good ideas was to put them all into one, big, F-off Spreadsheet. This was how we would search them, change them, work on them, and make them visible to anybody we wanted.</p><p><strong>I think it’s important to note that we chose Google Sheets over Excel to do this.</strong> It’s certainly <em>not</em> more powerful — Google have a lot of scrumming to do to get it to that point — but having the concept run in the cloud was invaluable for me.</p><p>Thing is: we could have created an Excel sheet on the shared drive and tried to get everyone that needed it to open it and update it as they worked… But I knew this would die.</p><p>For one, Excel still has a splash screen, and nothing makes me want to gouge my eyes out more than watching splash screens in 2016...</p><p>But other than that, it’s simply that people in your business are ruining your lives with Excel spreadsheets already; no-one needs any more.</p><p>There’re probably (about) four thousand spreadsheets at Andertons that people hope we will use/update/reference on a daily basis… How many of them get used at all? Well I can tell you that arguably the most important sales report here hasn’t been updated in the last four months because it involves opening and updating an Excel file…</p><p>We have the cloud, right? I have ten pinned tabs in Google Chrome which represent the majority of the tools I use daily. Our Google Sheets Feature book is one. It’s never far away.</p><h4>Too many projects? Not a problem</h4><p>Using spreadsheets, we group tasks into themes/projects. For us, projects run asynchronously and they don’t have to be a ‘project’ in a traditional sense with some big, end deliverable. Our <a href="https://medium.com/@andertonsmusic/search-laboratory-rock-n-roll-lab-rats-ce5f324b760a">Search Lab</a> is an ongoing piece of maintenance work, but we treat it as a ‘project’. We have a project called “Trust” with website feature ideas that will enable our users to feel confident in our expertise. It’s an ongoing ‘project’; it’s not a thing that ends!</p><p>As such, the framework supports most of our progressive, proactive work.</p><h4>What it looks like</h4><p>Each line of the feature book spreadsheet…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EqvsB011mItGhbb61fR7Bw.jpeg" /></figure><ul><li><strong>Is numbered:</strong> So we have a reference number for the task.</li><li><strong>Has a headline:</strong> If you can’t sum it up in one line, break it down more!</li><li><strong>Idea:</strong> Who is the visionary? Who are you going to ask to understand why the budgie needs to be on the moon?</li><li><strong>Delivery:</strong> Who is ultimately responsible for delivering the task?</li><li><strong>Date Added (to the ideas list): </strong>We have ideas dating back to 2011 that we still haven’t done but might still want to do.</li><li><strong>Target Date:</strong> Once a task is in a sprint, give it a target completion date.</li><li><strong>Estimate Value &amp; Effort:</strong> To help understand the team’s velocity.</li><li><strong>Status:</strong> We use things like <em>In Progress</em>, <em>Roadblocked</em> and<em> Completed</em>. I’d quite like to add: <em>Imminent danger to nearby objects</em>.</li><li><strong>Notes:</strong> Because we all talk too much (especially me).</li></ul><p>And that’s <em>all</em> we feel we need to log about a task to make decisions about what we’re going to work on in the next two week sprint, and therefore to progress effectively and visibly.</p><p>If you’re nodding off at this point, WAKE UP. This is the good bit. Here is a snapshot of all our “projects” and their statuses today; around 900 headlines that we could be working on in our next sprint.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*S_UwhRiQCJ0vcRG7JgcgeA.jpeg" /><figcaption><strong>One helluva ‘To-Do’ list</strong></figcaption></figure><p>This is kind of beautiful to me. I think it explains why the Scrum board and post-its don’t quite fit our project team model, but also shows that all that information about a task <strong>can</strong> fit onto one line in a spreadsheet.</p><p>Zoom out and I can see the whole picture in one go. Zoom in and I see all the meta information for singular tasks. No need to drill down through a UI.</p><p>By the way, I don’t mean to dump on <a href="https://trello.com/">Trello</a> or any other similar digital Scrum Board tool, but I felt like a spreadsheet is able to turn a mass of tasks into something that makes sense on a macro (in the other sense of the word, no pun intended) level.</p><h4>The Andertons.co.uk Feature Book Today</h4><p>If you can apply Scrum to projects, I think you can apply it to your project management framework!</p><p>Recently, we were well into the rhythm of our fortnightly sprint meetings, but we recognised that they were taking up to two-and-a-half hours, and all we were doing was managing and annotating tasks which were already known.</p><p>For example, we had created a dashboard view for ourselves for the sprint. We had got as far as using <a href="https://zapier.com/">Zapier</a> to automatically copy tasks that were “in progress” to the dashboard view so we could see our sprint tasks at a glance. However, when discussing tasks as we closed the sprint, we were constantly flipping between the dashboard and the main project sheet to make sure everything was updated correctly.</p><p>Frustrated, we laid a task to… make the task spreadsheet better! This meant exploring some of the more advanced features of Google Sheets.</p><p>Filter views, and the FILTER() function are quite useful, but to fully achieve that ‘dashboard view’ without entering everything twice, we looked to <a href="https://developers.google.com/apps-script/">Google Apps Script</a> which allows you to manipulate Sheets (and other Google cloud apps) using javascript and an API.</p><p>After about a day and a half of familiarisation and coding, I was hooked. We ended up automating colour formatting, mirroring changes on both the sprint dashboard and on the project sheet, and creating macros to clean up the dashboard at the end of a sprint. Every time a change was made, a script would run to keep all the data tidy across all views.</p><h4>Download our Google Sheets Feature Book for FREE</h4><p>This feature book, combined with working in sprints, has provided visible benefits to our team. Two-thirds of the way into 2016 we are managing nearly 1000 possible ‘features’ with business-wide visibility of our team’s work and prioritisation. Everyone in the projects team knows the tasks they must complete and the bigger-picture thing they are working towards by doing so.</p><p>As such, I’m hoping I might have inspired you to be MacroMan or MacroWoman in your company, and to embrace Google Sheets as a means of keeping track of your project work.</p><p>Not everybody is a javascript nerd, or has access to developers, so <strong>we’ve put a free version of our feature book up for download</strong>. It includes a description of its functionality and how we use it at Andertons, and I’ve also tried to include a bit of explanation about what the code is doing so you can dive in and modify the spreadsheet to better suit your own needs.</p><p>To keep things clear, I’ve made a separate post for that download:</p><pre><a href="https://medium.com/@andertonsmusic/the-andertons-co-uk-project-sprint-google-drive-spreadsheet-f3b2d3ed4e42"><strong>Get the Andertons.co.uk Feature Book — Free Download</strong></a></pre><h4>Getting on with it</h4><p>So now, it’s definitely time for us to get on with our projects and make our website customer experience better.</p><p>I get more excited about this kind of stuff than most, as you can probably tell, but hopefully you’ll understand my eagerness to share our productivity tools when I say that our adoption and adaption of Scrum has accelerated our projects dramatically. It really is superheroey.</p><p>Oh and, if you were wondering what happened to all those left over post-it notes… Well, our Pro Audio specialist, Ollie bore the brunt of that one. Never take a day off, Ollie. It’s not worth it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5_eQ-Y2nOroD3voMnjaDag.jpeg" /><figcaption><strong>Why does he have so many notebooks?!</strong></figcaption></figure><p><em>Do you have any suggestions for our projects team? Want more from </em><strong><em>Behind the Scenes</em></strong><em> at Andertons? We’d love to hear from you in the comments.</em></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ‘n’ roll musical instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching over half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart is the E-Commerce Projects Manager at Andertons. The irrational fear of post-it notes is called pittakionophobia. <br>Did you know that? Andrew knows that.<br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=97e06a5b138a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Andertons.co.uk Project Sprint Google Drive Spreadsheet]]></title>
            <link>https://medium.com/@andertonsmusic/the-andertons-co-uk-project-sprint-google-drive-spreadsheet-f3b2d3ed4e42?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/f3b2d3ed4e42</guid>
            <category><![CDATA[scrum]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Sun, 07 Aug 2016 19:56:51 GMT</pubDate>
            <atom:updated>2016-11-15T17:57:48.586Z</atom:updated>
            <content:encoded><![CDATA[<p><em>A.K.A. “The Good Ideas Book” / “The Andertons Feature Book”</em></p><p>The Andertons.co.uk digital team developed this turbocharged Google Sheets Spreadsheet application to manage tasks for our Scrum sprints.</p><p>We are sharing it with other Scrum fans because it has made our Scrum process and task visibility more efficient, across a number of projects.</p><p>It kills the need for post it notes; perfect for startups who work in offices without walls (not even fancy glass ones).</p><figure><a href="https://docs.google.com/spreadsheets/d/1jp9DPiaxbeAfMq01L8KeWSccyoDVXgE1tiJZRv4xLvI/edit?usp=sharing"><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*X5tpdDpNkwNDmEHLC9DYzQ.png" /></a><figcaption>Click the image to download the spreadsheet now.</figcaption></figure><p>Got ten minutes? <a href="https://medium.com/@andertonsmusic/adopting-scrum-part-1-macroman-the-google-sheets-superhero-97e06a5b138a">Read more about how we use Scrum, and why we created a Google Sheets application to manage our sprints</a>.</p><h3>Quick Start: Using the spreadsheet</h3><p>If all you want to do is start using the sheet to manage a Scrum sprint, just follow the instructions below…</p><blockquote>Note: You will be asked at some point to “authorise” the application to allow it to make modifications to the spreadsheet. You’ll need to say ‘yes’ for things to work as described. Don’t worry: the script can only modify this particular sheet.</blockquote><ul><li>A: <a href="https://docs.google.com/spreadsheets/d/1jp9DPiaxbeAfMq01L8KeWSccyoDVXgE1tiJZRv4xLvI/edit?usp=sharing">Open our demo Scrum spreadsheet file</a> in Google Drive</li><li>B: Make your own copy by clicking <em>File </em>&gt;<em> Make A Copy<br></em>(You’ll need to be logged in to a Google account)</li></ul><h4>Then…</h4><ol><li>Go to one of the <strong>Project Sheets</strong>. Type a new task into column B.<br>You should see a new task number appear and some of the columns will auto-populate. Well done. You have created a task.</li><li>Fill in other data. Who knows the requirements of the task? Who is responsible for delivery? When should it be done by?</li><li>You’re ready to add the task to your sprint. Change its status to <em>In Progress</em>. Now look at the <strong>Sprint Dashboard. </strong>The task should be there (because: magic).</li><li>Your task is roadblocked (oh no). Let everyone know by changing its status to <em>Roadblocked </em>on the dashboard<em>.</em></li><li>Head back to the project sheet. The task’s status has automatically been updated to <em>Roadblocked </em>here too!</li><li>Jon removed your roadblock. YES JON. Your task is complete. Change its status to <em>Completed</em> and buy Jon lunch.</li><li>Your sprint is over. Head over to the sprint sheet, and click the <em>Clean Dashboard</em> button. Concluded tasks disappear from the dashboard, but remain on the project sheets in case you wish to reinstate them later.</li><li>You can create as many new sheets as you want. They will all be considered “Project Sheets”. You’ll need to keep the column headers the same for all sheets so that task data is copied into the correct columns on the dashboard. Need different headers? Read the <em>Editing The Code </em>section below.</li></ol><p>That’s all you need to know for basic use to run your sprints. If you’re not going to read the next bit. <strong>PLEASE BACK UP YOUR WORK REGULARLY.</strong></p><p>The application is powerful enough to go around deleting stuff you don’t want it to if you try and do anything beyond the basic use steps above.</p><h3>Advanced: Customisation, Code, Nerd Stuff.</h3><h4><strong>Some boring stuff about how it works…</strong></h4><ol><li><strong>There are 3 “types” of sheet:</strong> the dashboard, project sheets, and the data sheet. The <strong>project sheets</strong> are where you can enter new tasks, and the <strong>Sprint Dashboard</strong> is your ‘view’ of tasks that are currently in progress (in your sprint). The <strong>Data</strong> sheet contains some predefined lists for dropdowns etc. and the “next task number” so that every task has a unique number.</li><li><strong>The unique task number is important. </strong>Because the code references it to be able to find the correct row to change on the dashboard when you make a modification on the project sheet (and vice versa).</li><li><strong>Column positions are also important.</strong> Don’t add or remove columns without reading the <em>Editing the Code</em> section below.</li><li><strong>Don’t rename the Dashboard or the Data sheet.</strong> At least not without addressing the references to those names in the Javascript code.</li></ol><h4>Stuff you might want to change</h4><ul><li>Head over to the <strong>Data </strong>sheet. Put your own team’s usernames into the list. The dropdowns in the project sheets will take values from here.</li><li>The Fibonacci scoring hasn’t really been working for us because we use this system to manage tasks that span more than ten projects at once. You could use any ratings you wanted (fish, dog, elephant!) by changing the list in the <strong>Data</strong> sheet.</li><li>The available statuses (and their colour formatting) is also determined by the list on the <strong>Data</strong> sheet. If you want more statuses, you can append the list. Note that most of the statuses are referenced by name in the code (e.g. <em>In Progress</em> is the status that triggers the auto-copy-to-dashboard function) so you may break stuff by changing them. Make sure you’ve read the code before doing so!</li></ul><h4>Stuff we want to improve / add</h4><ul><li><strong>Start Sprint Button</strong> — We want to create a button to search for tasks with a target date that falls between the sprint dates, and automatically pull it into the dashboard.</li><li><strong>Velocity </strong>— We’d like to keep historical records of the sprint “scores” (the ‘judging velocity’ idea in Scrum)</li><li><strong>Friendly names </strong>— I’d like to use friendlier team member names in the dropdowns (but we additionally use <a href="https://zapier.com/">Zapier</a> and rely on those usernames to tie this all up with <a href="https://slack.com/">Slack</a>).</li><li><strong>Overdue — </strong>Create a button that sets tasks with target dates in the past to <em>Overdue</em> status.</li><li><strong>Don’t allow task numbers to be edited by users </strong>— Editing the task number throws the “please don’t edit” alert, then wipes the cell meaning the task no longer has a number. Need to somehow capture original value and revert the cell to that. Don’t think undo is available via API?</li><li><strong>Minify the google apps script code </strong>— At least for our in-production version</li></ul><h4>Editing the code</h4><p>Let’s be realistic — if you’re interested in using this sheet, you’re probably going to want to modify it to suit your needs. To dive in, click “Tools” then “Script Editor”.</p><p>If you know a little Javascript, you’ll be able to customise the sheet, even you aren’t familiar with the <a href="https://developers.google.com/apps-script/reference/spreadsheet/">Google Apps Script API</a>. (But hey, it’s cool. Read it anyway!)</p><p>It’s slightly different to coding JS for the browser as your context is not the window object, but once we got going it wasn’t hard to pick up. Here are some tips:</p><p><strong>onEdit(e)</strong></p><p>You’ll notice that a lot of the work spins off the onEdit() event handler function. It runs every time the user makes a change to the spreadsheet.</p><p>It’s worth noting that <a href="https://developers.google.com/apps-script/guides/triggers/events">onEdit() is a special function</a> and the <strong>e </strong>argument is an event, passed by Google sheets.</p><p>If you end up in a situation where you can’t change a value on the sheet because the script is taking over a cell you want to edit manually, the quickest thing to do is to temporarily <em>return;</em> the onEdit function before it does anything i.e.</p><pre>function onEdit(e) {<br>  return;<br>  ...</pre><pre>}</pre><p><strong>Fixed References (Column Indexes &amp; Spreadsheet names)</strong></p><p>We opted to reference column index numbers (rather than header names), which means that a change in the column order, or number of columns may affect the operation of the sheet.</p><p>For example, check out line 93:</p><pre>// If the user is editing a status on a project task sheet..</pre><pre>else if(e.range.getColumn() === 11 &amp;&amp; isTaskSheet(thisSheetName())) { ... }</pre><p>This is special handling for onEdit if the user is changing a task status. If the task status is no longer in column 11, it won’t work the same! You’ll need to look for references like this if you’re changing the column order at all.</p><p><strong>Debugging</strong></p><p>We left an alert() function in the script as it was useful for quick debugging. It instantiates a new UI window which displays the content in the function argument.</p><pre>alert(&quot;Hello. The column number is: &quot; + e.range.getColumn());</pre><p>It’s worth noting that there are objects that <em>can’t</em> be called in this context; if you aren’t getting the result you’re expecting using alert(), check the logger by selecting <em>View </em>&gt;<em> Logs</em> from the Script Editor window.</p><h3>BYE</h3><p>I really hope you can find value in using this sheet. Feel free to drop me a line on andrewc@andertons.co.uk if you have any questions. I’ll try to help.</p><h3>Update History</h3><p>18th August 2016 — Prevented people from entering their own task numbers. This subsequently prevents people from entering tasks onto the dashboard directly. Also updated alert() function to non-deprecated API (“UI”).</p><p>12th August 2016 — Identified bug that allows tasks to be entered into dashboard</p><p>8th August 2016 — Made sheet public for the first time.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f3b2d3ed4e42" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Search Laboratory: Rock ‘n’ Roll Lab Rats]]></title>
            <link>https://medium.com/@andertonsmusic/search-laboratory-rock-n-roll-lab-rats-ce5f324b760a?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/ce5f324b760a</guid>
            <category><![CDATA[ecommerce]]></category>
            <category><![CDATA[search]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Wed, 13 Jan 2016 18:05:39 GMT</pubDate>
            <atom:updated>2016-01-15T01:47:38.485Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zz09--f_sjylo1chWyqKSQ.jpeg" /><figcaption>No no no no no!</figcaption></figure><p><a href="https://medium.com/@andertonsmusic/your-online-sales-adviser-finding-your-perfect-guitar-in-a-catalogue-of-thousands-81f6b9616912">Last month we wrote about</a> making use of dedicated site search technology by <a href="http://easyask.com/">EasyAsk</a> to improve the experience for our online browsing community. We also manually <em>optimise</em> our site search to ensure it continually returns the best results for you.</p><p>Behemoths of search like Google &amp; Bing are incredibly good at interpreting users’ questions. We figured that all we needed was billions of dollars and a crack team of - say - nine hundred people, and we too could build ourselves an infallible search engine that could basically read peoples’ minds.</p><p>Unfortunately, the combined resources of the web team piggy bank and the sales office swear jar (someone has clearly been neglecting to pay their dues into that swear jar) only amounted to £4.60.</p><p>We needed a humanised process to continually keep our site search performing exceptionally. The <strong>Andertons Search Laboratory</strong> was born.</p><h4>What is Search Lab?</h4><p>How many times have you been on a website where you were left frustrated by the search experience? Maybe you searched for something and received no results, only to stumble upon the thing you were looking for later whilst trawling through the category navigation?</p><p>It might feel something like this:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fcbtf1oyNg-8%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dcbtf1oyNg-8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fcbtf1oyNg-8%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/89cc30d1d2be4894d563a0f9f49f3144/href">https://medium.com/media/89cc30d1d2be4894d563a0f9f49f3144/href</a></iframe><p>We devised Search Lab to avoid being ‘one of those’ sites.</p><p>Every Tuesday members of the Andertons e-commerce technical &amp; content teams get together in what you might as well imagine as a long, white, strip-lit room with test tubes, gerbils and an arsenal of fire extinguishers in all colours of the rainbow. Because, safety first.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*z1j_tngCMJfv5J202mSYxA.jpeg" /></figure><p>O.K. well, it’s not entirely like that... For historical reasons that I can only speculate about, I wasn’t allowed to buy an office rodent, and we don’t conduct our sessions in lab coats (although I must admit I’m seriously <a href="http://www.ebay.co.uk/itm/Lab-Laboratory-Warehouse-Doctor-Work-Wear-Coat-Medical-Technician-Food-Hygiene-/261988127473?var=&amp;hash=item3cffb592f1:m:mX5Kth9J7Eu8WVGd0dRS8_A">considering it</a>).</p><p><strong>Search lab </strong><em>is</em> however<em> </em>where we act as <em>data</em> scientists and observe lab rats *cough* I mean… <em>real user </em>activity to help us improve our search engine for the masses.</p><h4>Searches with no results</h4><p>The most obvious optimisation is to look at is the search phrases that return zero results, and see whether we can fix them!</p><p>Our search engine, <em>EasyAsk</em>, provides us with a suite of analytics that lets us know words which real people searched for that provided zero results. Either we don’t sell the item/s, or we’ve ballsed something up and users are searching for something we <em>do</em> have, but not seeing it come up!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XGRDePaaE3ascrdW6vSo1A.jpeg" /></figure><p>Two years ago, we were seeing two phrases being searched-for again and again. They were for two brands we did not sell at the time: “<em>Schecter”</em> &amp; “<em>Peavey</em>”.</p><p>Armed with our search terms report, and knowing anecdotally that customers had often requested Schecter &amp; Peavey in store and via email, we regularly fed back to management about the noise. In 2014 the powers that be struck up a deal to start stocking some <a href="http://www.andertons.co.uk/brands/bid15328/schecter.asp">Schecter</a> &amp; <a href="http://www.andertons.co.uk/brands/bid15372/peavey.asp">Peavey</a> gear in store and online.</p><h4>Popular Searches</h4><p>Sort of the opposite of no-results searches, there are search phrases that come up as sure as the sun. We like to make sure that the results for these searches are as useful and efficient as they can be for users.</p><p>Our most popular search terms are broad. Brand terms like <em>‘Fender’ </em>or ‘<em>Gibson</em>’ and popular models like ‘<em>Telecaster</em>’ or ‘<em>SG</em>’ are always top of the reports. I think there are two issues worth solving here:</p><ol><li><strong>We have a lot of products for these terms; how should we order the results? </strong>When all else is equal (a telecaster is a telecaster is a telecaster), we generally show you results that we think are the ‘best deals’ at the top. If we’ve got a great price on something due to a bulk buy, or we’re offering 18 months 0% finance on an item — that tends to float to the top.</li><li><strong>Lots of users are typing these terms so it may be helpful if we put some of them into the navigation menu.</strong> The only trouble is working out which phrases deserve a spot! Typically we’ll try a few, conduct tests, and look at other data to prioritise.</li></ol><h4>Relaxing results</h4><p>In the video above, the user changing his search from “semi-skimmed milk” to “milk” is an example of <strong>relaxing</strong><em> </em>search terms in order to provide at least <em>some</em> results, if the initial search returns nothing.</p><p>As the video demonstrates this can be almost as frustrating an experience as providing no results at all. To help, we also investigate searches that only returned results <em>after</em> one or more terms were removed.</p><p>The added bonus for our lab technicians is that these are normally the hardest imperfections to fix!</p><p>We currently don’t list the <em>Mapex Black Panther Nomad</em> snare drum for sale. If a user asks for “<em>Mapex Nomad</em>” (a steady trickle of people do), a drum specialist would know that that person was trying to buy a snare drum. Computers aren’t this clever.</p><p>By default, what the search engine would choose to show you is <strong>all</strong> the results for “Mapex” which ranges from hardware to full drum kits! To add insult to injury, the message we use to tell you that we didn’t understand you makes nearly-no sense…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/989/1*apkbw4dM5-JjklXP9NQsOA.png" /><figcaption>Please, take a seat whilst we find that for you…</figcaption></figure><p>We do sell other snare drums from the <em>Black Panther </em>series, as well as specialist drums by other manufacturers. If you’re lucky you might happen upon a great alternative later, but the journey would have royally sucked.</p><p>To make any attempt at solving this, we need to help EasyAsk understand the context surrounding search terms (e.g. that “Mapex Nomad” could fall back to “Snare Drums”). There’s a high likelihood that EasyAsk will have no notion of the context of our industry-specific terms, so we’ll need to ‘teach’ EasyAsk about the term. This is slow work and a problem that I don’t think we’ve cracked yet… We’re working on it.</p><h4>Scientists vs. Robots</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/703/1*0lznHz05M5n1TsJE-364eg.jpeg" /><figcaption>Gahhh. It’s a dangerous web out there</figcaption></figure><p>The land of search is rife with evil robots (and not the Phil X amplifier kind). Our reports show a ton of queries that are being made by web crawler software. Well… either that or the person that searched for this is some kind of cyborg.</p><pre>Version:1.0 StartHTML:0000000203 EndHTML:0000002215 StartFragment:0000001974 EndFragment:0000002155 SourceURL: ://wwwgooglecouk/search?clientsafarirlsenqboss   dd-6ieutf-8oeutf-8gfe_rdcreioz9hvse6b47j8wfnnigabw</pre><p>We have to sift through bad data to troubleshoot real user problems. <strong>The good news is that Search Lab is helping us get there.</strong> Simply by knocking heads in the lab, we came up with a great way of cross referencing multiple data points to work out which queries are real human users and which are robots (or nefarious cyborgs).</p><p>I won’t share exactly how we cleanse the data because it’s a bit boring and — we thought — rather clever, so I’m loathe to share! But what it <em>means</em> is that we can clear the smoke and improve search for real users, all the while heroically defeating robot master races with our science.</p><h4>Experiments coming out of Search Lab</h4><p>Finally: looking at search data sometimes turns up a behavioural aspect of users that we hadn’t thought about before. <strong>We devise experiments to test new features that complement the behaviour we observed in search lab.</strong></p><p>We noticed that returning users that had visited Andertons.co.uk recently were more likely to use the search on their second (and subsequent) visits.</p><p>A little more data-digging reveals this:</p><blockquote>A lot of people use site search to quickly get back to a product they have viewed before.</blockquote><p>Whilst not exactly a mind-blowing revelation, we had hard data to prove this behaviour; we also had an idea that could help these users.</p><p><strong>Sticky Search Term<br></strong>We wrote a little code that allowed the user’s browser to ‘remember’ the last phrase that the person searched for; when they come back to the site we automatically populate the search box with their last query.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1005/1*K5cxrabMWGKGzuLDGqM30A.png" /><figcaption>Welcome back, fire extinguisher enthusiast.</figcaption></figure><p>We felt this made sense for Andertons. With a high-value purchase like an instrument, people take their time and continually view the same product a number of times before they decide whether or not to purchase.</p><p>Our change meant that the product was two clicks away, and users would not need to re-input the search term with their keyboard — particularly useful on mobile devices.</p><p>To test the efficacy of the sticky search term, we tracked the usage of the feature by recording whether or not the user modified the search term that we placed in the box before they hit ‘go’. We also made a note of the type of page a user was on when they searched. Here are the results:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qWbf1cpvQV3H3N4if-B_Tg.jpeg" /></figure><p>As you can see, the sticky search feature was used by close-to one third of the people searching from the homepage, but by a smaller proportion of people on other types of page. Again, this makes sense as you’re more likely to use the homepage as a starting point when your intention is to return to a previously-viewed product.</p><p>We had helped 30% of people searching from our homepage get to where they wanted to go more quickly, but added inconvenience to the other two thirds (and 75% of searchers across the site as a whole) because to perform their searches, rather than just tapping the search box and beginning to type they now had to erase the old (sticky) search term too.</p><p>But that’s cool. As a result of the experiment we intend to keep the feature but modify it as follows:</p><ul><li><strong>Only recall the sticky search term on the site homepage. </strong>Even on the product page where users may use the feature to go “back” to the search results, we felt the usage was low and that the back button was intuitive enough.</li><li><strong>Highlight the whole search term as soon as the user taps the search box.</strong> This ensures that the 70% of users that do not want to re-use the search term on the homepage can simply start typing their query as they would have done if the box was empty.</li></ul><p>Honestly — we’re only making you our guinea pigs to make you happier in the end!</p><p><strong>Search lab </strong>is still a relatively new concept for our team. We have always paid attention to what our users are searching for, but never have we been so empirical and iterative about improving our site search experience.</p><p>By way of regular reporting, analysis using EasyAsk’s tools, and action by the content &amp; tech teams, we hope to make the Andertons site search stand out. It should be effortless and enjoyable to discover music gear at Andertons.</p><p><em>Are you having a frustrating experience with the Andertons search engine? Tell us how you think we could improve the search in the comments and we’ll discuss it in our next Search Lab!</em></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ’n’ roll music instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching nearly half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart heads up the E-Commerce technical team at Andertons. He is not even nearly a doctor of anything but does take the threat of the robot master race extremely seriously.<br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ce5f324b760a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Your Online Sales Adviser: Finding your perfect guitar in a catalogue of thousands]]></title>
            <link>https://medium.com/@andertonsmusic/your-online-sales-adviser-finding-your-perfect-guitar-in-a-catalogue-of-thousands-81f6b9616912?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/81f6b9616912</guid>
            <category><![CDATA[search]]></category>
            <category><![CDATA[guitar]]></category>
            <category><![CDATA[ecommerce]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Fri, 11 Dec 2015 21:54:08 GMT</pubDate>
            <atom:updated>2016-01-15T01:39:35.741Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*n1DWMqNfx1iXSsZdvtEWmA.jpeg" /></figure><blockquote>On <a href="http://www.andertons.co.uk/electric-guitars/cid556/electric-guitars.asp">Andertons.co.uk</a>, you can currently choose from <strong>2130</strong> Electric Guitars.</blockquote><p>That’s a lot of strings! But does your perfect guitar have 6, 7, 8 or 9?! What about colour? For a long time, helping our online browsers narrow down the search for their perfect guitar was a challenge.</p><p>In our store, our guitar experts are easily able to guide people to the best instruments, based upon their needs. Online — of course you can drop us an email, or phone for help — but what if you <em>just</em> want to browse the website and find your dream instrument from the comfort of your own home?</p><p>Our users conduct 7000 keyword searches using our website search engine every day, so this is a something worth getting right! We partnered with search specialists, <a href="http://easyask.com/">EasyAsk</a> to tackle some of the more difficult challenges of guiding online browsers to their perfect product.</p><p>Here are a few of the ways EasyAsk’s clever search technology helps Andertons’ users to have a great browsing experience online.</p><h4>Designed for Humans</h4><p>To satisfy customers, <strong>we believe our website ought to behave like one of our in-store salespeople, </strong>interpreting questions and providing verbose, expert answers. Mindful of this, we ensure our content team impart their knowledge and passion into their writing when creating webpages for new products.</p><p>We reckon we spend a little longer than your average <a href="http://gizmodo.com/5710235/the-best-most-disgruntled-toner-cartridge-description-youll-ever-read">printer ink copywriter</a> (teehee) creating product content. In fact, it takes a member of our team <strong>30 minutes</strong> to list an item on our website. This is actually 4 minutes <em>longer</em> than it was eighteen months ago, but we don’t consider that to be a bad thing.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4R6yYHnZF2P8szrC2lF3OA.jpeg" /><figcaption>A slide from 2014 designed to make these stats seem exciting to senior management.</figcaption></figure><p>To connect customers’ questions with our rather excellent, answer-providing content, we need a search engine. That’s the complicated, ugly robot thing that stands in the middle of what should be a very human interaction! In our case, its name is <strong>EasyAsk</strong>. Luckily for us, what EasyAsk lacks in personality, it makes up for in SUPER AMAZING ALGORITHMS.</p><p>EasyAsk is a language-driven engine; it <em>understands</em> what our users type. That’s more than just matching keywords with data strings; it contains a dictionary which holds word and phrase definitions so that it can <em>interpret</em> queries containing keywords, natural language <em>and</em> industry specific terms (which are rife in the musical world as I’m sure you can fathom!)</p><p>If you type:</p><pre>white fender telecasters between £400 and £600</pre><p>You get these items as a result (which I think isn’t bad!):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/770/1*E16_NWXldh9R2z67QrStuw.png" /></figure><p>EasyAsk hasn’t treated the price element of the query as keywords like a simple algorithm might, but rather as a budget that the user has specified.</p><p>There are also music industry-specific customisations to the dictionary. For nerds like me who are into guitars like the <a href="http://www.andertons.co.uk/solid-body-electric-guitars/pid40304/cid671/ibanez-sa1060wzcntf-premium-series-electric-guitar.asp">Ibanez SA1060WZC-NTF</a>, EasyAsk needs to understand how customers think about model numbers.</p><p>It’s not uncommon for us to see users search for a partial model number in this case. They might type <strong>“SA1060”</strong> if they want to see all Ibanez SA1060 guitars regardless of colour,<strong> </strong>or <strong>“SA1060 NTF”</strong> if they know which finish they want (NTF means “Natural Flat” in this case).</p><p>Some search engines would need a user to type out the whole lot — SA1060WZC-NTF — or it wouldn’t match. We told EasyAsk how our users think about model names, and they responded by exploding our SKU field into many parts so that any relevant partial (or combination thereof) can be matched to the right product.</p><pre>SA1060WZC-NTF <em>matches on </em>SA, 1060, WZC, NTF, SA1060, SA1060WZC, SA1060WZCNTF, 1060WZC, 1060WZCNTF, 1060WZCNTF, WZCNTF</pre><p>And as you can see, this sorts our user out nicely:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/342/1*h1mMk2X8TwN4AtDNSdTw0w.png" /></figure><h4>Colourful Language: Refining results with advanced search filters</h4><p>Have you ever seen that Autotrader advert where the lady is swishing her finger around on an iPad and the cars she’s not interested in start veering off the road? Hold on, I’ll show you the one I mean…</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FS59Uc6KVHC8%3Ffeature%3Doembed&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DS59Uc6KVHC8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FS59Uc6KVHC8%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/eea75f0d0c4c3cd17921c9dde21a5254/href">https://medium.com/media/eea75f0d0c4c3cd17921c9dde21a5254/href</a></iframe><p>Well, frankly that’s <em>awfully </em>dangerous and I would never condone giving users the power to send 2 tonne cars careering in any which direction…</p><p>But fundamentally, Autotrader have the right idea: Put the power to refine product results down to the most relevant items, at the users’ fingertips. We refer to this as <strong>filtering</strong>, and we offer a wide selection of ever-changing filter options that allow our users to sculpt &amp; chisel product results until they see only items that fit their criteria.</p><p>You might think that somewhere in the background we have a ton of checkboxes that we can tick on each product for things like “Colour”, “Number of Strings” or “Size”, and that every time we need a new attribute we add more data [MOOAAR DATA] via a new checkbox or dropdown in our content management system.</p><p>Nope, we’re way too lazy for that.</p><p>We found that asking copywriters to spend half their time box-ticking really takes away from the human element of writing up a product online. As described earlier, the last thing we want is for them to lose their passion.</p><p>What’s more, we simply don’t have a database of “colours” (or anything else) for our 12,000 <em>existing</em> products, so creating one would be... kinda boring.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FIvBXQARTCa84nGBUih6AA.jpeg" /></figure><p>Of course, instrument manufacturers and marketers really don’t care about <em>my</em> problems; they thoughtlessly cast their products with colour names like “Reindeer Blue” meaning “<a href="http://www.andertons.co.uk/solid-body-electric-guitars/pid27929/cid671/esp-ltd-elite-horizon-iii-in-reindeer-blue.asp"><em>It’s actually purple</em></a><em>” </em>and “Blue Metal” when they should have said “<a href="http://www.andertons.co.uk/shell-packs/pid34076/cid639/gretsch-renown-euro4-maple-drum-shell-pack-in-blue-metal.asp"><em>Grey metal… Er oh actually, I guess it’s just </em><strong><em>metal</em></strong></a><strong><em>.</em></strong>”</p><p>So how <em>do</em> we make sure that when you search for “Red Guitar” you get all the guitars in our catalogue that are visibly red, without missing stuff that a user would see as red, but a marketer decided to call “brimstone cherry”?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/207/1*EDLR4DRDbHtOOyBgTYrOPQ.png" /><figcaption>Some of the things in the groovily-named ‘search filtration sidebar’.</figcaption></figure><p><strong>Oh, hi EasyAsk!</strong></p><p>EasyAsk allows us to define <em>advanced searches</em> then link them to a single checkbox in our search results filtration sidebar.</p><p>For the “colour” checkboxes, our team defined sixteen colour keywords as advanced searches.</p><p>It took a couple of afternoons head-scratching, combing through manufacturer price lists &amp; catalogues, and cross-referencing the Dulux colour chart (other paint brands are available), but by the end we felt pretty confident that we had accurately defined colours for the majority of the catalogue.</p><p>Here’s the advanced search that is hidden behind the checkbox for the colour “Red”.</p><pre>(category path contains ‘electric guitars’ or ‘acoustic guitars’ or ‘bass guitars’ or ‘electric guitar amps’ or ‘guitar straps’ or ‘acoustic drums’ or ‘stage pianos’ or ‘home keyboards’ or ‘clearance’) AND (Product Name contains ‘red’ or ‘cherry’ or ‘crimson’ or ‘ruby’ or ‘candy’ or ‘cola’ or ‘wine’ or ‘brimstone’ or ‘merlot’ or ‘blood’ or ‘fireglo’ or ‘fireglow’ or ‘vermillion’ not ‘blue’ or ‘black’ or ‘*burst’ or ‘washed cherry’ or ‘heritage cherry’)</pre><p>You’ll notice some ‘not’ keywords in there meaning anything with that word in its title <em>won’t </em>be shown to the user. If you’re wondering why ‘blue’ is in the not-list for ‘red’, it will be because someone has called their product ‘candy apple blue’ or ‘blood blue’ or something like that. The first part of the definition thinks ‘blood blue’ = ‘red’, then the second part said ♪ no no no ♪.</p><p>Amy Winehouse joke there.</p><p>Oh and just for fun, it gets a bit more complicated when it comes to defining “Natural” as a colour, but it’s still perfectly do-able!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NeMXXACOLHLJBXP_WNUXkg.png" /><figcaption>Basically, when it comes to acoustic guitars, we might not put “in Natural” into the product names, but if it has a colour finish, we <strong>would</strong> say “in Black”. Therefore anything that doesn’t fall into any specific colour definition is almost certainly “natural”.</figcaption></figure><h4>And Finally… Search FAST</h4><p>You might be able to see that a complex search like the one above for “Natural” would take a while to compute.</p><p>It is really important that users get search results <em>fast</em>. We know this from <a href="http://www.nngroup.com/articles/response-times-3-important-limits/">Jakob Nielsen research which is as old as web team member, Ben Greener</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*DzXxejJksWoWnzu6wVCDgA.jpeg" /><figcaption><strong>Hi Ben.</strong> You’re younger than everyone and you never forget to remind us.</figcaption></figure><p>One of the clever things about EasyAsk is that it doesn’t do that complex search for “Natural” on the fly. Instead it builds an index of definitions and computes the search results at build time. At runtime it only has to query the results associated with the single-word pre-definition.</p><p>Or in other words: “Natural” maps to “Product IDs: 123, 234, 345” etc.</p><p>This makes EasyAsk crazy fast. When a user ticks the box for “natural”, his or her web browser sends a request from wherever in the world it is to EasyAsk in America. Typically within less than 50ms, EasyAsk has sent back a list of ID numbers, which the Andertons website turns into product tiles.</p><p>Any slowdown here is almost always the network conditions, or the Andertons server’s ability process the data. If it were a relay race, EasyAsk would be Usain Bolt, and Andertons would be, well… me... I’m a terrible sprinter.</p><h3>Coming up next month: Search Laboratory!</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/320/1*AyJ6pJOx1XHYzPzkQlSDGg.jpeg" /></figure><p>So that concludes a brief look at the <em>technology</em> behind finding the perfect guitar on Andertons’ website! However when it comes to search there is much more that we are doing behind the scenes to optimise your experience.</p><blockquote>On our site, someone clicks a filter to narrow down their search once <strong>every 3.5 seconds</strong></blockquote><p>…and, on average, users click <em>ten</em> subsequent refinement criteria when they are looking at a search results or category page. Users really want to get to that perfect product, fast — so we need to make sure we give them all the help we can.</p><p>How do we make sure we’re helping you and not hindering you as you narrow down your search? I’ll tell you next time!</p><pre>Read part 2 now here: <a href="https://medium.com/@andertonsmusic/search-laboratory-rock-n-roll-lab-rats-ce5f324b760a">Search Laboratory, Rock ‘n’ Roll Lab Rats</a></pre><p><em>Do you have any suggestions to improve our search engine? Want more from </em><strong><em>Behind the Scenes</em></strong><em> at Andertons? We’d love to hear from you in the comments.</em></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ’n’ roll music instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching nearly half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart heads up the E-Commerce technical team at Andertons. He expertly avoids any and all box-ticking activities at work, and has frequently been compared to Harry Potter, both for his &#39;dark-hair-and-glasses&#39; aesthetic, and his safety research work in the field of &quot;<em>magic finger-swiping to send physical objects flying everywhere&quot;</em>. <br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=81f6b9616912" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Behind the scenes: How we replaced 12,000 rubbish product photos.]]></title>
            <link>https://medium.com/@andertonsmusic/behind-the-scenes-how-we-replaced-12-000-rubbish-product-photos-866c1ee7cdb2?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/866c1ee7cdb2</guid>
            <category><![CDATA[guitar]]></category>
            <category><![CDATA[ecommerce]]></category>
            <category><![CDATA[image]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Fri, 06 Nov 2015 11:46:09 GMT</pubDate>
            <atom:updated>2015-11-06T11:46:09.857Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IZHlsDaGQApd46Abn4pJPw.jpeg" /></figure><p>Product images are important to our customers. <em>Really</em> important. The vast majority of people visit our website to browse, ogle, and generally render their computers, tablets &amp; phones inoperable as distracted eyes gaze at pretty instruments and dribble seeps in-between keyboard keys and into headphone sockets.</p><p>Well… we don’t have any data on how much damage the Andertons website has caused to your electronics (but sorry anyway), but we do know that whenever someone visits one of our products online, almost without exception, <strong>the first thing they do is interact with the images.</strong></p><p>As recently as 2013, our website ONLY showed product images up to a resolution of 500 x 500px. That’s already ‘too small’ in a world where the screen of an Apple iPhone 4 (2010) displays 640 pixels across its short edge.</p><p>To bring our products to life online, we had to up our image game...</p><h4>Our Challenges</h4><ol><li><strong>No matter how large the source image, the largest picture we rendered &amp; saved for a product was 500px x 500px</strong></li><li><strong>Portrait or landscape, all source images were rendered into squares<br></strong>(This creates unnecessary white space)</li><li><strong>With 12,000 products listed for sale, we had a lot of work to do…</strong></li></ol><p>Hmmm. We’d better hop to it!</p><h4>1. Size Does Matter</h4><p>… and with only 500px to play with, we were beginning to develop an inferiority complex. Here’s a keyboard.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/1*VM2qdyabKmQ7QLXs32wQMQ.jpeg" /><figcaption><strong>A 500 x 500px image. </strong>“So, I was wondering, does this one play <em>‘She’ll Be Coming Round the Mountain’</em>?”</figcaption></figure><p>You can clearly see that:</p><ul><li>500 pixels is not enough to show any useful detail.</li><li>You only really get 460 pixels of usable width (to allow for padding).</li><li>No one has any idea whether the keyboard will play <em>She’ll Be Coming Round the Mountain</em> (and — serious point — pictures really are worth a thousand words; customers can often find all the information they need by looking at a good picture).</li></ul><p>In addition to this (somewhat stupidly), when putting pictures into our old system, there was no concept of keeping the full resolution source file. Images were crunched to 500px and 65% JPEG quality, then discarded.</p><p><strong>The fix is easy of course. </strong>We set a new maximum size of 3000px (how long before this is no longer enough?!) and KEPT the original file no matter how big it was. It’s almost like we were thinking about the future or something!</p><h4>2. No Room For Squares</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/200/1*U1ZcD9sti-BoqOuKAX0R_Q.jpeg" /><figcaption>It’s a crying <em>square</em> sponge. This is relevant, I promise.</figcaption></figure><p>As someone who has had a hand in designing layouts, I must confess that I love a good square! There are no complications in making square product picture work <em>O.K.</em> in any website context. At that point one can concentrate on something more nerdy like coming up with a <a href="https://blog.andertons.co.uk/thereisnothinghere">smart-alec 404 page</a>.</p><p>But what about the audience? Well their experience ends up being sub-par. The added white space to match the shorter dimension to the longer dimension becomes an obstacle to using the full dimensions of the screen.</p><p>Objects normally shown in landscape like keyboards and drum kits are a good example here. You can see below how much more detail the user can experience if the unnecessary white space is eradicated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*d91K_LlRdUwWDJgJF4invw.jpeg" /><figcaption><strong>I’ve overlaid the yellow lines to show the edges of the source pictures.</strong></figcaption></figure><p><strong>Today: we produce a number of “original aspect ratio” versions of the source image at different sizes.</strong> Squares can be pretty awesome in the right context of course, so we still keep a few of those kicking around too!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/342/1*1QFh5Mv6G2EwbQEYqwk2yg.jpeg" /><figcaption>Yes. Hooray.</figcaption></figure><h4>3. Lo-res, High Volume</h4><p>Perhaps the most sizeable problem was that there were 12,000 products but just 3 (bemused) web blokes, none of whom really liked the idea of spending the remainder of their lives airbrushing Thomann watermarks out of drum head pictures (and sorry Thomann, but yeah, we may have ‘borrowed’ one or two of your photographs).</p><p>Having discarded every single source image, our <em>best </em>case scenario was that a product had three 500 x 500 pixel square images; that was our starting point. The reality was often worse. The system would <em>upscale</em> any source picture that was less than 500px, so when the only photo that exists of that plectrum holder, or that rubber grommet, weighs in at a healthy 50px per side… Well you get a pretty meaningless result. For example:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/350/1*Ee_upVv-SPgW6ZfWFZ5KNA.jpeg" /><figcaption>Terrible pictures: not that uncommon.</figcaption></figure><p>I used to get phone calls from one of the partners at Andertons bemoaning yet another embarrassing situation where a customer was asking him something inane. It would be something truly bonkers like:</p><blockquote>“Could you please confirm, is this actually a<strong> <em>playable</em></strong><em> </em>guitar or just a model?”</blockquote><p>We’d muse, <em>“how on earth can he not see from the website that — of course it’s a proper guitar!?”, </em>then log on to see <em>yet another</em> indistinct blob that might as well have been a T-Rex, or a football, or a priceless Picasso, or whatever.</p><p>I hated those phone calls…</p><p><strong>The fix? Brute force, plus a little programming.</strong></p><p>We divided to conquer, prioritising more-popular products with each member of the team sourcing images for around 75 products a week.</p><p>In tandem, we enlisted our suppliers’ help. Many images are hosted on FTP sites and dedicated image banks so with a little pointer in the right direction, finding images for key products is generally not too hard.</p><p>Some manufacturers are <em>really</em> organised. <strong>Fender</strong> for example have an image bank where you can access the largest possible image of any product, just by passing its SKU into a dynamic URL. We have all Fender SKUs in our system, so it was a piece of pie to write a bit of code to loop through all the SKUs and download the hi-res images. This knocks 700 of the products out of the park in a few hours.</p><p>After running the program I watched the slideshow of the gorgeous, hi-res guitar &amp; bass pictures I’d just downloaded. I felt the same excitement I hope our customers feel when enjoying great images. Fender heaven!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VlPYXp0UDuxbipGUaPxU1g.jpeg" /><figcaption>Best day of my life…</figcaption></figure><h4>Andertons Images in 2015</h4><p>We take this pretty seriously now. For a start, at any given time we can objectively measure and report on the following things:</p><ul><li>How many images each of our products has.</li><li>The dimensions and orientation of all the images.</li><li>The proportion of our catalogue that has no product image at all.</li></ul><p>It would be amiss at this point not to mention the web content team and in particular Andy Scrimshaw, who over the last 12 months has chipped away at this project, putting countless hours into sourcing more and better imagery; driving <em>up </em>resolution and number-of-pictures, and driving down negative metrics like single-image products.</p><p>It is our aim to have NO products with fewer than two pictures at a minimum of 1000px resolution. Here’s how that’s going so far:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nh-YGRP8CFW-xnAnr7kH5A.png" /></figure><p><strong>We also now employ a full-time photographer</strong> to take photographs of our high end instruments so customers can see exactly the item that they could purchase, as opposed to a stock photo, which in the case of guitars can often be aesthetically very different. [We’ll write more about this in future posts.]</p><p>On the website, <strong>we have improved the product gallery</strong>, making use of full-screen capabilities in newer browsers so that no screen space is wasted. On a large retina screen, with a hi-res image of a beautiful instrument, this has a real <em>‘wow’</em> factor. You should check it out! <em>(I like to drop into the Apple store once in a while and call up a PRS Guitar page on a big iMac!)</em></p><h4>…And in the future?</h4><p>We realise that we’re not hosed yet when it comes to imagery — so what’s up next?</p><p>Well we know <strong>we now have to cater for a wide range of different screens responsively</strong>. Understanding compression, resolution and DPI will help us to speedily deliver appropriately-sized image files to users, based upon their device and connection parameters.</p><p><strong>We also hope to tackle orientation.</strong> If you are holding a smartphone in portrait, it makes a lot of sense to show an image of a guitar, or a microphone stand, with its longest edge matching the longest edge of the screen; but what about a keyboard or a drum kit? This is something we haven’t quite solved yet.</p><p>Whilst we keep working, please do go and check out the product images on our website. Let us know which ones are still rubbish, or settle down with a cup of tea and the instrument of your dreams, imagining that it is right there in front of you!</p><p><em>Do you have any suggestions for our website? Want more from </em><strong><em>Behind the Scenes</em></strong><em> at Andertons? We’d love to hear from you in the comments.</em></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ‘n’ roll music instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching nearly half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart heads up the E-Commerce technical team at Andertons. He loves a good JPEG compression algorithm and still wakes up every day thankful that his Fender image crawler program was not interpreted as a DDoS attack.<br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=866c1ee7cdb2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Behind the scenes: What we learned about mobile sites in 2011]]></title>
            <link>https://medium.com/@andertonsmusic/what-andertons-music-learned-about-mobile-commerce-in-2011-b15020803833?source=rss-1a6f7fafd253------2</link>
            <guid isPermaLink="false">https://medium.com/p/b15020803833</guid>
            <category><![CDATA[web-design]]></category>
            <category><![CDATA[ecommerce]]></category>
            <category><![CDATA[mobile]]></category>
            <dc:creator><![CDATA[Andertons Music]]></dc:creator>
            <pubDate>Thu, 15 Oct 2015 08:03:27 GMT</pubDate>
            <atom:updated>2015-10-19T22:56:22.698Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZEb7EjFwPUutZ3F0vyb9UA.jpeg" /><figcaption>Yeah, it really is that small!</figcaption></figure><h3>What Andertons Music Learned About Mobile Commerce… in 2011</h3><blockquote>“We know, we know!”</blockquote><p>When our customers lament the fact that we don’t have a mobile-friendly website, everyone in the <a href="http://www.andertons.co.uk/">Andertons</a> web team scrunches up their face a little. We know that our customers interact with us on their mobiles, and we know that the experience is poor, at best.</p><p>What many people don’t realise is that way back in 2011, Andertons <em>did </em>in fact have a mobile commerce site. We saw the mobile revolution taking shape, but we got it massively wrong and were swept behind the curve.</p><p>I’d like to tell you what we learned about mobile four years ago, why we switched our old mobile site off, and what we are doing in 2015 to meet our mobile customers’ needs.</p><p><strong>Three things we learned from our old mobile website:</strong></p><h4>1. Good architecture matters.</h4><p>What we didn’t want to do was write a new mobile commerce engine. The site had to work with our existing code. We just focussed on designing what the user<em> saw</em>, but in a back-office sense, we had ‘designed for desktop’.</p><p>We had category structures 4 levels deep. Images that were too big, or lazily compressed, a complex and involved checkout process with way too many features…</p><p>In addition, we had to manage two different template sets with two very different requirements. Often, we simply <em>forgot</em> to make the changes in both places. It was a nightmare.</p><h4>2. Our intent was selfish.</h4><p>It’s really easy to become engrossed in your conversion metrics; transactions and revenue. We never gave enough consideration to the vast number of people who come to our mobile site simply to <em>browse</em>.</p><p>Being part of a passion industry, we see a lot of window shoppers. This is great, but in 2011 we failed to cater for the dreamers. Our <em>future</em> customers.</p><p>We made sure it was possible to <em>buy</em> in any which way we could think of. <strong>All</strong> of the incentives and transactional options on the desktop site were available on the m-dot site too.</p><p>We were punished when we realised that all <em>most </em>people wanted to do when they were looking at Andertons.co.uk on their phones was drool over the stuff they wanted to buy… <em>later</em>, when they got home!</p><p>The product page was ‘skeleton’ and rough around the edges, the interaction experience with product imagery was poor, and we forsook product copy and vital value proposition content, hiding it all below the rather over-emphasised BUY NOW button.</p><p>As a result, people bounced like beach balls, spent less time on pages, and gave up on sessions mid-mission. I think we can presume that these people left disappointed.</p><p>But at least if someone came and wanted to buy something on their mobile, there and then, we had made it super easy for them... Right?</p><h4>3. Brand is everything.</h4><p>Whilst 3G was the standard in 2011, it wouldn’t be unusual to find people who were still getting juice out of their GPRS feature phones. Plus, data was expensive. As such, the central element of <em>the mobile site</em> became its speed of delivery over the network.</p><p>Because of our tunnel vision for delivering <em>fast, </em>we made another mistake — undoubtedly our biggest. We inadvertently tested our customers’ <em>trust…</em></p><p>I’m not so young that I don’t remember the days when, if one required a gradient on their website, one would carefully create a one-or-two pixel wide GIF, and marvel at the power of the &lt;table&gt; background attribute in HTML as it perfectly turned your almost-invisible sliver of colour into a beautiful canvas for your website.</p><p>Our 2011 website design was (and still is) <strong>skeuomorphic</strong>, which means it uses effects like shadows and gradients to mimic the realism of light, falling upon the page.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5t9V3pGVCXP1kOyUxmU0PQ.png" /><figcaption><strong>Not-flat design.</strong> Our 2011 website.</figcaption></figure><p>BUT… These were days when IE8 — bless its soul — was our users’ most popular browser, CSS3 seemed like a pipe dream, and I definitely had no idea what ‘skeuomorphic’ meant. Putting all of those effects onto our mobile site would have required lots of <em>images</em>, and images are big. It would have been suicide (for our <em>speed</em> goals).</p><p>So, instead, we took a small selection of the more-obvious design concepts — the font, the strokes, the general colourfulness — and haphazardly applied them to our mobile templates.</p><p>In hindsight it was a bit like trying to create the finesse of a Lego Starship Enterprise using Duplo. Your own mother wouldn’t appreciate your efforts.</p><p>As you can see, the site didn’t look unlike you might expect… if we were selling children’s toys!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*3yIoRhhKQgYFCGSOEiob8A.jpeg" /><figcaption><strong>Tomy V1.0. </strong>These are Photoshop proofs — the site didn’t really render this neatly!</figcaption></figure><p>18 months after launching the old mobile site, we found ourselves frustrated with content management and at seeing no improvement in engagement or sales. Even the load speed wasn’t that impressive. We wondered what would happen if we simply switched it off?</p><p>So we did. Mobile users got our regular site again; or rather they got a squinty, zoomed-out assimilation of the regular site…</p><p>And for all its usability woes, something astonishing happened when we gave our mobile users back the site that they were familiar with:</p><blockquote>After we switched our old mobile site off, revenue from mobile devices went UP — by 1600%.</blockquote><p>It sounds like a reporting error doesn’t it? Trust me, I checked all the code. It was fine. The change was astronomical and instant.</p><p>We had made an assumption: that people just weren’t interested in buying high value goods on mobile. But what we had actually done, by being massive nerds and putting technology before our users, was destroy the credibility of our own brand, <em>on our own website</em>. The two sites looked nothing alike, and people put their credit cards away.</p><p>Trust, brand, credibility, authenticity. If you ever wondered if you were overvaluing these intangible things…</p><p><strong>What we are doing in 2015 for mobile users:</strong></p><p>When I tell this story, people quite often ask: “why has it taken you so long to try again?” It’s a fair question; technology people are meant to be good at failing fast. The answer is that there are no excuses, and we’re somewhat embarrassed!</p><p>That said, a lot goes on behind the scenes with tech at Andertons that ultimately supports the experience our customers get when they engage with us. We’d be doing our customers a disservice if we did not continually strive to improve<em>, </em>and with limited resources sometimes that means putting some of the ugly operational software first!</p><p>The good news is that 2015 is the year of <strong>Project Zen</strong>, which is our (less-meaningful-than-it-sounds) codename for our new responsive site project.</p><ul><li>We’re focussed on <strong>delivering Andertons’ core value proposition on mobile for browsers <em>and </em>buyers</strong>, using fast tech &amp; modern code.</li><li>We’ll be using some clever architecture that allows us to knit together <strong>a site which is shown optimally on mobiles, tablets, and traditional point-and-click PCs alike</strong>, but still manage content effectively.</li><li>Just because we live in a mobile world, doesn’t mean that we’re going to reduce our mobile experience to lustful text copy! <strong>We want to make the products we sell shine, on any device.</strong> So one day soon, you’ll be able to enjoy browsing the gear you love on Andertons on your phone even more!</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/968/1*5XOGTPDZFvePm15FxW__yQ.jpeg" /><figcaption><strong>The Andertons Zen Desk. </strong>A great deal of care has gone into the design process.</figcaption></figure><p>We’ve spent the last few months designing and building prototypes of the new site, and whilst there are some hurdles to clear getting the new architecture in place, we’re more confident than ever that we will launch our new mobile site much more informed than we were in 2011.</p><p>Moreover, we are much better equipped now to <em>continually</em> improve the Andertons experience, for all folk, regardless of which device they choose to use when they say “hi” to us.</p><p>We hope you’ll join us to experience the new Andertons.co.uk very soon.</p><p><em>Do you have any suggestions for our upcoming mobile site? Want more from </em><strong><em>Behind the Scenes</em></strong><em> at Andertons? We’d love to hear from you in the comments.</em></p><p><a href="http://www.andertons.co.uk/"><strong>Andertons Music Co.</strong></a><strong> </strong>Is a UK based, rock ‘n’ roll music instrument retailer which has served the community for over 50 years. The brand is known by musicians worldwide, with videos by <em>Chappers &amp; The Captain </em>reaching nearly half a million YouTube subscribers.</p><pre><strong>About the Author</strong></pre><pre>Andrew Chart heads up the E-Commerce technical team at Andertons. He has been turning the website off-and-on-again for the last six years and knows a thing or two about the &lt;table&gt; background attribute. <br> <br><a href="http://twitter.com/@andrewchart">@AndrewChart</a></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b15020803833" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>