faulker046

These days SQL is a must have skill for marketers and marketing analysts. Data is everywhere but access to that data is still a challenge.  Marketers and Marketing Analysts generally depend on the tools or IT department to help them pull the data for marketing purposes. IT leaves you hanging because they have other priorities as a results Marketing Analysts have to know how to write SQL on their own so that they are not dependent on IT. No SQL means no data and no data means no insights. This course is for those marketers who would like to know how to use SQL to conduct their marketing analysis. If you are trying for a job as a Marketing Analysts then this course is a must for you. This will help your resume shine and put you ahead of other similar candidates. The more you can handle technology and data these days the better it differentiates you from the rest of the pack. The course uses mySQL to show how SQL works but all the leanings and most of the scripts are also applicable t...

I recently developed an online course which provides information on the Career in Digital and Web analytics. The course is a result of the emails that I get from recent graduates and people who are looking to change their career.   This course "Career in Web & Digital Analytics" is currently available on Udemy  The course covers following area: Introduction to the field Salary Expectation – Industry surveys Various Roles Deep dive into the roles Career progression Education and Skills   Resources for Learning I will add more content based on the student feedback.   Here are some ideas of content that I will be adding soon (you will have access to the course forever, so any new content will be available to you as soon as I upload it). Who hires – various types of companies What a digital marketer needs to know Step by step guide Use Coupon Code: ABWA10 or visit this link to get this course for only $10,  Get the course for only $10

What is the difference between segmentation and personalization? This is the question that came up during one of the webinar on personalization by Optimizely. This blog post is for those who have the same question. Basic definition of Segmentation is  - division into separate parts or sections.  For the purpose of marketing, it is a processing of grouping customer and prospects into similar groups based on various criteria such as demographic, geo, behavioral and psychographics.  You can use one or more of such attributes to define your segment.  The purpose of segmentation is to understand about a group (segment), and develop marketing strategy to better target those segments.  Personalization is providing marketing messages and/or experience that is tailored based on a customer’s needs or preferences.  Personalization can be very basic that can start from simply recognizing the person by name or it can be very complex that includes all sorts of data abou...

Those who know what internet bots and spiders are, know that know that spiders and bots visit your site very day and multiple times a day.   For those who don’t know here is the definition of bots according to Wikipedia :  An Internet bot, also known as web robot, WWW robot or simply bot, is a software application that runs automated tasks (scripts) over the Internet. Typically, bots perform tasks that are both simple and structurally repetitive, at a much higher rate than would be possible for a human alone. According to a recent survey , on an average about 51.8% of the website visitors are bots. Source: https://www.incapsula.com/blog/bot-traffic-report-2016.html One assumption many digital analysts make is that the JavaScript based analytics solutions such as Google Analytics , Adobe etc. either stop bots from executing the script or filter them out before calculating the metrics.   Well, this assumption was true years ago, it was one of the selling points of JavaScri...

Struggling to drive conversions?  The issue might be with customer experience. After having worked with several brands, big and small, I can assure you that you don't have to make sweeping changes to drive better results. Many times even small changes and little bit process can lead to happy customers and big impacts. In this post I have complied 11 tips that you can use today. If you need help then don't hesitate to reach out to me. Easy to fill forms  – How many times have you come across a form field where you don’t remember what the field was about?  Many designers/developers use the default text in the form filed as the filed label. Once you tab into that field, the default text is gone and now you can’t figure out what that field was about.  That is a very bad design which will likely cause customer frustration and kill conversions. No more unnecessary form field formatting and validations - Other than Captcha validation, you are likely using form field valida...

It is no secret that Amazon is a data driven organization.  The culture of testing is ingrained into pretty much everything Amazon does. However, a company like Amazon also makes mistake as I learned from my recent experience with Amazon Videos. I have two Amazon Fire TV Sticks, one attached to each TV that I have. Both are tied to the same Amazon account.  Using my Amazon Video account, I started watching a movie on one TV, turned it off halfway through and then a day later tried to watch it on the other TV. Guess what? I could not find that movie in any of the obvious menu options. I was expecting it to show up in my stream or at least in the same place where I found it last time.  Nope.  Amazon changed the order of movies on me. It’s not like it added new movies to the lineup and this movie got pushed down. They just reordered the existing movie selection. It appeared to me that some kind of movie display sorting experiments was going on. However, that experiment,...