At Balihoo, we recently encountered a problem. We needed to extract all the text and formatting from past blog posts we had written, but our service provider didn’t have a tool to do that. Since there were over 600 posts, this isn’t the kind of project you want to do by hand. With a bit…
Read MoreVBA or Visual Basic for Applications is a fantastic tool for automating a number of tasks across the Microsoft suite. Some of the greatest uses come from integrating Excel with Internet Explorer allowing a user to be able to scrape data off various websites and dump the data into Excel. This post will show how…
Read MoreWhile I usually try to post less articles, but I couldn’t help it this week, there is just too much I want to share. This afternoon grab a cold one and spend a few minutes reading through these great posts! Why “Simple” Websites Are Scientifically Better I’m always a sucker for case studies and examples,…
Read MoreAround 6 o’clock last night the multi-level marketing salesperson we had spoke with a few weeks ago showed up. While we didn’t end up buying the vacuum she was selling, I did get a fun “free gift” and a lot of great marketing insights. If this pitch can sell a $200 vacuum for $2500, what…
Read MoreEvery company has a different business case for building a mobile site. For some, mobile is simply a way for consumers to find their business. Other may rely on mobile for ecommerce purchases or even as a way to browse and explore content. Regardless of purpose, the difficulty is getting users to submit data on…
Read MoreThis week I ran across a few articles of interest to marketers. If you have any suggestions of blogs or articles I should cover next week, be sure to email me! 7 Tips to Make Your Email Marketing More Mobile-Friendly This article by JD Waldow is full of email tips for mobile. As more customers…
Read MoreI recently received an email from a video marketing platform called Vidyard. Ultimately we are soon going to be customers of theirs because they offer a product that we need we would never have known that had they not marketed their product in a way that caught my eye. Success #1- Making it through spam…
Read MoreFor those who didn’t catch the interviews on Jimmy Kimmel a few weeks back, take a couple minutes to watch this video. While admittedly conducting interviews on the streets of Hollywood is hardly the best way to conduct market research, Jimmy Kimmel has pointed out something out that all marketers should take note of: All…
Read MoreWhen reporting on data that has dramatically different scales but is correlated, it can sometimes be difficult to easily create visual charts that are meaningful. For example, you might have a marketing spend in the thousands of dollars per quarter for a program that generates significantly less than 100 leads per quarter. To visualize if…
Read MoreIn an ideal world, a marketer sends out 2 versions of an email, the first email is opened 58% of the time and the other only 2% of the time. It’s fairly easy to figure out that, almost regardless to sample size, the first email simply was superior to the second. But what about when…
Read More