Kerry Aufderhar

Why this persona fits the audience

Leads campaign list prep for a 6-person fundraising team in New York, where she trims, dedupes, and reformats donor and event-export tables in Google Sheets and Excel. Has never paid for a dedicated table or CSV tool and mostly uses built-in spreadsheet functions.

• Age: 32
• Location: Brooklyn, NY, US
• Occupation: Marketing operations manager
• Income: US$68k salary
• Education: BA in marketing
• Company size: Nonprofit
• Years in role: 5

““If the data isn't clean, the message gets lost before it even reaches the right person. It’s all about making sure our mission gets heard, and that starts with getting the details right.””

Kerry Aufderhar, 32, has carved out a niche for herself as the indispensable Marketing Operations Manager at a New York-based environmental nonprofit. Her journey into this role wasn't a straight line; after earning her BA in Marketing, she initially worked in agency roles that felt too corporate and disconnected from tangible impact. Drawn to the mission-driven work of nonprofits, she found her way to her current organization five years ago. Her position is critical, yet often invisible to the outside world. She is the primary architect of campaign list preparation, a task that consumes a significant portion of her workday. This involves meticulously trimming, deduplicating, and reformatting donor and event-export tables, primarily using Google Sheets and Excel. She has become exceptionally adept at leveraging built-in spreadsheet functions, a skill honed out of necessity due to budget constraints. She has never utilized or paid for a dedicated table or CSV manipulation tool, viewing her spreadsheet mastery as a core competency. This reliance on manual processes, while effective, is also a constant source of friction. Kerry is deeply committed to the organization's mission, which fuels her dedication to ensuring every outreach dollar is maximized. Her personal values of transparency and organization directly inform her professional approach, striving for clarity and order in the often-chaotic world of nonprofit data management. She sees her role as a vital service to both the organization's fundraising efforts and its relationship with its supporters. Her recent decision to explore advanced VLOOKUP and INDEX-MATCH functions more deeply stems from a desire to automate some of the more repetitive cleaning tasks, a small step towards greater efficiency without incurring new costs. She views time as a precious commodity, both personally and professionally, and is constantly seeking ways to optimize her workflow.

Background & daily life

A day in their life

Kerry's typical weekday begins around 7 AM with a quick check of her personal email and a glance at the news. By 8:30 AM, she's logged into her work computer, often starting with reviewing the previous day's campaign performance metrics. The bulk of her morning is dedicated to data preparation for upcoming fundraising appeals: exporting lists from the CRM, meticulously cleaning them in Excel (removing duplicates, standardizing addresses, flagging inactive donors), and then reformatting them for the email marketing platform. She might have a brief sync with a fundraiser to clarify segmentation needs. Lunch is usually a quick salad at her desk while listening to a podcast. The afternoon could involve troubleshooting an email deliverability issue, updating campaign tracking spreadsheets, or planning future data hygiene initiatives. She aims to log off by 5:30 PM, but sometimes stays later if a critical campaign deadline looms.

Lifestyle

Kerry lives in a rent-stabilized one-bedroom apartment in Greenpoint, Brooklyn, which she shares with a rescue cat named Pixel. She's a creature of habit, starting most mornings with a strong cup of coffee and a quick scan of industry news before her commute. Weekends are a mix of long runs along the East River, exploring new live music venues in Bushwick, and catching up with friends over brunch. She's mindful of her budget, preferring to cook at home and take advantage of free city events. Her social life is active but balanced, prioritizing quality time with her close-knit circle.

Work life

As the Marketing Operations Manager at a mid-sized environmental nonprofit, Kerry is the linchpin for campaign execution. Her days are consumed by data wrangling: cleaning, deduplicating, and reformatting donor lists and event attendee exports from various sources into usable spreadsheets. She works closely with the fundraising team, ensuring they have accurate segmentation for their appeals. The pressure is constant to maximize outreach with limited resources, meaning efficiency and accuracy in her data prep are paramount. She often feels like a detective, piecing together fragmented data points.

Relationships

Kerry maintains strong relationships with her immediate family, who live upstate and whom she visits monthly. Her closest friends are a mix of former college acquaintances and people she's met through running clubs and local music scenes. Within her organization, she has a collaborative but professional relationship with the fundraising team, who rely heavily on her data skills. Her manager, the Director of Marketing, trusts her implicitly with operational tasks.

How they decide

Kerry is a cautious and research-oriented decision-maker, especially when it comes to anything involving organizational resources. She prefers to gather as much information as possible, often testing free versions or trial periods before committing. She values practicality and demonstrable utility, looking for solutions that solve a clear, immediate problem without introducing unnecessary complexity or cost. Peer recommendations and case studies from similar organizations carry significant weight.

How they sound

Kerry speaks clearly and at a moderate pace, with a slight Brooklyn inflection that surfaces when she's relaxed or emphasizing a point. Her tone is generally professional but friendly, avoiding overly technical jargon unless explaining a specific data process. She tends to use phrases like 'basically,' 'you know,' and 'it's just that' when explaining challenges. She's direct about problems but frames them constructively, focusing on solutions rather than complaints. She avoids hyperbole and is quite grounded in her descriptions.