Duncan Macgregor Email & Phone Number

Phoenix, Arizona, United States

Develop analytical tools to provide clients of LocaliQ's Automotive Division deep insights into the performance of their dealership, advertising and inventory mix. Build relationships with analytically-minded clients and help them grow their sales and profitability.

Tempe, Arizona, United States

Bringing a fresh and fun perspective to the pre-owned car buying experience. At the intersection of technology and innovation, using proprietary tools and over two decades of industry knowledge to redefine the process of purchasing, financing and protecting a vehicle. Helped DriveTime customers find affordable and reliable transportation by providing the 16 Reconditioning Centers with accurate reporting and actionable insights to more efficiently provide services that add value to car buyers.

Phoenix, Arizona Area

Combining the resources of Gannett with a nationwide network of trusted media consultants to deliver powerful digital and print advertising solutions that help businesses grow.Applied data analysis to help auto dealerships understand the market and their place in it. Identified opportunities to improve the effectiveness and efficiency of advertising campaigns. Worked with clients to improve and expand their businesses.• Developed the LOCALiQ Dealer Scorecard to give auto dealers unprecedented market insight and enable a revolutionary metrics-based go-to-market strategy, realizing $5MM revenue growth in the first six months.• Built a functioning revenue optimization model to increase the utilization rate and profitability of unsold limited-inventory ad units.• Changed how state lotteries nationwide schedule advertising for draw games using regression analysis to identify when to start spending to influence demand.

Phoenix, Arizona Area

Boutique consulting firm helping clients better understand and market to their customers. AI develops analytical, reporting and selling tools to bring a fresh perspective on their business. Engagements:• Produced dashboard reporting for a major California winery to find trends in consumer perceptions of product and brand quality from direct contact and social media data.• Created selling tools and training for a global cyber security firm, allowing sales reps to define value for their flagship software product and demonstrate ROI to potential clients.• Evaluated pricing for Chinese startup’s innovative SaaS database and and advised senior management on options to capture the value of pioneering marketplace services.

Dfw Area Tx And Phoenix Az

Provider of advertising and e-commerce solutions for small to medium businesses, including website design, social media content, presence management, e-stores, SEM and SEO as well as traditional directory and direct mail products.• As an internal consultant reporting directly to the department VP, identified opportunities and led initiatives to generate revenue and cut costs in a rapidly-changing industry.• Partnered with Sales to build proposals for the largest, most difficult clients.• Developed KPI reporting and analysis for Sales, Marketing and C-suite to measure value, performance and competition.

Dfw Area Tx

• Built and managed a department of 8 managers and analysts in a newly-reorganized $2B company. • Set goals, defined strategy, prioritized tasks and championed new initiatives throughout the organization. • Launched systems to automate price administration and proposal building.

Dfw Area, Tx

• Managed price administration and coordinated regional pricing groups in a decentralized corporate structure.• Introduced demand-based segmentation for existing products and set value-based prices for new products.• Guided competitive response by introducing reporting to assess market position and relative value.

Dfw Area Tx

• Partnered with the National Sales group and client ad agencies to identify opportunities for improving marketing efforts to major corporations.• Restaged mature advertising trademark product with unique flat-rate pricing bundled with a digital counterpart.

Dallas Tx

The nation’s leading airline in terms of passengers carried, customer satisfaction and uninterrupted profitability.• Managed production of print, outdoor and collateral advertising by creative agencies to build awareness of fare sales, new service and the Southwest brand.• Supervised TV, radio, newspaper, magazine and outdoor placements with media agency for a rapidly-growing, promotion-driven company with a sizable advertising budget.• Analyzed booking trends to determine impact of fare promotions and plan for new offers.

Dallas Tx

• Determined seat and fare inventory on flights in competitive western-US markets to maximize profitability.• Developed comprehensive training and performance metrics for the newly-created department.

Bachelor Of Science (Bs), Finance

Activities and Societies: Pi Sigma Epsilon, Alpha Phi Omega

Master Of Business Administration (Mba), Marketing

Education record

Dex Media Marketing Management Development Program Southwest Airlines CORE Management Training Program Professional Pricing Society.