Ok, this is one that had been bugging me for a while and I’ve finally got around to spending some time to figure out how to do this. Quite boringly, this is actually for creating a WordCloud from Google Analytics data, but hey. It has nice visuals and is a great way of visualising data. Firstly, hats off to people like Jason Davies for creating awesome tools like this for people to use. What a lot of the better WordCloud tools available online allow you to do is to create WordClouds with phrases, not simply just single words. Single word WordClouds can be handy, but they can often lose the context. So personally I was looking for something that could keep things grouped by phrases. Specifically I was looking to turn Google Analytics data, which is in the format of Data | Number of Times, into a WordCloud. On smaller data sets, this is relatively straight forward as you can simply manipulate the data in Excel and copy and paste data a number of times to get the required result. When data sets get large though, this solution soon becomes difficult. And here comes more Excel magic that allows you to manipulate Excel data into the format you need, in this case….
Data from;
Name | Number of Times (i.e. Web Developer Job in Manchester | 50
Data into;
Web Developer Job in Manchester
Web Developer Job in Manchester
Web Developer Job in Manchester
Etc.
And the beauty of Excel, this is possible with a carefully crafted formula! Whoop!
The simple answer for how to do this is, with A1 being the ‘Name’ in the example above and B1 being the ‘Number of Times’ in the example above;
=REPT(CONCATENATE(A1, CHAR(10)), B1)
Then to break this down a little for those who aren’t too familiar with Excel, here’s what all this means;
REPT: This function quite simply is for repetition whereby the function is, REPT(text, number_times).
Text Required. The text you want to repeat.
Number_times Required. A positive number specifying the number of times to repeat text.
CONCATENATE: This is simply joining two or more things together, i.e. CONCATENATE(“This”, “With”, “This”), which would result in, This With This
CHAR(10): This is the formula for inserting a specific character into a formula, in this case a New Line Break character
And that is it. This magical formula formats all of the data into what is required. When you are viewing this data in Excel, it won’t add the data into a new Cell, so simply copy and paste the whole data into another text document and you’ll see the data on new lines as you expect.
You may remember the last product we launched, Tendo Jobs (https://www.tendojobs.com), the recruitment search engine that links employers directly with job hunters which is democratising recruitment. Since launching just over 12 months ago the platform has seen phenomenal growth with over 10,000 people having used the website during that time and attracting many well-known brands including the likes of the global taxi-booking platform Uber. This continues to grow month on month which is excellent to see. If you are recruiting and haven’t used the platform yet, we urge you to do so, it’s free and can be used as an additional tool for recruit candidates directly without the use of traditional and expensive recruitment methods.
Well, you’ll be glad to know that we’ve been busy working away in the background and are delighted to announce our latest product, GeezerCloud. This is a product that we’ve designed from the ground up to the cloud down, quite literally. Having been a chef myself for over 7 years in my early career, I can personally attest the laborious process involved with manually filling out printed sheets of paper while checking temperature records for fridges and freezers. Regularly checking temperatures is a critical part of food safety and is a legal requirement as part of HACCP within the catering trade, yet it needn’t be so time consuming and take a skilled member of staff away from preparing great food. That’s one of the reasons why we created GeezerCloud, to allow chefs to focus on what they do best, cooking awesome food and pleasing customers.
GeezerCloud is a hardware device coupled with a cloud based platform that is designed to automate the HACCP food safety legislation requirements for restaurants, those within the catering trade and further afield. GeezerCloud has been designed for commercial businesses that require regular temperature checks. Instead of manually filling out temperature checks on printed sheets of paper, GeezerCloud has been designed to fully automate this process for you, saving you significant amounts of time and money to focus on more productive activities.
To avoid having to repeat ourselves within this blog post, have a good read through the finer detail about GeezerCloud along with our special introductory offer which is valid over the next 4 weeks.
Well, this is a bit of great news for Contrado Digital. We’ve passed Google’s brand new Mobile Sites Certification and we believe we are the first in Lancashire to do so! This certification highlights that the mobile websites we develop are done to an extremely high standard to ensure your customers are happy customers when they visit your website. While what the non-technical users may just see as a “pretty website”, actually there is an awful lot going on behind the scenes, technologies, systems, processes, best practices and more that we know about so you don’t have to. We always say that any monkey can build a mobile website. Very few can build a mobile website that is designed to perform for your business. Whenever you are investing in a mobile website or a responsive website, make sure you are working with the right digital partner who knows what they are doing.
Want to chat about optimising your website for mobile devices? Then fill out your details on our contact form and let’s talk through the various options available to you within your budget.
The Mobile Sites Certification exam is designed to test your knowledge of advanced mobile website concepts, including the following:
Value proposition of mobile websites
How to improve mobile website speed
How to create an effective user experience for mobile websites
Advanced web technologies
Module 1: Mobile sites and why they matter
1.1. Basics of mobile sites
1.2.1 User expectations
1.2.2 Impact on conversions and interaction
1.2.3 Why UX matters
Discoverability
Module 2: Improving mobile site speed
2.1.1 Tools to get started
2.1.2 Understanding low bandwidth and high latency
2.1.3 Targets to focus on
2.2 Critical rendering path
2.2.1 Constructing the document object model
2.2.2 The render tree
2.2.3 The layout
2.2.4 Analysing the entire CRP in dev tools
2.2.5 Optimising the critical rendering path
2.3 Optimise content efficiency
2.3.1 Eliminating unnecessary downloads
2.3.2 Optimising encoding and transfer size
2.3.3 Image optimisation
2.3.4 Webfont optimisation
2.3.5 HTTP Caching
Module 3: Creating an effective mobile UX
3.1 UX principles
3.1.1 Assess your mobile site
3.1.2 Learn what makes a good mobile site
3.2 Mobile site design best practices
3.2.1 Homepage and site navigation
3.2.2 Site search
3.2.3 Commerce and conversions
3.2.4 Form entry
3.2.5 Usability and form factor
3.3 Testing and measuring success
3.3.1 A/B testing
3.3.2 Measuring success with Google Analytics and metrics to focus on
Gone is the era when families gathered around the television set and watched soap operas and news with undivided attention. We are now in the era of multiple screens, where we are getting content rich but attention poor. Multiple screens as well as tailored content for every individual in the family compete for the consumer’s attention, and Mobile is emerging as the clear winner in this tussle.
In India, young adults spend 2.2 hours per day on mobile, time that is being stolen from traditional mediums like TV, Print etc. With over …Read More
The invention of shipping containers in the 1950s changed the economics of exporting, and helped kick-start a new wave of exports among large companies. Today, the internet has the same impact among small businesses, helping them find new customers overseas and grow.
Whether you’re heading out for dinner or doing your weekly shopping, your Android phone is all you need to bring with you when you walk out the door. Starting now, Android Pay is available in Taiwan.
Android Pay helps you pay for things quickly and securely with your Android phone, plus lets you earn all the same loyalty points you would with your card.
You’ll be able to use Android Pay anywhere contactless payments are accepted, including your favorite shops like PX Mart, Carrefour, Watsons, and more. Simply unlock your phone and hold it to the …Read More
If you’re a KISS fan, you’ve probably spent some crazy, crazy nights rocking out in face paint. But what about when you want to bring a little KISS with you to work or Grandma’s house? You might want to leave the face paint at home, so we’ve got you (and your phone) covered. KISS joined forces with us to create 12 limited edition Live Case designs for Pixel and Nexus phones available on the Google Store. And we had the chance to ask Gene Simmons, the Demon himself, about the collaboration:
If you’re a KISS fan, you’ve probably spent some crazy, crazy nights rocking out in face paint. But what about when you want to bring a little KISS with you to work or Grandma’s house? You might want to leave the face paint at home, so we’ve got you (and your phone) covered. KISS joined forces with us to create 12 limited edition Live Case designs for Pixel and Nexus phones available on the Google Store. And we had the chance to ask Gene Simmons, the Demon himself, about the collaboration:
Posted by Sri Somanchi, Product Manager, Gmail anti-spam Today we announced new security features for Gmail customers, including early phishing detection using machine learning, click-time warnings for malicious links, and unintended external reply warnings. In addition, we have also updated our defenses against malicious attachments.
Let’s take a deeper look at the new defenses against malicious attachments. We now correlate spam signals with attachment and sender heuristics, to predict messages containing new and unseen malware variants. These protections enable Gmail to better protect our users from zero-day threats, ransomware and polymorphic malware.
In addition, we <a class="colorbox" rel="nofollow" …Read More
Keeping company data secure is priority one, and that starts with protecting the tools that your employees use every day. We’re constantly adding security features to help businesses stay ahead of potential threats, and are excited to announce new security features for Gmail customers, including early phishing detection using machine learning, click-time warnings for malicious links, unintended external reply warnings and built-in defenses against new threats.
New machine learning models in Gmail to block phishing
Machine learning helps Gmail block sneaky spam and phishing messages from showing up in your inbox with over 99.9 percent accuracy. This is huge, given …Read More
Awesome, then next time you're looking to procure digital services, keep us in mind. We provide these blog posts to help people and companies like yourself with common problems and challenges.
Better yet, subscribe to our monthly newsletter below so you'll always be updated with the latest digital news that is relevant for yourself.
Well, this is a bit of great news for Contrado Digital. We’ve passed Google’s brand new Mobile Sites Certification and we believe we are the first in Lancashire to do so! This certification highlights that the mobile websites we develop are done to an extremely high standard to ensure your customers are happy customers when they visit your website. While what the non-technical users may just see as a “pretty website”, actually there is an awful lot going on behind the scenes, technologies, systems, processes, best practices and more that we know about so you don’t have to. We always say that any monkey can build a mobile website. Very few can build a mobile website that is designed to perform for your business. Whenever you are investing in a mobile website or a responsive website, make sure you are working with the right digital partner who knows what they are doing.
