Use your myTVS Google Workspace account or an approved Google email. Access is restricted to emails approved by the dashboard admin.
Dashboard Access
Add approved Google emails and choose page access.
Choose All pages for full access, or select specific pages from the dropdown.
D2C Dashboard/Dashboard
Local DB
All Categories▼
All Products▼
Loading...
Channel-wise Breakdown
Last 15 Days — Gross Sales Trend
Ad Spend — Daily Trend (Google vs Meta)
Category-wise Summary
UTM Source Breakdown
Loading...
TI-18 · Product ID 3145
Action Plan
Ranked by expected sales impact. Every item below is recommendation-only until approved.
Loading TI-18 analysis...
WhatsApp Abandon Performance
Automated WhatsApp sequence on abandoned checkouts — message 1 at +30 min, reminders at +6.5 h and +30.7 h.
Skipped = the customer had already ordered, so nothing was sent. Ordered = that mobile number placed a web order within 7 days (tester orders, cancellations and returns excluded). A journey runs about 55 h end to end, so the last 2–3 days are still maturing and will keep moving.
Reflects the same filters (date range, stage, source, contact, risk profile) as the Abandoned Checkouts table below · GST excluded at 18%
Loading...
Abandoned Checkouts
Loading...
CS Action Items
To Be Blacklisted
Customers with 3+ cancellations, 3+ returns, or 50%+ failure rate on COD orders (testers excluded)
Paste the Shiprocket blocklist
Copy the complete COD blocklist from the Shiprocket / Fastrr checkout rule and paste it here. The two lists are made to match: pasted numbers move into Blacklisted, and anything missing from the paste comes back into this list.
Loading...
Order History
Blacklisted Customers
Customers already blocked on Shiprocket COD blocklist
Loading...
Tester Orders
Orders from known internal team members — excluded from blacklist
Loading…
Loading…
Loading…
Change History
Audit log of state mutations across Amazon / Google / Meta — auto-detected via diff-on-sync plus user-recorded actions
Loading…
Dispatch Split — who carried the Shopify orders
Loading...
Why these orders did not go to Quickshift
Quickshift — State-wise Performance
Loading...
Order Details
Inventory at Quickshift
Live stock at Quickshift fulfilment centers
Loading inventory...
Pincode Coverage by State
Quickshift-serviceable pincodes from RDS
Loading pincode coverage...
Sale Projection — best case
Demand is stock-corrected: units ÷ days the SKU was actually sellable, not calendar days —
so a SKU that spent the window out of stock is projected on what it would have sold.
Growth defaults to each SKU’s own recent trend (floored at 0% — a best-case table never projects a decline).
Override anything per SKU; overrides survive every rebuild.
Loading...
—
—
Set this when you know the SKU can do more than history shows — e.g. a listing about to be fixed, or a channel about to open. Blank = use the stock-corrected rate.
Applied month on month from the current month. Blank = the SKU’s own trend, floored at 0%.
Blank = keep the historical mix. Use this when a channel is about to be relisted (e.g. an Amazon listing coming back live).
For a SKU that is out of stock now and only re-launches when the PO lands.
Amazon Listings
All products listed on Amazon.in with live stock, price and Buy Box status
Loading...
All Couriers▼
Logistics — Courier-wise Performance
Loading...
Order Details
CoD Pincodes — Performance & Recommendations
Pincode × courier breakdown of COD orders. Recommendation updates from the latest data each time you change the date range or filter — no static blocklist.
Block-COD / Prepaid-only candidates surface automatically as the return pattern emerges.
Date Range
From
To
Courier
Min COD Orders
Recommendation
Search
Click Apply to load.
🧠 Analyst Recommendations
Independent AI analyst — research + operator data verified against the live account, ranked by ₹ impact. Proposals only — approve before acting.
Loading…
Cron Jobs
Everything scheduled on the VPS — the root crontab plus our systemd timers.
All times are IST. Last run comes from cron's own journal, so it is what
actually executed, not what was supposed to.
Frequency
Time (IST)
Job
What it does
Ends / Expiry
Last run
Status
Loading…
✅ AI Approvals
Actions proposed by AI agents, pre-checked against hard guardrails (approval_guardrails.json). Approve executes instantly via the platform API; reject discards. Out-of-bounds proposals are auto-rejected before they reach you.
⏳ Pending your approval
Loading…
History
Loading…
Pricing
Product-level marketplace and trade price reference from the latest pricing snapshot.
Loading pricing...
All Categories▼
All Sub-Categories▼
All Products▼
Sort by (multi-level)
Price Comparison — what each channel is selling at
Selling price per channel, side by side. Price Issue = Yes when Amazon or Flipkart is selling below myTVS — our own storefront being undercut where we control the listing. A channel with no live listing is never counted as an undercut. Click an Amazon or Flipkart price for its full margin breakup.
All Categories▼
All Sub-Categories▼
Loading price comparison...
Internal — Pricing Reference
All numbers are excl GST — output GST is treated as govt liability and input GST on purchases / platform fees is netted as recoverable ITC. Covers every product live on a channel — myTVS rows come from the live mytvs.com (Shopify) catalogue, Amazon/Flipkart from their active listings — so a SKU that simply hasn't sold in 90 days still shows its margin, tagged LISTED. Selling price is the live listing price where we have one, else the most recent order in the last 90 days; purchase price is master cost (excl GST).
Amazon SAFE-T is synced daily — set this by hand only for Flipkart SPF or a correction.
Mark Disputed
Profit & Loss Statement
Monthly P&L — all values excl. GST. COGS available from Apr 2026 onwards.
Loading...
All Categories▼
All Products▼
Section 1: Traffic to Gross Conversion
Ad spend & traffic from local ads cache · Gross orders & revenue from UTM-attributed Shopify orders
Loading MTD ads data...
Section 2: Gross to Net Revenue
Gross orders → Cancelled → Returns → Net delivered orders & revenue · Net ACOS = Ad Spend ÷ Net Revenue
All Categories▼
All Products▼
Engagement · YouTube
YT Comments — Reply Manager
Unanswered comments across @myTVSAccessories with AI-suggested replies. Review, edit and post one by one.
Video Title
Comment Date/Time
Comment
Suggested Reply (editable)
Action
No comments in this view.
Advertising · Meta
Meta Ads — Performance & Optimization
Facebook + Instagram campaigns from the Meta Marketing API merged with Shopify ground truth for net economics. Period set by the filter bar above.
✨ AI Action Items — Meta
Same unified engine + same recommendations as the AI Recommends tab (dual-window · attribution-lag · change-aware · auto root-cause). Meta supports live Apply.
on — Apply only stages
Loading…
Loading…
01
Channel & Trend
— how spend is distributed and tracking through the period
Meta Ad Spend — Daily Trend
01
Campaign Performance
— sortable, drill into ad-sets & ads
Meta Ads — Campaign Performance
Campaign & ad set data from local Meta cache · Orders matched by campaign_id in UTM URLs
Loading MTD Meta campaign data...
03
AI Recommendations & Action Items
— Claude-generated optimization plan with approval + execute workflow
Dynamic recommendations from Claude Opus 4.7 · Net economics on Shopify ground truth
Checking write access…Unlocked · 0m left
No recommendations yet. Click "Generate / Refresh" to run Claude analysis on the current period.
Audit Log
Click Refresh to load action history.
Advertising · Google
Google Ads — Performance & Optimization
Search + Performance Max campaigns from the Google Ads API merged with Shopify ground truth for net economics. Period set by the filter bar above.
Loading…
02
Campaign Performance
— sortable, drill into ad-groups, ads & PMax asset-groups
Google Ads — Campaign Performance
Cost data from local Google Ads cache · Orders matched via gclid / utm_source=google
Loading…
03
Product-wise Sales
— Shopify orders attributed to Google Ads · Sale total ties to the KPI gross sales
Google Ads — Product-wise Sales
Per-product units & sales (excl. GST) for orders attributed to Google via gclid / utm_source=google · Sale total = KPI Conversion Value
Loading…
Advertising · Google
PMax Landing Monitor
Where each Performance Max campaign's clicks actually land (after Final URL expansion) — live from the Google Ads API. Red note = traffic going somewhere off-theme (wrong category / OOS / homepage). Top 20 URLs by spend per campaign, last 30 days.
01
Where clicks land (by URL)
— actual landing pages after Final URL expansion. Clicks, not impressions (expansion impressions are unreliable — see the SKU funnel below).
Tracking the restructure through its learning phase. Sub-tabs split no-lag signals (judge daily) from attribution-matured outcomes (judge after ~7 days).
⚡ No attribution lag — these are safe to judge today
Impressions, clicks, CTR, CPC, spend and budget utilisation settle within ~48h. Orders / sales / ACoS are not here — they take ~7 days to mature and live in Matured Conversions. Each category is graded against its restructure plan (grow / wind-down / hold), so a fall in Wipers reads as success, not failure.
Account SP spend vs cap
Loading…
Category scorecard — last 7 days vs prior 7 days
Each category vs its restructure plan. Δ = last 7 days vs the 7 days before. CTR is impression-weighted (SB banners pull it down). Util = avg daily spend of enabled campaigns ÷ their combined daily budget.
Loading…
Daily trend (last 21 days)
Rows on/after the restructure date are highlighted. Watch impressions/clicks build (growth bets) or fade (wind-downs).
Advertising · Amazon
Amazon Ads — Performance & Optimization
Native Amazon attribution merged with Shopify ground truth for net economics. Period set by the filter bar above.
Amazon Ads not connected
Click Connect to authorize the dashboard to read your Amazon Advertising account
(one-time OAuth flow). API access approval from Amazon is required first — typically 24-72 hours
after submitting the application at advertising.amazon.com.
Native Amazon attribution (7-day click) · Action history is date-independent
Data range: —
Sync: Local SQLite ← Amazon Ads API; 05:00 IST yesterday-only + 15:00 IST recent 7 days; manual sync available.
Loading…
01
Channel & Trend
— how spend is distributed and tracking through the period
Amazon Ad Spend — Daily Trend
Amazon Ads — Channel Summary
Aggregated by ad product · Updates with the date range filter above
Loading…
02
Where the money goes
— product × strategy with auto-classified verdicts
▶🎯 Where the money goes (Product × Strategy)
Spend grouped by product + ad strategy · Auto-classified verdict per row · Click # Camps to filter the Campaign Performance table below
Loading…
Advertising · Strategy
Amazon recommendations
Agency-style growth playbooks for product-level bets, new campaign creation, upper-funnel video, DSP, and AMC. This page intentionally skips existing campaign-level fixes.
What the agency pitch adds beyond our current dashboard
Regro's deck is strongest on the full-funnel operating model: create demand with DSP/video, capture intent with Sponsored Products and Sponsored Brands, convert with tighter Amazon search/catalog coverage, and retain through DSP/Sponsored Display retargeting. The useful takeaway is not to outsource ordinary bid hygiene; it is to build campaigns we are not running today.
Use Amazon MX Player and Streaming TV for new-to-brand reach, then retarget viewers who engaged but did not buy. Start with hero products where the use case is easy to understand in 6-15 seconds.
Tyre inflator: emergency, highway, monsoon, family safety.
Car accessories: convenience and maintenance bundles.
Create campaigns around buyer intent and occasion, not only around SKU names. Each product should have separate campaign roles for category capture, competitor conquesting, branded defense, and remarketing.
Sponsored Brands Video for category education.
Exact search campaigns for proven terms.
Product targeting against substitute ASINs.
Measurement discipline
Judge awareness campaigns by assisted outcomes, not same-day ACOS alone. Use AMC/DSP audiences to compare exposed vs unexposed cohorts, new-to-brand rate, branded search lift, PDP lift, and retargeting conversion.
Separate prospecting budget from harvest budget.
Track 7/14/30-day view and click paths.
Move winners into always-on retargeting pools.
01
Strategic campaign playbooks
— product-level ideas for incremental Amazon growth
Funnel role
What to launch
Product-level idea
Why it can grow Amazon business
How to measure
Demand
Amazon MX Player pre-roll / mid-roll video and contextual display
Run a problem-solution video around tyre pressure emergencies, monsoon driving, highway trips, and family car safety. Land traffic on the strongest ASIN or Store page.
MX Player gives contextual video inventory in India; Amazon case studies show high completion/CTR when the content context matches the product use case.
Reach, video completion rate, PDP views, branded search lift, new-to-brand sales, retargeting pool size.
Demand
Streaming TV campaign under Amazon's Streaming TV offering
Use a premium 15-20 sec video for hero SKUs. Target auto intenders, recent auto accessory shoppers, in-market buyers, and geography clusters where Amazon delivery economics are strong.
Amazon Streaming TV now sits under the wider Streaming TV ads offering and supports full-screen video across Prime Video, Fire TV Channels, Twitch, and third-party publishers where available.
View-through PDP visits, add-to-cart rate, branded search growth, exposed vs unexposed conversion in AMC.
Intent
Sponsored Brands Video category campaign
Create category-led videos for "portable tyre inflator", "car air pump", "car safety kit", and "road trip essentials"; split exact, phrase, and broad discovery into separate budgets.
Captures shoppers who already have intent but need education on trust, warranty, speed, PSI, and emergency utility before they choose a brand.
Build ASIN-target campaigns against cheaper, lower-rated, or weaker-feature competitor listings. Pair with a comparison-led image/video and coupon where margin allows.
This creates new demand capture without relying only on generic keywords, and it can steal buyers at the comparison stage.
Product-target ACOS, share of advertised sales by target ASIN, add-to-cart, coupon redemption, rank on priority terms.
Retain
DSP / Sponsored Display retargeting ladder
Retarget video viewers, Store visitors, PDP viewers, add-to-cart non-buyers, and past purchasers with different messages: proof, offer, bundle, warranty, accessory cross-sell.
The agency deck's useful retention idea is connecting DSP and Sponsored Ads audiences instead of treating every click as cold traffic.
Create an AMC report that answers: which video exposure sequences create Amazon search, which audiences produce first-time buyers, and how many touches are needed before purchase.
This prevents upper-funnel tests from being killed by last-click ACOS before they have time to build demand.
Path-to-purchase, exposed/unexposed lift, NTB rate, branded query lift, retargeting conversion after video exposure.
02
30-day launch sequence
— practical order of execution
Week 1: choose products
Pick 2 hero products with clean listings, enough reviews, inventory depth, and margin room.
Create one Amazon Store landing page per use case, not only per product.
Lock the offer: coupon, bundle, warranty proof, or comparison hook.
Week 2: build creative
Produce one 6-sec hook, one 15-sec explainer, and one comparison video.
Make MX/Streaming TV creative lifestyle-led; make SBV creative problem-solution-led.
Create retargeting variants for social proof, urgency, and bundle value.
Weeks 3-4: test and harvest
Launch MX/Streaming TV as prospecting with capped frequency.
Launch exact search, SBV, and ASIN targeting to capture the generated intent.
Retarget video/PDP/cart audiences; evaluate blended Amazon lift after 14 and 30 days.
Product ratings and review analysis from Amazon.in
Loading...
📖
Action plan
—
—
Authorize Execution
Enter the execution passcode. The session unlocks for 15 minutes.
All Categories▼
All Products▼
RTO Risk Profile — Returns Analysis
Click Apply to load returns analysis.
Customer Service — help@mytvs.com
AI email assistant for the support inbox — filters ~90% noise, drafts replies for a human to review & send. Drafts only; nothing is auto-sent.
Customer queries by category
Loading…
Recent emails
Loading…
Call Learnings
CS & sales call recordings transcribed with Sarvam Saaras v3 (diarized Hinglish + English),
then mined for what worked, what failed and what we should change.
Machine transcription — treat digits (pincode, order IDs, amounts) as indicative only.