Building Your Email List with Gmail + MailChimp + Zapier in 2 Clicks

Building Your Email List with Gmail + MailChimp + Zapier in 2 Clicks

This is a tip for all my artist and entrepreneur friends. If you plan to do anything in your future and invite people to donate/attend/up vote/whatever…the highest converting method is an email. Not Twitter, not Facebook, not an ice bucket. Sending personalized email to people who know and like you will help you accomplish your goals. Do this pre work now and reap the rewards for years. If you use Gmail (free but well worth $50/year to upgrade) & MailChimp (free up to 2,000 subscribers), Zapier will turn anyone who emails you into an email subscriber in 2 clicks (free up to 100 times per month). Just to clarify that math for you, if you’re a small brand looking to build an audience, ALL these tools are free until you get bigger. And when you do get big, shelling out less than $50 a month on these tools combined will be the most effective marketing dollars you spend. 1. Sign Up For Free Accounts If you haven’t already, create accounts on the following services (I get a free monkey on Tuesdays if you sign up using these referral links): Gmail MailChimp Zapier 2. Set Up Your Email Lists & Groups in MailChimp Do a little thinking about why you might email people to support you in the future. If you don’t have particular projects on the horizon, maybe you dump everyone into one list. If you have a company (Women Grow in my case) and web design services, you probably want to be able to email groups of people separately for those topics. Just note that this method only allows you to put...
Using Google Spreadsheets for Data Visualization Charts

Using Google Spreadsheets for Data Visualization Charts

To learn how to build interactive data visualizations with no code, using completely free tools, I attended Ben Jackson‘s class at General Assembly. Importing HTML into Google Spreadsheets (This tip was worth the cost of the class!) In a cell type =ImportHTML("http://www.anyurl.com", "table", "#")The number is which table is it on the page. So if it’s the 6th table on the page, enter 6. This data will live update with the page, that’s awesome except if they take down the page. So it’s best to copy it and use Paste Values into a new sheet if you’d like to continue using the data. Creating Pivot Tables Pivot tables allow you to view data sets with multiple attributes in different ways. It’s a great tool when you’re trying to figure out if disparate data correlates in a meaningful way. Just remember correlation doesn’t equal causation. Select all the data you want to analyze (including the top column names). Select Data > Pivot Table Report. First add one or more rows. Then add one or more values. To split how the values are displayed you can by adding columns. Inserting Charts Select the data you want to display. Click the Insert Chart button on the tool bar. Google will default to chart suggestion, this is a live preview that you can play with. If you chose a chart type that the data doesn’t support, Google will tell you why is doesn’t work. Creating Maps Another option for creating Maps is MapBox. Your data must have the full state names or country names (no abbreviations) and you have to spell them right. Click Insert Chart button...
How To Get Serious About Continuous Learning On A Budget

How To Get Serious About Continuous Learning On A Budget

In times of change, learners inherit the Earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists.” ~ Eric Hoffer   Read A New Book Every Month John Spence says that the average business person reads one business book every 5 years. If you read 6 business books a year, you’ll be in the top 1% of learners in America. If you read a business book every month, you’ll be in the top 1% of learners in the world. However you can, make reading a monthly goal. Use Audible to listen to books during your commute, workout, or while you do chores (about $15 each or less). Use Read It For Me for video summaries and workbooks of major business books ($29.99/month). Start a book club with some like-minded colleagues to keep each on top of reading. If you’re in NYC, join my (Reading Optional) Business Book Club. Replace Your TV Time If you haven’t already cut the cord and ditched cable, now is a great time. With the money you save on your cable bill you can still buy your favorite TV shows and stop watching all the junk you’re just filling time with. I’ve replaced my TV time with: TED – Instead of watching 20 minute sitcoms, watch 20 minute of the worlds greatest living ideas (free). Netflix Documentaries – They may not all be unbiased but they’re definitely interesting ($7.99/month). Take Free Courses Online Academic Earth is the largest directory of video lectures from universities like NYU, Harvard, and more. Most of us have skipped, forgot, or never really...

Building Your Resume Without Going Back To School

When men want to learn a new skill they get a new job, when women want to learn something new, they go back to school — or so I found in years of hiring. In my experience, men were more likely to apply for jobs that they were under-qualified for and plan to fake it until they made it. Overall they were right to do so, if you’re only applying to jobs you already know how to do, you’re underselling yourself and stumping your growth. Here’s three methods to build up your resume, make connections, and learn new skills, without going back to school. Speak You’re an expert in something and there are organizations that would love you to share your expertise. Not only will you get great practice at public speaking but the next time a friend of an audience member is looking to hire an expert in your field, you may be the first person they recommend. Contact the organizers of the following groups to get started: Meetup.com – lists thousands of groups on hundreds of topics. You may know nothing about restaurants but there’s plenty of restaurant owners who would love your advice on social media. Local Chamber of Commerce, co-working spaces, and professional associations – anywhere business owners and managers meet, you need to be. Conferences – you may not be ready for the big time but there are thousands of smaller conferences desperate for speakers. Start looking early though, many conference start booking speakers up to year in advance. You’ll typically get a free full pass to the conference in exchange and some clout...