Case Study: Streamlining Metadata Audits for Cal Poly Pomona’s Website Refresh

Overview

As part of a campus-wide brand refresh, Cal Poly Pomona’s Strategic Communications team needed to audit and update meta titles and descriptions across hundreds of cpp.edu pages. The work was being done manually, creating major bottlenecks under a tight deadline.

My Role

Brought in during the final stretch, I designed an automated workflow using Google Sheets, IMPORTXML, and OpenAI’s API to reduce manual effort and speed up review cycles.

What I Built

The solution (shown in the GIFs to the right) automated and simplified key steps:

• Pulled each page’s current meta title, description, and <p> content via IMPORTXML

• Passed that content to OpenAI’s GPT API to generate optimized metadata in the university’s brand voice

• Included word and character count checks to stay within SEO best practices

• Consolidated everything into an editor-friendly format for fast CMS updates

Why It Worked

The system didn’t replace editors—it equipped them. Instead of rewriting from scratch, they reviewed strong first drafts, saving hundreds of hours and helping the refreshed site launch on time with consistent, brand-aligned metadata.

Keywords:
content automation, brand consistency, search engine optimization, workflow efficiency, Excel, web development, case study, alumni, prospective students, yield, website refresh