Job hunters! Auto-gather LinkedIn’s job suggestions for you to a spreadsheet!

Hi everybody! I made a little IFTTT recipe to automatically add all of LinkedIn’s job suggestions to a Google Drive spreadsheet for you. If you’re on the job hunt, this is a handy way to bring the leads straight to you.

Click here to set it up. All you have to do is connect your IFTTT account to Google Drive and to LinkedIn, and you’re done! One minute and you’re ready to roll.

For those that don’t know, IFTTT is a wonderfully useful task automation tool that’s compatible with Gmail, Google Drive, Dropbox, Evernote, LinkedIn, and over 100 other services to automate all manner of tasks in an incredibly simple way.

Hope you enjoy! I may post these more often as I create them. Task automation is of great interest to me these days.

3 reasons never to use in-line images for art feedback

Hi all! Quick tip — don’t use in-line images for art feedback! Ever. Seriously. This shows the correct way to Attach images instead of embedding them as inline images. Again, this applies to art feedback, not general emails. The primary reason is that they’re annoying to save and they make searching for attached images later very difficult, when they really don’t need to be. Think of this in the context of working on a project with thousands of emails spanning hundreds of contacts. Being able to come back to an attached image later becomes a hell of a lot more important when you’re operating at scale. Fortunately, this is an incredibly simple process tweak anyone can do. :)

Here are three reasons why you should never use in-line images for art feedback:

  1. It makes Gmail’s search vastly less effective. It prevents searching by filename\keyword\attachment in Gmail.

    Example: If I’m looking for Art_Pasta_paintover_14.jpg and it’s an Attachment, I can search Gmail for it. However, if it’s embedded as an in-line image, it cannot be searched for, so I have to remember who was on the email, what the subject was, what some of the key words were, etc. I get ~150 emails a day and I can’t expect myself to remember absolutely everything.

  2. It strips filenames. If you have to use the images, it requires manually saving them. Since it doesn’t store the original filename, it’s dependent on the end user to adhere to naming conventions and place the file appropriately. If you save the file and ever need to find it again, now it only exists as whatever you thought to name it, or in an email you can’t easily search for.
  3. It breaks formatting. Large images completely obliterate formatting by stretching out the horizontal scroll bar, which makes ALL email replies span multiple pages. This makes emails unreadable and is a great way to kill a thread, if that’s what you’re trying to do.

I’d initially considered JPG artifacting and re-saving images degrading image quality, but that doesn’t seem to be the case in my limited testing. Here’s an interesting tutorial on checking for JPG artifacting in Photoshop.

Thoughts? Agree\disagree? I’d like to hear your comments!

The Jon Jones Job Journal is live!

Hi everybody! I used some cool tech to automatically create and update a spreadsheet of every game company that posts video game development jobs on LinkedIn. There are 471 jobs posted so far, and about 25 new jobs get added every day. I’ve also gone all crazy cross-media with it so people can get the list of the latest jobs whether they prefer a website, a downloadable and filterable spreadsheet, Twitter, or Facebook. See the Jon Jones Job Journal link above, or just click that.

Here are the relevant links:

This is an experiment. It’s a spreadsheet is continuously and automatically populated with job postings on LinkedIn from game companies I follow that are posting new positions. I use the wonderful task automation tool IFTTT and this recipe to create it:

The way it works is that it automatically monitors all the game companies I personally follow on LinkedIn (~170 or so) that post jobs on LinkedIn, then automatically enters the data onto this spreadsheet. I let it run for a few days as an initial test to make sure that only game companies’ jobs are getting posted and that the formatting is intact, and it seems to work now. I don’t have the time to spend on maintaining this, but fortunately, it’s pretty much all automatic now! To the best of my knowledge, there isn’t anything else like this on the internet, but I’d love to be proven wrong so I can drive people to it! Let me know.

For security and bandwidth reasons, I’m sharing it as “View Only” which unfortunately disables the smart filtering by location\company\etc. If you’d like to download your own copy of it so you can use the filtering options, simply click here to download an up-to-date XLS copy. Then you can filter and edit to your heart’s desire!

