Skip to main content
Hootsuite bulk tweet upload Google Spreadsheet tool

Spreadsheet Sunday: Hootsuite Bulk Tweet Scheduler

Hootsuite is a great tool for almost any social media manager out there. It lets you manage multiple accounts and schedule social media posts across channels. Hootsuite is probably most used by marketers to help manage multiple twitter accounts and streams, and it is a great tool for doing that.

One of the power features that Hootsuite offers is bulk message scheduling via a CSV file. Bulk scheduling tweets can be a huge time saver, especially if you want to promote certain tweets or links several times throughout a month. However, creating a bulk upload sheet can be a bit of a pain with the default CSV template that Hootsuite provides.

Worry no more, you can use this simple Google Spreadsheet to help you bulk schedule your tweets with ease! Simply use the “Editor” sheet in this Google Doc and you can enter your tweet’s information. What this sheet will help you do is after you add your message and a link (if you want to include one) and this sheet will perform a character count for you to make sure your tweets are within the 140 character limit. You can also choose the time and date with ease by clicking on the little triangle in the cell and selecting the options you want from a drop down menu.

When you are ready to schedule your tweets, simply go to the “Export” sheet and export the sheet as a CSV file to upload to Hootsuite. This “Export” page automatically puts the data in the proper format for uploading to Hootsuite, so there is no extra work for you to do.

To get your own copy, click the button below, select “File” from the menu, then select “Make a copy…” to create a copy that you can use. Don’t forget to share this page with anyone who you think might find it useful!

Get It Now

728x90_landing

Read More

Top 3 Mistakes Made By Facebook Advertisers

Facebook ads can be a great way to connect with more of your current and potential customers. However, that does not mean that all Facebook ads are created equally. Many Facebook advertisers make the same mistakes over and over again, costing them more money and creating a disconnect for their customers. Listed below are the top 3 mistakes to avoid as a Facebook advertiser.

  1. Lack of proper ad targeting

    It’s truly unfortunate, but so many advertisers still fall under “the more, the merrier” mindset when it comes to ad targeting. They are so afraid of missing one potential customer that they feel it is better to pay to target nearly everyone. This has a few negative effects, first and foremost being that you are paying way more than you need to. You have to pay for all those impressions and clicks from uninterested people, often several times.

    The second major problem that this is creating is that you are sending annoying and irrelevant messages to people. If your ad shows up enough, they may be inclined to think bad things about your company and possibly could even influence their friends to think the same. All of this leads to bad business. Don’t be afraid to micro-target, you can expand as needed.

  2. Generic messages

    Generic ad copy is another huge waste of time and money for many companies. While your ads might be successful using the same copy over and over to target different markets, it is almost certain that you can improve your CTR with unique and customized copy. If you are targeting people in a different areas or with different interests, your ad copy should reflect that.

    Most businesses have multiple services or products, but fail to realize the difference to the customer. Let’s say you sell clothes online. Many Facebook advertisers out there would make one ad that claims they have awesome shirts out there. That’s great, but so do many other businesses, this doesn’t give the user a great reason to click on your ad. However, let’s say there is a classic rock section to your store (among other categories). Instead of making that generic ad and blasting it out to everyone, you would most likely have much greater success if you made your ad about classic rock tshirts and then targeted it to people who like classic rock. Repeat this for your other categories and you should be spending less while getting more clicks.

  3. Poor use of images

    Images are one of the most important assets to your limited ads. These are usually what will grab the readers eye and direct the user to reading your ad. Getting their attention with an image and using a related image that adds meaning to your ad are often two different things for many Facebook advertisers.

    You are limited to 25 characters for your title and 90 characters for your ad, so it is vital that you use your images wisely to create the most impact for your ads. Be sure to avoid using an eye catching image if it doesn’t add meaning to your ad, otherwise you will create a disconnect for the user and will most likely miss out on their business, even after they clicked your ad. Choose an image that compliments your ad copy, but also one that is fitting and evokes the feeling you would like for your brand.

What other big mistakes do you find Facebook advertisers making over and over? Let me know by leaving a comment below.

[note color=”#efeeeb”]
Need to hire help? Get hassle-free, professional, and effective Social Media Marketing services.
[/note]

Read More

What Makes A Great Social Media Marketing Plan Work?

Social Media is a very exciting topic for a lot of people, especially for business owners and managers. Therein lies the problem however, companies get excited and they jump right into doing it. This is what creates so much confusion and frustration for them, after they jump in and post random links and images like they heard from somewhere online, they wonder where their results are. My question to them is, “What are your goals and how are you measuring?” Without knowing that, its hard to know if you are really achieving anything. This is why it is important to have a Social Media Marketing plan.

Sounds great; but how do I actually do it? I believe there are only 4 simple requirements to make a great social media marketing plan: research, strategy, execution, and maintenance. “Rsem” is an acronym I use for this, it is pronounced similar to “awesome” but with an “r” sound instead of the “awe” sound. If you get these basics of Rsem down you are well on your way to utilizing social media for your business instead of wasting time and resources with it.

Research

Research, research, research! This is the most essential stage of setting a plan. Get to know your customers, what kind of results are realistic, and what channels will work best. A little research can go a long way and save you tons of headaches down the road.

Strategy

This is where you set your goals and define how you will achieve them. Having a strategy gives you a starting point and direction for your social media execution. You should include information about what social media channels you will be using, when and how often you will post, the tonality of your posts, the types of content you will share, who is responsible for posting, and other relevant information.

Execution

Success is a good friend of action. At this stage you have already triumphed through the hard parts, now its time to put that knowledge into practice. Monitor and analyze as you go, making sure to have a little patience and to avoid making decisions with information or findings that are not based on enough analytical data.

Maintenance

After you have been implementing and executing your plan, you must be sure that you are maintaining it properly. This means checking to make sure you are reaching your goals, tracking data insights efficiently, paying attention to trends, and utilizing new or viral opportunities. A social media plan is not a stiff, unchangeable marketing execution. The social landscape is constantly changing and you need to make sure you can keep up and handle the ride.

Do you need someone to handle one or more social media accounts for you? Get hassle-free professional and effective social media marketing services, contact me now.

Read More