Managed Meta Ads accounts and AI content strategy as a freelance project. Optimized Meta Ads accounts, restructured pixel architecture for clean and scalable measurement. Innovated with AI to generate synthetic persona models, significantly reducing production and advertising costs. Developed a zero-cost virtual catalog integrated directly into ads, allowing native product browsing without leaving the platform. Implemented advanced tracking and Meta Pixel integration for granular event measurement (Purchase, Lead, ViewContent) and optimization of delivery algorithms. Achieved a measurable increase in engagement and direct sales volume.

Detected and corrected a critical error in an SQL query within the revenue extraction pipeline, which caused reported client revenues to be systematically lower than actuals, impacting billing. Identified the flaw through independent data reconciliation and provided the correction with documented methodology. Constructed a complete n8n automation that compressed the monthly reporting cycle from approximately 30 days of manual work to a single business day, eliminating manual sheet creation and freeing the team to focus on strategy. Performed an end-to-end ETL process on a complex nested JSON dataset (operational CRM export), remodeling raw records into a relational star-schema (Events, Actions, Sales, Orders, Stores, and Financial Facts tables) with quality validations: uniqueness, null rates, and revenue reconciliation. Designed and delivered a strategic win-back analysis on over $20.5M in historical revenue (323K unique receipts, 952K transactions, 5 years of data), segmenting a pipeline of 40,521 lost customers and identifying a recovery potential of $2.57M in incremental revenue. Defined optimal intervention windows ('Early Lost' bucket of 61–90 days) for maximum recovery efficiency. Built a Snowball attribution model to track incremental post-recovery revenue, capturing both the first transaction and all subsequent purchases to demonstrate the real ROI of win-back campaigns. Performed customer lifecycle and churn analysis using AlpineIQ + AWS Aurora PostgreSQL (integrated with Dutchie POS): calculated first-time churn rates, LTV by cycle level, and retention velocity metrics to feed campaign trigger logic. Designed and implemented a centralized tracking and reporting infrastructure capable of supporting 25+ simultaneous accounts, allowing the client base to grow from less than 10 without a proportional increase in operational overhead. Established full-funnel visibility by integrating CallTrackingMetrics (CTM), Agency Analytics, Google Analytics 4, and Google Tag Manager across all accounts, generating a unified view of paid media performance, content, and phone lead attribution. Built a real-time KPI monitoring system with n8n: flows connected to the Google Ads API (OAuth2), daily extraction of campaign metrics (clicks, impressions, conversions, cost), comparison against goals, and automatic alerts to Slack for mid-cycle strategy pivots. Designed and developed a proprietary AI chat widget (HTML/CSS/JavaScript + n8n webhook + LLM integration) deployed in production, replacing the TalkFurther platform and generating $500/month in recurring license savings. The widget qualifies leads 24/7 and injects captured data directly into the CRM. Implemented LiveChat ↔ CTM ↔ Slack integration via n8n, connecting the web chat with the call attribution system and ensuring chat-originated leads were captured in the attribution model with structured follow-up by the sales team. Created a standardized GTM tag template deployed across multiple client sites, improving measurement consistency, reducing implementation time per new client, and ensuring correct data flows to GA4.

Wrote a Standard Operating Procedure (SOP) for setting up n8n monthly reporting flows for new clients, enabling repeatable onboarding without relying on undocumented knowledge. Executed organic positioning strategies for various brands in the Spanish market, managing competitive niches and optimizing search engine performance. Conducted technical SEO audits, keyword research, and On-Page optimization to improve site relevance and crawling. Implemented link-building and domain authority strategies, along with optimized content management, achieving sustained increases in organic traffic.