Pinupolu Sai Praneeth

Marketing Spend Optimization & Business Impact Analysis

• Collected and analyzed monthly marketing spend and lead performance data using Excel and SQL.
• Built a basic comparison model to evaluate cost per lead, credit loss, and business impact across partners.
• Helped reallocate budgets based on data insights, resulting in 5.2% cost savings and 8% monthly business growth.

Lead Qualification Analysis for Partner Channels

• Extracted and analyzed lead data from multiple sourcing partners to identify qualification patterns.
• Created partner-wise dashboards to track unlock rates and lead conversion using pivot tables.
• Improved unlock rate from 13.5% to 37% and supported onboarding of 8 new partners.

Customer Targeting Model Using Profile Signals

• Compiled customer data (recency, frequency, credit score) to build a basic targeting model in Excel.
• Segmented leads into priority groups to guide campaign targeting and reduce marketing waste.
• Increased engagement and improved ROI by optimizing messaging to high-potential segments.