Overview

Wednesday 23 September Example data
Ask an agent
Sales yesterday
Rp 21.4m
+12%
vs Tue 15 Sep
Bookings today
14
+3
vs Wed 16 Sep
Deposits unpaid
3
Rp 1.5m, 2 due tomorrow
Bills due in 7 days
Rp 58.2m
1 overdue, Rp 6.8m

Needs attention 4

Things to action today

Bali Medical Supplies, invoice 2291 is overdue
Rp 6.8m, due 17 Sep
New booking, Fri 25 Sep 10:00 with Dr Andreas
Client not added yet
2 deposits unpaid for tomorrow
Sarah M. 10:00, Kadek P. 14:30. Links sent Monday
2 AI Front Desk reservations to book
Deposits paid. Book them in Fresha, then tick off

Ads

16 to 22 September

Details
ChannelSpendBookings
MetaRp 7.4m11
GoogleRp 3.1m6
TotalRp 10.5m17
Cost per booking
Rp 618k9% vs 9 to 15 Sep

Daily sales

10 to 22 September, closed Sundays

TreatmentsProducts

From your agents

Waiting for your OK

Ads: pause "Glow Reel 2"
Rp 1.9m, no bookings in 14 days
Email: October skin boosters
To 214 past booster clients
Products: reorder draft
3 items below minimum

Ads agent

Nothing is changed or spent without your OK

Why were bookings from Meta down last week?

Meta bookings fell from 15 to 11 (16 to 22 Sep vs the week before). Two things changed:

  • "Glow Reel 2" took 26% of the budget but brought no bookings in 14 days.
  • Your Hydrafacial ad reached the same people 4.1 times on average, up from 2.6, so it's tiring.

I'd pause "Glow Reel 2" and move its Rp 1.9m a week to the skin booster ad, which books at Rp 480k each.

Sales, last 7 days
Rp 118.6m
+8%
vs week before
Treatments
Rp 104.2m
from Fresha
Products
Rp 14.4m
Fresha retail and Shopify
Average visit
Rp 1.9m
+Rp 110k
vs week before

Top treatments

Last 7 days, from the weekly Fresha export

TreatmentBookingsSalesvs week before
Hydrafacial Premium9Rp 22.5m+2
Anti wrinkle injections7Rp 19.6msame
Hydrafacial Pro8Rp 14.4m+1
Skin booster5Rp 12.0m-2
Advanced skin assessment11Rp 5.5m+3
Daily totals from Fresha's daily summary email; treatment breakdown from the weekly Fresha export; online product sales live from Shopify.

Friday 25 September

By doctor. Click a booking to open it in Fresha.

Deposit paid Link sent Overdue Client not added No deposit needed
Dr Andreas
Dr Putu
Wayan, therapist
Ayu, therapist
10:00
Client not added
Add client
11:30
Nyoman S.
No deposit needed
Kadek P.
Link sent
13:00
Lucy R.
Deposit overdue
14:30
Client not added
Add client
Bookings come from Fresha's calendar feed by doctor and time. Fresha doesn't share client names, so the team adds them.
Needs client
1
New booking, add the client
Link sent, unpaid
2
Rp 1.0m
Overdue
1
Link expired
Paid this week
Rp 9.5m
19 deposits

Deposits

Each link is for one booking only, so payments match automatically

BookingClientStatus
Fri 25 Sep 10:00
Dr Andreas
Not addedNeeds clientAdd client
Fri 25 Sep 11:30
Wayan
Kadek P.
+62 812 ••• 4471
Link sent MonSend reminder
Fri 25 Sep 13:00
Dr Putu
Lucy R.
+61 4•• ••• 208
ExpiredNew link
Fri 25 Sep 10:00
Dr Putu
Sarah M.
+44 7••• ••• 915
Paid, QRIS, Rp 500kFresha
Thu 24 Sep 15:00
Ayu
Tom H.
+61 4•• ••• 551
Paid, card, Rp 500kFresha

Message preview

Written for you; send on WhatsApp in one tap

Hi Kadek, thanks for booking with Wayan on Friday 25 September at 11:30. To hold your appointment we take a Rp 500,000 deposit, which comes off your treatment on the day. Pay securely here: pay.doku.com/… If you'd rather pay by bank transfer or QRIS, just reply and we'll send the details. Our booking terms are attached.
Send on WhatsApp
Spend, 16 to 22 Sep
Rp 10.5m
Meta Rp 7.4m, Google Rp 3.1m
Bookings from ads
17
-4
vs week before
Cost per booking
Rp 618k
-9%
vs week before
Return on ad spend
3.1x
treatment sales from ad bookings

Campaigns

16 to 22 September

CampaignChannelSpendBookingsCost per booking
Skin boosters, CangguMetaRp 2.4m5Rp 480k
Hydrafacial PremiumMetaRp 3.1m6Rp 517k
Glow Reel 2MetaRp 1.9m0No bookings
Aesthetic clinic BaliGoogleRp 3.1m6Rp 517k
Ad bookings come from Fresha's booking tracking; walk ins and WhatsApp bookings aren't attributed to ads.

Stock

From Fresha's weekly stock export and low stock emails; online sales live from Shopify

ProductIn stockMinimumSold, 30 days
Hyaluronic serum 30ml3821Low
Mineral SPF 5051034Low
Hydrafacial booster, Britenol249Low
Barrier repair cream18815OK

Bills

Read from your Google Drive folder and snapped photos. You approve and pay every one.

SupplierDueAmountStatus
Bali Medical Supplies, 229117 SepRp 6.8mOverdueMark paid
PLN electricity25 SepRp 4.2mDue in 2 daysMark paid
Aesthetic Distribution Asia28 SepRp 41.5mUpcomingMark paid
Linen service30 SepRp 5.7mUpcomingMark paid

Due back this week

Based on each treatment's cycle, from Fresha client history updated weekly. Messages drafted for the team to send.

Jessica T.
Anti wrinkle injections on 12 Jun; due on a 3 to 4 month cycle
Made W.
Skin booster 2 of 3 on 26 Aug; session 3 due
Chloe B.
Hydrafacial Premium on 24 Aug; monthly
Google clicks, 28 days
412
+18%
Times shown on Google
9,860
+22%
Average position
14.2
up from 17.9
AI search mentions
6 of 20
questions where AI names Silk

Searches you show up for

From Google Search Console

SearchPositionClicks
hydrafacial canggu648
skin clinic pererenan271
botox bali189
prp facial bali1214

Suggested articles

Searches you nearly rank for, and questions your site doesn't answer

Anti wrinkle injections in Bali: what to expect
"botox bali" at position 18
Write
PRP facial: recovery and results
"prp facial bali" at position 12
Write
Hydrafacial vs chemical peel
Asked often, not answered on your site
Write
AI search mentions come with the SEO Article Engine.
Enquiries, 7 days
63
WhatsApp 41, Instagram 22
Turned into bookings
38%
24 of 63
Reserved, deposit paid
2
to book in Fresha
Handed to the team
7
clinical questions

Reservations to book

Taken by the AI Front Desk. Book in Fresha, then tick off.

ClientTreatmentPreferred timeDeposit
Hannah W.
WhatsApp
Hydrafacial PremiumSat 26 Sep, morningPaid Rp 500kBooked in Fresha
Rizky A.
Instagram
Skin assessmentMon 28 Sep, after 3pmPaid Rp 500kBooked in Fresha