Search source code of any sites with Excel

What is site searching and why do I need it? If you ever find yourself looking at a list of URLs and are contemplating doing anything that involves copying and pasting each one into a browser and looking at the corresponding website, you are probably looking at something that could be automated. To that end,…

Read More

Humor, distribution, and going viral on LinkedIn

At 261 LinkedIn connections, I’m hardly a power-user; but I still find it to be one of the most interesting social networks, especially from a professional/business perspective. Over the past 6 months, I’ve tried publishing updates to Linked in around once or twice a day. The second most viewed/shared content A few months back I…

Read More

Correlation and causation: Why testing is important

Correlation and causation is touchy subject for mathematicians and marketers alike. Despite what every person passionate about anything would like you to think, just because two sets of data are correlated it does not mean one caused the other. There may be a link, or they may be just co-incidental. As a marketer, you do…

Read More

Visual Basic & div tags Part 2- How to scrape data off of webpages

This post is includes the second half of the scripting required for the web-scraping project described in last weeks post. With a completed list of the blog post and their corresponding URLS, the next step is to code a scraper that will visit each page, search out the blog content and any relevant tags then…

Read More