PCI HiCare | Performance Dashboard

April 2026 — MTD Performance

Apr 1–21 · 21 days tracked · 9 days remaining · Budget ₹5,80,000

⚠️ Budget Pacing Alert: 77.1% budget spent in 70% of the month. Projected month-end spend ₹6,48,723 — ₹68,723 OVER budget. Reduce daily to ₹14,734 for remaining 9 days.

📊 Revenue on Track: April MTD ₹10,70,324 at 2.39x ROAS. Week 3 recovered to 2.62x. Need ₹10,93,371 more to hit month target.

💸

Ad Spend

₹4,47,393

↑ +3% vs Mar ₹4,34,182

77.1% of ₹5,80,000₹1,32,607 left

💰

Total Revenue

₹10,70,324

↓ -11.5% vs Mar ₹12,09,834

49.5% of target21/30 days

📈

Revenue ROAS

2.39x

↓ vs Mar 2.79x · Target 2.90x

Gap to target: −0.51x

🛒

Paid Orders

563

Google: 535 · Meta: 28

Avg 26.8 orders/day

🏪

Total Sales (incl CC)

₹18,30,855

CC: ₹5,67,873 · Web: ₹12,62,982

Google: ₹7,61,093 · Meta: ₹37,721

📅

Daily Avg Spend

₹22,370

⚠ Over target ₹19,333/day

Reduce to ₹14,734 for W4

🔵

Google Rev. ROAS

1.41x

Shopify ROAS: 1.66x

Rev ₹6,44,994 · Spend ₹4,57,468

🟣

Meta Rev. ROAS

1.15x

Shopify ROAS: 1.36x

Rev ₹31,967 · Spend ₹27,718

📅 April Budget Pacing Tracker

77.1% — ₹4,47,393 of ₹5,80,000

0%25%50%75%100%

✅ W1 (Apr 1–8) — Under Budget

⚠️ W2 (Apr 9–15) — Overspend

⚠️ W3 (Apr 16–22) — Overspend

⏳ W4 (Apr 23–30) — Target ₹14,734/day

77.1%

Budget Used (₹4,47,393)

49.5%

Revenue Target Hit (₹10,70,324)

+₹68K

Projected Overspend at Current Pace

Week-wise April Performance

Budget split · Actual spend · Revenue · ROAS

Week	Period	Budget	Actual Spend	Total Sales	Revenue	ROAS	Orders	Status
W1	Apr 1–8	₹2,32,000	₹1,52,371	₹4,21,417	₹3,57,133	2.34x	247	Under Budget ✅
W2	Apr 9–15	₹1,16,000	₹1,72,097	₹4,02,099	₹3,40,762	1.98x	145	Overspend ⚠️
W3	Apr 16–22	₹1,16,000	₹1,60,718	₹4,97,465	₹4,21,580	2.62x ⬆	155	Overspend ⚠️
W4	Apr 23–30	₹1,16,000	—	—	—	—	—	Upcoming
MTD Total	Apr 1–21	₹5,80,000	₹4,47,393	₹12,62,982	₹10,70,324	2.39x	563	In Progress

Daily Performance Trend — April 2026

Day-by-day spend, sales and ROAS · Apr 1–21

🏆 Best Day

Apr 21

3.90x ROAS · ₹85,360 sales

📉 Worst Day

Apr 20

0.92x ROAS · ₹65,949 sales

📊 Daily Avg ROAS

2.02x

21 days tracked

✅ Days Above 2x ROAS

8 / 21

38% of days hit target

Daily Spend vs Total Sales

Blue bars = Spend · Orange line = Sales · Apr 1–21

Daily ROAS (Total)

Target line = 2.90x · Green = good · Red = below target

Google vs Meta Daily Sales

Stacked bars showing platform contribution per day

Daily DRR — April 2026

Day-by-day breakdown · ROAS color-coded

Date	Google Spend	Google Sales	G. ROAS	Meta Spend	Meta Sales	M. ROAS	Total Spend	Total Sales	Total ROAS

ROAS Distribution — April 2026

Days above/below target across 21 tracked days

2 days ≥2.9x

6 days 1.5–2.9x

13 days <1.5x

≥2.9x ROAS: 2 days (9.5%) 1.5–2.9x: 6 days (28.6%) <1.5x: 13 days (61.9%)