Please share this with your friends and colleagues, and enjoy! And if anything’s acting weird or bugging out, please drop me a line on my Contact page above. Thanks!

LinkedIn For People Who Hate LinkedIn

I hear a lot of criticism levelled at LinkedIn from game developers. It’s a business networking tool, and on some level, people find that mildly repugnant. What the hell am I supposed to do with LinkedIn? Why should I care? It’s spammy. I’m not even looking for a job. Should I just delete it?

No, no, no, hell no. You need a LinkedIn, and I’m going to explain exactly why: If you don’t have a LinkedIn, you don’t look professional. Worse, you look like you don’t care enough to spend 15 minutes doing the bare minimum to look professional.

*mic drop*

I’m going to show you how to get a basic professional-level LinkedIn profile set up in 15 minutes, and wrap that up with some power-tips on how to use LinkedIn to get a job. This information is from the perspective of 1) a heavy, long-time LinkedIn user, and 2) someone who uses LinkedIn to research people to hire. I will tell you what I look for and why, and what to do and what not to do.

LinkedIn has over 225 million members in over 200 countries. There is no question that it is *the* social network for business networking. But that doesn’t mean you have to be a recruiter or a spammer or a job seeker to use it. If you’re an average developer that isn’t looking for a job, it still has its use. You can get set up in 15 minutes with a basic professional-looking profile, and contact settings that will keep people from bothering you.

Ultimately it doesn’t hurt anything to be on LinkedIn, whereas it limits future opportunities not to. In general, it’s a good life strategy to make sure good things can come to you without expending much effort, and this is a potentially high-yield way to do that. Let’s get into it!

1) Why do I need a LinkedIn profile?

Having a LinkedIn profile is the bare minimum you can do to look professional when people search for you. It’s a respected, credible source of information over which you have ultimate control. Controlling what you put on there controls how you present yourself. LinkedIn is the FIRST place people look if they want to know what you do professionally. If a hiring manager that could give you your dream job is searching for the right candidate, would you rather have your important professional information listed in the first place they will look for it, or not?

That’s one angle not many people consider… passive presence. You don’t have to be on LinkedIn every single day updating and posting and searching. Or even looking for a job. Think of it as your professional storefront. Wash the windows every once in a while, but don’t worry too much about it day-to-day. This is the key point: You want to be discoverable, even without applying consistent effort, even if you don’t need something *right now.*

2) What shouldn’t I put on my LinkedIn?

It pains me that this even needs to be said, but DON’T BREAK YOUR NON-DISCLOSURE AGREEMENTS AND TALK ABOUT WHAT SECRET PROJECTS YOU’RE WORKING ON. If you’re not sure, ask your company. When in doubt, don’t say anything. Game news sites regularly look for stories by combing through your LinkedIn profile and connecting the dots. Stalking peoples’ resumes to make the news is a scumbag thing to do, and I hate that it happens. However, it IS public information. There’s a new story every couple of weeks about a developer breaking their NDA on LinkedIn and making headlines. That one guy over at Kotaku has an entire column where he does this. And we give him the material.

Generally speaking, it’s not a good thing if product announcements happen accidentally. Especially not if it makes headlines and they link directly to your personal LinkedIn page. It shows a lack of discretion, and makes you look less hireable. And it’s also completely preventable, which makes you look even worse. You don’t have to be that person!

