Author Archives: Chris Makara

About Chris Makara

Since 2003, I have developed an in-depth of experience in Interactive Marketing & Digital Strategy, with a focus on SEO, Social Media & Demand Generation. I am an avid Football Fan, Golf Enthusiast & Ambidextrous Bowler. I can also be found on LinkedIn and Twitter.

[HOW TO] Brilliantly Scrape Twitter Data With Microsoft Excel

Who doesn’t love data? Not just Data who was in Goonies, but cold hard Twitter data?

Back in the day (I guess I am showing my age here), the character Data had all the gadgets in Goonies. No matter the situation he seemed to always have some contraption that bailed himself (and others) out of trouble. Twitter has tons of data to bail you out of a jam. Whether it is content creation ideas, targeting the right followers, or even seeing what your competition is up to.

While there are countless tools that provide insight into Twitter data, chances are you have said, “there has to be a way to do this in Microsoft Excel.” If not, now I might have you thinking.

The bad news is it is not a straight forward process. The good news is, I figured it out how to export Twitter data to Excel and will share the details on how to do it through some trial and error after reading this post from Matthew Barby. If you know of a better/cleaner way to construct any of the formulas, please let me know in the comments below.

With this Excel spreadsheet, you will be able to pull in most data from any Twitter user, including first and last name, location, bio, URL, number of Twitter followers, number of Twitter users they are following, number of tweets, how long ago they last tweeted, and the content of their latest tweet. This info is very handy if you are trying to analyze certain Twitter users. Continue reading

My #1 Top Secret Trick to Remembering Blog Topic Ideas

We’ve all been there. You have thought of the best blog idea EVER! Unfortunately, you are nowhere near a computer. No worries, there is no way you will forget this topic.

Nope, not this time.

Let’s fast forward to the moment when you finally sit down to write you epic blog post. What was it you were going to write about? Surely you remember? Right?

Don’t Fool Yourself

If you are like me, chances are you won’t remember the exact topic you were planning to write about. Sure, you might remember the general idea you originally came up with, but will you remember all the details?

This has happened to me more times than I can remember…so I looked for ways to make sure it doesn’t happen again. Continue reading

[HOW TO] Use Instagram to Turbo-charge Your Small Business With Ease

Most small business owners and marketers focus on the “big fish” of social media sites for their social efforts and lead generation. Commonly, they look to Twitter, Facebook, and LinkedIn for generating leads. However, many are neglect using Instagram for business marketing.

With over 200,000,000 (yes, that is 200 million) active monthly users, there is no reason your business should not be looking at ways to use Instagram for business to explore opportunities for cultivating meaningful relationships with current and potential customers. Continue reading

4 Genius WordPress Hacks That Will Save Your Bacon

WordPress is one of my “go-to” platforms when creating websites. It is flexible, highly customizable, and easy to use. However, over the years, I have encountered the occasional “oh $4!+” moments where I either broke something or got stuck trying to fix an issue.

Luckily for you, I will reveal my 4 WordPress hacks that helped to get me out of a jam. Please do not attempt these hacks/fixes yourself if you are not comfortable in doing them. If you need help, you can always contact me.

You’ll want to bookmark this post because chances are you will need one of these WordPress hacks later to bail you out. With that being said, let’s jump in. Continue reading