Todd Chenard Email & Phone Number

• Designed and developed a Looker Studio marketing performance dashboard for a major GTM initiative that sourced data from Salesforce, Google Analytics, Google Search Console, and ad platforms.• Built quarterly demand gen forecasts dynamically driven by inputs of paid media spend and benchmarks for cost per lead, conversion rates, and average sales price. Forecasts aggregated by region and channel.

Englewood, Co

• Designed and developed various marketing performance dashboards which incorporated pipeline/sales metrics, funnels, and contribution percentages. Tableau based dashboards included extensive filtering and drill-down capabilities. Merged Salesforce, Oracle Eloqua, Conversica, Drift, and Adobe Analytics data sources in Alteryx to feed the dashboards. Also built an Alteryx custom macro to abstract data retrieval from the Oracle Eloqua Bulk API.• Designed and created a Tableau based Sales/Marketing dashboard app to identify cross-sell opportunities and new accounts. Stitched S&P Capital IQ account data with customer purchases using fuzzy match logic in Alteryx.• Built data migration processes in Alteryx for a WCM taxonomy switch-out, the population of Expert profiles, and several CRM migrations.• Executed more than 100 website migrations which entailed various technical SEO and redirect strategies, movement and cleansing of web-based content, plus the specification of DNS changes. Highly skilled with Screaming Frog and Google Search Console.• Developed Eloqua lead scoring models in Alteryx, encompassing Random Forest and Generalized Boosted (GBM) machine learning algorithms.• Implemented Adobe Analytics on a redesign of the corporate website. Included definition of both business & technical requirements, JavaScript/jQuery coding (1500+ lines of code), administration, and report/dashboard creation.

Englewood, Colorado, United States

• Defined and deployed new advertiser performance and consumer usage reports to 1500+ end-users in the local and national sales forces. Coordinated 4 data warehouse and report developers. Included but not limited to the design of the website logging and the associated 3 TB data repository.• Gathered and wrote both business requirements and detailed specifications for implementing Adobe Analytics (formerly Omniture) on DexKnows.com. Entailed 30+ custom variable and 15 custom event definitions that provided reporting around traffic sources, advertiser engagement, and internal search types & phrases.

Greenwood Village, Colorado, United States

Highlands Ranch, Colorado, United States

Greenwood Village, Colorado, United States