Sankranti Campaign Analysis

Solution

To summarize the effectiveness of each Sakshi Telugu OTT Sankranti campaign (Alanati, Baahubali, Cheppave) in generating subscriptions among different districts of Telangana and Andhra Pradesh for Lakshman Rao, I would primarily use the following descriptive statistics:

• 1. Total Number of New Subscriptions per Campaign:
  • The absolute count of new subscribers attributed to Campaign Alanati (Star Maa IPL ads), Campaign Baahubali (YouTube stars like Nagababu, Jabardasth comedians), and Campaign Cheppave (billboards at RTC X Roads, Ameerpet, Kukatpally) individually. This provides an overall measure of reach and conversion for each.
• 2. Number of New Subscriptions per Campaign, Broken Down by District:
  • A cross-tabulation (or contingency table) showing the count of new subscriptions for each campaign within each specific district of Telangana and Andhra Pradesh.
  • Example:
    • Campaign Alanati: Hyderabad - X subs, Warangal - Y subs, Krishna - Z subs, etc.
    • Campaign Baahubali: Hyderabad - A subs, Warangal - B subs, Krishna - C subs, etc.
    This directly answers where each campaign resonated most geographically for viewers interested in new web series or classic NTR/ANR films.
• 3. Proportion/Percentage of New Subscriptions per Campaign, by District:
  • For each campaign, calculate the percentage of its total subscriptions that came from each district.
  • Example: For Campaign Alanati, if it got 1000 total subs and 300 were from Hyderabad, then 30% of Alanati's subs are from Hyderabad.
  • This helps understand the relative contribution of each district to a campaign's success, normalizing for different population sizes or campaign reach in those districts.
• 4. Proportion/Percentage of a District's Total New Subscriptions Attributable to Each Campaign:
  • For each district, calculate what percentage of its total new Sakshi Telugu OTT subscriptions (from any of these three campaigns) came from Campaign Alanati, Campaign Baahubali, and Campaign Cheppave.
  • Example: If Hyderabad district got 500 total new subs from these campaigns, and 300 were from Alanati, then Alanati contributed 60% of Hyderabad's new subs from these efforts.
  • This helps understand which campaign was most dominant or effective within a specific geographic area.
• (If data on campaign reach/impressions is available) Conversion Rate per Campaign (Potentially by District):
  • While not purely descriptive of the subscription data alone, if Lakshman Rao has data on how many people were potentially exposed to each campaign (e.g., estimated TV viewership for Alanati, views for Baahubali, estimated footfall for Cheppave), a conceptual conversion rate (Subscriptions / Reach) could be discussed. This would be a more advanced effectiveness measure. For a purely descriptive summary of collected subscription data, the above points are primary.

These statistics will provide Lakshman Rao a clear overview of which campaigns performed best overall and highlight geographic strengths and weaknesses for each, allowing for targeted insights for future strategies for Sri Sai Digital Solutions and Sakshi Telugu OTT.

Solution

For presenting the campaign effectiveness results to Padma Reddy, CEO of Sakshi Telugu OTT, at the board meeting at Novotel HICC, the most appropriate primary visualization would be a Grouped Bar Chart or a Stacked Bar Chart.

1. Grouped Bar Chart:

• Structure:
  • The X-axis would represent the different districts or regions (e.g., Hyderabad, Visakhapatnam, Warangal, Rajahmundry, other key districts in Telangana and Andhra Pradesh).
  • For each district, there would be a group of three bars, each representing one of the campaigns (Campaign Alanati, Campaign Baahubali, Campaign Cheppave).
  • The Y-axis would represent the number of new subscriptions. Different colors would be used for each campaign type.
• Why it's Effective for Comparing Urban vs. Tier-2 Cities:
  • Direct Comparison within Locations: It allows Padma Reddy to easily compare the performance of the three campaigns (Alanati - Star Maa IPL, Baahubali - YouTube/Jabardasth, Cheppave - Billboards at RTC X Roads) side-by-side within each specific location (e.g., see which campaign drove most subs in Hyderabad, then separately for Warangal).
  • Highlights Regional Differences in Campaign Efficacy: It visually demonstrates if one campaign type (e.g., social media - Baahubali) performs exceptionally well in urban centers like Hyderabad and Visakhapatnam (perhaps due to higher internet penetration or demographic affinity for YouTube stars like Nagababu), while another (e.g., billboards - Cheppave) might have better relative performance in tier-2 cities like Warangal or Rajahmundry where traditional media might still have strong impact for reaching audiences interested in classic NTR/ANR films or new web series.
  • Shows Absolute Performance: The height of the bars directly reflects the number of subscriptions, making it easy to see the scale of success in different areas. This can illustrate whether urban centers are driving the bulk of subscriptions versus tier-2 cities.

2. Stacked Bar Chart (100% Stacked for Proportions, or Absolute Stacked for Totals):

• Structure (Absolute):
  • X-axis for districts. Each district has one bar.
  • The bar for each district is segmented by color, with each segment representing the number of subscriptions from Campaign Alanati, Baahubali, and Cheppave. The total height of the bar is the total subscriptions for that district from these campaigns.
• Structure (100% Stacked):
  • Similar to absolute, but each district's bar goes up to 100%, and the segments show the proportion of subscriptions each campaign contributed within that district.