Here are a few bullet points of what NOT to put on your LinkedIn profile:

  • A fake profile. Don’t fill out a personal profile with your company name, then go around adding people. There are Company Pages for a reason, and you look like you don’t understand how to use the system, or just don’t care. Have you ever made the mistake of adding your grandparents on Facebook? Seeing this is similar to grandparent social media cringe.
  • Fake names. Use your real name. Don’t be cute. LinkedIn is a place to present yourself professionally, not be funny. I’m talking to you, Sparklesunshine von Ponypants. You were not as advertised.

  • Bad spelling. Especially for job titles. I’ve seen my fair share of Arists, Prodcuers, Desingers, Principles, Enviroment Artists, and once a “Certified Scum Master.” I’m also fairly certain you didn’t attend Pubic School. That, or I forgot to reset my search filter settings from last night.

  • “Cute” job titles. Having a creative title like “BADASS!” or “Pixel Wizard!” or “I fart polys!” isn’t necessarily bad, but it is *really* dorky. It makes you stand out, and not necessarily in a good way.

  • Douchey job titles. I find it hard to take anyone seriously that refers to themselves as a “visionary” or “thought leader” on a resume or LinkedIn. This tells me that person’s idea of a good night is a glass of wine and reading their own blog.

  • Party photos. I don’t care how many shot glasses you can fit into your mouth, how many glitter-dusted bar skanks you can hang off each arm, or about how you can turn a pig into a bong without killing it. Unless you’re applying to be on some sort of totally awesome reality show, keep it professional and boring. No one has ever said “Well, Candidate A is more qualified, but Candidate B burned off his eyebrows drinking a flaming Dr. Pepper while standing on his head — and he kept drinking. Our choice is clear.”

  • Age. Never tell anyone your age. You could be 10, 50, or 14 million years old. Never indicate your age. It’s not professionally relevant and it’s very easily judgeable. Don’t give them that. I’ve followed this rule since I was 12, because people get weird about people being too young, or too old. It’s ammo, and it can only lead to negative judgments. Don’t give it to them.

  • Religious affiliation. No one cares, it’s one additional data point that’s easy to judge people for, no one cares, aaaaand no one cares. I will be blunt: Being really up-front about your religious affiliation on your resume could make people think you’re likely to be enthusiastically obnoxious about it in the workplace. Think day one, enter that person: “HI EVERYBODY I’M REALLY EXCITED TO WORK HERE! I LOVE AND WORSHIP BACCHUS. LET’S STRIP DOWN, DRINK WHISKEY AND ROAST A GOAT!” This isn’t discriminating or stifling religious belief or thought, it’s a very simple and practical consideration: religion is an extremely sensitive subject that people really like starting discrimination lawsuits over. No one wants that drama. Don’t bring it up.

  • Twitter. DON’T LINK YOUR TWITTER. DON’T DON’T DON’T. Do. Not. Link. Your. Twitter. No good can come of that. It will confuse the message that you are a professional, because Twitter is the guileless Ritalin-popping chatterbox child of social networks.

3) What should I put on my LinkedIn?

Think searchable, relevant key words. You want to be easily discoverable via simple key words that apply to your skill set. Hiring managers, recruiters, and people like me search for people by job title, software proficiencies, and skills. For example, environment artist with Maya and ZBrush experience that’s worked on the Xbox 360. UI artist that knows Scaleform and has developed for the Wii. Animator with Softimage and Motionbuilder experience and has developed for the Ouya. (just kidding, no one cares about having Ouya platform experience! wah wah.)

Golly, I like bulleted lists. Here’s another one:

  • A professional summary. Two to three short paragraphs, depending on how long you’ve been in games. First person or third person never mattered much to me personally, but do it in the first person to be on the safe side.
  • Start\end dates for all your jobs, with proper job title. Under each job, describe your duties, what software you used, what titles you worked on (if you can), and one or two specific, interesting aspects of it that stand out. Don’t brag, don’t bitch, don’t gripe, and don’t fluff it out. This is a very important point: These are simplified pieces of data that are the basis for starting a conversation, not the conversation itself.

  • Education. I personally don’t care about education or what school you went to, but my purview is primarily art, where education for that matters less in the game industry. Still, include it if you’ve got it. It’s a qualification and another potential point of distinction that tells the story of you.

  • List of projects you’ve worked on. Link it to the company and the other people you worked with. Creating a little network like that will show people who you’ve worked with before, and in a job-getting situation, they’ll most likely be asked about you. And if you link to them that may encourage reciprocal linking, which will make it easier for people to find you from other peoples’ LinkedIn pages. Bam, discoverability.

  • Skills and expertise. The Endorsements system in LinkedIn is stupid and mostly useless, but it’s still worth it to edit that list to make sure that only skills relevant to you are listed. Keep it serious, and don’t list yourself as a Taco Expert or Beer God. Keeping these up to date and relevant make you easier to find. Keywords, yo!

  • Recommendations. The usefulness of written recommendations from people on LinkedIn is a controversial subject. Many people say they ignore them and think they’re worthless, and other people think they’re the greatest thing ever. My opinion is that it’s never a bad thing if you can get people on the record saying they liked working with you. However, if you’re in a layoff and everyone at the company is writing them for everyone else, it’ll be obvious that it’s probably going to be stress-induced fluffery, and more likely to be ignored. You can’t help but reciprocate if someone offers it without looking like a jerk. But if you can get a lead or a colleague you’ve worked with a lot to say a few good words about you, that’s never a bad thing. Just don’t put up 14 million of them, because that does start to look douchey.

  • Published works. If you’ve published articles or given talks at a conference, link them to your page. It’s a good thing! It demonstrates professional relevance, and it’s another point of distinction in your favor. Not everybody writes, and you look even smarter about the subject if you take the time to write about it.

