Spencer Mayes Email & Phone Number

Portland, Or, Us

Portland, Oregon Metropolitan Area

Senior Data Analyst on the BI team, leading reporting on web attribution, paid user acquisition, marketing ROI, web traffic, SEO performance, top-of-funnel metrics, and ad-hoc data requests for marketing and cross-functional teams.- Coordinated with marketing team and marketing operations to ensure proper measurement, tracking and attribution of campaigns, from top of funnel conversion points to lower funnel metrics.- Integrated marketing spend with CRM data to build a full-funnel paid media report, providing visibility into lower-funnel campaign performance. This shift in strategy reduced breakeven from 10 years to three years, a 70% improvement.- Collaborated with Marketing Operations to scope and enhance data tracking by passing GA4 ClientIDs through form submissions, enabling web data integration into Salesforce. This reduced “unknown” traffic sources by 75% and provided insights into channels and content driving customer acquisition.- Utilized BigQuery and SQL to develop a comprehensive customer journey report in CRM, mapping the entire web journey for each paying customer or opportunity.- Partnered with Marketing Operations to export GA4 data into BigQuery, creating a web traffic report that offered Publishing and CRO teams greater visibility into traffic patterns, high-performing blog content and conversion rate tests.

Portland, Oregon Metropolitan Area

Portland, Oregon Metropolitan Area

Portland, Oregon Metropolitan Area

Marketing Analytics Expert at MKG Marketing, responsible for web analytics implementations, reporting, and analysis for Enterprise B2B SaaS clients- Build out full funnel marketing reporting for enterprise level clients using NinjaCat, Google Data Studio and other data visualization tools - Create weekly, monthly and quarterly marketing reports tailored to their respective audience - Use data to tell a story in all reporting, always including insights, actions, and business actions - Pull data from CRMs (Marketo, Salesforce, Pardot) to gain insights and actions on Leads, Opportunities, Revenue and Marketing ROI for enterprise level clients- Set KPI goals, optimal media mix, and baseline trending with time series forecasts using historical client data and industry benchmarks- Automate data pulls using Google Scripts and APIs - Create client facing Google Data Studio dashboards to give clients a real-time view of their marketing data - Use Adobe Analytics reporting and workspaces to build out SEO reporting for enterprise level clients - Setup robust Google Analytics tracking with Google Tag Manager for complex, high traffic websites- Implement advanced Google Analytics features for clients (Internal Promotion Tracking with Enhanced Eccomerce, Events, Cross-Domain Tracking, Third party integrations)- Use Google Tag Manager and Google Analytics to pass marketing channel source data into CRMs and Marketing automation tools - Add third-party tracking tags to client websites using Google Tag Manager

Portland, Oregon Metropolitan Area

Served as the primary source for all marketing data, analysis, recaps, and forecasting. Delivered reports to the executive team on ad spend, marketing ROI, sales performance, and print catalog effectiveness.- Created ad-hoc reports and analysis using SQL- Collaborated with IT to develop live reports for use across multiple departments- Monitored and reported on marketing KPIs to executive leadership team- Built annual and monthly sales forecasts using historical data and assumption tables- Measured performance, ROI and insights regarding customers, market trends, and marketing campaigns using tools such as SQL, Google Analytics, and Excel- Analyzed and optimized email marketing programs in regards to open rates, deliverability and conversionrates- Acted as main point of contact with third party marketing vendors, holding them accountable andnegotiating best pricing and terms- Managed all aspects of print catalog circulation and performance, overseeing an annual send of over 1 million catalogs

Donald, Oregon, United States

Manage all Pay Per Click advertising campaigns, overseeing a $30,000 monthly budget. Supervise all updates of product information and product pricing. Write SEO friendly copy, blog posts and press releases.Selected Accomplishments: * Increased Google Adword conversion rate 95.1% year over year (Jan-April) while decreasing conversion cost by 37.5%. * Created and managed Yahoo and Bing pay per click campaigns which were credited by company owner as bringing in more sales. * Setup and wrote a company blog featuring articles on material handling that attracts over 600 visitors a year to main websites. * Performed ongoing pricing comparisons with competitors which were instrumental in the company staying competitive during the tough economy. * Effectively supervised updates of product pricing, photos, and copy.

Bachelors, Digital Technology And Culture

Certificate, Professional Writing

Associate Of Arts - Aa, General Studies