<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:media="http://search.yahoo.com/mrss/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>FreelanceSwitch</title>
	
	<link>http://freelanceswitch.com</link>
	<description>Freelance Advice and Freelance Jobs</description>
	<lastBuildDate>Wed, 19 Jun 2013 12:00:16 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=3.5.1</generator>
	<language />
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.5.1</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/FreelanceSwitch" /><feedburner:info uri="freelanceswitch" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><media:copyright>Copyright (c)2007 FreelanceSwitch.com</media:copyright><media:thumbnail url="http://www.freelanceswitch.com/podcasts/Radio_144.jpg" /><media:keywords>Freelance,Radio,Switch,FreelanceSwitch,Advice,Freelancer,Designer,Programmer,Business,Contractor,Photographer</media:keywords><media:category scheme="http://www.itunes.com/dtds/podcast-1.0.dtd">Business</media:category><itunes:author>FreelanceSwitch.com</itunes:author><itunes:explicit>no</itunes:explicit><itunes:image href="http://www.freelanceswitch.com/podcasts/Radio_144.jpg" /><itunes:keywords>Freelance,Radio,Switch,FreelanceSwitch,Advice,Freelancer,Designer,Programmer,Business,Contractor,Photographer</itunes:keywords><itunes:subtitle>FreelanceRadio</itunes:subtitle><itunes:summary>Advice, Tips and Resources for Freelancers from FreelanceSwitch.com</itunes:summary><itunes:category text="Business" /><image><link>http://freelanceswitch.com</link><url>http://envato.s3.amazonaws.com/rss_images/fsw.jpg</url><title>FreelanceSwitch</title></image><feedburner:emailServiceId>FreelanceSwitch</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>7 Ways to Monetize Your Speaking, Beyond Selling Your Services</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/yGnm8F0ITnw/</link>
		<comments>http://freelanceswitch.com/freelance-marketing/monetize-your-speaking/#comments</comments>
		<pubDate>Wed, 19 Jun 2013 12:00:16 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Marketing]]></category>
		<category><![CDATA[public speaking]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39105</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39105&amp;c=855038664' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39105&amp;c=855038664' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/05/7-preview-ways-to-monetize-your-speaking.png" alt="7-preview-ways-to-monetize-your-speaking" width="200" height="200" class="alignright imageborder size-full wp-image-39153" /&gt;&lt;/p&gt;
&lt;p&gt;There are far more unpaid speaking gigs in the world than there are paid opportunities. Even major events like TED don&amp;#8217;t pay their speakers. Yet taking an unpaid speaking gig isn&amp;#8217;t necessarily a bad idea. The reason that there are hordes of people clamoring for TED talk slots, as well as less prestigious unpaid speaking opportunities, is that there are other ways to make money once you&amp;#8217;ve managed to get on a stage in front of an audience.&lt;/p&gt;
&lt;p&gt;The obvious option is to pitch those audiences on your services: just by talking about how awesome you are and how you&amp;#8217;ve helped your other clients, you can often convince people to hire you on the spot. But there are other effective options to monetize your speaking, as well.&lt;span id="more-39105"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h3&gt;1. Sell a Recording of Your Talk&lt;/h3&gt;
&lt;p&gt;Not everyone obsessively takes notes at each event they attend. If they want to go back over what you said, they may wind up trying to piece it together from tweets, other people&amp;#8217;s notes and whatever they can scrounge together.&lt;/p&gt;
&lt;p&gt;Such people are often willing to buy a recording to avoid the hassle. Another market for recordings are people who couldn&amp;#8217;t make it to your live presentation. Particularly if you knocked the socks off of your audience, the folks who missed out will love a second chance.&lt;/p&gt;
&lt;p&gt;The cost of offering your past talks as products doesn&amp;#8217;t have to be high. A freelance videographer can tape and edit a talk, often fairly quickly. Then it&amp;#8217;s just a matter of making the recording available. You do need to make sure that any event you&amp;#8217;re speaking at approves of your offering such recordings; some don&amp;#8217;t, and some offer their own. Double-check to avoid trouble.&lt;/p&gt;
&lt;h3&gt;2. Write a Book for Your Audience&lt;/h3&gt;
&lt;p&gt;Often, when you&amp;#8217;re speaking, you&amp;#8217;re only able to cover a fraction of the information associated with your topic. The common cure for this situation is to use your speaking opportunities to build up interest in your topic or idea as a whole, which you then offer in a book or another format that your audience can purchase after your talk.&lt;/p&gt;
&lt;blockquote class="pullquote"&gt;&lt;p&gt;You&amp;#8217;ll see many speakers offering books: it&amp;#8217;s a reliable way to increase your income as an expert.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;You&amp;#8217;ll see many speakers offering books: it&amp;#8217;s a reliable way to increase your income as an expert. It&amp;#8217;s crucial that you speak to the correct audiences to promote your book. &lt;/p&gt;
&lt;p&gt;It may also be worth exploring other formats for the information you want to sell, depending on your audience. A series of videos, a workbook or another format may prove more useful for some people. It&amp;#8217;s even possible to line up a whole series of information products to offer after you&amp;#8217;ve been in the business for a while.&lt;/p&gt;
&lt;p&gt;There&amp;#8217;s often a question of whether you should go through a traditional publisher or self-publish your book. As long as you&amp;#8217;ve already established a following as a speaker, you&amp;#8217;re able to do either fairly easily. Generally speaking, self-publishing is harder because marketing such a book is difficult, but with an established speaking platform, that concern disappears. It&amp;#8217;s really just a question of how much you&amp;#8217;re prepared to invest in creating your information products: traditional publishers handle most of the work, so that you can focus on writing and marketing, but they also take a bigger cut of the proceeds.&lt;/p&gt;
&lt;h3&gt;3. Create the Tools Your Audience Needs&lt;/h3&gt;
&lt;p&gt;If you dedicate yourself to speaking in a niche on a regular basis, you&amp;#8217;ll have on-going access to people who are in the same industry and demographic on a regular basis. That access is invaluable for creating new tools or software for that industry. Take advantage of the reach you have to figure out what tools are most needed and then build them. Your reach can be valuable in other ways, too: you can find people to test out your new tools at the next talk you give. You can even turn your speaking career into the main way you market such a tool.&lt;/p&gt;
&lt;p&gt;Even if you can&amp;#8217;t personally create the necessary tool, there are numerous firms out there who are always willing to work with an expert who already has reach into the appropriate industry. To look for such partnerships, focus on companies that are already targeting the same niches you speak to. Your audiences will hopefully trust your opinion on what can help them improve their businesses or lives, so why not reward that trust with a truly useful tool?&lt;/p&gt;
&lt;h3&gt;4. Train Your Audience&lt;/h3&gt;
&lt;p&gt;Giving a talk to a large group of people can often serve as an introduction to your work. You may get a few audience members who want an easy way to bring that knowledge back to their businesses or another group. By offering follow up training or workshops for those small groups, you can build on the connection you&amp;#8217;ve already established with a few audience members.&lt;/p&gt;
&lt;p&gt;Training can require different skills than public speaking, despite the fact that both involve talking in front of a group of people. You&amp;#8217;ll likely want to structure your training sessions for smaller groups, as well as focus on doing activities together that your audience can learn from. &lt;/p&gt;
&lt;p&gt;It&amp;#8217;s worth building a training program that you can test out before agreeing to offer that training to paying customers: there will be bugs in the program the first few times you give it. Just as you may take unpaid speaking gigs to build up your skills before looking for paid speaking opportunities, you can offer to give your training program a few times for free to make sure it&amp;#8217;s top of the line.&lt;/p&gt;
&lt;h3&gt;5. Promote an Affiliate Product&lt;/h3&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;It&amp;#8217;s possible to promote affiliate products in several ways as a speaker: you might point your audience to a certain link to make their purchase through or give them a coupon code that gets them some benefit when they buy.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;An affiliate product is something that you did not create, nor that you sell directly. But any time someone purchases that product as a result of your recommendation, the company that does offer that product gives you a small commission. It&amp;#8217;s possible to promote affiliate products in several ways as a speaker: you might point your audience to a certain link to make their purchase through or give them a coupon code that gets them some benefit when they buy. Either way, the company you&amp;#8217;re marketing for will know how many sales you&amp;#8217;re responsible for.&lt;/p&gt;
&lt;p&gt;However, it is important to make it clear to your audience that you are benefiting if they make a purchase. Trying to hide your association with an affiliate product that you&amp;#8217;re promoting is rarely successful and your audience may feel betrayed if you attempt to do so. It doesn&amp;#8217;t take much to relieve such concerns, though: by announcing your association and moving on, you can be transparent without making a big deal of the whole thing.&lt;/p&gt;
&lt;p&gt;There are a variety of different types of affiliate programs. You may even be able to find a program that allows you to earn a commission from products you&amp;#8217;d like to promote even if you weren&amp;#8217;t earning money.&lt;/p&gt;
&lt;h3&gt;6. Use Your Expertise to Land Other Gigs&lt;/h3&gt;
&lt;p&gt;Once you&amp;#8217;ve successfully given a few talks, you&amp;#8217;ve got a seal of approval from the organizations you&amp;#8217;ve worked with: you&amp;#8217;re officially an expert on your chosen topic. In addition to using that expertise as leverage to sell any services or products you currently offer, you can also use it to land new gigs.&lt;/p&gt;
&lt;p&gt;The opportunities available to experts vary widely: you can be paid for writing articles about your area of expertise or for testifying in court trials that require an expert witness. It&amp;#8217;s all a question of what opportunities appeal to you and how hard you&amp;#8217;re willing to chase them. It&amp;#8217;s important to market yourself as an expert, as well as a speaker. Make it clear that you&amp;#8217;re open to other opportunities, even ones that you can&amp;#8217;t yet predict, both in your marketing materials and when you network.&lt;/p&gt;
&lt;h3&gt;7. Organize Your Own Events&lt;/h3&gt;
&lt;p&gt;After you&amp;#8217;ve been speaking a while, you may have picked up a solid understanding of how an event is organized. That can allow you to set up a small conference, a workshop series or another event that requires speakers. While you may still not get paid for speaking, you can earn money through ticket sales, sponsorships and other financial support for the event.&lt;/p&gt;
&lt;p&gt;It can require a lot of work to put on events, but if you work in a niche where attendees expect to have to pay for the pleasure, you can get an excellent return on the work you invest. Make full use of your opportunities to speak ahead of time if you&amp;#8217;re considering using your knowledge to set up your own events. Shadow the event organizer as much as she will allow and see how much you can pick up on just from being in the area. You can also sit in on talks given by other speakers and decide who you might like to have at your own events. Consider every speaking invitation an opportunity to scout out the competition.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=yGnm8F0ITnw:Kwpq4cRBdQA:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=yGnm8F0ITnw:Kwpq4cRBdQA:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=yGnm8F0ITnw:Kwpq4cRBdQA:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=yGnm8F0ITnw:Kwpq4cRBdQA:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=yGnm8F0ITnw:Kwpq4cRBdQA:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=yGnm8F0ITnw:Kwpq4cRBdQA:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=yGnm8F0ITnw:Kwpq4cRBdQA:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=yGnm8F0ITnw:Kwpq4cRBdQA:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=yGnm8F0ITnw:Kwpq4cRBdQA:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=yGnm8F0ITnw:Kwpq4cRBdQA:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=yGnm8F0ITnw:Kwpq4cRBdQA:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/yGnm8F0ITnw" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-marketing/monetize-your-speaking/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-marketing/monetize-your-speaking/</feedburner:origLink></item>
		<item>
		<title>How Nathan Barry Made $12,000 in eBook Income in 24 Hours</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/8d1rwrzxHpE/</link>
		<comments>http://freelanceswitch.com/freelance-writing/ebook-income-case-study/#comments</comments>
		<pubDate>Tue, 18 Jun 2013 13:00:41 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Writing]]></category>
		<category><![CDATA[case studies]]></category>
		<category><![CDATA[ebooks]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39895</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39895&amp;c=108884820' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39895&amp;c=108884820' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/preview-ebook-income-case-study.jpg" alt="preview-ebook-income-case-study" width="200" height="200" class="alignright imageborder size-full wp-image-39972" /&gt;&lt;/p&gt;
&lt;p&gt;Nathan Barry is a web designer who quit his job at a software company in October 2011 in order to work for himself.&lt;/p&gt;
&lt;p&gt;In 2012, his first year of being self-employed, Nathan managed to make $145,471 USD, which is more than double of what he used to make in his last job. Interesting thing here is that over $85,000 out of that was income from his two e-books, “App Design Handbook” and “Designing Web Applications”. Want to know how it all started and how you can have similar success?&lt;/p&gt;
&lt;p&gt;Let&amp;#8217;s take a look at the launch of Nathan&amp;#8217;s first e-book, “App Design Handbook”, with which he made over $12,000 in the first 24 hours, and uncover what he did right.&lt;span id="more-39895"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h3&gt;Starting Point&lt;/h3&gt;
&lt;p&gt;It&amp;#8217;s easy to look at Nathan now and say “Oh, he has a popular blog and a decent audience, no wonder he&amp;#8217;s doing well with his e-books.&lt;/p&gt;
&lt;p&gt;An important thing to understand here is that although Nathan is quite well-known now, that definitely wasn&amp;#8217;t the case when he started working on his first e-book.&lt;/p&gt;
&lt;p&gt;In fact, in June 2012, only 3 months before his “&lt;a href="http://nathanbarry.com/app-design-handbook/"&gt;App Design Handbook&lt;/a&gt;” launch, his blog was only getting around 100 visitors per day and he only had 100 RSS subscribers.&lt;/p&gt;
&lt;p&gt;That&amp;#8217;s why this particular launch is a great lesson for those who don&amp;#8217;t have a massive online following yet. Before you jump in, consider these points, which will help get your mindset on track:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;You don&amp;#8217;t need a popular blog in order to make money with your product.&lt;/strong&gt; Many people think that they need to build a high-traffic website first before they can sell anything. However, this can take years, and is a very inefficient way to go about it if your goal is to make money. What you really need is an &lt;a href="http://freelanceswitch.com/freelance-marketing/free-mailchimp-email-newsletter/"&gt;email list&lt;/a&gt;.&lt;/li&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;When you consider the option of failing from the very beginning, and make your decisions accordingly, you prevent yourself from being disappointed later on.&lt;/p&gt;&lt;/blockquote&gt;
&lt;li&gt;
&lt;strong&gt;You don&amp;#8217;t have to spend a lot of time in order to build a product that makes money.&lt;/strong&gt; That is another mindset that holds people back from making money online: they think that it will take years before they can earn their first dollar this way. &lt;/p&gt;
&lt;p&gt;Nathan&amp;#8217;s story is a proof that you can go from an idea to thousands of dollars in profit in 3 months provided that you do things the right way.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Pick an amount of time that you can afford to waste on a product that ends up being a complete failure.&lt;/strong&gt; Nathan mentioned in one of his interviews that the reason why he chose 3 months as a time frame for this project was because this was the amount of time that he was willing to spend on a personal project without guaranteed return on investment.&lt;/p&gt;
&lt;p&gt;When you consider the option of failing from the very beginning, and make your decisions accordingly, you prevent yourself from being disappointed later on.
&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;Picking an eBook Idea&lt;/h3&gt;
&lt;p&gt;Nathan knows a lot about creating iPhone apps: he has three apps of his own in the App Store and has created quite a few apps for other people as well. It wasn&amp;#8217;t difficult for him to come up with an idea for an ebook about app design. &lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/nathan-barry-case-study-app-design-handbook.jpg" alt="nathan-barry-case-study-app-design-handbook" width="550" height="199" class="alignright imageborder size-full wp-image-39902" /&gt;&lt;/p&gt;
&lt;p&gt;However, before investing time and energy into creating a product, Nathan wanted to make sure that there was an actual demand for it. He created a landing page that described the upcoming e-book and asked people who were interested in it to subscribe to his email list. Then, he drove some traffic to it, and got around 100 subscribers in a few weeks. &lt;/p&gt;
&lt;p&gt;That success was enough to convince Nathan that it&amp;#8217;s time to start writing the e-book. Keep in mind:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Always validate your ideas.&lt;/strong&gt; Most people are so convinced that their business idea is amazing that they don&amp;#8217;t bother to do a reality check. This often leads to wasting a lot of time, energy, and money on building something that nobody wants. &lt;/p&gt;
&lt;p&gt;You have to find ways to check whether there&amp;#8217;s enough demand for your product before creating it, even when the idea seems like an obvious winner.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;You can&amp;#8217;t sell free, you can&amp;#8217;t sell paid.&lt;/strong&gt; Squeeze pages are a cheap and effective way to validate your ideas. Put up a squeeze page in which you describe your product, offer a freebie, and ask people to subscribe to your email list. Then, drive some targeted traffic to it via guest posting, and see what happens. &lt;/p&gt;
&lt;p&gt;Getting 100-200 subscribers in a few weeks is a good indication that there&amp;#8217;s enough interest to justify creating that product. Keep in mind that if you can&amp;#8217;t convince people to give you their email addresses, you won&amp;#8217;t be able to convince them to give you their hard-earned money.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;Writing the “App Design Handbook”&lt;/h3&gt;
&lt;p&gt;The &amp;#8220;App Design Handbook&amp;#8221; is 125 pages + bonus material. Nathan made a comittment to write 1000 words everyday. He took it seriously, kept writing every single day, and after just a bit over three months from the day he started, the e-book was finished.&lt;/p&gt;
&lt;p&gt;It&amp;#8217;s important to set a daily writing quota for yourself. You won&amp;#8217;t get far if you only write when you are in the mood to write. One of the simplest ways to complete a big writing project is to commit to writing a set amount of words everyday (even 250 or 500 will do). This way, no matter how much you struggle with writing, you will have publishable material in your hands in due time.&lt;/p&gt;
&lt;h3&gt;Building a Pre-launch Email List&lt;/h3&gt;
&lt;p&gt;Nathan made sure to build an email list prior to the launch. He collected 100+ e-mail addresses just by creating a previously mentioned squeeze page and tweeting about it. Nathan also added an opt-in box under each of his blog posts. Then, he focused on writing valuable content, with hopes that people will like it, and sign up to his e-mail list. This way, he got around 800 subscribers prior to the book launch. Put these proven practices to good use:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;Build an e-mail list prior to the launch of the product.&lt;/strong&gt; Your launch will be much easier this way: you will be able to simply shoot an e-mail to hundreds or even thousands of people who already expressed an interest in whatever it is that you are selling. Keep in mind that the hardest part is not building a product, it is selling it.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Guest post on popular blogs in your niche.&lt;/strong&gt; Nathan mainly promoted his upcoming ebook on his blog. This might work well if you already have a huge audience. However, that wasn&amp;#8217;t the case with Nathan, and he could have built a much bigger list if he would have focused on &lt;a href="http://freelanceswitch.com/freelance-marketing/pitch-a-guest-post-email/"&gt;guest posting on popular blogs&lt;/a&gt; in his niche and driving that traffic to his squeeze page. Guest posting is the most effective way to build your pre-launch list fast.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;Choosing the Right Price&lt;/h3&gt;
&lt;p&gt;Nathan knew a bit about pricing, therefore he decided to offer the buyers three options: base package for 29$, middle package for 59$, and the highest package for 129$ (current prices are 39$, 79$, and 169$). &lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/nathan-barry-case-study-prices.jpg" alt="nathan-barry-case-study-prices" width="550" height="199" class="alignright imageborder size-full wp-image-39903" /&gt;&lt;/p&gt;
&lt;p&gt;He did all he could to push the buyers to the middle option, which in his opinion, provided the best value for it&amp;#8217;s price. He put these practices to good use:&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;There’s no such thing as an inherent value, there’s only the perceived value.&lt;/p&gt;&lt;/blockquote&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;Price based on value.&lt;/strong&gt; Many people who sell ebooks feel uncomfortable pricing them high because it doesn&amp;#8217;t cost anything to distribute ebooks (as opposed to paper books). This mindset is flawed, though:  as long as your product provides value to people, and they are willing to pay the price that you are asking, it doesn&amp;#8217;t matter how much it cost you to produce it. Charge a fair price for the value that you provide.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Offer several packages with different prices.&lt;/strong&gt; There&amp;#8217;s no such thing as an inherent value, there&amp;#8217;s only the perceived value. The price that people are willing to pay will largely depend on what they are comparing the product with: 59$ for an e-book seems outrageous when you compare the price with Kindle store prices, but it seems reasonable when you compare the price with the 129$ version of the same product. &lt;/p&gt;
&lt;p&gt;You want to have several different prices points in order to “anchor” people to the price range that you want. Otherwise, you might end up competing with Amazon&amp;#8217;s 0.99$ e-books, and that&amp;#8217;s &lt;a href="http://blog.asmartbear.com/selling-ebook.html"&gt;not a race you want to be in&lt;/a&gt;.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;Creating the Sales Page&lt;/h3&gt;
&lt;p&gt;Nathan made several interesting choices with his sales page:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;He asks people to opt-in to his e-mail list to get a sample chapter (although you can get it without opting-in as well).&lt;/li&gt;
&lt;li&gt;He nudges people towards the middle package with subtle design elements such as an orange “Buy it” button.&lt;/li&gt;
&lt;li&gt;He uses a quote from Mark Kwano, who is UX evangelist at Apple, as social proof (instead of an actual testimonial about his book).&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Take a look at the &lt;a href="http://nathanbarry.com/app-design-handbook/"&gt;App Design Handbook sales page&lt;/a&gt; to see how Nathan put these principles into action:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;Good design makes you look more credible.&lt;/strong&gt; You can see that Nathan&amp;#8217;s sales page looks much better than most sales pages out there. This makes people more likely to trust him and buy from him (especially considering that the product itself is about design).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;You should explain both features and benefits, but focus more on benefits.&lt;/strong&gt; Features are qualities of a product (e.g. these shoes are waterproof) and benefits are the advantage that someone will get from using that product (e.g. your feet will stay dry). &lt;/p&gt;
&lt;p&gt;In general, people buy because of the benefits, and then rationalize the purchase to themselves and others using features, therefore copywriting experts advise to always focus on benefits in your copy. Nathan&amp;#8217;s sales page is focused almost entirely on features and would probably convert better if he would talk more about the benefits.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Add social proof even if you have to get creative about it.&lt;/strong&gt; In general, having testimonials on your sales page increases the conversion rate, but if you don&amp;#8217;t have any testimonials yet, you can always add a quote about the topic by a well-known person. Surprisingly, it will still serve as social proof, even if it&amp;#8217;s a general quote.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;The Launch of “App Design Handbook”&lt;/h3&gt;
&lt;p&gt;Nathan had an an email list of around 800 subcribers at the day of the launch (he originally planned to get 1000 subscribers, but didn&amp;#8217;t make it on time). &lt;/p&gt;
&lt;p&gt;He sent out a free sample chapter to his email list a week before launch which led to a few unsubscribes, but overall made his subscribers more excited about the upcoming book.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/nathan-barry-case-study-sample-chapter.jpg" alt="nathan-barry-case-study-sample-chapter" width="550" height="239" class="alignright imageborder size-full wp-image-39904" /&gt;&lt;/p&gt;
&lt;p&gt;Nathan also made sure that there was some buzz about the ebook on the launch day itself. He had 5 guest posts of his go live on the September 4th which drove a lot of traffic to his sales page and helped him get noticed by the web design and web development community. &lt;/p&gt;
&lt;p&gt;Nathan ended up making over $1,000 USD within the first 10 minutes and over $12,000 withing the first 24 hours after the launch. Apply these pre-launch strategies to maximize success:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;It&amp;#8217;s extremely important to build an email list prior to the launch.&lt;/strong&gt; I know that I&amp;#8217;m repeating myself, but I can&amp;#8217;t stress it enough. Nathan&amp;#8217;s launch was so successful because he already had 800 people who had expressed interest in his ebook and wanted to be notified when it came out. It&amp;#8217;s very hard to have a successful launch without an email list.&lt;/li&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;Too many people obsess about the launch day itself. That’s a mistake: you should obsess about what you do prior to the launch.&lt;/p&gt;&lt;/blockquote&gt;
&lt;li&gt;&lt;strong&gt;It&amp;#8217;s good to create some buzz on the launch day, but it shouldn&amp;#8217;t be your main focus.&lt;/strong&gt; Having several guest posts of yours go live on popular blogs in your niche in the same day will make sure get you some attention. However, most of your sales on the launch day will come from your email list, not from the people who heard about you five minutes ago.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;It&amp;#8217;s what you do prior to the launch that matters.&lt;/strong&gt; Too many people obsess about the launch day itself. That&amp;#8217;s a mistake: you should obsess about what you do prior to the launch. That is what will make it or break it, not how many retweets you will get on the big day. Nathan managed to make over $12,000 in 24 hours because he focused on doing the right things for the entire summer, not because he did someting magical on September 4th.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Expect sales to decline very quick after the first 24 hours.&lt;/strong&gt; Keep in mind that you will probably make your biggest lump of money on the launch day. Don&amp;#8217;t expect to keep making thousands of dollars a day after that: sales will decline drastically in the coming week or two and then stabilize at some point.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;What Happened Next?&lt;/h3&gt;
&lt;p&gt;Nathan has three e-books for sale at the moment:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;“App Design Handbook” with which he made over $12,000 USD in 24 hours on the launch day.&lt;/li&gt;
&lt;li&gt;“Designing Web Applications” with which he made over $26,000 in 24 hours on the launch day.&lt;/li&gt;
&lt;li&gt;“Authority” with which he also made over $26,000 in 24 hours on the launch day&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Nathan has made well over $100,000  selling these ebooks in only 9 months from the day that he launched his “App Design Handbook”. Read more about &lt;a href="http://nathanbarry.com/self-doubt-launch-stats/"&gt;these three ebook launches&lt;/a&gt;. &lt;/p&gt;
&lt;p&gt;It&amp;#8217;s possible, you can make a living online. Nathan is a good example that if you do things right it&amp;#8217;s very realistic to make a decent amount of money selling info products. Keep in mind that he went from no experience with ebooks to making over $100 000 in e-book sales in only 9 months. It&amp;#8217;s amazing how much one&amp;#8217;s life can change in less than a year.&lt;/p&gt;
&lt;h3&gt;What are You Waiting For?&lt;/h3&gt;
&lt;p&gt;At the moment, there&amp;#8217;s a golden opportunity available for those who want to write and sell their own ebooks: there is a big demand due to Kindle and iPad sales, but the supply hasn&amp;#8217;t caught up with the demand yet. With the right topic it&amp;#8217;s not difficult to promote your ebook and get noticed.&lt;/p&gt;
&lt;p&gt;You are probably an expert at something. Why not find a problem that people are struggling with and write an ebook that offers a solution to that problem?&lt;/p&gt;
&lt;p&gt;Sure, there&amp;#8217;s a real chance that your first ebook won&amp;#8217;t be as successful as you would like it to be, but you will at least learn valuable business lessons, which will help you in your later endeavors. And, you just might hit the points we&amp;#8217;ve discussed just right and land some reliable income out of the gate.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8d1rwrzxHpE:24lkwG6uh0k:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8d1rwrzxHpE:24lkwG6uh0k:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8d1rwrzxHpE:24lkwG6uh0k:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8d1rwrzxHpE:24lkwG6uh0k:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8d1rwrzxHpE:24lkwG6uh0k:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8d1rwrzxHpE:24lkwG6uh0k:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8d1rwrzxHpE:24lkwG6uh0k:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8d1rwrzxHpE:24lkwG6uh0k:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8d1rwrzxHpE:24lkwG6uh0k:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8d1rwrzxHpE:24lkwG6uh0k:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8d1rwrzxHpE:24lkwG6uh0k:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/8d1rwrzxHpE" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-writing/ebook-income-case-study/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-writing/ebook-income-case-study/</feedburner:origLink></item>
		<item>
		<title>How to Write a Facebook Ad That Works</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/50sIPdz7mk0/</link>
		<comments>http://freelanceswitch.com/freelance-marketing/how-to-write-a-facebook-ad/#comments</comments>
		<pubDate>Tue, 18 Jun 2013 12:00:24 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Marketing]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39330</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39330&amp;c=1391970549' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39330&amp;c=1391970549' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/05/photodune-3883085-facebook-logo-billboard-sign-xs-2.jpg" alt="Facebook Logo Billboard Sign" width="360" height="235" class="alignright imageborder size-full wp-image-39457" /&gt;&lt;/p&gt;
&lt;p&gt;Facebook, the world&amp;#8217;s favorite social networking platform, is the ideal place to connect with potential clients. Having a &lt;a href="http://freelanceswitch.com/freelance-marketing/facebook-page-configuration/"&gt;Facebook page&lt;/a&gt; for your freelance business gives you the opportunity to engage with prospects, developing a relationship so that when they need help, you&amp;#8217;re the freelancer they turn to first.&lt;/p&gt;
&lt;p&gt;However, many new freelancers face the problem of how to grow their Facebook fan base. Just like getting your first client is the biggest and often the most difficult step in a freelancer&amp;#8217;s career, getting your first Facebook fans is the biggest and often the most difficult step in growing your Facebook Page. &lt;/p&gt;
&lt;p&gt;Having a few hundred fans gets the ball rolling, and helps you grow in two ways. First, you have the social proof of a dedicated fan base. Second, those fans help you spread the word about your business to their friends.&lt;/p&gt;
&lt;p&gt;What can you do to get your first few hundred Facebook fans?&lt;/p&gt;
&lt;p&gt;There are ways you can &lt;a href="http://freelanceswitch.com/freelance-marketing/get-more-fans-facebook/"&gt;grow your Facebook page organically&lt;/a&gt; for free. However, if you&amp;#8217;ve got a few dollars to spare, going for an ad campaign can give your Page the boost it needs quickly. I&amp;#8217;ve known freelancers who&amp;#8217;ve picked up 100&amp;#8242;s of fans overnight from a simple, low-cost ad campaign.&lt;/p&gt;
&lt;p&gt;Done right, ads can help you grow and reach your business goals. Get it wrong, and you could end up pouring your hard earned dollars into a white elephant.&lt;/p&gt;
&lt;p&gt;How can you write a Facebook ad that works?&lt;span id="more-39330"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;
&lt;h2&gt;Tutorial Assets&lt;/h2&gt;
&lt;p&gt;To complete this tutorial you will need:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;A Facebook Page for your freelance business.&lt;/li&gt;
&lt;li&gt;Images (or access to images. Stock photography is fine).&lt;/li&gt;
&lt;li&gt;Image editing software.&lt;/li&gt;
&lt;li&gt;A text editor.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;1. Prepare for Success&lt;/h3&gt;
&lt;p&gt;The success of your Facebook ad isn&amp;#8217;t only in the copy. It&amp;#8217;s also in the work you do before you even start writing.&lt;/p&gt;
&lt;h2&gt;Step 1: Check Facebook&amp;#8217;s Ad Guidelines&lt;/h2&gt;
&lt;p&gt;Facebook has a &lt;a href="http://www.facebook.com/ad_guidelines.php"&gt;strict set of rules&lt;/a&gt; on what you can and can&amp;#8217;t include in your ad.&lt;/p&gt;
&lt;p&gt;Most of the rules are obvious (be a decent human being!), but it&amp;#8217;s worth taking five minutes to make sure you don&amp;#8217;t shoot yourself in the foot with an ad that flouts Facebook&amp;#8217;s rules.&lt;/p&gt;
&lt;h2&gt;Step 2: Decide Who to Target&lt;/h2&gt;
&lt;p&gt;When you write an ad for Google, you target people with keywords. That way, you know your ad shows up for people searching for the service or product you provide. In that respect, Google ads are about &lt;em&gt;what&lt;/em&gt; people want.&lt;/p&gt;
&lt;p&gt;Facebook&amp;#8217;s different. People don&amp;#8217;t use Facebook to find solutions to problems. They go there to catch up with friends. Facebook is about people, and as such, Facebook ads target particular groups of people. Facebook ads are about &lt;em&gt;who&lt;/em&gt; you want to engage with.&lt;/p&gt;
&lt;p&gt;If you haven&amp;#8217;t done so before, it&amp;#8217;s time to think about the type of people you want to work with, and the type of people who need your services. Sit down and ask yourself:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;Where do they live?&lt;/li&gt;
&lt;li&gt;How old are they?&lt;/li&gt;
&lt;li&gt;What do they do in their free time?&lt;/li&gt;
&lt;li&gt;What business are they in?&lt;/li&gt;
&lt;li&gt;What&amp;#8217;s their family status?&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Facebook lets you target all of these aspects in ads. You can select everything from activities your target audience is interested in (from food to gardening to literature) to their interests (from beer to politics), to the films, movies and sports they like. You can check out the full range of categories at Facebook&amp;#8217;s &lt;a href="http://www.facebook.com/ads/create/"&gt;Create an Ad&lt;/a&gt; page.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-35481" alt="Facebook Ads" src="http://freelanceswitch.com/wp-content/uploads/2012/11/Facebook-Ads.png" width="550" height="484" /&gt;&lt;/p&gt;
&lt;p&gt;For some freelancers, the interests of their clients will be obvious. If you&amp;#8217;re a landscape gardener, or an interior designer, you can target those with a &amp;#8220;Home and Garden&amp;#8221; interest. If you provide web design services to restaurants, then aiming your ads at dedicated foodies is a safe bet. However, other freelancers may have to dig a little deeper.&lt;/p&gt;
&lt;p&gt;Consider sending out a survey to find out the demographics and interests of your current client base, so you know who to target. As a bonus, a survey where you allow respondents to craft their own answers will help you write your ad copy in a way that directly engages your target audience.&lt;/p&gt;
&lt;h2&gt;Step 3: Sharpen Your Focus&lt;/h2&gt;
&lt;p&gt;The tighter the focus of your ad, the better it will perform.&lt;/p&gt;
&lt;p&gt;You may discover your clients&amp;#8217; interests and demographics fall into several distinct groups. If this is the case, consider running a separate ad campaign for each group.&lt;/p&gt;
&lt;h2&gt;Step 4: Set a Budget&lt;/h2&gt;
&lt;p&gt;Advertising can be expensive, and during a campaign it&amp;#8217;s easy to get carried away by the thrill of the chase. As such, it&amp;#8217;s a good idea to set a budget for your campaign so you can hold yourself to that when you&amp;#8217;re tempted to splash out &amp;#8220;just five bucks more&amp;#8221;.&lt;/p&gt;
&lt;p&gt;Even a small budget can return significant results for a well-written ad.&lt;/p&gt;
&lt;h3&gt;2. Write Your Ad&lt;/h3&gt;
&lt;p&gt;As Facebook ads have been around for a few years, marketers have uncovered the types of ads that perform best. Even Facebook have chipped in with what works when writing an ad. Here are the steps to give your ad the best chance of success.&lt;/p&gt;
&lt;h2&gt;Step 1: Write Some Ads&lt;/h2&gt;
&lt;p&gt;It sounds obvious, but the best way to write ads is to write ads. With Facebook ads, the more ideas you can put together the better, as if you&amp;#8217;re running an extended campaign you&amp;#8217;ll want to try several different ads.&lt;/p&gt;
&lt;p&gt;If you can, come up with at least 20 ad ideas. Each one can be up to 90 characters long. However, shorter can be better, so don&amp;#8217;t feel obliged to fill your character allocation.&lt;/p&gt;
&lt;p&gt;Once you&amp;#8217;re done, use the following steps to tweak your best ideas.&lt;/p&gt;
&lt;h2&gt;Step 2: Pick Your Focus&lt;/h2&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;Give your ad a specific focus. People want to know exactly what they’ll get out of liking your ad or engaging with your company.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;Give your ad a specific focus. People want to know exactly what they&amp;#8217;ll get out of liking your ad or engaging with your company. For example, promoting your ebook will draw more engagement than promoting your business in general.&lt;/p&gt;
&lt;p&gt;You can focus on a specific service or product. To make your ad even more powerful, also focus on the benefits of working with you.&lt;/p&gt;
&lt;p&gt;&amp;#8220;Try our Twitter audit to generate 10% more leads from your tweets&amp;#8221; will perform better than &amp;#8220;Check out our website to find out how to do better on Twitter.&amp;#8221;&lt;/p&gt;
&lt;h2&gt;Step 3: Be Proud of Who You Are&lt;/h2&gt;
&lt;p&gt;According to Facebook&amp;#8217;s research time, ads that include the name of the company they&amp;#8217;re promoting perform better. Tweak your copy to include the name of your business.&lt;/p&gt;
&lt;p&gt;Say who the advertiser is. In other words, include the name of your business in your advert.&lt;/p&gt;
&lt;h2&gt;Step 4: Inject Personality&lt;/h2&gt;
&lt;p&gt;Do the tone of your ads reflect your brand image and personality? Are they written in a way you&amp;#8217;d speak to a friend? Ads that attract clicks give a strong sense of your company just from their tone.&lt;/p&gt;
&lt;p&gt;If you feel stuck with this, just have fun! Write as many wild and wacky ad ideas as you can think of. You don&amp;#8217;t have to use them, but by letting rip, you&amp;#8217;re opening the flow of your creativity.&lt;/p&gt;
&lt;p&gt;On top of having personality, your ads should be upbeat. The best performing ads make people smile, share interesting information, or leave viewers with a positive feeling.&lt;/p&gt;
&lt;h2&gt;Step 5: Ask For What You Want&lt;/h2&gt;
&lt;p&gt;It&amp;#8217;s a simple fact of marketing (and life in general) that if you ask for what you want, you&amp;#8217;re more likely to get it.&lt;/p&gt;
&lt;p&gt;Conclude your ad with a call to action. Use a phrase such as &amp;#8220;Click to like&amp;#8221;.&lt;/p&gt;
&lt;h2&gt;Step 6: Rinse and Repeat&lt;/h2&gt;
&lt;p&gt;Once you&amp;#8217;ve run through these steps with one of your ad ideas, go back and do it again with another.&lt;/p&gt;
&lt;p&gt;There&amp;#8217;s three reasons for this. First, ideas spark ideas, so the more you work on your ads, the more ideas you&amp;#8217;ll come up with.&lt;/p&gt;
&lt;p&gt;Second, Facebook ads have a short shelf life. If you&amp;#8217;re targeting your ad well, the same people will keep seeing your ad over and over again, so it will get old fast.&lt;/p&gt;
&lt;p&gt;Typically, interest in ads drops off after 3-5 days. If you&amp;#8217;re planning a campaign longer than this, you&amp;#8217;ll need to mix things up to maintain interest, so it&amp;#8217;s a good idea to have a series of ads up your sleeve.&lt;/p&gt;
&lt;p&gt;Third (I know I&amp;#8217;m repeating myself here, but this is vital), ads work best if they&amp;#8217;re targeted. By writing more ads, you can target different ads at different groups.&lt;/p&gt;
&lt;h2&gt;Step 7: Add Images&lt;/h2&gt;
&lt;p&gt;While this tutorial is primarily about the copy of your ad, the images you choose are also key to success. The most effective images:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;strong&gt;Stand out from the crowd&lt;/strong&gt;. Bright colors and an attention grabbing image are key here.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Use smiling faces&lt;/strong&gt; &amp;#8211; as long as they&amp;#8217;re relevant to your ad. Don&amp;#8217;t be shy if that means using an image of yourself. Facebook is a social network, and people relate to people.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Colored borders grab attention&lt;/strong&gt;, especially if the color contrasts with Facebook&amp;#8217;s blues and whites.&lt;/li&gt;
&lt;li&gt;Make sure your &lt;strong&gt;image reinforces the message&lt;/strong in your copy&gt; and your brand&amp;#8217;s personality.&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;3. Run Your Campaign&lt;/h3&gt;
&lt;p&gt;With your ad copy written and your image prepared, you can launch your campaign on Facebook.&lt;/p&gt;
&lt;p&gt;No ad is perfect, so it&amp;#8217;s okay to feel nervous at this stage. Besides, as you run your ad, you can use the stats from the campaign as feedback to improve your future ads.&lt;/p&gt;
&lt;h2&gt;Step 1: Launch Your Campaign&lt;/h2&gt;
&lt;p&gt;Head over to Facebook&amp;#8217;s &lt;a href="http://www.facebook.com/ads/create/"&gt;Create an Ad&lt;/a&gt; page. You&amp;#8217;ll be asked to input everything you&amp;#8217;ve prepared, including your budget, who you want to target, your ad copy and image.&lt;/p&gt;
&lt;h2&gt;Step 2: Monitor and Tweak&lt;/h2&gt;
&lt;p&gt;Check in daily to see how your campaign is going. The more you&amp;#8217;re willing to tweak, and try out different ideas for your copy and images, the better your results will be.&lt;/p&gt;
&lt;p&gt;In simple terms, see what works, and do more of it!&lt;/p&gt;
&lt;p&gt;&lt;em&gt;Photo credit: &lt;a title="Attribution License" href="http://photodune.net/wiki/support/legal-terms/licensing-terms/"&gt;Some rights reserved&lt;/a&gt; by &lt;a href="http://photodune.net/item/facebook-logo-billboard-sign/3883085"&gt;deberarr&lt;/a&gt;&lt;/em&gt;.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=50sIPdz7mk0:Mz44zy4le5k:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=50sIPdz7mk0:Mz44zy4le5k:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=50sIPdz7mk0:Mz44zy4le5k:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=50sIPdz7mk0:Mz44zy4le5k:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=50sIPdz7mk0:Mz44zy4le5k:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=50sIPdz7mk0:Mz44zy4le5k:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=50sIPdz7mk0:Mz44zy4le5k:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=50sIPdz7mk0:Mz44zy4le5k:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=50sIPdz7mk0:Mz44zy4le5k:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=50sIPdz7mk0:Mz44zy4le5k:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=50sIPdz7mk0:Mz44zy4le5k:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/50sIPdz7mk0" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-marketing/how-to-write-a-facebook-ad/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-marketing/how-to-write-a-facebook-ad/</feedburner:origLink></item>
		<item>
		<title>Freelance Freedom 315: Reply To All – Part 2</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/2xfbVs1dbls/</link>
		<comments>http://freelanceswitch.com/freelance-freedom/315-reply-to-all-part-2/#comments</comments>
		<pubDate>Mon, 17 Jun 2013 14:34:46 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Freedom Comic]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39885</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39885&amp;c=509600677' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39885&amp;c=509600677' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/FF315_ReplyToAllPart2.jpg" alt="FF315_ReplyToAllPart2" width="550" height="225" class="aligncenter size-full wp-image-39886" /&gt;&lt;/p&gt;
&lt;p&gt;Once a week, we feature a fantastic freelance-themed comic from the talented N.C. Winters. Why not also &lt;a href="http://freelanceswitch.com/category/freelance-freedom/"&gt;take a look at our comic archive&lt;/a&gt;?&lt;span id="more-39885"&gt;&lt;/span&gt;&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=2xfbVs1dbls:qtbgWJxA_F8:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=2xfbVs1dbls:qtbgWJxA_F8:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=2xfbVs1dbls:qtbgWJxA_F8:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=2xfbVs1dbls:qtbgWJxA_F8:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=2xfbVs1dbls:qtbgWJxA_F8:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=2xfbVs1dbls:qtbgWJxA_F8:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=2xfbVs1dbls:qtbgWJxA_F8:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=2xfbVs1dbls:qtbgWJxA_F8:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=2xfbVs1dbls:qtbgWJxA_F8:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=2xfbVs1dbls:qtbgWJxA_F8:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=2xfbVs1dbls:qtbgWJxA_F8:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/2xfbVs1dbls" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-freedom/315-reply-to-all-part-2/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-freedom/315-reply-to-all-part-2/</feedburner:origLink></item>
		<item>
		<title>What It Takes to Drive Home a Paid Speaking Gig</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/8eApJ-6Cnrw/</link>
		<comments>http://freelanceswitch.com/freelance-marketing/drive-home-a-paid-speaking-gig/#comments</comments>
		<pubDate>Wed, 12 Jun 2013 12:00:51 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Marketing]]></category>
		<category><![CDATA[public speaking]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39103</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39103&amp;c=328206146' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39103&amp;c=328206146' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/05/6-Drive-Home-Paid-Speaking-Gig.png" alt="6-Drive-Home-Paid-Speaking-Gig" width="200" height="200" class="alignright imageborder size-full wp-image-39165" /&gt;&lt;/p&gt;
&lt;p&gt;It&amp;#8217;s easy enough to land a speaking gig: every organization in your city wants a speaker to come in every once in a while. But that&amp;#8217;s not the same as driving home a paid speaking gig. &lt;/p&gt;
&lt;p&gt;To actually receive payment, beyond travel expenses or an event ticket, requires a different approach. You need to be more targeted, at the very least, in order to get paid for your talks.&lt;span id="more-39103"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h3&gt;There Has to Be a Budget&lt;/h3&gt;
&lt;p&gt;The biggest mistake new speakers make when trying to land a paid speaking gig is to approach organizations or events that just don&amp;#8217;t have a budget for paid speakers. If there isn&amp;#8217;t money, it&amp;#8217;s rare that they can magically come up with some just to bring on a new speaker. &lt;/p&gt;
&lt;p&gt;Before you even think of approaching an organization with a proposal, you need to do some digging. Have they paid speakers in the past? Is there a budget available for upcoming events? Like any other business, success lies in knowing who has the money and what they&amp;#8217;re prepared to spend it on.&lt;/p&gt;
&lt;p&gt;If you&amp;#8217;re having a hard time finding out if there&amp;#8217;s a budget, take a look at the level of event being put on: a small, organizational meeting is far less likely to have a budget than a large corporation putting on an annual event. There aren&amp;#8217;t any strict rules; some events (like conferences) will include a mix of paid and unpaid speakers). But making an educated guess can at least reduce the time you might otherwise waste on pitching event planners who can&amp;#8217;t afford you.&lt;/p&gt;
&lt;p&gt;Knowing who has the money, however, isn&amp;#8217;t enough to guarantee you a gig. It&amp;#8217;s just the start.&lt;/p&gt;
&lt;h3&gt;You Have to Be Worth Paying For&lt;/h3&gt;
&lt;p&gt;If an event planner visits your website, can she immediately tell that you&amp;#8217;re an excellent speaker and that everyone who hears you talk loves you? Can she tell that you have something new and interesting to say? Can she tell you&amp;#8217;re available for speaking gigs, at a price, and willing to travel? The answer to all of these questions has to be yes. Furthermore, your website is just the starting point of your marketing efforts.&lt;/p&gt;
&lt;blockquote class="pullquote"&gt;&lt;p&gt;The people who hire paid speakers for conferences and other events base their decisions on past performance.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;Until the right people can clearly tell that you&amp;#8217;re available, it&amp;#8217;s a lot harder to land a paid speaking gig, or even an unpaid opportunity. If you&amp;#8217;re relying on your professional site for another career to get you speaking opportunities, make sure that you at least have a page devoted to speaking. List your availability for paid work, as well — otherwise, an event planner may contact you assuming that they can get you to speak for free.&lt;/p&gt;
&lt;p&gt;You also need to make your niche clear. There is likely a specific type of audiences who you best connect with and who you have something crucial to tell. It&amp;#8217;s practically impossible to land a speaking gig if you&amp;#8217;re trying to be an expert in a wide variety of fields at once, so narrow things down. Be obvious about telling event planners your niche, so there can&amp;#8217;t be any mistakes.&lt;/p&gt;
&lt;p&gt;The people who hire paid speakers for conferences and other events base their decisions on past performance. That&amp;#8217;s why you may see the same speakers over and over again in certain circles. You need to be able to show these people a professional speaker&amp;#8217;s reel, with examples of past talks you&amp;#8217;ve given. That can require investing time in some unpaid speaking gigs and some money in developing a professional reel.&lt;/p&gt;
&lt;p&gt;It can take some time to build a reputation as a great speaker. It&amp;#8217;s like every other profession in that regard. If you need to sink some resources into building up your appeal as a speaker, do so before spending any resources on trying to land paid speaking gigs.&lt;/p&gt;
&lt;h3&gt;It&amp;#8217;s All About the Network&lt;/h3&gt;
&lt;p&gt;Like landing any other type of work, having the right network is crucial to a speaker. You need to invest time in networking with the right people: event planners, conference organizers and the like are usually the decision makers when it comes to lining up speakers. However, if you&amp;#8217;re looking to offer a very specialized type of public speaking, like motivational talks at colleges, you might be looking at a different group of people to network with. Either way, you need to identify the people who can offer you speaking opportunities.&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;You’ll want to build as much of a relationship as possible before you send in a proposal for a particular event.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;On a broad level, you need to have a long list of connections in the industry who will actively recommend you, as well as call you up with a paid gig every so often. That means attending their meetings and events, as well as plugging into their communities online. Treat event planners and other decision makers like clients — that&amp;#8217;s what they really are. You need to reach out to them to build the right connections to land work.&lt;/p&gt;
&lt;p&gt;If you take that logic down to a narrower view, you&amp;#8217;ll need to make a point to connect with the right individuals. You&amp;#8217;ll want to build as much of a relationship as possible before you send in a proposal for a particular event. Provided you can focus your energies on the right people (the ones with budgets, remember?), there&amp;#8217;s no reason not to reach out to them directly. Attend the same events, read their blogs, connect on social media: you can often build a solid relationship without ever sending a cold call or email.&lt;/p&gt;
&lt;p&gt;You can even prove to an event planner that you&amp;#8217;re an amazing speaker before ever asking her about a specific opportunity. Since you should only be approaching those people who are likely to want speakers in your specific niche, you&amp;#8217;re in a position to offer anyone local a taste of your work ahead of time. Since you&amp;#8217;ll likely wind up taking some unpaid speaking gigs in order to establish yourself, why not invite an event planner or two to each talk you give? They&amp;#8217;ll be able to see you in action and you may have done them a favor if it&amp;#8217;s an event they wouldn&amp;#8217;t have gone to otherwise.&lt;/p&gt;
&lt;h3&gt;Play the Speaker&amp;#8217;s Game&lt;/h3&gt;
&lt;p&gt;There are directories of speakers, as well as bureaus that help line up speakers for particular types of events. There&amp;#8217;s a fair amount of debate about how effective these platforms are for actually landing paid speaking opportunities. But even if someone hiring speakers doesn&amp;#8217;t actually find you through such platforms, they may use such tools to gather more information. Essentially, making use of such tools can help establish you as a professional. Since it&amp;#8217;s possible that someone can find you online and won&amp;#8217;t have a clear idea of your reliability, your inclusion in the proper directories or organizations can make you more trustworthy.&lt;/p&gt;
&lt;p&gt;While you don&amp;#8217;t need to be a member of every website out there that promises to help you land speaking gigs, it&amp;#8217;s worth picking a few to help cement your status as a top-notch speaker. Do the research to find out what sources are considered reliable in your niche and sign up with those sites.&lt;/p&gt;
&lt;p&gt;Make a point of asking anyone who hires you about what convinced them to do so, as well as for any other feedback you can. That information can be invaluable at the end of the year when you&amp;#8217;re deciding whether to renew your listing in a particular directory or your membership in an organization.&lt;/p&gt;
&lt;h3&gt;Never Stop Marketing&lt;/h3&gt;
&lt;p&gt;Speaking is one of those professions that requires you to regularly fill the marketing tank; otherwise, people can forget about you. Appearing as a speaker isn&amp;#8217;t enough to guarantee that you can keep landing more paying gigs. Event planners want to make sure that every event they organize is unique. That doesn&amp;#8217;t mean they can&amp;#8217;t have the same speakers over and over again, but those speakers need to be saying new things.&lt;/p&gt;
&lt;p&gt;It&amp;#8217;s common for speakers to pair their work with writing: articles, books and anything else that can get your name out there will do double-duty. It can convince the people you&amp;#8217;ve worked with in the past that you have something new to share, as well as get your name in front of people. To be an effective speaker, you have to be an expert, so make use of that fact.&lt;/p&gt;
&lt;p&gt;Keep a close eye on the rest of your marketing, as well. Keep updating your website and your speaking reel on a fairly regular basis. Maintain your relationships with your network and build new ones. Keep pushing to make sure that you know who needs a speaker and how much they can pay. The time that you can invest in your speaking career will pay off.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8eApJ-6Cnrw:JgEEtkwNzyY:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8eApJ-6Cnrw:JgEEtkwNzyY:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8eApJ-6Cnrw:JgEEtkwNzyY:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8eApJ-6Cnrw:JgEEtkwNzyY:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8eApJ-6Cnrw:JgEEtkwNzyY:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8eApJ-6Cnrw:JgEEtkwNzyY:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8eApJ-6Cnrw:JgEEtkwNzyY:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8eApJ-6Cnrw:JgEEtkwNzyY:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8eApJ-6Cnrw:JgEEtkwNzyY:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=8eApJ-6Cnrw:JgEEtkwNzyY:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=8eApJ-6Cnrw:JgEEtkwNzyY:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/8eApJ-6Cnrw" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-marketing/drive-home-a-paid-speaking-gig/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-marketing/drive-home-a-paid-speaking-gig/</feedburner:origLink></item>
		<item>
		<title>How To Clean Up Data in a CSV File</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/jkU_z4dE-Z4/</link>
		<comments>http://freelanceswitch.com/industry-tips/clean-up-data-in-a-csv-file/#comments</comments>
		<pubDate>Tue, 11 Jun 2013 12:00:06 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Tips & Tricks]]></category>
		<category><![CDATA[data]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39773</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39773&amp;c=514217541' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39773&amp;c=514217541' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/preview-how-to-clean-up-data-in-a-csv-file.png" alt="preview-how-to-clean-up-data-in-a-csv-file" width="200" height="200" class="alignright imageborder size-full wp-image-39830" /&gt;&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;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. &lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;&lt;span id="more-39773"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;h2&gt;Tutorial Assets&lt;/h2&gt;
&lt;p&gt;To complete this tutorial, you will need:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;an internet connection&lt;/li&gt;
&lt;li&gt;an email account&lt;/li&gt;
&lt;li&gt;a Google account (free)&lt;/li&gt;
&lt;li&gt;Microsoft Excel (optional)&lt;/li&gt;
&lt;li&gt;data that you want to clean up (see below for more examples)&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;What is a CSV File?&lt;/h3&gt;
&lt;p&gt;A CSV file is a “Comma Separated Value” file. This sort of file takes all your data and puts the headers of each column in the first row, then lists all your data in subsequent rows, with all non-numerical data enclosed in inverted commas (“like this”), followed by a comma.&lt;/p&gt;
&lt;p&gt;A CSV file can be read in many types of apps and software programs. At its most basic it is a text file. It takes all your data and parses it (i.e. breaks it down into its units of data), so that you can then feed the data back into another app.&lt;/p&gt;
&lt;p&gt;For example, here’s the data from Google’s Keyword tool for the keyword “CSV file”:&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/1-keyword-tool.png" alt="1-keyword-tool" width="550" height="148" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;And here’s a sample of how it looks in a CSV format: &lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/2-csv-file-example.png" alt="2-csv-file-example" width="550" height="185" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h3&gt;Why Clean Up Your Data?&lt;/h3&gt;
&lt;p&gt;Increasingly, clients are expecting you to be able to manage data when you work with them. For example, a freelancer working on writing SEO content for a client may be expected to show a list of which long-tail keywords are being used in each blog article scheduled for production, and to have these keywords added to a spreadsheet or content calendar. As a freelance content producer, you will be expected to produce compelling visuals to go with your articles. You can add simple infographics to your content by cleaning up a CSV file of your research statistics and then import this into a diagram or infographic tool.&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;As big data and opendata continue to become more commonplace, you can quickly increase the value of your business service offerings and reduce your workload by knowing how to move data around.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;If you run a micro business that provides social media services, you may be expected to show your client a week’s worth of tweets in advance, and then be able to schedule these to be tweeted at regular intervals throughout the week. Or you may be able to develop a business service where you help a client keep their contact data in sync between their email, marketing campaigns and customer relationship management (CRM) software.&lt;/p&gt;
&lt;p&gt;Maybe your business has grown big enough that you want to start using an invoicing and accounting app rather than a spreadsheet. You can clean up a CSV file of all your old financial data so it is imported easily into your invoicing app without having a heap of data re-entry to do.&lt;/p&gt;
&lt;p&gt;As big data and opendata continue to become more commonplace, you can quickly increase the value of your business service offerings and reduce your workload by knowing how to move data around. Being data proficient is a skill in great demand and can help you carve out a unique value proposition. Cleaning up CSV files is central to making the most of all of these opportunities.&lt;/p&gt;
&lt;h3&gt;&lt;span&gt;1.&lt;/span&gt; Creating a CSV File From a Spreadsheet&lt;/h3&gt;
&lt;h2&gt;Step 1: Open Your Spreadsheet File&lt;/h2&gt;
&lt;p&gt;A CSV file is simply a spreadsheet file saved in a text format so it can be moved to another software program or cloud-based app or tool. So first, you will need to open it in your spreadsheet software.&lt;/p&gt;
&lt;p&gt;If you are using Excel, open the file of data you want to move around (&lt;strong&gt;File &gt; Open…&lt;/strong&gt;). If you do not have Excel, you can signup to Google Drive with your Google account details. Google Drive offers an online cloud-based toolset which includes a spreadsheet tool. After you have signed up, open your spreadsheet in Google Drive.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/3-excel-drive-example.png" alt="3-excel-drive-example" width="550" height="310" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;The same spreadsheet in Excel (left) and Google Drive (right).&lt;/p&gt;
&lt;h2&gt;Step 2: Check Your File Basics&lt;/h2&gt;
&lt;p&gt;In Excel, make sure you only have one worksheet in your spreadsheet. Worksheets are shown at the bottom of Excel. They are normally named Sheet1, Sheet2, etc. Make sure there is only one sheet. If there is more than one sheet in the Workbook, click on the tab for each additional sheet and make sure there is no data on these pages. Then right-click on the tabs for Sheet 2 and so on and delete each additional sheet.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/4-excel-delete-extra-sheets.png" alt="4-excel-delete-extra-sheets" width="296" height="149" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h2&gt;Step 3: Save as a CSV File&lt;/h2&gt;
&lt;p&gt;In Excel, now select &lt;strong&gt;File &gt; Save As…&lt;/strong&gt;. Choose a name for your file and select &lt;strong&gt;Comma Separated Values&lt;/strong&gt; under the Format drop-down menu.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/5-excel-save-as-screenshot.png" alt="5-excel-save-as-screenshot" width="550" height="406" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;In Google Drive, select &lt;strong&gt;File &gt; Download as…&lt;/strong&gt;. Select &lt;strong&gt;Comma Separated Values&lt;/strong&gt; from the second menu box and save to your hard drive.&lt;/p&gt;
&lt;h3&gt;&lt;span&gt;2.&lt;/span&gt; Creating a CSV File From Data in an Online App or Webtool&lt;/h3&gt;
&lt;p&gt;When data is stored in an online app (such as FreshBooks, the invoicing and book-keeping app for small businesses) or website tool (such as the Google AdWords Keyword tool), it is necessary to use the app or tool’s import functions to save the data in a CSV file format.&lt;/p&gt;
&lt;h2&gt;Step 1: In Your Online App, Look for a Data Export Option&lt;/h2&gt;
&lt;p&gt;If you are wanting to create a CSV file using data in an online app, look for a menu option that lets you export the data from the app.&lt;/p&gt;
&lt;p&gt;In FreshBooks, for example, this is located under the &lt;strong&gt;My Account&lt;/strong&gt; menu. After you click on &lt;strong&gt;My Account&lt;/strong&gt; a second level menu appears, where you can select &lt;strong&gt;Import &amp;#038; Export&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;Now select &lt;strong&gt;Comma Separated File (CSV)&lt;/strong&gt; next to &lt;strong&gt;Export Clients, Invoices, Staff and Timesheets&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/6-freshbooks.png" alt="6-freshbooks" width="550" height="449" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;Other cloud-based apps may arrange their options differently. If there is not an option under “Account”, look for a “Settings” menu, or a “Data” menu option. You should be able to locate a similar menu option that allows you to save the data stored online into a CSV file.&lt;/p&gt;
&lt;h3&gt;Step 2: In a Web-Based Tool, Look For a “Save as CSV” Menu Option&lt;/h3&gt;
&lt;p&gt;For a webtool, look for a “save” menu option. For example, in the Google Adwords Keyword tool, there is a &lt;strong&gt;Save All&lt;/strong&gt; button above the list of keyword ideas. Click on &lt;strong&gt;Save All&lt;/strong&gt; to save a copy of all keywords from your search.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/7-keywords-save-a.png" alt="7-keywords-save-a" width="514" height="332" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;Now click the &lt;strong&gt;Download&lt;/strong&gt; button. Select &lt;strong&gt;All search results&lt;/strong&gt;. A dialog box will pop up, offering you the choice to save in CSV format. Click &lt;strong&gt;Download&lt;/strong&gt; to confirm. Depending on the size of the file, it may take a little time for this to be prepared.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/8-keywords-save-b.png" alt="8-keywords-save-b" width="371" height="172" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;Finally, you will be offered a dialog box to indicate where you would like to save the file.&lt;/p&gt;
&lt;p&gt;Other online tools work in a similar fashion.&lt;/p&gt;
&lt;hr /&gt;
&lt;h3&gt;&lt;span&gt;3.&lt;/span&gt; Cleaning a CSV File&lt;/h3&gt;
&lt;p&gt;Now that you have a CSV file, you will need to clean it up and make sure it is readable to wherever you want to send it. In some cases, you may just be wanting to use it in a spreadsheet.&lt;/p&gt;
&lt;p&gt;In other cases, you may need to clean up the CSV file so that you can then import it into another cloud-based app or online tool.&lt;/p&gt;
&lt;h2&gt;Step 1. Excel: Import Your CSV file into a Spreadsheet&lt;/h2&gt;
&lt;p&gt;In Excel, create a new workbook. Then select the &lt;strong&gt;Import&lt;/strong&gt; option from the &lt;strong&gt;File&lt;/strong&gt; menu.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/9-excel-import.png" alt="9-excel-import" width="268" height="420" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;A dialog box will pop up. Make sure &lt;strong&gt;CSV file&lt;/strong&gt; is selected and click the &lt;strong&gt;Import&lt;/strong&gt; button.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/10-freshbooks-example.png" alt="10-freshbooks-example" width="550" height="382" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;You can now select your CSV file from where you have saved it.&lt;/p&gt;
&lt;h2&gt;Step 2. Excel: Confirm Your Data is ‘Delimited’&lt;/h2&gt;
&lt;p&gt;In Excel, you will now be asked to confirm that your data is &lt;strong&gt;delimited&lt;/strong&gt;. That is, your CSV file is filled with data separated only by a comma. Excel should be able to automatically tell that this is correct. Now click the &lt;strong&gt;Next&lt;/strong&gt; button.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/11-excel-dialogbox1.png" alt="11-excel-dialogbox1" width="545" height="385" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h2&gt;Step 3. Excel: Confirm Your Data Columns&lt;/h2&gt;
&lt;p&gt;In Excel, you will now be shown a preview of how your data will be sorted into columns, based on the fact that your data is separated by commas, and text items may be enclosed in “inverted commas”. Check the data preview, and select or deselect delimiter options and text qualifier options until the preview reflects how you expect the data to look. In most of these cases, this will be chosen for you automatically. For example, Excel will know that all text data has a text qualifier of inverted commas, so it will let you know it plans to remove the inverted commas when it imports the data. When you are happy with how the data will be imported, click the &lt;strong&gt;Next&lt;/strong&gt; button.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/12-excel-dialogbox2.png" alt="12-excel-dialogbox2" width="531" height="459" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h2&gt;Step 4. Excel: Confirm Data Types&lt;/h2&gt;
&lt;p&gt;In Excel, you will now be asked to select what type of data is in each row. Select &lt;strong&gt;General&lt;/strong&gt; for all columns now (we will customize each column of data after it is imported). Double-check the advanced setting to ensure your data reflects standard conventions for numbers in their thousands and for decimal places.&lt;/p&gt;
&lt;p&gt;For example, if you are using a US data source, a comma is generally used to separate thousands,(e.g. “1,000”) and a full stop represents decimal points. It’s the other way around in Europe! So depending on your original data source, you may need to change these settings.&lt;/p&gt;
&lt;p&gt;Now click the &lt;strong&gt;Finish&lt;/strong&gt; button to import the CSV data into your Excel spreadsheet.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/13-excel-dialogbox3.png" alt="13-excel-dialogbox3" width="530" height="459" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h2&gt;Step 5. Excel: Choose Where to Import Your Data&lt;/h2&gt;
&lt;p&gt;Finally in Excel, you will be asked where you want to import the data. If you opened a new workbook at Step 1 above, select the &lt;strong&gt;Existing sheet&lt;/strong&gt; already chosen for you, then click &lt;strong&gt;OK&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/14-excel-dialogbox4.png" alt="14-excel-dialogbox4" width="550" height="279" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h2&gt;Step 6. Google Drive: Import Your CSV File into a New Spreadsheet&lt;/h2&gt;
&lt;p&gt;In Google Drive, you can do the above steps 1 – 5 in the one dialog box. First, create a new spreadsheet from the File menu. Now choose &lt;strong&gt;Import&lt;/strong&gt; from the File menu.&lt;/p&gt;
&lt;p&gt;A dialog box will appear. Select your CSV file from your hard drive.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/15-excel-dialogbox5.png" alt="15-excel-dialogbox5" width="394" height="177" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;Now select &lt;strong&gt;Replace spreadsheet&lt;/strong&gt;, as we have already opened a new spreadsheet.&lt;/p&gt;
&lt;p&gt;Check that the preview shows how you want your data distributed in columns. In most cases, this will automatically be set up correctly. If not, change the “separator character” to “tab” or “comma” to see if the data is now shown correctly in columns.&lt;/p&gt;
&lt;p&gt;Click the &lt;strong&gt;Import&lt;/strong&gt; button to proceed.&lt;/p&gt;
&lt;h2&gt;Step 7. Tidy Up Columns&lt;/h2&gt;
&lt;p&gt;As we will be cleaning your data spreadsheets, it will be easier to do so if you can see all your data in neat columns. Adjust the width of columns to better show the data. Move your cursor between the column letters at the top of either Excel or Google Drive until the cursor turns into a width movement symbol and stretch the column width so that your data is easier to read.&lt;/p&gt;
&lt;h2&gt;Step 8. Check Your Header Row&lt;/h2&gt;
&lt;p&gt;Now check that your first row has the correct column headings. When you import some data from some sources, you may have the dates down the left column (the y-axis) and the values along the rest of the row, starting from the second column (the x-axis). So the very first column on the x-axis will be left blank.&lt;/p&gt;
&lt;p&gt;For example:&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/16-gdrive-dialogbox.png" alt="16-gdrive-dialogbox" width="550" height="360" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;If that’s the case, enter a description (for now) for the first column, for example “Date” or “Month”.&lt;/p&gt;
&lt;p&gt;If you are using your CSV data in a spreadsheet, you can also set the first row as your column headings. This is useful if you are working with large sets of data where you may scroll down and not be able to see the headings row.&lt;/p&gt;
&lt;p&gt;In Excel, click on &lt;strong&gt;Page Layout&lt;/strong&gt; under the &lt;strong&gt;File&lt;/strong&gt; menu. Choose &lt;strong&gt;Sheet&lt;/strong&gt; from the menu in the popup dialog box and click on the row in your spreadsheet for the column headings. It should now be indicated in the box &lt;strong&gt;rows to repeat at top&lt;/strong&gt; usually as &lt;strong&gt;$1:$1&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/17-excel-headers.png" alt="17-excel-headers" width="550" height="436" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;In Google Drive, select &lt;strong&gt;Freeze row&lt;/strong&gt; from the &lt;strong&gt;View&lt;/strong&gt; menu and select &lt;strong&gt;Freeze 1 row&lt;/strong&gt; to indicate the header row.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/18-gdrive-headers.png" alt="18-gdrive-headers" width="401" height="434" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;h2&gt;Step 9. Confirm What Data You Need&lt;/h2&gt;
&lt;p&gt;If you are cleaning up this data because you will be moving it into another online tool or app, check the requirements for importing data into your destination app (see the Use Case examples under Section 3. Moving Data, below).&lt;/p&gt;
&lt;p&gt;If you are cleaning your CSV file to share it in a spreadsheet, confirm with your client what data they want you to be able to show.&lt;/p&gt;
&lt;h2&gt;Step 10. Delete Unnecessary Data&lt;/h2&gt;
&lt;p&gt;&lt;em&gt;Note: You may want to save a copy of your spreadsheet before you start deleting any data, just in case you change your mind or need it later on.&lt;/em&gt;&lt;/p&gt;
&lt;p&gt;Now remove any columns you will not need. For example, if you want to import your keyword research into a content calendar, you may only be interested in the keyword and local monthly search volume columns.&lt;/p&gt;
&lt;p&gt;You can delete the columns you don’t need by clicking on the column header letter until the whole column is shaded. Now choose &lt;strong&gt;Delete&lt;/strong&gt; from the &lt;strong&gt;Edit&lt;/strong&gt; menu (in Excel) or &lt;strong&gt;Delete column&lt;/strong&gt; from the Edit menu (in Google Drive).&lt;/p&gt;
&lt;h2&gt;Step 11. Make Sure Date Columns are in the Right Date Format&lt;/h2&gt;
&lt;p&gt;Again, check where you will be importing the data for any requirements (see section 3 user cases below).&lt;/p&gt;
&lt;p&gt;If your CSV file data includes dates, select the column with the dates.&lt;/p&gt;
&lt;p&gt;In Excel, select &lt;strong&gt;Cells…&lt;/strong&gt; from the &lt;strong&gt;Format&lt;/strong&gt; menu. Now select &lt;strong&gt;Number&lt;/strong&gt; from the top row menu, and &lt;strong&gt;Date&lt;/strong&gt; from the lefthand side menu. Choose the date menu that corresponds with the import requirements, or select the most readable version for you and your client, if you are just importing the data into your own spreadsheets.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/19-excel-format.png" alt="19-excel-format" width="544" height="375" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;In Google Drive, select the column and the click on the button that reads &lt;strong&gt;123&lt;/strong&gt; in the toolbar. Choose a date format from the list, or select more formats to see an additional menu of date format options.&lt;/p&gt;
&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/20-gdrive-format.png" alt="20-gdrive-format" width="452" height="872" class="imageborder aligncenter" /&gt;&lt;/p&gt;
&lt;p&gt;If your CSV file requires times to be included with the dates, make sure they are in the right format (hh:mm or hh:mm:ss).&lt;/p&gt;
&lt;p&gt;If your CSV file requires dates and times to be in separate columns, copy the whole column, then format the first column to be in date only format, and the second column to be in time only format. The rest of the data will be automatically removed.&lt;/p&gt;
&lt;h2&gt;Step 12. Make Sure All Numbers are Uniform&lt;/h2&gt;
&lt;p&gt;Any columns with numerical data are best formatted by removing the thousand separators so numbers appear as 23000 for example and not 23,000.&lt;/p&gt;
&lt;p&gt;In Excel, select the column, and again choose &lt;strong&gt;Cells…&lt;/strong&gt; from the Format menu. Choose &lt;strong&gt;Number&lt;/strong&gt; from the horizontal menu, and &lt;strong&gt;Number&lt;/strong&gt; from the lefthand menu. Make sure &lt;strong&gt;Use 1000 separator&lt;/strong&gt; is unchecked.&lt;/p&gt;
&lt;p&gt;Google Drive insists on using thousand separators. This will not affect your CSV imports, but may be confusing if your clients are European. Click on the column to select it, select the &lt;strong&gt;Format&lt;/strong&gt; menu option and click on &lt;strong&gt;Number&lt;/strong&gt;, then select &lt;strong&gt;Normal&lt;/strong&gt;.&lt;/p&gt;
&lt;h2&gt;Step 13. Add Columns You Do Need&lt;/h2&gt;
&lt;p&gt;Check the list of data you need that you created at Step 9. Add columns to your spreadsheet for each of these. Some online tools also require that data be ordered in a particular way (for example, scheduling tweets may require a specific order for your CSV file data). If that’s the case, move the columns now to match the preferred import order where you will be sending the data.&lt;/p&gt;
&lt;p&gt;Now make sure the column headings are an exact match for what your importing destination is expecting. Do not use inverted commas at this stage for headings or any text data in your columns.&lt;/p&gt;
&lt;h2&gt;Step 14. Incorporate Cleaned Data into Your Working Spreadsheets&lt;/h2&gt;
&lt;p&gt;In some cases, such as cleaning your keyword data, you may not be looking to add it to any destination source, other than a content calendar. Save a copy of your spreadsheet as a backup file, and then select the columns you want to move into your content calendar. Copy these columns now and paste them into their destination spreadsheet.&lt;/p&gt;
&lt;h2&gt;Step 15. Save Cleaned Data as a CSV File Ready to Import into an Online Tool&lt;/h2&gt;
&lt;p&gt;If the final destination for your cleaned data is to add it to another program, you are now ready to save this spreadsheet as a CSV file so you can import it into an online app or webtool.&lt;/p&gt;
&lt;p&gt;Repeat Section 1 Creating a CSV file from a spreadsheet again.&lt;/p&gt;
&lt;hr /&gt;
&lt;h3&gt;&lt;span&gt;4.&lt;/span&gt; Moving Data from a CSV File into an Online App or Web Tool&lt;/h3&gt;
&lt;p&gt;In many cases, you will need to move your data into another online app or webtool to complete your work.&lt;/p&gt;
&lt;p&gt;To make sure your data will be able to be read by the app you are adding it to, check any requirements for what columns and data need to be included.&lt;/p&gt;
&lt;p&gt;Look for a menu option like “Account”, “Settings”, or “Data” and review the import data information. Alternatively, check the help section of the app/web tool. Look for what column headings you need to use and the required format for each column of data. For example, if you are adding data to a Google Calendar, you would need columns for Start Date, Start Time, End Date, End Time, Subject and (as an option) Venue.&lt;/p&gt;
&lt;p&gt;On the other hand, if you were importing data on your project work into a time tracking app like Toggl, they want a column for Start Time, but instead of End Time, you need to have a column for Task Duration, in which you indicate how much time was spent on the task rather than it’s end time.&lt;/p&gt;
&lt;p&gt;Each online app and webtool may be slightly different, so being able to clean data in CSV files means getting acquainted with user documentation and online guides to importing data.&lt;/p&gt;
&lt;h3&gt;What are Your Data Needs?&lt;/h3&gt;
&lt;p&gt;What are your current data needs? Have you used CSV formatted files to move important data for your business from one application to another? Let us know about your data projects in the comments below.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=jkU_z4dE-Z4:kUGnnbdGJCI:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=jkU_z4dE-Z4:kUGnnbdGJCI:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=jkU_z4dE-Z4:kUGnnbdGJCI:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=jkU_z4dE-Z4:kUGnnbdGJCI:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=jkU_z4dE-Z4:kUGnnbdGJCI:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=jkU_z4dE-Z4:kUGnnbdGJCI:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=jkU_z4dE-Z4:kUGnnbdGJCI:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=jkU_z4dE-Z4:kUGnnbdGJCI:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=jkU_z4dE-Z4:kUGnnbdGJCI:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=jkU_z4dE-Z4:kUGnnbdGJCI:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=jkU_z4dE-Z4:kUGnnbdGJCI:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/jkU_z4dE-Z4" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/industry-tips/clean-up-data-in-a-csv-file/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/industry-tips/clean-up-data-in-a-csv-file/</feedburner:origLink></item>
		<item>
		<title>Freelance Freedom 314: Reply To All – Part 1</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/fRmgmOIe1HE/</link>
		<comments>http://freelanceswitch.com/freelance-freedom/314-reply-to-all-part-1/#comments</comments>
		<pubDate>Mon, 10 Jun 2013 12:00:08 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Freedom Comic]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39875</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39875&amp;c=1322335941' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39875&amp;c=1322335941' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/FF314_ReplyToAllPart1.jpg" alt="FF314_ReplyToAllPart1" width="550" height="225" class="aligncenter size-full wp-image-39876" /&gt;&lt;/p&gt;
