Interns: Creating Your Spreadsheet

I've just finished giving two presentations to SJSU's latest batch of ad majors. The consensus: They're keeners.

That's a good thing, because if they want to break into the industry they'll need to poke and prod as much as possible to soak up all the info between now and when they graduate.

After I give a presentation I always walk away learning something about myself. During Monday's presentation I learned that I wasn't just "Lucky."

No dear reader - I worked my ass off. I really fucking did. Here's a list of what I did prior to landing my first internship with BBH NY:

• Applied (and got rejected) to the Vance & Betty Lee Stickell Internship Program. In the process, I put together my first professional resume and found my mentor.
  
• Visited NYC with SJSU's School of Journalism and Mass Communications. While I was there, I visited Deutsch, McCann Erickson, CNN and Good Housekeeping. I talked to people - at the agencies/at bars/on the subway. I always got a card & followed up with them.
  
• I spoke with an Account Planner from RPA that a friend of mine hooked me up with. He was the first person who really gave me an understanding of what planning was and introduced me to Jon Steel's: Truth, Lies and Advertising - aka, The Planners Bible.
• I absorbed as much information from AdAge, Creativity, AdWeek, my professors and anyone else who would give me the time of day.
• I volunteered at The Billy DeFrank GLBT center. I learned how to talk to a wide range of people from what many consider a homogeneous minority. You couldn't be more wrong.
  
• I called/emailed/pleaded with agencies throughout the US for two weeks straight. I would wake up at 5 am and start calling agencies on the East Coast and then work my way west. When I had reached the Pacific Time Zone, I would start over again. In the process I learned how to talk to receptionists, how to leave a voicemail, how to email HR reps, and how to use Excel.

The last bit is what I want to show you. Keeping a spreadsheet of agencies is a great tool for anyone who wants to land an internship (or even an entry-level job). Here's a snapshot of one I did last year (while waiting for MAIP's decision).


So the first thing you'll notice is that there is basic info: Agency name, location, telephone and address. This helps to keep things all in one place and prevents you from hunting websites for general contact info.

The next thing you'll need are columns with your contacts info: Contact name, their direct # and email (also take note of the Initial Date of Contact and how you contacted them). Knowing when you contacted people is imperative to not coming across as annoying but showing that you're persistent.

The next section includes: Feedback and notes. This is the section you use to document the details of your conversations and helps you list your next steps (following what the HR rep asks you to do is imperative to making a good impression). Make sure you document everything you talk about immediately after talking with an HR rep.

That said - get working on your spreadsheet and I'll post something juicy in the next day or two.