Platform Performance — April 2026

Google Ads vs Meta Ads · Organic · Apr 1–21

🔵 Google Ads

₹4,57,468

April MTD Spend

ROAS 1.41x · Shopify 1.66x

Impressions5,47,975

Clicks9,706

CTR1.77%

Shopify Orders535

Shopify Revenue₹7,61,093

Reported Revenue₹6,44,994

Spend Share94.3%

Spend vs Revenue

Spend ₹4.57LRevenue ₹6.44L

🟦 Meta Ads (Facebook + Instagram)

₹27,718

April MTD Spend

ROAS 1.15x · Shopify 1.36x

Impressions28,918

Clicks368

CTR1.27%

Campaign TypeAdvantage+

Shopify Orders28

Shopify Revenue₹37,721

Reported Revenue₹31,967

Spend Share5.7%

🌱 Organic + Direct

₹18,30,855

Total All-Channel Sales

Organic Sales

₹4,64,167

Direct Sales

₹5,11,244

CC Revenue

₹5,67,873

Email Sales

₹4,592

💡 Google Insight

94.3% revenue

Primary paid growth lever — scale top campaigns

⚠️ Meta Insight

1.15x ROAS

Below break-even. Review creative or reallocate budget

🌱 Organic Insight

₹4.64L

Strong non-paid contribution — invest in SEO/content

Spend Share — Google vs Meta

% of total April MTD paid spend

Revenue Share by Channel

April MTD total sales attribution

Platform Comparison Summary

April MTD · Paid platforms only

Platform	Impressions	Clicks	CTR	Spend	Orders	Shopify Sales	Revenue	Rev. ROAS	Spend Share
🔵 Google	5,47,975	9,706	1.77%	₹4,57,468	535	₹7,61,093	₹6,44,994	1.41x	94.3%
🔵 Meta	28,918	368	1.27%	₹27,718	28	₹37,721	₹31,967	1.15x	5.7%
Total Paid	5,76,893	10,074	1.75%	₹4,85,186	563	₹7,98,814	₹6,76,961	1.40x	100%

Keyword Performance Report — April 2026

Google Ads Search Keywords · Source: Google Ads · Apr 1–21

🔑 Keywords Tracked

+1 PMax auto (Shopping)

🏆 Top Performer

hicare automos

4.34x ROAS · 24.25% CTR

🚨 Needs Pause

pci mosquito bat

0.22x ROAS · Losing money

📊 Avg CTR

11.6%

Branded keywords strong

✅ Top Performer: "hicare automos" — 24.25% CTR, 4.34x ROAS, ₹68.13 CPC. Branded + product keywords converting best.

⚠️ Needs Attention: "pci pest control" — 10.46% CTR but only 0.45x ROAS (300 clicks, 5 conversions). Review landing page or reduce bids.

⚠️ Low Performer: "pci mosquito bat" — 14.03% CTR but 0.22x ROAS. Product page or price mismatch.

Top Keywords by Clicks

Top 10 keywords · April MTD

Keyword ROAS Comparison

Revenue ROAS by keyword · Target 2.9x

Full Keyword Report

13 keywords tracked · April 2026 · Google Ads

#	Keyword	Impr.	Clicks	CTR	Avg CPC	Conv.	ROAS	Status
1	Shopping / PMax (auto)	11,61,322	19,917	1.72%	₹8.78	389	2.51x	Strong
2	pci pest control	2,869	300	10.46%	₹21.20	5	0.45x	Losing $
3	automos	2,394	295	12.32%	₹43.42	18.5	2.16x	Below Target
4	hicare automos ⭐	973	236	24.25%	₹68.13	36.85	4.34x	Top Performer
5	hicare	1,772	210	11.85%	₹36.35	17	2.62x	Good
6	hi care company	1,532	208	13.58%	₹39.98	17.81	2.80x	Good
7	bug spray for house	2,845	172	6.05%	₹27.39	6.98	1.01x	Break-even
8	hicare products	877	130	14.82%	₹29.47	3.99	1.14x	Below Target
9	automos mosquito repellent	547	101	18.46%	₹56.34	8.93	2.71x	Good
10	pest control india	916	92	10.04%	₹17.08	5	2.72x	Good
11	pci mosquito bat 🚨	606	85	14.03%	₹18.69	0.32	0.22x	Pause?
12	cockroach gel	1,781	80	4.49%	₹47.00	4.97	1.16x	Below Target
13	pci insect killer	640	78	12.19%	₹18.64	2.32	1.07x	Below Target