&lt;p&gt;Once a week, we feature a fantastic freelance-themed comic from the talented N.C. Winters. Why not also &lt;a href="http://freelanceswitch.com/category/freelance-freedom/"&gt;take a look at our comic archive&lt;/a&gt;?&lt;span id="more-39875"&gt;&lt;/span&gt;&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=fRmgmOIe1HE:MrR8WHoY1UE:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=fRmgmOIe1HE:MrR8WHoY1UE:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=fRmgmOIe1HE:MrR8WHoY1UE:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=fRmgmOIe1HE:MrR8WHoY1UE:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=fRmgmOIe1HE:MrR8WHoY1UE:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=fRmgmOIe1HE:MrR8WHoY1UE:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=fRmgmOIe1HE:MrR8WHoY1UE:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=fRmgmOIe1HE:MrR8WHoY1UE:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=fRmgmOIe1HE:MrR8WHoY1UE:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=fRmgmOIe1HE:MrR8WHoY1UE:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=fRmgmOIe1HE:MrR8WHoY1UE:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/fRmgmOIe1HE" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-freedom/314-reply-to-all-part-1/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-freedom/314-reply-to-all-part-1/</feedburner:origLink></item>
		<item>
		<title>Top Freelance Jobs from Job Board – Week 1, June</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/L_N2F_48huw/</link>
		<comments>http://freelanceswitch.com/finding/top-freelance-jobs-from-job-board-week-1-june-2/#comments</comments>
		<pubDate>Sat, 08 Jun 2013 15:20:48 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Finding Work]]></category>
		<category><![CDATA[finding work]]></category>
		<category><![CDATA[freelance jobs]]></category>
		<category><![CDATA[freelance work]]></category>
		<category><![CDATA[job board]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39867</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39867&amp;c=1758627645' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39867&amp;c=1758627645' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p style="text-align: center"&gt;&lt;img class="aligncenter" title="freelancejobs" src="http://freelanceswitch.com/wp-content/uploads/2011/02/freelancejobs.png" alt="" width="520" height="160" /&gt;&lt;/p&gt;
&lt;p&gt;Looking for a new client? The FreelanceSwitch &lt;a href="http://jobs.freelanceswitch.com/jobs"&gt;job board&lt;/a&gt; is a great resource of freelance gigs and opportunities. These opportunities are in various fields, from development to writing to design, and come from a wide range of potential clients. The job board is hand-moderated by dedicated staff and volunteers from the freelance community.&lt;/p&gt;
&lt;p&gt;Each week, we&amp;#8217;ll feature a selection of the best job opportunities posted for the week. This week, we&amp;#8217;re featuring jobs in Mobile Phone App Development, Web Design, Web Development and more!&lt;/p&gt;
&lt;p&gt;To apply for any of these jobs, simply pick up a &lt;a href="http://jobs.freelanceswitch.com/account/subscription"&gt;FreelanceSwitch membership&lt;/a&gt; for an affordable $7 a month. See something you like? &lt;a href="http://jobs.freelanceswitch.com/account/subscription"&gt;Join now!&lt;/a&gt;&lt;img title="More..." src="http://freelanceswitch.com/wp-includes/js/tinymce/plugins/wordpress/img/trans.gif" alt="" /&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="more-39867"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h3&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22860-freelance-phonegap-app-builder-wordpress"&gt;Freelance Phonegap App Builder &amp;#8211; WordPress&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;&lt;strong&gt;Budget: $1,000 to $2,500&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;We are looking for a freelancer with Phonegap and WordPress experience to design a mobile application that will link to properties listed on a WordPress website to display within native iOS and Android applications.  &lt;/p&gt;
&lt;p&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22860-freelance-phonegap-app-builder-wordpress"&gt;Learn more &amp;amp; apply!&lt;/a&gt;&lt;/p&gt;
&lt;h3&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22849-talented-and-creative-web-designer"&gt;Talented and Creative Web Designer&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;&lt;strong&gt;Budget: $100 to $500&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Looking for a Talented and Creative web designer for a long term work and able to create a clean and modern looks.&lt;/p&gt;
&lt;p&gt;It is very important to bring some idea, with someone who is familiar with HTML or WordPress is a plus.&lt;/p&gt;
&lt;p&gt;We’re a theme club which we’ll code the design to a CMS theme and resell them.&lt;/p&gt;
&lt;p&gt;Project Description:&lt;/p&gt;
&lt;p&gt;We need 5pages standard website in Business category like company profile, education, insurance company, travel, etc.(with Dummy images included for display purpose).&lt;br /&gt;
Since we need to fill up our category, we will need few designers working on different category at the same time.&lt;br /&gt;
It&amp;#8217;s going to be a long term work for someone who is qualified in working on this project. &lt;/p&gt;
&lt;p&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22849-talented-and-creative-web-designer"&gt;Learn more &amp;amp; apply!&lt;/a&gt;&lt;/p&gt;
&lt;h3&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22847-bachelorette-business-talented-designer-and-developer-required"&gt;Bachelorette Business: Talented designer and developer required&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;&lt;strong&gt;Budget: $10,000+&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;We are a team of four women who are dedicated to revolutionizing bachelorette party planning.  Incubated at Harvard Business School, our company, Project Bachelorette, is working to become the premier online destination for women planning and attending bachelorette parties.  We offer integrated planning tools that make party coordination easy and enjoyable, fun and spunky content to inspire and assist, and irresistible travel packages that simplify the party planning process.&lt;/p&gt;
&lt;p&gt;Our initial prototype received strong interest from users and investors and we are now looking to take our product to the next level with the help of a dedicated web designer and developer. You can watch a video about the first version of our product here. The ideal candidate will be excited about our mission and have a strong background in both design and development. Compensation may include equity.   &lt;/p&gt;
&lt;p&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22847-bachelorette-business-talented-designer-and-developer-required"&gt;Learn more &amp;amp; apply!&lt;/a&gt;&lt;/p&gt;
&lt;h3&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22850-ios-developer"&gt;iOS developer&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;&lt;strong&gt;Budget: $2,500 to $5,000&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;We&amp;#8217;re looking for an experienced iOS developer that is highly skilled in writing native iOS apps.&lt;br /&gt;
Must be available in US timezone and be able to follow instructions. Delivery of work is expected on time without excuses. No chance takers.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22850-ios-developer"&gt;Learn more &amp;amp; apply!&lt;/a&gt;&lt;/p&gt;
&lt;h3&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22846-ecommerce-with-custom-data-php"&gt;eCommerce with custom data (PHP)&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;&lt;strong&gt;Budget: $1,000 to $2,500&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;I&amp;#8217;m looking for a PHP developer to build a custom e-commerce. The data comes in flat text files and needs to be imported on demand to the store using a script. The clients then can login, browse the categories. The item display contains unique set of data. Client can print out the display and add to cart and continue shopping. The cart execution will not charge the client but rather send the information back to request the quote. Client can see what quotes iit has requested and we can see that quotes has been requested. Historical data.&lt;/p&gt;
&lt;p&gt;This can be possible be done in CakePHP, Lvarel, CodeIngiter, and maybe even Foxycart. Layout design to the bear minimum bootstrap should be fine and enough for this.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://jobs.freelanceswitch.com/jobs/22846-ecommerce-with-custom-data-php"&gt;Learn more &amp;amp; apply!&lt;/a&gt;&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=L_N2F_48huw:XWVwX5DK07s:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=L_N2F_48huw:XWVwX5DK07s:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=L_N2F_48huw:XWVwX5DK07s:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=L_N2F_48huw:XWVwX5DK07s:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=L_N2F_48huw:XWVwX5DK07s:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=L_N2F_48huw:XWVwX5DK07s:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=L_N2F_48huw:XWVwX5DK07s:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=L_N2F_48huw:XWVwX5DK07s:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=L_N2F_48huw:XWVwX5DK07s:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=L_N2F_48huw:XWVwX5DK07s:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=L_N2F_48huw:XWVwX5DK07s:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/L_N2F_48huw" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/finding/top-freelance-jobs-from-job-board-week-1-june-2/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/finding/top-freelance-jobs-from-job-board-week-1-june-2/</feedburner:origLink></item>
		<item>
		<title>How to Create an Email Newsletter with MailChimp for Free</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/lzAbhez2EEE/</link>
		<comments>http://freelanceswitch.com/freelance-marketing/free-mailchimp-email-newsletter/#comments</comments>
		<pubDate>Thu, 06 Jun 2013 12:00:32 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Marketing]]></category>
		<category><![CDATA[email marketing]]></category>
		<category><![CDATA[email newsletter]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=39066</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39066&amp;c=837607071' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=39066&amp;c=837607071' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/05/preview-create-an-email-newsletter-with-mailchimp.png" alt="preview-create-an-email-newsletter-with-mailchimp" width="200" height="200" class="alignright imageborder size-full wp-image-39085" /&gt;&lt;/p&gt;
&lt;p&gt;MailChimp offers a high quality email service, and you don&amp;#8217;t pay a cent until you hit more than 2,000 subscribers. MailChimp calls it &amp;#8220;Forever Free&amp;#8221;.&lt;/p&gt;
&lt;p&gt;If you&amp;#8217;re planning to sell products online, other email newsletter providers, such as &lt;a href="http://aweber.com/?416710"&gt;Aweber&lt;/a&gt;, offer more options for segmenting your lists and targeting particular subscribers.&lt;/p&gt;
&lt;p&gt;MailChimp, however, is charming, quirky, and perfect for freelancers looking to stay in touch with clients and prospects once or twice a month. In fact, it powers our &lt;a href="http://freelanceswitch.com/newsletter-series/"&gt;FreelanceSwitch newsletter&lt;/a&gt; and is a quality service we highly recommend. In this tutorial, you&amp;#8217;ll learn how to get started with MailChimp for $0.00.&lt;span id="more-39066"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;h2&gt;Tutorial Assets&lt;/h2&gt;
&lt;p&gt;For this tutorial, you will need:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;A website or blog&lt;/li&gt;
&lt;li&gt;An email address&lt;/li&gt;
&lt;/ul&gt;
&lt;h3&gt;The Power of Email Marketing&lt;/h3&gt;
&lt;p&gt;Email became part of our world in the early 90&amp;#8242;s. This was a time when kids played SuperMario on the SNES, when if you wanted to &amp;#8220;download&amp;#8221; a music track your only option was to record it off the radio (or buy the CD or cassette), and when Bill Clinton had just been sworn in as President.&lt;/p&gt;
&lt;p&gt;Email has stood by and watched the rise and fall of numerous web technologies and empires &amp;#8211; from MySpace to Napster to AOL.&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;If you’ve got a website or blog, setting up an email list should be the next step in your marketing strategy.&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;Email is here to stay. If you want to build long-term relationships with your clients and prospects, email should be your tool of choice.&lt;/p&gt;
&lt;p&gt;Still not convinced? The stats should win you over.&lt;/p&gt;
&lt;p&gt;Back in 2010, research by Exact Target found 62% of internet users start their online day with email. With the rise of smartphones, email has become an even more intimate part of our lives, carried with us everywhere in our pockets.&lt;/p&gt;
&lt;p&gt;According to &lt;a href="http://www.campaignbrief.com/wa/2013/02/exacttarget-research-reveals-e.html"&gt;research published this year&lt;/a&gt;, 93% of consumers subscribe to at least one brand&amp;#8217;s email, and 49% of consumers have made a purchase as a direct result of an email marketing message.&lt;/p&gt;
&lt;p&gt;If you&amp;#8217;ve got a website or blog, setting up an email list should be the next step in your marketing strategy.&lt;/p&gt;
&lt;p&gt;Creating a list doesn&amp;#8217;t have to be complicated or expensive. In fact, with &lt;a href="http://eepurl.com/xsiZX"&gt;MailChimp&lt;/a&gt;, you can start your email list for free.&lt;/p&gt;
&lt;h3&gt;1. Sign Up For MailChimp&lt;/h3&gt;
&lt;h2&gt;Step 1: Visit the Chimp&lt;/h2&gt;
&lt;p&gt;Head over to &lt;a href="http://eepurl.com/xsiZX"&gt;MailChimp.com&lt;/a&gt; and click &lt;strong&gt;Sign Up Free&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://eepurl.com/xsiZX"&gt;&lt;img class="aligncenter imageborder size-full wp-image-39067" alt="Image 1" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-11.png" width="550" height="353" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;h2&gt;Step 2: Create Your Account&lt;/h2&gt;
&lt;p&gt;Enter your email address, and choose a username and password.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39068" alt="Image 2" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-21.png" width="542" height="601" /&gt;&lt;/p&gt;
&lt;p&gt;When you click &lt;strong&gt;Create My Account&lt;/strong&gt;, you agree to MailChimp&amp;#8217;s terms. The main things to note are that MailChimp reserve the right to view and review your emails. You&amp;#8217;re also not allowed to send out spam. (Find out what spam really means &lt;a href="http://www.spamhaus.org/consumer/definition/"&gt;here&lt;/a&gt;) .&lt;/p&gt;
&lt;h2&gt;Step 3: Welcome to the Party&lt;/h2&gt;
&lt;p&gt;Once you&amp;#8217;ve signed up you&amp;#8217;ll be sent an email filled with typical MailChimp charm.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39069" alt="Image 3" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-31.png" width="550" height="387" /&gt;&lt;/p&gt;
&lt;p&gt;Click the red button to get things going! You&amp;#8217;ll be asked to enter a reCAPTCHA phrase to prove you&amp;#8217;re human and not a spammer.&lt;/p&gt;
&lt;h2&gt;Step 4: Fill Out Your Details&lt;/h2&gt;
&lt;p&gt;Now, go to the &lt;a href="https://login.mailchimp.com"&gt;login page&lt;/a&gt; and enter your username and password.&lt;/p&gt;
&lt;p&gt;You&amp;#8217;ll be asked for your name and physical address. You must enter these before you can continue.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39073" alt="Image 4" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-42.png" width="550" height="410" /&gt;&lt;/p&gt;
&lt;p&gt;You&amp;#8217;ll also be asked for your website address and industry. MailChimp visits your website and uses it to automagically create a color palette for your newsletter. Entering your industry allows you to see how your newsletter performs compared to others in your sector. &lt;em&gt;Professional Services&lt;/em&gt; or &lt;em&gt;Creative Services&lt;/em&gt; are good choices for most web-based freelancers.&lt;/p&gt;
&lt;p&gt;When you&amp;#8217;re done, click &lt;strong&gt;Save And Get Started&lt;/strong&gt;.&lt;/p&gt;
&lt;h2&gt;Step 5: Understand The Lingo&lt;/h2&gt;
&lt;p&gt;Next, MailChimp introduces you to its jargon. In short:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;A &lt;em&gt;form&lt;/em&gt; is where people sign up to your email list on your website. If you&amp;#8217;ve ever signed up to receive an email newsletter by entering your name and email address, you used a form.&lt;/li&gt;
&lt;li&gt;A &lt;em&gt;list&lt;/em&gt; is the group of people who&amp;#8217;ve filled in your form to receive emails from you. You can have more than one list.&lt;/li&gt;
&lt;li&gt;&lt;em&gt;Templates&lt;/em&gt; are the design of your emails. Once you&amp;#8217;ve created a template, you can use it for as many emails as you like.&lt;/li&gt;
&lt;li&gt;Every time you send out an email to your list it&amp;#8217;s called a &lt;em&gt;campaign&lt;/em&gt;.&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Click &lt;strong&gt;Let&amp;#8217;s Go&lt;/strong&gt; to move on.&lt;/p&gt;
&lt;h3&gt;2. Get Subscribers&lt;/h3&gt;
&lt;h2&gt;Step 1: Create a List&lt;/h2&gt;
&lt;p&gt;Before you can create a form to put on your website, you first need to create a list.&lt;/p&gt;
&lt;p&gt;In the MailChimp dashboard, click &lt;strong&gt;Create a List&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39074" alt="Image 5" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-5.png" width="328" height="327" /&gt;&lt;/p&gt;
&lt;p&gt;You&amp;#8217;ll be asked for several details about your list.&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;The &lt;strong&gt;List Name&lt;/strong&gt; is what you&amp;#8217;ll use in MailChimp when you&amp;#8217;re deciding who to send your emails to. If you&amp;#8217;re only collecting one list of emails, the name doesn&amp;#8217;t matter too much. &amp;#8220;Client Newsletter&amp;#8221; would be a good choice.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Default From Name&lt;/strong&gt; is the name that will show up in the inbox of everyone on the list who receives your email.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Default Reply-To Email&lt;/strong&gt; is where emails will be sent if anyone hits reply when you send out an email.&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Remind People How They Got On Your List&lt;/strong&gt;. This will show up in the footer of every email you send to the list. For example, &amp;#8220;You are receiving this email because you signed up at our website.&amp;#8221;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;After filling out these details, check that your company address is correct.&lt;/p&gt;
&lt;p&gt;Under &lt;strong&gt;Notifications&lt;/strong&gt;, you can opt to receive updates whenever your list has a new subscriber.&lt;/p&gt;
&lt;p&gt;Finally, you choose whether subscribers can pick between HTML and Plain Text emails. I recommend &lt;em&gt;not&lt;/em&gt; selecting this option, as it can confuse potential subscribers who don&amp;#8217;t understand what it means and put them off from subscribing.&lt;/p&gt;
&lt;p&gt;When you&amp;#8217;re done, click &lt;strong&gt;Save&lt;/strong&gt;.&lt;/p&gt;
&lt;h2&gt;Step 2: Create a Sign Up Form&lt;/h2&gt;
&lt;p&gt;Go back to the MailChimp Dashboard, and head to the &lt;strong&gt;Lists&lt;/strong&gt; &amp;#8211; it&amp;#8217;s the third option in the top menu.&lt;/p&gt;
&lt;p&gt;Next, click &lt;strong&gt;Design Signup Forms&lt;/strong&gt; &amp;#8211; it&amp;#8217;s the green button in the right hand column.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39075" alt="Image 6" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-6.png" width="251" height="243" /&gt;&lt;/p&gt;
&lt;p&gt;As you only have one list, MailChimp will assume the form you&amp;#8217;re creating is for that list.&lt;/p&gt;
&lt;p&gt;Creating a sign up form has two stages.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Build It&lt;/strong&gt; stage, you choose which components to include in your form, for example email address, first name, phone number, address, zip code. Drag and drop the components you need on the form.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39076" alt="Image 7" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-7.png" width="550" height="399" /&gt;&lt;/p&gt;
&lt;p&gt;&lt;em&gt;Hint: The fewer components you choose, the more people will sign up for your list. Unless you&amp;#8217;ve got a good reason to ask for lots of details, I recommend just asking for an email address and first name.&lt;/em&gt;&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Design It&lt;/strong&gt; stage, you choose the colors for your form. Make sure the background color is a good fit for your website.&lt;/p&gt;
&lt;h2&gt;Step 3: Share Your Sign Up Form&lt;/h2&gt;
&lt;p&gt;Once your form is designed, you&amp;#8217;re ready to share it with the world. In MailChimp&amp;#8217;s &amp;#8220;Create Forms&amp;#8221; page, click the &lt;strong&gt;Share It&lt;/strong&gt; tab.&lt;/p&gt;
&lt;p&gt;On the right hand side, you&amp;#8217;ll see a Subscribe Form URL. You can share this URL on your social media accounts. Anyone who clicks the URL will be taken to your sign up form.&lt;/p&gt;
&lt;p&gt;One the left hand side, you&amp;#8217;re given the option to &lt;strong&gt;Create Form HTML&lt;/strong&gt;. This lets you create a sign up form on the sidebar of your website. Click the grey button &lt;strong&gt;Create HTML Code For a Small Subscribe Form&lt;/strong&gt;.&lt;/p&gt;
&lt;p&gt;On the next page, you can choose your form type (Super Slim, Classic or Naked).&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39077" alt="Image 8" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-8.png" width="550" height="354" /&gt;&lt;/p&gt;
&lt;p&gt;Click the &lt;strong&gt;Options&lt;/strong&gt; button beside the form type to change the title of the form. The default title is &amp;#8220;Subscribe to our mailing list&amp;#8221;.&lt;/p&gt;
&lt;p&gt;When you&amp;#8217;re done, click &lt;strong&gt;Create Embed Code&lt;/strong&gt;. You can copy and paste the code that appears into a sidebar widget on your blog.&lt;/p&gt;
&lt;p&gt;Now anyone who visits your blog can sign up to your email newsletter. Once you&amp;#8217;ve got a few subscribers, you&amp;#8217;re ready to send your first email.&lt;/p&gt;
&lt;h3&gt;3. Send Out Your First Email&lt;/h3&gt;
&lt;h2&gt;Step 1: Create Campaign&lt;/h2&gt;
&lt;p&gt;On the MailChimp Dashboard head to the &lt;strong&gt;Campaigns&lt;/strong&gt; Page &amp;#8211; it&amp;#8217;s the second option in the top menu.&lt;/p&gt;
&lt;p&gt;Then click the red button &lt;strong&gt;Create Campaign&lt;/strong&gt;. Select &amp;#8220;Regular Ol&amp;#8217; Campaign&amp;#8221;.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39078" alt="Image 9" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-9.png" width="519" height="355" /&gt;&lt;/p&gt;
&lt;p&gt;On the next page, you&amp;#8217;ll be asked to choose which list to send the campaign to. Select your list, then click &lt;strong&gt;Next Step&lt;/strong&gt;.&lt;/p&gt;
&lt;h2&gt;Step 2: Name Your Campaign&lt;/h2&gt;
&lt;p&gt;Give your campaign a name. If you&amp;#8217;re sending out a monthly newsletter, you might simply call it &amp;#8220;June 2013 Newsletter&amp;#8221;. Your subscribers don&amp;#8217;t see the name of the campaign.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39079" alt="Image 10" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-10.png" width="445" height="358" /&gt;&lt;/p&gt;
&lt;p&gt;You&amp;#8217;re also asked for an email subject. Your subscribers &lt;em&gt;do&lt;/em&gt; see this. Write a subject that will entice them to open the email.&lt;/p&gt;
&lt;p&gt;Leave all the other options selected. You want to personalize the To: field, Track Opens and Track Clicks.&lt;/p&gt;
&lt;p&gt;Click &lt;strong&gt;Next Step&lt;/strong&gt;.&lt;/p&gt;
&lt;h2&gt;Step 3: Choose Your Template&lt;/h2&gt;
&lt;p&gt;You&amp;#8217;re now given a range of options for designing your email template. You can create your own if you like using the drag and drop editor.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39080" alt="Image 11" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-111.png" width="550" height="307" /&gt;&lt;/p&gt;
&lt;p&gt;For this tutorial, we&amp;#8217;ll choose a basic template.&lt;/p&gt;
&lt;h2&gt;Step 4: Write Your Newsletter&lt;/h2&gt;
&lt;p&gt;MailChimp&amp;#8217;s editor is simple to use. To edit a section, simply double click it.&lt;/p&gt;
&lt;p&gt;&lt;img class="aligncenter imageborder size-full wp-image-39081" alt="Image 12" src="http://freelanceswitch.com/wp-content/uploads/2013/05/Image-12.png" width="550" height="413" /&gt;&lt;/p&gt;
&lt;p&gt;After you&amp;#8217;ve written your newsletter, you&amp;#8217;re given the option to edit the plain text version. If you&amp;#8217;ve given subscribers the option to receive plain text emails, check that everything looks okay, then click next.&lt;/p&gt;
&lt;h2&gt;Step 5: Send!&lt;/h2&gt;
&lt;p&gt;You can send your email immediately, or schedule when you&amp;#8217;d like to send it. Now sit back and relax. If you want to see how your Campaign is doing, you can go to the &lt;strong&gt;Reports&lt;/strong&gt; Page on the MailChimp dashboard.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=lzAbhez2EEE:GEqhUo5tws8:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=lzAbhez2EEE:GEqhUo5tws8:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=lzAbhez2EEE:GEqhUo5tws8:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=lzAbhez2EEE:GEqhUo5tws8:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=lzAbhez2EEE:GEqhUo5tws8:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=lzAbhez2EEE:GEqhUo5tws8:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=lzAbhez2EEE:GEqhUo5tws8:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=lzAbhez2EEE:GEqhUo5tws8:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=lzAbhez2EEE:GEqhUo5tws8:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=lzAbhez2EEE:GEqhUo5tws8:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=lzAbhez2EEE:GEqhUo5tws8:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/lzAbhez2EEE" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-marketing/free-mailchimp-email-newsletter/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-marketing/free-mailchimp-email-newsletter/</feedburner:origLink></item>
		<item>
		<title>Using Speaking to Market the Products and Services You Sell</title>
		<link>http://feedproxy.google.com/~r/FreelanceSwitch/~3/nLN5Y_EhyZo/</link>
		<comments>http://freelanceswitch.com/freelance-marketing/speaking-to-market-and-sell/#comments</comments>
		<pubDate>Wed, 05 Jun 2013 12:00:16 +0000</pubDate>
		<dc:creator>FreelanceSwitch.com</dc:creator>
				<category><![CDATA[Freelance Marketing]]></category>
		<category><![CDATA[public speaking]]></category>
		<guid isPermaLink="false">http://freelanceswitch.com/?p=38988</guid>
		<description>&lt;p&gt;&lt;a href='http://rss.buysellads.com/click.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=38988&amp;c=2018735536' target='_blank'&gt;
				&lt;img src='http://rss.buysellads.com/img.php?z=1259904&amp;k=f7b7931ec28da9e4ff2580bfd4eddb18&amp;a=38988&amp;c=2018735536' border='0' alt='' /&gt;&lt;/a&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;&lt;img src="http://freelanceswitch.com/wp-content/uploads/2013/06/5-preview-speaking-to-market-and-sell.png" alt="5-preview-speaking-to-market-and-sell" width="200" height="200" class="alignright size-full imageborder wp-image-39751" /&gt;&lt;/p&gt;
&lt;p&gt;While many speakers earn money for each speaking engagement they land, the real money is often in using your speaking engagements to sell the products and services you offer. That&amp;#8217;s because you have attendees who already know on some level that you&amp;#8217;re an expert — otherwise they wouldn&amp;#8217;t be coming to hear you.&lt;/p&gt;
&lt;p&gt;You don&amp;#8217;t have to be overtly &amp;#8216;salesy&amp;#8217; either — if you&amp;#8217;re offering a product or a service that is a logical extension of your topic as a speaker, a brief mention can be enough to land you a sale.&lt;/p&gt;
&lt;p&gt;&lt;span id="more-38988"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;hr /&gt;
&lt;h3&gt;&lt;span&gt;1.&lt;/span&gt; Examine the Audience You&amp;#8217;re Trying to Reach&lt;/h3&gt;
&lt;h2&gt;Step 1&lt;/h2&gt;
&lt;p&gt;Look at the audience who is most likely to buy your products or services. Hopefully, you&amp;#8217;ve considered potential customers as you&amp;#8217;ve developed your offerings, in order to plan out your marketing. Those same potential customers are who you want to make sure you&amp;#8217;re speaking to, so that you can effectively sell to them.&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;Plan to talk about topics that make the benefits of your product or service clear — even if you never mention your company&amp;#8217;s name.&lt;/p&gt;&lt;/blockquote&gt;
&lt;h2&gt;Step 2&lt;/h2&gt;
&lt;p&gt;Choose speaking gigs where you&amp;#8217;ll get to address your ideal audience. Whether you&amp;#8217;re pitching proposals to conference organizers or you&amp;#8217;re being sought out to speak, make sure that you&amp;#8217;re getting in front of the right people. Of course, if you really want to speak to a group of folks who aren&amp;#8217;t likely to purchase anything from you, that&amp;#8217;s your perogative — but categorize the work that goes into such presentations as something other than marketing.&lt;/p&gt;
&lt;p&gt;Ask for extra information about the type of people attending an event if you need to. While not all event organizers can give you lots of details, many will be happy to help you make sure that your talk is spot on for their audience.&lt;/p&gt;
&lt;h2&gt;Step 3&lt;/h2&gt;
&lt;p&gt;Plan to talk about topics that make the benefits of your product or service clear — even if you never mention your company&amp;#8217;s name. Focus on the problems you can solve for your audience, as well as for your customers. &lt;/p&gt;
&lt;h3&gt;&lt;span&gt;2.&lt;/span&gt; Plan an Offer Just for the Event&lt;/h3&gt;
&lt;h2&gt;Step 1&lt;/h2&gt;
&lt;p&gt;Look over the products or services that you offer to find one that fits particularly well not only with the audience who you&amp;#8217;re speaking to, but also fits with the topic you are talking about.&lt;/p&gt;
&lt;h2&gt;Step 2&lt;/h2&gt;
&lt;p&gt;Create an offer specifically for the event. Your offer doesn&amp;#8217;t actually have to be all that unique: unless you&amp;#8217;re seeing the same audience over and over again, no one is really going to know. It can even be something that you normally offer to customers, but put into the context of the talk you&amp;#8217;re going to give.&lt;/p&gt;
&lt;h2&gt;Step 3&lt;/h2&gt;
&lt;p&gt;Develop a physical manifestation of your product, if it&amp;#8217;s not something that you can just take with you to the event. Even if you have the most amazing ebook or website theme in the world, very few people will remember to look you up after the fact, just based on notes they may have taken as you talk. &lt;/p&gt;
&lt;p&gt;If they have a postcard, perhaps with a coupon code, there&amp;#8217;s a physical reminder that they plan to take action. Having a piece that audience members can take away is doubly important if you&amp;#8217;re asking them to make a big commitment — the sort that they&amp;#8217;re going to go away and think about before committing to.&lt;/p&gt;
&lt;h2&gt;Step 4&lt;/h2&gt;
&lt;p&gt;Plan how to measure your sales resulting from your speech. Especially if what you&amp;#8217;re offering is the sort of thing that a potential customer won&amp;#8217;t immediately act on, making sure that you&amp;#8217;re correctly attributing your sales to the marketing work you&amp;#8217;ve done is necessary. Otherwise, it&amp;#8217;s hard to tweak your marketing to sell more in the long run.&lt;/p&gt;
&lt;h2&gt;Step 5&lt;/h2&gt;
&lt;p&gt;Line up a way to get your marketing materials, or even a sample of your product, into the hands of attendees. Preferably, you can find an option beyond handing it out yourself, although that&amp;#8217;s also a necessary part of marketing your products or services. If you can arrange to have your materials included in a swag bag or available on a table for attendees, you can make sure that more people have access to what you&amp;#8217;re offering.&lt;/p&gt;
&lt;h3&gt;&lt;span&gt;3.&lt;/span&gt; Arrange to Sell Your Products at the Event&lt;/h3&gt;
&lt;h2&gt;Step 1&lt;/h2&gt;
&lt;p&gt;Check what sales are permitted at the event. Not all conferences or other events allow speakers to set up a table for their products or to offer a service to attendees. The logic behind that requirement is that if a speaker is good enough that an audience member wants to make a purchase, she can find the speaker after the event.&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;Even if the event doesn’t allow direct sales, check what other options you have: if you are creating a special deal just for attendees, many event organizers are willing to be a little more flexible.&lt;/p&gt;&lt;/blockquote&gt;
&lt;h2&gt;Step 2&lt;/h2&gt;
&lt;p&gt;Even if the event doesn&amp;#8217;t allow direct sales, check what other options you have: if you are creating a special deal just for attendees, many event organizers are willing to be a little more flexible. You may need to pay for an exhibit hall table or for a sponsorship to be able to sell your product or services.&lt;/p&gt;
&lt;h2&gt;Step 3&lt;/h2&gt;
&lt;p&gt;Prepare your presentation based on the guidelines of the event organizer. If you are not allowed to pitch your product or service during your talk, don&amp;#8217;t. Make sure you&amp;#8217;re giving your all at such events, though, to ensure that people come up to speak to you afterwards.&lt;/p&gt;
&lt;h2&gt;Step 4&lt;/h2&gt;
&lt;p&gt;Prepare statements that you can use in conversation after your talk or at your booth. While you can&amp;#8217;t script out a conversation in advance, you can make sure that you have facts and numbers at hand and you&amp;#8217;re prepared to talk about them. These conversations are often when you can close a deal that you started on stage.&lt;/p&gt;
&lt;h3&gt;&lt;span&gt;4.&lt;/span&gt; Make Your Offer&lt;/h3&gt;
&lt;h2&gt;Step 1&lt;/h2&gt;
&lt;p&gt;Share your background during your talk. You need to win over your audience from the very beginning of any talk you give. Doing so is actually part of your sales pitch, albeit a very subtle part. But by talking about the experiences your clients and customers have had, particularly in addressing a problem that members of your audience face, you&amp;#8217;re establishing yourself as the person with the solution.&lt;/p&gt;
&lt;h2&gt;Step 2&lt;/h2&gt;
&lt;p&gt;Show — don&amp;#8217;t tell — what you can do. You can&amp;#8217;t get up on stage and tell everyone you know what you&amp;#8217;re doing. Rather, you need to be two steps ahead of your audience: you might tell them about a problem that they don&amp;#8217;t even know they have, a trend that&amp;#8217;s coming soon or another factor that they can&amp;#8217;t easily deal with, unless they have your help.&lt;/p&gt;
&lt;h2&gt;Step 3&lt;/h2&gt;
&lt;p&gt;Mention any special offer that you&amp;#8217;ve brought for your audience — but just mention it. Repeating what a great deal it is or trying to make a hard sell is rarely appealing to an audience, so keep your pitch brief.&lt;/p&gt;
&lt;h2&gt;Step 4&lt;/h2&gt;
&lt;p&gt;Make yourself available after your talk to address questions and concerns from the audience. Even if you&amp;#8217;ve added your information to a swag bag or you&amp;#8217;ve got a table where you&amp;#8217;re handing out information, make sure that you can hand something out — preferably more than just a business card — while you&amp;#8217;re talking.&lt;/p&gt;
&lt;h3&gt;&lt;span&gt;5.&lt;/span&gt; Make Yourself Easy to Find After the Event&lt;/h3&gt;
&lt;h2&gt;Step 1&lt;/h2&gt;
&lt;p&gt;Include all of your relevant contact information in your presentation. It&amp;#8217;s often best to have an introductory slide, giving your name and company, and then using the last slide to offer up all of your contact details — that&amp;#8217;s the slide that will stay up the longest if you take questions.&lt;/p&gt;
&lt;blockquote class="pullquote pqRight"&gt;&lt;p&gt;By asking your audience to contact you about a specific question, a survey or some other detail, you’re making it more likely that they’ll contact you after the event.&lt;/p&gt;&lt;/blockquote&gt;
&lt;h2&gt;Step 2&lt;/h2&gt;
&lt;p&gt;Create opportunities for follow up. By asking your audience to contact you about a specific question, a survey or some other detail, you&amp;#8217;re making it more likely that they&amp;#8217;ll contact you after the event. Integrate such a request into your presentation.&lt;/p&gt;
&lt;h2&gt;Step 3&lt;/h2&gt;
&lt;p&gt;Mention your talk on social media, both before and after. Make sure that you use any &lt;a href="http://freelanceswitch.com/freelance-marketing/hashtags-and-social-media/"&gt;event hashtag&lt;/a&gt; or the specific forums where your audience may be, so that you can remind your audience of what they found valuable about your talk.&lt;/p&gt;
&lt;h2&gt;Step 4&lt;/h2&gt;
&lt;p&gt;Post your slides online. It&amp;#8217;s so easy to share slides after a presentation, as well as make it clear that those slides are part of a particular event, that you should do so every time, unless there is a very specific reason not to.&lt;/p&gt;
&lt;hr /&gt;
&lt;h3&gt;Speak, Market, and Repeat&lt;/h3&gt;
&lt;p&gt;If you&amp;#8217;re selling a product or service, marketing is a constant process. Speaking can be a practical strategy for including in your overall marketing plan, because it can be possible to make a sale on the spot — not just once, but to multiple members of your audience.&lt;/p&gt;
&lt;p&gt;Provided you&amp;#8217;re offering interesting presentations, you&amp;#8217;ll be able to use the same strategies for marketing your products or services within your speeches, over and over again.&lt;/p&gt;&lt;div class="feedflare"&gt;
&lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=nLN5Y_EhyZo:AnQ_xfbJ_kI:yIl2AUoC8zA"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?d=yIl2AUoC8zA" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=nLN5Y_EhyZo:AnQ_xfbJ_kI:V_sGLiPBpWU"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=nLN5Y_EhyZo:AnQ_xfbJ_kI:V_sGLiPBpWU" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=nLN5Y_EhyZo:AnQ_xfbJ_kI:gIN9vFwOqvQ"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=nLN5Y_EhyZo:AnQ_xfbJ_kI:gIN9vFwOqvQ" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=nLN5Y_EhyZo:AnQ_xfbJ_kI:F7zBnMyn0Lo"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=nLN5Y_EhyZo:AnQ_xfbJ_kI:F7zBnMyn0Lo" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=nLN5Y_EhyZo:AnQ_xfbJ_kI:wF9xT3WuBAs"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=nLN5Y_EhyZo:AnQ_xfbJ_kI:wF9xT3WuBAs" border="0"&gt;&lt;/img&gt;&lt;/a&gt; &lt;a href="http://feeds.feedburner.com/~ff/FreelanceSwitch?a=nLN5Y_EhyZo:AnQ_xfbJ_kI:D7DqB2pKExk"&gt;&lt;img src="http://feeds.feedburner.com/~ff/FreelanceSwitch?i=nLN5Y_EhyZo:AnQ_xfbJ_kI:D7DqB2pKExk" border="0"&gt;&lt;/img&gt;&lt;/a&gt;
&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/FreelanceSwitch/~4/nLN5Y_EhyZo" height="1" width="1"/&gt;</description>
		<wfw:commentRss>http://freelanceswitch.com/freelance-marketing/speaking-to-market-and-sell/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
        	<feedburner:origLink>http://freelanceswitch.com/freelance-marketing/speaking-to-market-and-sell/</feedburner:origLink></item>
	<copyright>Copyright (c)2007 FreelanceSwitch.com</copyright><media:credit role="author">FreelanceSwitch.com</media:credit><media:rating>nonadult</media:rating><media:description type="plain">FreelanceRadio</media:description></channel>
</rss>
