Social Media

Hootsuite Bulk Uploader Date Changer

I use Hootsuite a lot for scheduling my social media post. I have a few spreadsheets that I upload every month with 30-50 items in each and when the month changes to the next month I have to go into my Google Drive (Never use Excel with Hootsuite) and open the spreadsheet. One of the things you would think is that you can just do a simple search and replace and change the month. Normally you would think that would work but what ends up happening is the days of the week also get messed up.

Let's say I am going from July to August. I would open the spreadsheet and go EDIT > Search and Replace and change the date from 7/ to 8/. Well it works fine but it also changes the date on the 7th, 17th, and 27th of the month to the 8th, 18th, and 28th. Needless to say that if you don't fix this the spreadsheet will have errors in it when you upload it via the Hootsuite bulk upload tool because the post are not in order date anymore and the times will get messed up.

Hootsuite Bulk Uploader Solution

After months of struggling with this I finally figured out a solution. In the find and replace box add a caret (That funny thing above the 6 key on your keyboard) in the find section. Then scroll down and check off match case and search using regular expressions. You should then be able to look at your csv file and notice that the dates for the 7th, 17th, and 28th hasn't changed at all.

Save the file as a csv and you are good to go. Then make the same changes the next month. This will save you valuable time using the bulk upload tool.

Speaking at Author Marketing Live

Just putting on the finishing touches to our presentation for Author Marketing Live. Debbie and I are doing a presentation called “Fast & Easy Ways To Find True Fans & Rabid Readers with Social Media” which I have to say I am quite proud of.

I have about 4 or 5 tips that will help authors save time when using social media while building a fan base that will want to read their books. While I can't say exactly what these tools are I can say that it will be a sold out audience and we are prepared to have authors sitting there with their eyes wide open and writing down the tips we are giving them.

It will be my first time in Cleveland unless you count the 2 minutes I spent there changing planes once. If you are going to be there I look forward to seeing you, please come up and say Hi!

If you waited to long and didn't get a ticket I suggest you follow the hashtag #AMLive14 as I will be tweeting from the stage. Well not really since I set up the tweets to go out last week.

Extend Facebook Reach With One Button

I was talking with a buddy online and he was telling me how his Facebook reach was going down and down and down. At first I gave him a few tips on how to increase it and then I told him why not put your Hootsuite tweet sheet in and push the same tweets to Facebook as you are putting on Twitter. I talked a little about this in my Twitter post last week.

Of course I would not do this all the time but for the sake of testing I did it myself with one of my sites. I pulled out my monthly Twitter sheet I have set up for Hootsuite and deleted the first 9 rows and saved it and uploaded it using the bulk upload tool in Hootsuite. As you can see below I expanded my reach with no problem. This was only posting 2 more times a day.

Now if I was to do this seriously I would have a longer Tweet sheet than having the normal 140 characters. Maybe take a snippet of content out of a page and link it back to that page. Odds are the image for the post would get pulled automatically from the page?

If you are using Hootsuite and the bulk uploader why not give this a try! For people that are familiar with the tool already this could be set up in a matter of 1 minute pushing one button.

[Tweet “My Facebook reach has been off the charts since doing this.”]