BBDO/West:
we have applied a range of abilities for the west coast branch of this
worldwide advertising agency. they have come to us for photo works to
hang in their lobby, databases to track media buys or to
calculate savings for their biggest client (Dodge), leave behinds and website for new business pitches, illustrations for explaining
concepts to clients and technical support to make sure everything runs
as planned. we’ve also written and designed software manuals for
training new employees and designed PowerPoint templates for standardized client
communications.
recent projects:
- BBDO Donovan/Dodge Cost Reporting System - this system was developed to account for every dollar spent on advertising for Dodge across the entire US and compare it against SQAD to calculate Dodge's savings. we created an automated system (at the click of a button) which takes data from Donovan and SQAD, manipulates it in Excel to correct irregular data formatting (the data comes in from 5 different media buying regions) and drops it into Filemaker Pro to create a reporting tool (accurate to the penny) for presenting to the client.
- BBDO Cost Guide for Television - this system indexed BBDO's CPP and CPM for all of Dodge's media TV buys for all 211 Nielsen markets, broke it down by city, demographics, dayparts, compared the data to SQAD and calculated the difference. to do this, we took the data from Donovan and SQAD, manipulated it in Excel and dropped it into Filemaker Pro to create a comprehensive tool for all of BBDO's North America offices.
- BBDO Cost Guide for Radio - same as above, but for radio buys.
- New Business pitches
- Technical Support
- Graphic Design & Illustration
