Start Your Project with Us

Whatever your project size is, we will handle it well with all the standards fulfilled! We are here to give 100% satisfaction.

  • Any feature, you ask, we develop
  • 24x7 support worldwide
  • Real-time performance dashboard
  • Complete transparency
  • Dedicated account manager
  • Customized solutions to fulfill data scraping goals
Careers

For job seekers, please visit our Career Page or send your resume to hr@actowizsolutions.com

Real-Time Regional Insights with Customizable E-commerce Dashboards

Introduction

Introduction

In a crowded digital marketplace, the success of FMCG brand promotions increasingly hinges on hyperlocal visibility and stock availability. A discount campaign is only effective if the product is (a) visible to shoppers and (b) available for purchase—both of which can vary drastically based on geography and platform algorithms.

Actowiz Solutions empowered a leading FMCG conglomerate to optimize regional promotions by scraping product rankings and availability data at the pin code level across Amazon, Flipkart, and BigBasket. The result? Better ROI on promotions, reduced wastage, and improved digital shelf share.

Business Problem

The client's promotional campaigns were not converting as expected. After investigation, they uncovered three critical gaps:

  • 🚫 Discounted SKUs weren’t ranking on page 1 for many pin codes.
  • 📦 Out-of-stock issues in target locations led to lost conversions.
  • 🧩 There was no centralized view of availability vs promotion vs visibility.

They needed real-time insights into:

  • Product ranking by keyword and category
  • Stock status at the pin code level
  • Promotion mapping to visibility zones

Actowiz Solutions Strategy

A. Targeted Web Scraping Deployment

We designed platform-specific scrapers with:

  • 📍 Pin code-switching modules for regional simulation
  • 🔍 Keyword-based ranking extraction to track product placement on search pages
  • 📦 Stock status detection per listing (in-stock, out-of-stock, limited stock)
  • 📊 Scheduled crawls every 6 hours for time-sensitive insights
B. Product Intelligence Framework

The scraped data was structured into a product availability and visibility matrix, including:

  • Product Rank Position
  • Page Number
  • Keyword Performance
  • Regional Availability
  • Fulfillment Partner
  • Delivery SLA

Sample Data Output

Platform Pin Code Product Name Keyword Rank Availability Delivery Time Promotion Active Page No
Amazon 560001 Colgate 200g toothpaste 3 In Stock 1 Day Yes 1
Flipkart 110001 Colgate 200g toothpaste 15 Out of Stock - Yes 2
BigBasket 400001 Colgate 200g toothpaste 1 In Stock Same Day No 1

Insights Delivered

✅ 1. Promotional ROI Boosted by 28%

By aligning discounts only in pin codes where:

  • Product was ranking within top 5 positions, and
  • Inventory was confirmed as in-stock

This reduced budget wastage in low-converting areas.

✅ 2. Visibility-Based Campaign Triggers

Using real-time ranking data, promotions were deployed where the SKU had:

  • High organic rank (top 3)
  • Strong seller performance
  • Faster fulfillment via platform partners (Cloudtail, RetailNet, etc.)
✅ 3. Reallocated Spend from Low-Impact Zones

Regions where products were consistently below page 2, or out of stock, were deprioritized, and funds were reallocated to high-converting zones.

✅ 4. Predictive Stock vs Rank Dashboard

Actowiz delivered a BI dashboard that overlaid:

  • Live stock vs historical promotion performance
  • SKU-wise regional ranking
  • Promo fatigue indicators (e.g., when ranking dropped despite active discounts)

Dashboard Example (Illustrative)

📍 Region-Wise SKU Ranking vs Availability Matrix
City SKU Rank Availability Promotion Running Action Needed
Mumbai Colgate 1 In Stock Yes Optimize Bid
Bangalore Colgate 8 In Stock Yes Stop Campaign
Ahmedabad Colgate 2 Out of Stock Yes Replenish SKU

Tech Stack & Delivery

  • Scraping Tools: Python (Selenium, BeautifulSoup, Playwright)
  • Data Processing: Pandas, PostgreSQL
  • Storage: AWS S3 + MongoDB
  • Visualization: Power BI & Google Data Studio
  • Delivery Frequency: 4x Daily, API + Excel Export

Why It Worked

Unlike traditional scraping that focuses on price or stock alone, Actowiz Solutions combined:

  • 🎯 Search position scraping (per keyword)
  • 📦 Real-time stock tracking
  • 📍 Location-aware pin code emulation
  • 🤖 Automation triggers for promo optimization

This allowed the client to create data-driven campaign segmentation, improving efficiency and increasing ROI across Tier-1 and Tier-2 markets.

Future Enhancements

  • 📲 Integrate real-time promotion heatmaps for D2C vs Marketplace
  • 🧠 Use AI/ML to auto-recommend pin codes for future campaigns
  • 📦 Add shelf-share tracking with image-based scraping
  • 🚀 Expand to additional platforms like JioMart and Blinkit

Business Impact Summary

KPI Before Actowiz After Actowiz
Promo ROI 3.8x 4.9x
Regional Conversion Rate 12% 18%
Campaign Wastage 27% 8%
Out-of-stock promo loss ₹24 Lakhs/Q ₹4.8 Lakhs/Q
Time to Insights 3 Days <4 Hours

Client Testimonial

“We were running blind before Actowiz came in. Now our campaigns are targeted, measurable, and regionally smarter. It’s like having a promotional GPS.”

— Head of Digital Commerce, Top 10 Indian FMCG Brand

Conclusion

In today's hyper-competitive D2C and marketplace landscape, promotional efficiency is not about blanket discounts, but about precision targeting.

Actowiz Solutions proved how scraped data on product rankings and stock status can transform how FMCG brands plan, execute, and optimize regional campaigns—one pin code at a time.