Dorcas Davies

UGC Video Creator & Social Media Ad Specialist

Feb 2022 - Present • 4 yrs 5 mos

I create authentic, engaging user generated content (UGC) videos for TikTok, Facebook, Instagram, and YouTube, designed to capture attention, boost engagement, and drive conversions. My work focuses on short-form, scroll-stopping ad videos that resonate with audiences and deliver measurable marketing results. I help brands tell their story through compelling visuals, relatable content, and a clear call-to-action, helping clients reach new customers and grow their online presence. I specialize in scripting, filming, and editing videos that reflect organic, humanized content rather than overly polished ads. By understanding platform specific trends and audience behaviors, I create videos optimized for engagement metrics, such as likes, shares, comments, and click-through rates. My services include product demonstrations, lifestyle content, testimonials, and AI enhanced video production to make content stand out. Clients hire me for my ability to deliver high-quality content quickly, providing ready-to-post videos that meet each platform’s technical requirements. I focus on results-driven storytelling that aligns with brand identity and campaign goals, ensuring that every video is not only visually appealing but also converts viewers into customers. With experience across multiple niches, I adapt my style to suit beauty, personal care, cosmetic, skin care and e-commerce brands, producing content that feels authentic and relatable. My goal is to provide businesses with videos that look professional, feel real, and perform exceptionally, helping them scale their social media advertising campaigns effectively.

Property Management Spreadsheet Specialist

Feb 2022 - Present • 4 yrs 5 mos

I specialize in creating custom Excel and Google Sheets solutions for Airbnb hosts, rental property owners, and real estate managers. Managing multiple properties, tenants, bookings, and expenses can be overwhelming, and that’s where my expertise comes in. I design fully automated, user-friendly spreadsheets that track rental income, occupancy rates, maintenance costs, and tenant records, giving clients a clear, organized view of their property portfolio. My spreadsheets include interactive dashboards, charts, and conditional formatting, making it easy to monitor financial performance at a glance. I implement advanced formulas, pivot tables, and automation features that save time, reduce errors, and improve workflow efficiency. Whether it’s generating monthly income reports, tracking tenant payments, or managing bookings and availability, my solutions help clients focus on growing their rental business instead of drowning in paperwork. I have worked with individual hosts and small property management companies, tailoring each spreadsheet to meet specific needs, whether simple tracking or full-scale property management systems. My goal is to provide clients with tools that are not only functional but intuitive, so even those with minimal spreadsheet experience can manage their properties effectively. By hiring me, clients get a professional, reliable, and efficient solution that organizes their data, improves decision-making, and optimizes revenue management. My work ensures that property management becomes less stressful and more profitable, empowering clients to focus on their core business.