Mackenzie Farmer Email & Phone Number

Kansas City, Mo, Us

San Francisco, Ca, Us

Philadelphia, Pa, Us

Philadelphia, Pa, Us

Overland Park, Kansas, Us

- Leverage a dynamic set of data analysis and visualization tools to create, maintain and QA client marketing performance datasets and dashboards, specifically Tableau, Google Analytics, Google Tag Manager and Google Campaign Manager- Assist the media team with client website analytics tracking implementation, development of marketing measurement and creative tagging strategies- Assist with building and maintaining client-facing marketing performance Tableau dashboards - Collect and analyze data from external marketing vendors translating data into insights for the Media team and clients- Manage the retrieving, compiling, and formatting of large volumes of data- Work with Media team on ad hoc reporting requests- Assist with client analytics meetings, presenting insights and making marketing recommendations derived from multiple data sources- Coordinate data connections in performance reporting database- Collaborate with MMGY Account, Media, Social, eCRM, Paid Search, Creative, and MarTech teams to collect requirements for dashboard builds- Utilize BigQuery to update internal media pacing dashboard daily - Establish and adhere to client and internal deadlines

Columbia, Missouri, Us

- Track, measure, report and optimize performance across campaigns using tools such as: Tableau, Data Studio, Doubleclick, Google Analytics and Miro- Daily monitoring of Doubleclick campaigns -- identify issues and optimization opportunities- Generate and analyze automated and ad-hoc reports for internal and external stakeholders- Maintain campaign visualization, testing and tracking libraries- Work hand in hand with Marketing Success and Partnerships team to onboard campaigns, reconcile billing/invoicing- Work with Account Managers to request and manage assets from Creative team for implementation

Columbia, Missouri, Us

- Utilized platforms such as Tableau, DoubleClick Campaign Manager and Data Studio to analyze and pull various data sets, conduct secondary research, send out loan return reports, check and create URLs, aid in lead generation and facilitate the testing of numerous copy variations to optimize company performance and maintain strong relations with partners.

Columbia, Mo, Us

- Facilitated meeting with students, set up weekly quizzes and aided in the teaching of a digital strategy course

St. Louis, Mo, Us

- Conducted secondary research for new business and crisis management efforts- Created content for executive thought-leadership- Consistently monitored local and national media and tracked coverage and possible client threats- Pitched and secured a media placement for a client event in NYC- Built targeted media lists using Cision- Drafted backgrounders- Participated in brainstorms- Developed content with a focus on corporate social responsibility and sustainability.

Columbia, Missouri, Us

- Worked with a team of 11 to create an annual, in-depth report based on primary research gathered in our national quantitative study called the State of the YAYA (Youth and Young Adults) presented via a live webcast- Lead the touchpoints team and personally drafted press releases, constructed a media kit, wrote a blog post on cause marketing and reached out to media outlets, resulting in a placement with Elevated Chicago- Planned and executed the 2019 Strategic Communication Career Fair with three others, which included reaching out to local and national advertising agencies as well as setting up student workshops prior to the fair- Collaborated with a team of 11 to create a fully integrated advertising and marketing campaign for Chevrolet.

Maryland Heights, Missouri, Us

- Became proficient in MailChimp, Buildout and Crexi, using the first to send recent successes out via email and the second and third to update Intelica's properties- Produced one video from a brokerage event- Reconstructed the online descriptions of more than 20 properties- Drafted four client testimonials- Wrote two press releases- Constructed four biographies for full-time workers - Wrote one short article, two content analysis papers and 11 blog posts- Used excel and Salesforce for organizational purposes.

Columbia, Mo, Us

- Crafted one press release, two media alerts and one creative fact sheet for a media packet- Wrote for the September newsletter- Used Adobe InDesign to work on informational brochures- Interviewed multiple agencies and wrote blog posts on them, expanding networking skills and polishing my communication skills- Utilized Hootsuite to evaluate social media analytics and schedule weekly updates

- For swim lessons, I used creative methods, like games, to help children who did not want to swim and created enjoyable 30 minute lessons to enhance participants' swimming abilities- For the concession stand, I improved time management skills by working hour-long rushes, swim meets and special events- Enhanced my interpersonal skills by working closely with coworkers and serving new and existing customers

Master Of Arts - Ma, Journalism, Strategic Communication

Bachelor Of Journalism, Strategic Communication

Minor, Business