4) What else can I use LinkedIn for besides looking for a job?

LinkedIn is a search engine in which people generally want to be found, so they make the relevant information easy to find. Aside from being a place simply to look for jobs, here are a few ideas for how LinkedIn can be useful:

  • Instead of applying for a job through the website, try to find their recruiter or HR manager on LinkedIn. Path less traveled!
  • Take advantage of LinkedIn Groups. You can meet cool people and learn. Check your friends’ Groups on their profile and join them. You can also request connections with people based on groups you have in common.

  • Are you interviewing? Ask for the names of the people you’re interviewing with and look them up. Find out who they know that you know. Ask questions about them. Knowing people in common can’t hurt. Also, make sure you check the gender of the person with which you’re interviewing… this does happen.

  • Add your coworkers. Find out where they’ve worked before, and get to know them better through that. “Hey, I saw on LinkedIn that you used to work at X company. Did you know Sparklesunshine von Ponypants? What a complete tool, right?”

  • Learn about new companies. See a new one opening in the news? Look it up. Look up the founders. Find out what they’ve done before. It’s a great way to educate yourself, and to find new connections with people you didn’t know you had.

5) General LinkedIn tips

  • If you don’t want people to contact you all the time, take the time to set your contact settings under Settings -> Communications. Set email frequency settings as low as you like, set who can send you invitations, and select the type of messages you’re willing to receive. If you want to do a fully fire-and-forget LinkedIn profile, set most of it to ‘off’ and enjoy the silence.
  • If you’re prepping to change jobs and want to stay secret, you can turn off LinkedIn’s profile update notifications first… shh. Settings -> Profile -> Turn on/off your activity broadcasts.

  • Keep LinkedIn updated quarterly. Set up a calendar event to update it.

  • Don’t forget your portfolio website link! Put it in the Summary, too. People forget this a lot.

  • If you’re trying to add someone you don’t know on LinkedIn, when it asks you how you know them, don’t select “Friend.” It’s tacky. If you don’t know them, don’t add them. If you’re a member of the same Group where you’re active, that’s cool, use that.

  • Here are ten simple but very important security settings to protect yourself on Facebook, Google, Twitter, LinkedIn, etc:

  • If you’re adding someone, please remind them how they know you or how you met. Again, don’t call them a Friend if you’re not.

  • A link to your LinkedIn profile is not a substitute for having a resume on your portfolio.

  • After layoffs, I see floods of LinkedIn contact requests from people who never had LinkedIn before. This is one of my most important points: Connect with people before you need it, and before there’s a huge rush! It’s annoying getting hit up only by people who want something from you, right then. It’s worth taking the time to maintain your network and get your friends and coworkers in there.

In conclusion, if you want to look professional, be discoverable, and control the way you appear to potential employers, take the time to set up a basic LinkedIn profile. Even if you’re not looking for a job, you need a periodically-updated LinkedIn profile to ensure discoverability in case something good could come your way, or in case you really need it in the future. There is no downside to being easy to find and appearing professional to people who might give you money.

Worklog — how to create an art wall.

Art management time! Has anyone created a wall grid full of printed art assets for basic tracking and visualization? How did you do it and what did you track? I decided to design a system for that today.