🎯 Keyword Strategy Recommendations

Based on April MTD performance data

Action	Keywords	Reason
⬆️ Scale Up	hicare automos, hi care company, hicare	ROAS 2.6–4.3x · Branded keywords with strong conversion intent
🔍 Review Bids	automos, cockroach gel	Good CTR but ROAS 1.0–2.2x · Optimize CPCs or improve landing page
⚠️ Fix Landing Page	pci pest control, pci insect killer	High CTR but near-zero conversions — landing page or product mismatch
⏸️ Pause / Reduce	pci mosquito bat	0.22x ROAS · Actively losing money · Review product page price vs. ad
📈 Expand	pest control india, automos mosquito repellent	ROAS 2.7x+ with low impression share · Significant scale opportunity

Campaign Performance — April 2026

Google Ads · 16 active campaigns · Apr 1–21

Total Campaigns

16 Active

Search + Shopping + PMax

Best CPA

₹198

ST_SShopping_Sprays

Highest Spend

₹23,962

ST_Search_Brand_Automos

Top Type

Shopping

7 campaigns · Highest volume

Google Ads — Campaign Breakdown

16 active campaigns · Sorted by spend · April MTD

#	Campaign	Type	Impr.	Clicks	CTR	CPC	Spend	Conv.	CPA	Status
1	ST_Search_Brand_Automos	Search	2,921	385	13.18%	₹62.24	₹23,962	30.68	₹781	Active
2	ST_SShopping_Campaign	Shopping	1,28,719	2,079	1.62%	₹9.37	₹19,481	21.39	₹911	Active
3	BI_Search_Brand_7Jan26	Search	4,734	538	11.36%	₹35.57	₹19,136	15.94	₹1,200	Active
4	ST_SShopping_Automos	Shopping	69,827	818	1.17%	₹17.94	₹14,675	21.88	₹671	Active
5	ST_Performance-Max-Fly-Machines	PMax	15,846	535	3.38%	₹21.91	₹11,722	12.91	₹908	Active
6	ST_Performance-Max-AutoMos	PMax	81,576	912	1.12%	₹9.78	₹8,915	9.23	₹966	Active
7	BI_EcoProducts_Shopping	Shopping	35,068	642	1.83%	₹12.26	₹7,871	10.8	₹729	Active
8	BI_TrubbleGum_Shopping	Shopping	28,419	658	2.32%	₹11.31	₹7,439	23.18	₹321	Active
9	BI_EcoTrap_04Mar2026	PMax	33,923	512	1.51%	₹14.18	₹7,260	7.94	₹914	Active
10	Performance-max-Automoss-Refill	PMax	34,860	348	1.00%	₹16.30	₹5,671	9.47	₹599	Active
11	ST_SShopping_Sprays	Shopping	55,029	1,129	2.05%	₹4.38	₹4,944	25	₹198	Active
12	BI_Shopping_RoachWiz	Shopping	32,498	599	1.84%	₹5.59	₹3,348	8.02	₹417	Active
13	BI_Generic_Cockroach_Search	Search	1,129	51	4.52%	₹39.97	₹2,038	2.37	₹861	Active
14	BI_Generic_Mosquito_Search	Search	1,685	98	5.82%	₹20.51	₹2,010	1.12	₹1,802	High CPA
15	ST_SShopping_Others	Shopping	21,441	397	1.85%	₹4.58	₹1,818	4	₹455	Active
16	BI_ILT_Machine_Shopping	Shopping	300	5	1.67%	₹24.06	₹120	0	—	Low Traffic
Total / Average			5,47,975	9,706	1.77%	₹13.88	₹1,40,410	203	₹692

Search Campaigns (4)

₹47,146

Spend · Brand + generic search

Shopping Campaigns (7)

₹58,896

Spend · Product listings

Performance Max (5)

₹34,368

Spend · AI-driven campaigns

Monthly Comparison — Feb / Mar / Apr 2026

