Skip to main content
Solved

Stammgäste filtern

  • October 23, 2023
  • 5 replies
  • 215 views

Forum|alt.badge.img

Hallo zusammen,

hat jemand einen Tipp, wie ich am besten die Gäste mit den meisten Aufenthalten filtern kann?

Der Reservierungsreport versagt leider immer wieder und ich bekomme eine Fehlermeldung.

Und in Analytics habe ich auch nix Passendes gefunden.

Danke für Euer Schwarmwissen.

Liebe Grüße

 

Best answer by wendy.batkova

Hi Jasmin,

You can run the “Customer profiles” report (Mode: Arrivals; Status: C/I, C/O, Confirmed) and Export the report to Excel. 

Once you have your report exported, select the tab “Data”, and navigate to the upper navigation bar and select the option “Insert” > “Recommended PivotTables”.
 

Excel will generate a Pivot Table and provide a wide range of selectable fields to customize your table as desired. I would recommend using “Classification & Last name / Email” as Rows selections, and for Values I’d chose “Arrival”. This will show you the number of arrivals / guest. 

You can find more information about Pivot tables here.


Hope it helps! ​​​Have yourself a lovely day! 

5 replies

  • Superstar Contributor
  • October 23, 2023

Suche “Returning guest count” thread

Dort findest Du auch eine Anleitung.

 

Max


  • Senior Apprentice
  • October 25, 2023

Geht es nicht über die VIP codes?


Forum|alt.badge.img
  • Author
  • Senior Guru
  • October 25, 2023

@Sara_LeClay Aber es gibt dann keinen Filter für ‘Wiederkehrend’ im Reservierungs- oder Kundenprofilbericht.


wendy.batkova
Mews Employee
Forum|alt.badge.img
  • Mews Employee
  • Answer
  • November 2, 2023

Hi Jasmin,

You can run the “Customer profiles” report (Mode: Arrivals; Status: C/I, C/O, Confirmed) and Export the report to Excel. 

Once you have your report exported, select the tab “Data”, and navigate to the upper navigation bar and select the option “Insert” > “Recommended PivotTables”.
 

Excel will generate a Pivot Table and provide a wide range of selectable fields to customize your table as desired. I would recommend using “Classification & Last name / Email” as Rows selections, and for Values I’d chose “Arrival”. This will show you the number of arrivals / guest. 

You can find more information about Pivot tables here.


Hope it helps! ​​​Have yourself a lovely day! 


  • Senior Apprentice
  • November 4, 2023

This is nice! I did not know that… you may add this content to Mews Univerisity