Car wash

Jessamine Commons Car Wash · Car wash · Tampa, FL

Bastian Kettleby is the site manager at Jessamine Commons Car Wash, an express car wash, and he works this list so each member's ask is answered and closed inside the week, tracing any pile-up from the kind of ask down to who handled it and what it cost.

AutomotiveCustomer serviceDrill-down4 tables · 5 views · 1 form · 1 dimension set · 1 drill-down · 1 digest · 1 notification · 1 agent
Use this template

All requests

Member requests
RequestRequest numberKindMemberCame in byStandingHandled by
Pause for the winterJC-26-139Pause or cancelNadezhda Carrow-PikeApp messageNew—
Invoice copy for taxesJC-26-140Billing questionFenella Okwuosa-RayEmailNew—
Add a second plate to the planJC-26-137Plan changeDelphine Ostrander-KayeCounterNew—
Cracked taillight after the washJC-26-138Damage claimIgnatius Brightwell-NairPhoneNew—
Brush marks on the roofJC-26-135Tunnel complaintKendrick Aldous-MbekiApp messageNew—
Update the card on fileJC-26-136Billing questionMaximilian Ravenhill-OdeTextNew—
Sticker residue left on the glassJC-26-129Tunnel complaintPetronella Hargrove-WuTextIn progressRafferty Osgood-Lund
Key fob lost near the vacuumsJC-26-130Lost itemCassius Whitlow-AzizCounterIn progressRafferty Osgood-Lund
Rear bumper trim came looseJC-26-127Damage claimNadezhda Carrow-PikePhoneIn progressBastian Kettleby
Resume the plan after the pauseJC-26-128Plan changeHonoria Pelletier-GunnApp messageIn progressOdile Fenwick-Banda
Confirm the new plate for the planJC-26-134Plan changeGregor Haldane-ItoApp messageWaiting on memberOdile Fenwick-Banda
Charged for a plan I downgradedJC-26-126Billing questionLeocadia Fairbanks-SunPhoneIn progressOdile Fenwick-Banda

28 more rows

Tables

Member requests

40 sample rows · 13 columns

Everything a member asks of the site, who is on it and whether it was closed the same week.

RequestRequest numberKindMemberCame in byStandingHandled by
Pause for the winterJC-26-139Pause or cancelNadezhda Carrow-PikeApp messageNew—
Invoice copy for taxesJC-26-140Billing questionFenella Okwuosa-RayEmailNew—
Add a second plate to the planJC-26-137Plan changeDelphine Ostrander-KayeCounterNew—
Cracked taillight after the washJC-26-138Damage claimIgnatius Brightwell-NairPhoneNew—
Brush marks on the roofJC-26-135Tunnel complaintKendrick Aldous-MbekiApp messageNew—
Update the card on fileJC-26-136Billing questionMaximilian Ravenhill-OdeTextNew—
Sticker residue left on the glassJC-26-129Tunnel complaintPetronella Hargrove-WuTextIn progressRafferty Osgood-Lund
Key fob lost near the vacuumsJC-26-130Lost itemCassius Whitlow-AzizCounterIn progressRafferty Osgood-Lund
Rear bumper trim came looseJC-26-127Damage claimNadezhda Carrow-PikePhoneIn progressBastian Kettleby
Resume the plan after the pauseJC-26-128Plan changeHonoria Pelletier-GunnApp messageIn progressOdile Fenwick-Banda
Confirm the new plate for the planJC-26-134Plan changeGregor Haldane-ItoApp messageWaiting on memberOdile Fenwick-Banda
Charged for a plan I downgradedJC-26-126Billing questionLeocadia Fairbanks-SunPhoneIn progressOdile Fenwick-Banda

28 more rows

Members

16 sample rows · 13 columns

Each wash club member, their plan and plate, and the requests they have made.

MemberMember numberMobileEmailLicense platePlanMember since
Cassius Whitlow-AzizMB-2101(813) 555-0111cassius.whitlow@pinellasrowmail.comKTR-4821ShineNov 4, 2024
Delphine Ostrander-KayeMB-2102(813) 555-0112delphine.ostrander@gulfcoastbendmail.netBJN-2290Express BasicJan 3, 2025
Everett Moorcroft-OseiMB-2103(813) 555-0113everett.moorcroft@tampabaypostal.netMWC-7714Ceramic ShieldMay 3, 2025
Fenella Okwuosa-RayMB-2104(813) 555-0114fenella.okwuosa@pinellasrowmail.comHDP-3056Family two-carJun 12, 2025
Gregor Haldane-ItoMB-2105(813) 555-0115gregor.haldane@gulfcoastbendmail.netRTL-9187Express BasicAug 31, 2025
Honoria Pelletier-GunnMB-2106(813) 555-0116honoria.pelletier@tampabaypostal.netSCV-4403ShineOct 5, 2025
Ignatius Brightwell-NairMB-2107(813) 555-0117ignatius.brightwell@pinellasrowmail.comNPA-1672Ceramic ShieldNov 9, 2025
Jessamyn Torvald-ColeMB-2108(813) 555-0118jessamyn.torvald@gulfcoastbendmail.netFQY-5938ShineDec 9, 2025
Kendrick Aldous-MbekiMB-2109(813) 555-0119kendrick.aldous@tampabaypostal.netGZB-8025Express BasicJan 18, 2026
Leocadia Fairbanks-SunMB-2110(813) 555-0120leocadia.fairbanks@pinellasrowmail.comLXE-6341Family two-carFeb 27, 2026
Maximilian Ravenhill-OdeMB-2111(813) 555-0121maximilian.ravenhill@gulfcoastbendmail.netTUD-2759Ceramic ShieldApr 8, 2026
Nadezhda Carrow-PikeMB-2112(813) 555-0122nadezhda.carrow@tampabaypostal.netVHK-0486ShineMay 8, 2026

4 more rows

Wash plans

4 sample rows · 3 columns

The monthly plans on the price board and what each one covers.

PlanMonthly feeWhat it covers
Express Basic$19One tunnel wash, any day
Shine$29Wash plus wax and tire shine, any day
Ceramic Shield$39Shine plus a ceramic sealant coat
Family two-car$49Shine for two plates on one account

Forms and booking

Log a member request

Form
Log a member requestWhat the site fills in when a member asks for something at the counter, by phone or in the app.
What is the member asking for? *
What kind of request is it? *Billing questionPlan changeDamage claimTunnel complaintLost itemPause or cancel
Which member is it? *
How did it reach us?CounterPhoneTextApp messageEmail
Which day did it come in?
By which day will it be closed?
Log the request

Also included

  • Requests by kind and standingDrill-down
  • Requests waiting on a memberDigest
  • New member requestNotificationTells the site manager when a request is logged so it is answered before the week is out.