Month-on-month performance trend · April is MTD (21 days)

February 2026Full Month

Ad Spend₹3,85,000

Revenue₹6,50,000

Revenue ROAS1.69x

Orders~450

Budget₹3,85,000

Budget Utilization

100% utilized

March 2026Full Month ✅

Ad Spend₹4,34,182

Revenue₹12,09,834

Revenue ROAS2.79x ⬆

Orders1,091

Organic Revenue₹5,05,000

Budget Utilization

101% (slightly over)

April 2026 MTD21 of 30 days

Ad Spend₹4,47,393

Revenue₹10,70,324

Revenue ROAS2.39x

Orders563

Organic Sales₹4,64,167

Budget Utilization (21d)

77.1% · Pacing to overspend

Monthly Spend vs Revenue Trend

Feb → Mar → Apr MTD comparison

ROAS Trend — Month on Month

Revenue ROAS · Feb / Mar / Apr · Target 2.9x

MoM Growth Analysis

February → March growth · April MTD context

Metric	Feb 2026	Mar 2026	MoM Growth (Feb→Mar)	Apr MTD	Note
Ad Spend	₹3,85,000	₹4,34,182	+12.8%	₹4,47,393	April on track to exceed Mar
Revenue 🚀	₹6,50,000	₹12,09,834	+86.1% 🚀	₹10,70,324	Apr incomplete — 21/30 days tracked
Revenue ROAS	1.69x	2.79x	+65.1%	2.39x	Slight Apr dip — room to recover in W4
Orders	~450	1,091	+142.4%	563	Apr pacing for ~800+ full month
Budget Utilization	100%	101% (+₹4K)	Stable	77.1% (21d)	⚠️ Pacing to overspend by ₹68K

Budget Tracker — April 2026

Monthly budget · Daily pacing · Platform-wise allocation

⚠️ Overpacing Alert: 77.1% budget used in 70% of the month. Reduce daily spend to ₹14,734 for remaining 9 days to stay within ₹5,80,000 budget.

🎯

April Budget

₹5,80,000

Google: ₹5,32,000 · Meta: ₹48,000

💸

MTD Spent

₹4,47,393

77.1% used · Day 21 of 30

⏳

Budget Remaining

₹1,32,607

9 days left · Need ₹14,734/day

Current avg: ₹22,370/day ⚠️

📊

Projected Month Spend

₹6,48,723

+₹68,723 OVER budget

If current daily pace continues

🎯

Revenue Target

₹21,63,695

Est ROAS: 2.90x · Month target

💰

Revenue Achieved

₹10,70,324

49.5% of target

Gap: ₹10,93,371 remaining

📅 April Budget vs Revenue Pacing

💸 Budget Spent₹4,47,393 / ₹5,80,000 — 77.1%

💰 Revenue Target₹10,70,324 / ₹21,63,695 — 49.5%

📅 Days Elapsed21 / 30 days — 70%

Monthly Budget History

Planned vs Actual · Feb / Mar / Apr

Month	Budget	Actual Spend	Utilization	Revenue Target	Actual Revenue	ROAS Target	Actual ROAS	Status
Feb 2026	₹3,85,000	₹3,85,000	100%	₹6,50,000	₹6,50,000	1.69x	1.69x	Baseline
Mar 2026	₹4,30,000	₹4,34,182	101%	₹13,28,831	₹12,09,834	1.90x	2.79x ✅	Exceeded ROAS
Apr 2026 MTD	₹5,80,000	₹4,47,393 (21d)	77.1%	₹21,63,695	₹10,70,324 (MTD)	2.90x	2.39x	In Progress ⚠️

April Daily Budget Plan — Week-wise

Allocation · Actual · Variance · Recommendation

Week	Period	Budget Allocated	Actual Spent	Variance	Rec. Daily	Actual Daily Avg	Status
W1	Apr 1–8	₹2,32,000	₹1,52,371	−₹79,629	₹29,000	₹19,046	Under Budget ✅
W2	Apr 9–15	₹1,16,000	₹1,72,097	+₹56,097	₹16,571	₹24,585	Overspend ❌
W3	Apr 16–22	₹1,16,000	₹1,60,718	+₹44,718	₹16,571	₹22,960	Overspend ❌
W4	Apr 23–30	₹1,16,000	—	—	₹14,734	—	Upcoming
Total	Apr 1–30	₹5,80,000	₹4,47,393	+₹21,186 pace	₹19,333/day	₹22,370/day	⚠️ Watch Budget

