Home > Blog > Is this the Most Powerful Excel Formula in Digital Marketing? 27th February 2019 - 17 minutes read Data & Analytics SEO Tips & Tricks Richard Lewis - SEO LeadThe formulas & functions in Excel give you the power to get mountains of work done in minimal time. The most powerful formulas of all can do the work of many people at once and save days of campaign time. When it comes to these formulas in my experience of digital marketing, the heavyweight champion is the keyword grouping formula: =LOOKUP(2^15,SEARCH(C2:C4,A2),D2:D4) =LOOKUP(2^15,SEARCH(text to look for in your keyword, your keyword), what to return if the text was found) It puts all your millions of keywords into groups based on the words they contain: Bulk categorisation of hair related keywords by colour and hair type groups. Diagram of what the formula does, with colours representing individual words that could be found within … [Read more...] about Is this the Most Powerful Excel Formula in Digital Marketing?
Personalization in digital marketing
As 2017 is coming to an end, companies are busy planning their digital marketing strategy for the new year coming up. The next year will be crucial for the digital marketing sector as most of the popular marketing strategies will be on their way out and they’ll be replaced by many emerging technologies and platforms. Let us take a look at the industry trends that’ll be of great prominence in the near future. 1. AI-Powered Content Creation Guess what? Content will still remain king in the years to come. But, content creation and the way it will be received eventually will remain in the hands of AI. Most of the prominent platforms like Forbes and Amazon use the machine-generated content. Human editors will have to review the work at different stages. AI has been heavily involved in content creation recently, for instance writing articles for websites, scheduling social media posts, and generating content to read as per user interests. In the coming year, almost all the … [Read more...] about 6 Trends In Digital Marketing To Watch Out For In 2018
Attribution is the science behind assigning values to individual touch points throughout a customer's decision journey. It's not only a key driver in how we currently optimize marketing campaigns, but attribution is also used for media mix modeling and developing media budgets. Herein lies the problem: marketers tend to look at attribution within our own channel silo, so it's not easy to understand the full picture of a multi-channel environment. As search continues to evolve in form and function, it's raising some important questions around how we think about and use attribution models - and is putting some of our long-held practices to the test. Do you have an attribution problem? Attribution modeling has seen incredible progress over the years, offering increasingly better solutions to track touch points throughout a conversion. While progress has been made, the attribution models that most companies are using today offer a partial solution that tracks only online conversions and … [Read more...] about Rethinking today’s attribution problem in digital marketing
“Digital marketing” sounds big and scary. Even the most adroit web users shy away from laying claim to being an expert digital marketer. Over the past few years, however, I’ve come to realize something. I’ve blogged, read, researched, spoken at conferences, mingled at meet-ups, chatted with friends, listened in on social media, and this is what I’ve learned: Most people are better at digital marketing than they think. Digital marketing is mainstream. It used to be that nobody had cars. Now, a lot of people own cars. It used to be that nobody owned a personal computer. Now, many people do. It used to be that few people owned a mobile device. Today, mobile devices are everywhere. Digital marketing is similar. Perhaps you’ve not achieved expert status yet, but see how you rank according to these signs of digital marketers. You Know What SEO Stands for Search engine optimization is a fixture in digital marketing. Ever since there has been internet … [Read more...] about 10 Signs You’re a Digital Marketing Expert
Do you work in digital marketing and do you love it? Are you new to the industry and feeling overwhelmed by it? Either way, all this constant change means people in this industry are always learning and sharing their ideas. In case you hadn’t noticed, the digital world is all around us. For those people still trying to fend off the ‘future’ by disengaging from the digital world, the tide is turning. It’s now getting harder and harder to do everyday things like pay a gas bill, book a holiday or apply for a job without some kind of digital presence. In some parts of the world – like China – you can’t even get a taxi these days unless you are connected to the internet. In the words of Bill Heslop: “You can’t stop progress.” That quote might be lost on anyone who is not Australian, but in the two years since I attended my first ClickZ Live event, the digital landscape has changed phenomenally and there are no signs it’s … [Read more...] about What’s so great about digital marketing anyway?