About this internship

Data Integration & Pipeline Set-up

  • Multi-Platform Data Scraping: Pulling advertising spend data from ad managers (Meta Ads, Google Ads, LinkedIn Campaign Manager) and matching it with transaction/revenue data from internal CRM or e-commerce platforms (Shopify, WooCommerce, Salesforce).
  • UTM Parameter & Tracking Audit: Auditing or setting up strict UTM tracking links (Source, Medium, Campaign tags) to ensure that every visitor coming to the website can be traced back to a specific marketing channel or campaign.
  • Data Cleaning & Currency Alignment: Using Python (pandas) or Excel to merge daily ad spends with daily sales revenue, accounting for data delays, currency conversions, and refunds.

 

Marketing Attribution Modeling

  • Rule-Based Attribution Analysis: Building models in Excel or Python to compare traditional allocation methods:
    • First-Touch Attribution: Giving 100% of the sales credit to the first channel that introduced the customer to the brand.
    • Last-Touch Attribution: Allocating all credit to the final ad clicked right before the purchase.
    • Linear & Time-Decay Attribution: Spreading the credit across all touchpoints evenly or heavily weighting the touchpoints closest to the conversion.
  • Data-Driven/Algorithmic Modeling: Utilizing Markov Chains or Shapley Value models (game theory) to calculate the mathematical contribution of each channel when a customer interacts with multiple ads before buying.

 

Unit Economics & Efficiency Metrics

  • CAC Calculation: Computing the Customer Acquisition Cost (Total Channel Ad Spend ÷ Number of Customers Acquired) for each individual channel.
  • ROAS & ROI Formulation: Calculating the financial efficiency metrics for every marketing rupee spent:
    • Return on Ad Spend (ROAS): Revenue Generated ÷ Ad Spend
    • Marketing ROI: (Revenue - Ad Spend - Cost of Goods Sold) ÷ Ad Spend
  • Customer Lifetime Value (LTV) Mapping: Matching the source channel of a customer with their repeat purchasing behavior over time to determine which channels bring in the highest-value long-term buyers.

 

Data Visualization & Budget Optimization

  • Performance Dashboarding: Developing live dashboards using Tableau, Power BI, or Looker Studio that visualize key performance indicators (KPIs) like Cost Per Click (CPC), Click-Through Rate (CTR), Conversion Rate (CR), and ROAS across all channels.
  • Budget Reallocation Modeling: Running a mathematical optimization scenario to answer: “If we shift ₹50,000 from underperforming Meta campaigns to high-intent Google Search campaigns, what is the projected increase in net profit?”
  • Executive Presentation: Compiling a concise deck for management detailing clear recommendations on which channels to scale up, which to optimize, and which to cut completely.

Courses included free