Reporting Framework

What to report · When to report · How to evaluate

📧

Daily Report

Every morning · 10 AM · Internal team

Yesterday Total SpendTarget ₹19,333

Google ROAS≥2.5x

Meta ROAS≥1.5x

Total Revenue (Paid)≥₹45,000

Total Orders≥25 orders

MTD Budget %<100%

MTD Revenue TrackOn pace

Top Campaign ROASBest performer

📊

Weekly Report

Every Monday · 9 AM · Client-facing

Week Spend vs Budget±10%

Week Revenue vs Target≥Target

Week ROAS≥2.5x

Top 5 CampaignsReview CPAs

Revenue to TargetOn pace

Platform SplitGoogle vs Meta

Top 5 KeywordsROAS ≥2x

Next Week Budget PlanPlan ahead

📅

Monthly Report

1st of every month · Client presentation

Executive SummaryFull review

Platform BreakdownG vs Meta

Budget Analysis±5%

Campaign PerformancePause <1x

Keyword InsightsScale ≥2.5x

Website AnalyticsConv ≥2%

MoM ComparisonTrend +

Next Month PlanClient sign-off

KPI Targets — Quick Reference

Agreed benchmarks · Current Apr MTD performance vs target

KPI	Daily Target	Weekly Target	Monthly Target	Alert if Below	Apr Status
Ad Spend	₹19,333	₹1,35,333	₹5,80,000	>110% overspend	⚠️ Overpacing
Revenue (Paid)	₹45,000	₹3,15,000	₹16,73,695	<80% of target	In Progress
Revenue ROAS	≥2.0x	≥2.5x	≥2.90x	<1.5x any day	⚠️ 2.39x (gap)
Orders	≥25	≥175	≥767	<15 orders/day	⚠️ Pacing ~800
Google ROAS	≥2.0x	≥2.5x	≥2.90x	<1.5x	⚠️ 1.41x
Meta ROAS	≥1.2x	≥1.5x	≥2.20x	<1.0x	❌ 1.15x
CTR (Google)	≥1.5%	≥1.5%	≥1.5%	<0.8%	✅ 1.77%
CPA	≤₹900	≤₹850	≤₹800	>₹1,200	✅ ₹692 avg

Automated Email Reports

Google Apps Script · Daily + Weekly + Monthly · Auto-send to client & team

✅ Apps Script configured for jayesh@binaryic.in · minakshi@binaryic.in · sneha@binaryic.in · Triggers ready — connect DRR sheet to activate

📧

Daily Briefing

Every 9 AM

To: Jayesh · Minakshi · Sneha

Yesterday spend · ROAS · Orders · MTD pacing

📊

Weekly Summary

Every Monday

To: Client + Team

Week spend · ROAS · Campaign top 5 · MTD progress

📅

Monthly Report

1st of Month

To: Client + Team

Full month recap · MoM growth · Next month plan

✉️ Daily Team Briefing Template

Sent automatically every morning at 9 AM · Internal team use

      Subject: 📊 PCI-HiCare Daily — [DATE] | ROAS: [X]x | Spend: ₹[X]

      Hi Team,

      Yesterday's performance summary for PCI HiCare:

      Platform  │ Spend    │ Revenue  │ Orders │ ROAS  │ Status

      ──────────┼──────────┼──────────┼────────┼───────┼────────

      🔵 Google  │ ₹[G_S]   │ ₹[G_R]   │ [G_O]  │ [G_R]x│ [OK/⚠]

      🟣 Meta    │ ₹[M_S]   │ ₹[M_R]   │ [M_O]  │ [M_R]x│ [OK/⚠]

      ──────────┼──────────┼──────────┼────────┼───────┼────────

      Total     │ ₹[TOT_S] │ ₹[TOT_R] │ [T_O]  │ [T_R]x│ [STATUS]

      📈 MTD Spend: ₹[MTD_S] / ₹5,80,000 ([PCT]%)

      💰 MTD Revenue: ₹[MTD_R] / ₹21,63,695 target

      ⚡ Budget Remaining: ₹[REM] for [DAYS] days

      Dashboard: https://reportiq.app/pci-hicare

