How to bulk upload to Hootsuite Fast (w/ pictures)

[fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=”” min_height=””][fusion_text]

Why do people curate?

People curate so they can provide high-quality articles to their audience. You give them as much information as you can in order to help them. It creates loyalty, and they will keep coming back to your website.

There are many steps, but, once you start using it, you will never go back to doing it manually. I promise. 🙂

Tools:

  1. OneTab
  2. Google Chrome
  3. Microsoft Excel or Google Sheets
  4. Hootsuite Pro
  5. Follower Wonk
  6. Feedly account (free is fine).

How to find the best times to publish

Sometimes it’s hard to find the best time to publish. You can find this information by going to follow or walk. I’m pretty sure there are other tools out there that will help you find this information. If you find something that can be alternative to this, please mention it in the comment section.

Make sure you find the best times to publish for Facebook and Twitter for your audience. Choosing the best time to publish it so the majority of your audience will be online and will get to see your update in real time. Most people do not try and check all their updates. They only see whatever is shown to them on the screen because most have a lot of updates.

Steps

1) Open up feedly and select the urls you want to add.

One thing I like to do is search for websites similar to my niche. Once I find these websites I go look at the blocks. I then add the seeds into Feedly. I name them according to whatever I need for them to be labeled

Feedly Curation Folder

2) Get all links you’re interested in

I used to have a big problem with this. I hired a VA especially for my content curation because it can be a tedious task. Not only is it a tedious task, but it is also time-consuming. The time you spend doing this task correlates to how fast your Internet speed is and how fast your computer is.

Loading all links

Don’t tell anybody, but here is a tool I use. As a power user, I use the “OneTab” tool. This tool grabs whatever tabs you have on your browser, and it’ll compile it and put it in a clear list. This stops your computer from slowing down and increases its speed. This is especially useful for people like me who have a lot of ideas and have a hard time organizing them.

3) Install OneTab on Chrome

Going back to feedly, you can hold down the control key and then press each link you want to open. Instead of right clicking or doing this manually, this will open up each tab without you leaving the current.

Press one tab extension

Once you are happy with the number of links you have collected, press the OneTab icon on the top right-hand corner of the screen.

You will see OneTab will merge all the links together and add them as a list on its tab.

4) Export!

Now, you will have these beautiful links that put in your spreadsheet. Click on the import/export link which is located on the top right-hand corner of OneTab. Once you press this link, it’ll show you a box of all the links. Copy this and paste it on your spreadsheet.

Compile all list into one-tab

My long list of content

Export URLs

The link is at the top-right hand corner

 

Copy and paste to text file

5) Copy and paste to your notepad (.txt) file and save it.

6)Open up Microsoft Excel and open the (txt) file.

Open in Excel

Make sure it's in .txt format

Since it is a txt file, excel will ask you how you want it to be formatted when importing the file. Follow the steps below.

text import 1

Step 2

Step 4 text

7) Rearrange the column according to Hootsuite’s format.

ctrl x

8) Add your comments and upload

Once you have your beautiful list of URLs, now is the time for you to comment on them. You could comment on them however you want; although just inputting the title would not be the best way to comment on them. Your audience wants you to be authentic. Therefore, you would want them to think that you read the article.

You must learn how to skim articles and be able to see the main point of them. What I usually do is skim the article, find the most useful point, then comment on it. This comment will be my tweet.

9) Add Dates

Choose date and time in column one.

When you’re choosing a date and time for column one, select the date and time in which you want this content to be published. After that, click the drag button. It won’t change the time, but it will change the date. You could change the time by adding another. Now, all you need to do is put some more content on that tab.

 

date section

 

10) Once you arrange the columns, save the file as a CSV file and upload it to HootSuite.

bulk upload in hootsuite

 

Tips:

Know the optimal time to send a tweet. You may send a tweet three to six per day. You don’t have to do all the way to six tweets. But if you are a big company, definitely do six tweets. But if you are starting out, three tweets would be enough.

For Facebook, I would recommend sending two posts per day unless you have really humorous posts to where they have a tendency to go viral. You don’t want your Facebook audience to get sick of your posts and unfollow you.

A better way to know is by testing. Nobody can tell you how you to do anything because each business is different. It is up to you to research more about your audience so that you could cater to them.

[/fusion_text][fusion_title size=”2″ content_align=”left” style_type=”default” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]To Recap:[/fusion_title][fusion_text]

1) Get our links using feedly.

2) We used Onetab to compile them all into a neat list

3) We saved this list as a txt file and upload it to excel.

4) We rearranged the columns according to Hootsuite’s standards and uploaded it into their bulk uploader.

 

Did you get that?

Good! If you have any questions, feel free to comment below and I’ll be sure to clear things up for you!

 

If you found this helpful, please help spread the word through social media. Thanks!

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

How to give other users access to your Facebook page

If you need someone to manage your Facebook page, it’s best to give them access to manage it than give them your personal username and password. Here are the steps on how to give other users access to manage your Facebook page.

Note:
Users who have liked the page are the only ones that are allowed to be added as a moderator of that page.

1) Log into Facebook and go to your Facebook page.

2) Click on the Settings > Page Roles.

facebook page settings

3) Put the name or email address of that person in the box shown in the picture.

Facebook page settings

Which role would you like to assign this person? Here is a table to help you decide.

Facebook page user roles

 

Once you hit save at the bottom, the person invited will receive the notification that they have been given access to that page.

 

How to add a user with admin rights on Google Analytics

If you have someone analyzing data for your site, it is a good idea to give them editing, collaborating, and reading access to save you the trouble of having to export the information yourself. A user with admin rights will have access to enabling services such as looking at the geographic information of users and also having the ability to export or download a pdf file derived from the data. Below are steps on how to add a user with admin rights to your account.

1)Log into Google Analytics.

2)Go to Admin > Account (wherever it is located)

3)Go to User Management

Google analytics add user

4)Add the email of the user and check the 3 boxes.

Google analytics add user

Note:

It is a good idea to send this user an email stating that you gave them access. Google Analytics will attach a link to the email which will make it easier for them and the system to know that they have accepted the invitation.