Skip to Content

category

Category: Social Media

post

Without Authorship, Google+ Still Matters. See How Google+ Sent Me 197 Extra Visitors in 24 Hours

As many are aware, Google decided to drop showing authorship images from its search results. Previously, as you may have noticed, when you ran a search on Google, some of the search results would display the author’s image next to the search result. In fact, I even took the time to show you how to setup Google authorship.

Unfortunately, that ship has sailed. It was fun while it lasted.

But does that mean Google+ should no longer be part of your overall digital marketing strategy? Read more »

post

[HOW TO] Create a Twitter Dashboard in Excel That Scrapes Data

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. Read more »

post

[HOW TO] Use Instagram for Your Small Business

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. Read more »

You might also likeclose