📊 Weekly Client Report Template

Sent every Monday at 9 AM · Client-facing professional format

📊 PCI HiCare | Weekly Performance — Week [N], [Month] 2026

Dear [Client],

Here's the weekly performance summary for PCI HiCare campaigns.

📌 Week [N] Summary ([Date Range]):
  • Total Ad Spend: ₹[SPEND] vs Budget ₹[BUDGET] ([STATUS])
  • Total Revenue: ₹[REVENUE] (ROAS: [ROAS]x)
  • Total Orders: [ORDERS] orders
  • Google: ₹[G_SPEND] spend · [G_ROAS]x ROAS
  • Meta: ₹[M_SPEND] spend · [M_ROAS]x ROAS

📈 MTD Progress (as of [DATE]):
  • Spend: ₹[MTD_SPEND] / ₹5,80,000 budget ([PCT]%)
  • Revenue: ₹[MTD_REV] / ₹21,63,695 target
  • Overall ROAS: [MTD_ROAS]x

🔗 Live Dashboard: reportiq.app/pci-hicare

Best Regards,
Jayesh | BiNARY Web Solutions

📜 Apps Script Setup Guide

Step-by-step to activate auto-send triggers

Step	Action	Details
1	Open DRR Google Sheet	The sheet with "Paid DRR" tab where you enter daily data
2	Go to Extensions → Apps Script	Opens the script editor in a new tab
3	Paste the automation script	PCI_HiCare_Automation_Script.js (provided separately)
4	Update CONFIG values	CLIENT_EMAIL, TEAM_EMAILS, NETLIFY_TOKEN, NETLIFY_SITE_ID
5	Run setupTriggers() once	Creates daily 9AM + weekly Monday + monthly 1st triggers
6	Authorize permissions	Allow Gmail + Sheets access when Google prompts
✅	Done! Fully automated	Emails send forever — no manual work needed

Tools & Integrations

Connected platforms · Automation setup · Tech stack overview

✅

Active Connections

⚙️

Setup Pending

❌

Not Configured

🔄

Automation Tasks

📡 Ad Platforms & Analytics

🔵

Google AdsAccount: PCI HiCare

Live

Account ID5577699805

Active Campaigns16 running

Apr MTD Spend₹4,19,675

Apr MTD ROAS2.47x

Looker Studio✅ Live feed

🟦

Meta AdsFacebook + Instagram

Live

Campaign TypeAdvantage+

Apr MTD Spend₹27,718

Apr MTD ROAS0.97x

Looker Studio✅ Live feed

Spend Share6.2% of total

📊

Google Analytics 4pci-hicare.com

Live

Mar Sessions73,195

Mar Revenue₹21,66,245

Conv Rate (Mar)2.17%

Mobile Traffic72%

TrackingGA4 + Ads Tag

🛒

Shopifypci-hicare.com store

Live

Apr MTD Orders563 paid

Apr MTD Revenue₹7,98,814

Mar Revenue₹12,09,834

Conversion Tag✅ Active

TrackingGA4 + Google Ads

📈

Looker StudioPCI HiCare Dashboard

Live

Data SourcesAds + Meta + GA4

Refresh RateReal-time

Report TypePerformance KPIs

Scheduled Email⚠️ Not set up yet

Best ForClient reporting

📂

Google DriveDRR Sheet — Apr 2026

Connected

FileApr 2026 DRR Sheet

Last UpdatedApr 21, 2026

Data InsideDaily spend + sales

PlatformsGoogle + Meta

Used ForDashboard updates

🤖 Automation & Hosting

🚀

ReportIQ / Netlifyreportiq.app/pci-hicare

Live

Live URLreportiq.app/pci-hicare

Site ID4d73ee7f-991b-4736

Update MethodManual monthly

Auto-update❌ Not configured

Best ForClient presentations

⚙️

Google Apps ScriptAuto email automation

Setup Needed

PurposeAuto email reports

Daily Trigger9:00 AM IST

Weekly TriggerMon 9:00 AM IST

Monthly Trigger1st of month 9AM

RecipientsJayesh + Minakshi + Sneha