0
Wed 13 May
SnapshotDirectoryReputationJourneyLoyaltyMessy dataFindings

Fix it in the PMS — the materialised view follows.

AGENTPLANNEDDQ Sweeper· planned · auto-flag missing/duplicate fields nightly
LAST RUNno runs · agent not registered
SOURCEguest.mv_guest_profile· cleanup workflow: Cloudbeds → cron → mv refresh
CLEAN81%809 of 1000
UNREACHABLE0no email + no phone
DUPLICATES108same email · multiple guest_id
← DIRECTORY
Issue breakdown
By severity · count of profiles affected
Duplicate emailDuplicate email · 108 guests · 10.8% of 1,000 · guest.mv_guest_profile108No phoneNo phone · 68 guests · 6.8% of 1,000 · guest.mv_guest_profile68No countryNo country · 53 guests · 5.3% of 1,000 · guest.mv_guest_profile53Email looks invalidEmail looks invalid · 22 guests · 2.2% of 1,000 · guest.mv_guest_profile22
1,000
Total profiles
191
Flagged
80.9%
Clean rate
0
Unreachable
108
Duplicate emails
Top messy guests100
Sorted by lifetime revenue · top 100 of 191 flagged · fix in Cloudbeds
guest.mv_guest_profile
GuestIssuesEmailPhoneCountryStaysLTVLast stay
Nork Keophaengkhamphuan
119874161
No phoneDuplicate emailamuthmann@dgrv.coop—LA1$3,9782024-12-13
Anja Muthmann
119874192
Duplicate emailamuthmann@dgrv.coop+8562058797942LA1$2,6522024-12-12
Didier Alain Theraulaz (ERP20250312033620470)
134671558
No phoneSoulisack@easia-travel.com—CH2$2,3412026-01-01
Elena Dubnova
119926747
Duplicate emailoleg.ajf@gmail.com+745997631307RU1$2,1572025-01-28
Kelly Crawford
115711694
Duplicate emailkelcraw71@gmail.com+61418646387AU1$1,8902025-01-13
Wei Li
100633437
Duplicate emailbandith171@gmail.com+8618839402755CN2$1,8282024-04-04
Bhavya Pabby
130386891
No phonebhavyapabby@gmail.com—IN1$1,7822025-03-04
Clare Fleming
122841274
No phoneoutbluetravel@gmail.com—GB1$1,7642025-01-07
Anna Maria Gritti
124954185
No phonegiorgio@vicentinaleone.it—IT2$1,5952025-02-20
Quan Yuan
126413954
Duplicate emailyuanmuran@my.com+8613910197996CN2$1,5932025-01-30
Steven Lim Hing
123084065
Duplicate emailswarrenlimey@yahoo.com+1 954 376 8648CN1$1,4862025-01-31
Jens Ralf JAEHNIG
111309296
No phonejaehning@jaaehningmbh.de—DE1$1,3782024-12-27
Fufeng Chen
128013696
No phonedxb06104@163.com—CN1$1,2792025-02-02
Tony David Smith
120580320
No phonetranau@gmail.com—VN1$1,2562024-12-21
Catherine Magno-Dejacto
125586935
No phonecatherine.dejacto@dfa.gov.ph—LA1$1,2562025-01-12
Oleg Dubnov
121406904
Duplicate emailoleg.ajf@gmail.com+774959713304RU1$1,2112025-01-29
Jonathan Phillips
131113919
No phoneDuplicate emailclassic.reservations.officer@laos-adventures.com—LA1$1,2012025-10-22
Samantha Gangemi
127040807
No phonesamantha-gangemi@yahoo.it—IT2$1,1532025-02-17
Sean Rybar
118363633
Duplicate emailsrybar11@gmail.com+1 (916) 221-8536US1$8972024-10-24
Rachael Kilroy
121147010
Duplicate emailrachael.kilroy@gmail.com+6598572650SG1$7442025-01-31
Marko Sekulic
124469698
Duplicate emailm.sekulic@me.com+6583573833SG2$7102025-01-05
Jemma Wilson
103451544
Duplicate emailreservations@laosmood.com21/05/1968AU1$6862024-07-07
Giap Dang
124635810
No countrygdang.938739@guest.booking.com+1 236 787 5579—1$5932025-01-03
Dominique Martinez
127840730
No phonedom.mz16@gmail.com—TH1$5922025-02-09
Robert de Vries
123061293
Duplicate emailrobertwillemdevries@gmail.com+31 6 28520785NL1$5602025-02-11
Sean Rybar
118340529
Duplicate emailsrybar11@gmail.com+1 (916) 221-8536US1$5162024-10-22
Jay Mcsorley
134171269
Duplicate emailjayinwisc@gmail.com+12428531827US1$5132025-04-06
Trevor Nunez
126289697
Duplicate emailtrevnun9@aol.com+15617145261US1$5122025-01-17
Wuyong Yang
127691109
No phone138528550@qq.com—CN1$4842025-01-29
Lena Heidrich
130381336
No phonelenaheidrich@gmx.net—AT1$4812025-02-27
Robert de Vries
123060954
Duplicate emailrobertwillemdevries@gmail.com+31 6 28520785NL1$4782025-02-14
Milan Freudenberg
126975634
No phonemfrendenberg1@gmail.com—DE1$4632025-01-25
Devottam Sengupta
120590570
Duplicate emailantara@gmail.com+65 8780 8160SG1$4622024-12-27
Jay Mcsorley
134346256
Duplicate emailjayinwisc@gmail.com+1 262 863 1822US1$4592025-04-08
Wenguang Zeng
100633439
No phoneDuplicate emailbandith171@gmail.com—CN1$4322024-04-03
Jennifer Bright
127029672
No phonejq5457@yahoo.com—CA2$4172025-01-25
KIRI ADACHI
124695206
No phonekiriadachi1992@gmail.com—JP1$4142025-01-27
Xinyue Ma
102472237
No phoneriemnkai@ibs.com—CN1$3932024-05-06
Chiori Maeda
123084614
Duplicate emailbook@thenamkhan.com+09059991135JP1$3652025-03-05
Peter Edward Schneider
106733636
No phonepeter.schneider.pen@gmail.com—CH1$3442024-08-14
Monique Buker
119346998
Duplicate emailmoniguebueker@gmx.de+49 4915121328963DE1$3402024-11-03
genevieve ding
104447199
Duplicate emailgenevieve.ding@gmail.com006598210467SG1$3332024-06-20
Datong Gao
114912425
No phone1323069550@qq.com—CN1$3322024-09-23
Anja Muthmann
119874261
Duplicate emailamuthmann@dgrv.coop+8562058797942LA1$3212024-12-13
Karin Mitsushiro
125363119
Duplicate emailpinkrobo@hotmail.com+6597554875SG1$3122025-03-30
Steven Lim Hing
126494824
Duplicate emailswarrenlimey@yahoo.com+8618548905524CN1$2932025-01-28
Christine Gora(TP-BT-253)
131769509
No phoneDuplicate emailclassic.reservations.officer@laos-adventures.com—CH1$2832025-12-17
Monique Büker
107827324
Duplicate emailmoniguebueker@gmx.de+49 1512 1328963DE1$2772024-11-04
Patrizia Baratella
124956940
No phonelucia@blessyou.me—IT1$2742025-02-18
Genevieve Ding
104447523
Duplicate emailgenevieve.ding@gmail.com+6598210467SG1$2612024-06-22
Chengyu Zhang
101945655
No phone1033509334@99.com—CN1$2552024-05-03
Sumatsa tamayo
104670728
Duplicate emailsumatsa.pp@gmail.com02077717278US1$2492024-05-21
Quan Yuan
134137531
Duplicate emailyuanmuran@my.com+8562099288294CN1$2402025-04-06
Xuehui Mao
128606466
Duplicate emailzhoumuyeparis@qq.com+8618201682722CN1$2402025-03-03
Eugene Chen
117556143
Duplicate emaileugenechenbrookiyn@gmail.com+1 917 376 2771US1$2402024-11-04
Antara Lahiri
120590506
Duplicate emailantara@gmail.com+65 8780 8160SG1$2282024-12-27
Parham Gohari
119975977
Duplicate emailparhamgohari@yahoo.com+48 798918247PL1$2272024-11-11
Chengli Yu
101946025
No phone466202568@99.com—CN1$2252024-05-03
Masaya Kondo
119579948
No phonecocoa06710@gmail.com—JP1$2202024-11-07
Liprani Michele
129504893
No phoneDuplicate emaillmicheliprani@hotmail.com—CH1$2202025-11-28
Sumatsa tamayo
104670081
Duplicate emailsumatsa.pp@gmail.com02077717278US1$2152024-05-21
Liprani Michele
129503779
No phoneDuplicate emaillmicheliprani@hotmail.com—CH1$2062025-11-25
Marko Sekulic
124691634
Duplicate emailm.sekulic@me.com+656583573833SG1$1972025-01-04
Eugene Chen
117556022
Duplicate emaileugenechenbrookiyn@gmail.com+1 917 376 2771US1$1912024-11-05
Oskar Mielczarek
126376357
Duplicate emailomielcz@eyahoo.com1 917 5365800GB1$1862025-01-15
Emmanuelle Canas
106351445
No phoneemmanuelle.canas@yahoo.fr—FR1$1792024-06-09
ZHOU MUYE
128604723
Duplicate emailzhoumuyeparis@qq.com+8618201682722CN1$1672025-03-03
Karthik Kili Anandaraj
133067933
Duplicate emailkarthik@kraphics.my+60178787870MY1$1642025-03-26
David Chan-Tin
134402775
No phoneechantin@gmail.com—US1$1612025-12-21
Parham Gohari
120070598
Duplicate emailparhamgohari@yahoo.com48 798918247PL1$1612024-11-13
Karin Mitsushiro
125363487
Duplicate emailpinkrobo@hotmail.com+6597554875SG1$1532025-03-31
Melissa Kaye
133230435
Duplicate emailkarthik@kraphics.my+44-20-3929-3737US1$1142025-03-27
Vincent Deprez
126873684
Duplicate emailvincent.deprez@icloud.com0032496237384BE1$1082025-04-23
Vincent Deprez
132880469
Duplicate emailvincent.deprez@icloud.com0032496237384BE1$1002025-04-22
Rachael Kilroy
127425376
Duplicate emailrachael.kilroy@gmail.com+6598572650SG1$962025-01-28
Dong Nhat Lam
103541571
No countrymr7akf8jjk@m.expediapartnercentral.com+62 21 29103377—1$612024-05-22
Amin Brodie
119275694
No phonea.brodie@oakcover.com—US1$432024-12-17
Susie Keratiotis
107452742
Duplicate emailsoozee13@gmail.com+61402156655AU1$162024-08-28
XI YU
100290219
No countryrs.6vs.9u2l4i7pwl.1.c35d@guest.trip.com18601122532—0$0—
cher xiong
102972789
No phonehahaa@gmail.com—LA0$0—
Sam Wu
103835918
No countrycs+RTW5C3970933@tablethotels.com1 888 644 7452—0$0—
Peter Fistrovic
103857350
No phonepeter.fistrovic@gmail.com—SI0$0—
Palimone Thammavong
103943135
Duplicate emailreservations@laosmood.com+ 856 (20) 29968188LA0$0—
Bojana Marzidovšek
104364245
No phoneNo countrybojana.marzidovsek@authentic-luxury.com——0$0—
Sebastien CARRE
104376528
Duplicate emailhotelSupport@trip.com+44-20-3929-3737000$0—
Rena (140125S01)
104504755
No phonesavanhdaly@hotmail.com—LA0$0—
Srikanth Chandrasekharan Saradha
104534675
No countryj1pxl6rpun@m.expediapartnercentral.com+91 124 439 5000—0$0—
Nejc Novak
105148702
No phonenejc.novak92@gmail.com—SI0$0—
Jared Lim
105932242
Email looks invalidNo countryDuplicate emailN/A6598561831—0$0—
Sanna-Maaria Siintoharju
107032471
No phonesanna-maaria.siintoharju@outlook.com—PT0$0—
paul bauer
107047067
No countrycs+RV72G3980918@tablethotels.com1 888 644 7452—0$0—
Arpon Arpon
107964677
No phoneaumaimtunjumras@g.com—TH1$02024-06-26
Apurba Swatee Mahboob
108368110
No country8i9dtwmhs5@m.expediapartnercentral.com+86 20 3124 8103—0$0—
Testing testin
108571932
Duplicate emailsetup@hy-digital.com0808808080AF0$0—
setup setup
109426801
Duplicate emailsetup@hy-digital.com059509095TH0$0—
setup setup
109427124
Duplicate emailsetup@hy-digital.com2105150450TH0$0—
SANGIL HONG
110172417
No country9rhkenktc8@m.expediapartnercentral.com01089491332—0$0—
Sharareh Brealey
110392820
No countryufaf3c7qu9@m.expediapartnercentral.com447941575944—0$0—
Saul Lopes
110394650
No phoneEmail looks invalidDuplicate emailN/A—GB0$0—
Bounlerd Test for VAT
110951388
Duplicate emailbook@thenamkhan.com0309997327LA0$0—
How to fix
Open the guest in Cloudbeds (PMS) · merge duplicates via the guest profile screen · add missing email / phone / country. The materialised view guest.mv_guest_profile refreshes via cron, so changes appear here on the next tick.