I do all my project tracking in Shotgun ( but I like the idea of a wall to visualize relationships between sets, with really limited tracking indications that map to asset-specific tasks.

Let’s choose a standard 8.5 x 11 piece of paper to print on. That’s 2550 x 3300 pixels at 300dpi. Let’s see how many figures (characters in this case) we can fit onto a sheet. The practical considerations here are:

1) Scale. How many can I fit onto one sheet and still be meaningful? If it’s too few it’ll take up too much wall space. If it’s too many it’ll make looking at it difficult. We can also use either portrait or landscape mode, depending on the proportions of the image. Additionally, if there are too many and you’re printing updates, if you update more than one asset in a sheet you’ll be printing up new pages all the time.

5×4 grid: 510×825
3×3 grid: 850×1100
2×3 grid: 1275×1100
2×2 grid: 1275×1650

2) Buffer room at the edges in case you’re using a paper cutter. Do EVERYTHING you can to size it correctly so you don’t have to use a paper cutter to correct it. Trust me, I’ve been down that road.

3) Buffer room at either the top center (for magnets) or in the corners (for push-pins) so you’re not covering up information.

4) Clearly labeled asset name with stroke around text, for easier visibility in all conditions. I like white text in Impact with a black border, or inverted colors if necessary.

5) Limited colors so we don’t waste printer ink.

6) Character is on a neutral RGB 128 grey background, but outside of those bounds it’s white. This saves ink, and prevents the painful contrast of looking at a character with a bright white background. That’ll distort your perception of color and values. (note: I’m using a placeholder since I can’t show any of my game’s assets.)

7) Stroked inside edges of the image. This’ll aid in snapping them correctly (although you should be using Guides) and cutting them out, if you absolutely have to.

8) When you print, make sure to Scale to Fit Media otherwise it’ll clip the edges by default.

9) Clear indications of asset status at the bottom that you can mark with a ballpoint pen or Sharpie. I have “R C B S T I,” which stands for “Ref – Concept – Blockout – Sculpt – Texture – Ingame.”

After several experiments, this is what I ended up with:


This is what 4 of them on an 8.5×11 sheet looks like:


And this is what all my experiments look like on the wall:


Bottom right is the winner. :) Obviously this is just the start of a LOT of effort, but I feel like I have the design down and have avoided a LOT of pitfalls I’ve subjected myself to in the past.

Hope that was helpful, or at least interesting! I’d really like to hear how your studios do it and if you have any suggestions on a simpler format, or if there’s anything I haven’t covered.


Game layoffs: The year 2013 so far, by the numbers

I created and maintain an extremely detailed spreadsheet tracking video game industry layoffs for the last five years, so I decided to work up some numbers of the year 2013 so far.

There were 61 announced layoffs worldwide in 2013. 34 are in the US, 8 in the UK, 8 in Canada, 2 in Australia, and the rest are countries like Brazil, Belarus, India, China, etc. Of that total, 18 studios are confirmed as having closed, but I don’t have data on whether or not 19 of the remaining 43 studios are still open.

Only 40 studios announced layoff numbers. The total number of layoffs from the studios that reported numbers is 2,262, rounding up from the numbers for which I had “25 to 30″ or “50 – 75″ as the only data points. 20 studios did not report layoff numbers, and 1 studio (Io Interactive) only reported a 50% reduction in force.

Cities most affected:

- San Francisco, CA – 4 layoffs totaling 322 people
- Austin, TX – 5 layoffs totaling 304 people
- Montreal, Quebec – 1 layoff totaling 200 – 250 people (EA Montreal)
- San Diego, CA – 3 layoffs totaling 140 – 240 people (Trion Worlds’ full layoff numbers were never announced for the first event and I don’t have data on the studio’s headcount at closure)
- Dallas, TX – 1 layoff totaling 215 people (Zynga Dallas)
- Seattle, WA – 4 layoffs totaling 155 people
- Vancouver, BC – 6 layoffs totaling 91 people (however, PopCap Vancouver, Quicklime Games, and Slant Six’s closure did not report numbers)
- Boston, MA – 3 layoffs totaling ~35 people (Majesco Boston did not report numbers)

This would be a good time to mention :)