• Why it's Effective:
  • Shows Composition: Clearly illustrates the mix of campaigns contributing to subscriptions in each location. A 100% stacked bar chart is particularly good for seeing if, for example, Campaign Baahubali makes up 60% of Hyderabad's subscriptions but only 20% of Rajahmundry's, indicating different campaign dynamics.
  • Comparison of Relative Importance: Helps understand the dominant campaign(s) in urban centers (Hyderabad, Visakhapatnam) versus tier-2 cities (Warangal, Rajahmundry).

Alternative/Complementary Visualization:

• Geographic Heatmap (Choropleth Map) of Telangana and Andhra Pradesh:
  • Districts colored based on the total number of subscriptions, or the conversion rate of the most effective campaign in that district. This provides a quick, high-level overview of geographic hotspots for Sakshi Telugu OTT. Could be useful as an opening visual before diving into bar charts.

For the board meeting at Novotel HICC, I would likely lead with a Grouped Bar Chart to show absolute numbers and allow easy comparison of campaigns within each key city/district. Then, I might use a 100% Stacked Bar Chart to emphasize the proportional contribution of each campaign type in urban versus tier-2 locations, as this directly addresses how strategies might need to differ. This combination effectively communicates both the scale and the relative success of the campaigns across diverse markets to Padma Reddy and other stakeholders.

Solution

With the collected demographic data (age, preferred Telugu dialect, occupation), Sri Sai Digital Solutions can perform a more granular descriptive analysis to identify specific segments that responded best to each Sankranti campaign for Sakshi Telugu OTT. This would involve:

Further Descriptive Analysis with Demographic Data:

1. Cross-Tabulation of Subscriptions by Campaign and Demographic Variables:
   • Create multi-dimensional contingency tables (or a series of two-way tables) to see the number of new subscriptions:
     • Per Campaign AND Age Group (e.g., 18-24, 25-35, 36-50, 50+).
     • Per Campaign AND Preferred Telugu Dialect (Telangana, Coastal Andhra, Rayalaseema).
     • Per Campaign AND Occupation (IT professionals, government employees, students, others).
     • Even three-way tables if sample sizes allow (e.g., Campaign by Age Group by Occupation).
   • Calculate proportions/percentages within these cross-tabulations. For example, what percentage of IT professionals who subscribed came from Campaign Baahubali vs. Campaign Alanati?
2. Profile of Subscribers for Each Campaign:
   • For each campaign (Alanati, Baahubali, Cheppave), describe the demographic makeup of the subscribers it generated.
   • Example for Campaign Alanati (Star Maa IPL ads): "Subscribers from Campaign Alanati were predominantly [Age Group X], with a high concentration of [Occupation Y] who prefer the [Dialect Z], and showed strong interest in classic NTR/ANR films."
3. Comparative Analysis of Demographic Response:
   • Compare the demographic profiles across the three campaigns. Did Campaign Baahubali (YouTube stars like Nagababu) attract a significantly younger audience or more students interested in new web series compared to Campaign Alanati? Did Campaign Cheppave (billboards at RTC X Roads, Ameerpet, Kukatpally) resonate more with a particular occupation or dialect group?
4. Visualizations for Demographic Insights:
   • Grouped or Stacked Bar Charts: For each campaign, show bars representing different age groups (or occupations, or dialects) and the number/percentage of subscriptions from each.
   • 100% Stacked Bar Charts: To compare the proportional demographic makeup of subscribers attracted by each campaign.
   • Pie Charts (used cautiously): Could show the breakdown of a single campaign's subscribers by one demographic variable (e.g., occupation mix for Campaign Baahubali).

Informing Future Promotions (Ugadi or Dasara Festivals):

This deeper analysis by Sri Sai Digital Solutions for Lakshman Rao would significantly inform future promotions for Sakshi Telugu OTT:

• Targeted Campaign Strategies:
  • If Campaign Baahubali (social media with YouTube stars) was highly effective among young IT professionals interested in new-age Telugu web series, similar digital campaigns with relevant influencers can be planned for Ugadi, perhaps with messaging tailored to that demographic.
  • If Campaign Alanati (Star Maa IPL ads) successfully attracted an older demographic interested in classic NTR/ANR films, similar TV ad placements during popular general entertainment shows or movies could be considered for Dasara.
• Content-Channel-Audience Alignment:
  • The analysis can reveal which channels (TV, social media, OOH like billboards at Ameerpet) are best for reaching specific demographic segments interested in particular types of content (e.g., new web series vs. classic films).
  • For instance, if students primarily responded to social media campaigns, future student-targeted content could be heavily promoted there.
• Personalization of Messaging (Dialect/Regional Nuances):
  • If data shows that ads using a specific Telugu dialect (e.g., Telangana dialect by Jabardasth comedians in Campaign Baahubali) led to higher conversions in that region, future ad creatives can incorporate more localized language or cultural references.
• Budget Allocation:
  • Lakshman Rao can make more data-driven decisions on how to allocate marketing budgets for Ugadi or Dasara across different campaign types and channels based on their proven effectiveness with key target segments from the Sankranti analysis.
• Identifying Untapped Segments:
  • The analysis might also reveal demographic segments that did not respond well to any of the Sankranti campaigns, prompting investigation into why and how to better reach them during future festivals.

By understanding these granular details, Sakshi Telugu OTT can optimize its marketing spend, tailor its messaging, and choose the most effective channels to attract desired subscriber segments during subsequent festive seasons like Ugadi and Dasara.