Mark Boyd
  • Business
    How to Auto-Schedule Tweets in Hootsuite From a CSV File3 twitter
    As service providers and online business owners, we are often expected to maintain the social media profiles of our clients, as well as use social media accounts to promote our own work. You can offer social media management as a service to prospective clients, but potential clients will often want to see how you manage your own social media before deciding to work with you. If you are managing social media for a client, the actual networks you use may vary (Pinterest, Facebook, Linkedn, Vine, Instagram...), depending on the audience you are appealing to, and the brand identity of your client. But one social media network all clients will undoubtedly have in common is Twitter. Hootsuite has risen fast to become the defacto tool for anyone building and engaging with an audience on Twitter. While not the prettiest interface, it is often the most practical, providing you with easy-to-review streams that you can use to coordinate your Twitter messaging. At any given time, you can have a dashboard open showing what Twitter messages are being sent amongst your community of followers, who has mentioned you (or your client) in a tweet, and streams dedicated to key hashtag terms in your field. Social media management can be a demanding and time-consuming business service to provide for your clients and needs to be strictly time managed. Scheduling tweets in advance is a key strategy that you can use to maintain productivity in your daily work. If you are tweeting on behalf of a client, scheduling tweets also allows you to offer an accountability loop so that clients can sign off on your communication strategy in advance. This tutorial helps you provide a tweet scheduling service to your clients and includes tips on best practices for managing social media. Learn how to schedule tweets using Hootsuite Pro’s bulk scheduling feature. This service is a big time saver.Read More…
  • Business
    How To Clean Up Keyword Research Data in a CSV File2 key
    Your business, services and products – or those of your clients – need to get noticed on the web: and keywords are the way that happens. Whether it be the exact terms people use when searching for something in Google, the hashtag trends they look out for in social media, or the subject words they use to find an ebook in the Kindle store, it's the keywords you use that help your potential customers find you. Nowadays, keyword research is a part of a data-driven approach to your content marketing efforts. Only several years ago, keywords were stuffed into whatever webpage was being created as part of an internet real estate scramble. Now, fortunately, the landscape has narrowed. There are, however, strategic keyword tools that work well to bring more eyeballs your way when coupled with a foundation of great content. Let's look at how to plan your keyword research and format it into a CSV file you can put to use.Read More…
  • Business
    How To Clean Up Data in a CSV File1 data
    Regardless of the size of your business, there are growing expectations that you will be data proficient. While big data gets hyped at an enterprise level, the reality for freelancers and micro businesses owners is that you will need to get your hands dirty playing with data at some stage of your client work. Whether it be from transferring keywords into a spreadsheet, scheduling tweets, syncing data between business apps, managing contact lists, or importing data into an infographic, you will need to know how to clean data from a spreadsheet and organize it into a format that any online app or software can read. The good news is that being able to manage data and move it between apps is a marketable skill in itself and with a few tricks up your sleeve, you can also save a lot of time: time that you could be spending on more profitable work.Read More…