Customer List with Notes

This is a Club Prophet Executive Report v4 – Power BI or PBI.

Note: Samples are using demo data and do not reflect real-world data.

Scroll right to see more columns.

Customer List with Notes

This report is a list of all customers including Retail and F&B pop-up notes assigned to the given account.

The following fields are included:

Acct: Customer account number (note when sorting this is a TEXT field**).
Name: Last Name, First Name.
Sales Class: Customer Sales Class description.
Customer Type: Customer Type description.
Email: Customer email address.
MobilePhone: Customer mobile phone.
HomePhone: Customer home phone.
City: Customer City address.
State: Customer State address.
Country: Customer Country.
Active: Active account [True, False].
NotePopUp: Sale Note Pop-Up flag [True, False].
Sales_Note: Text of the Sale Note Pop-Up.
FBNotePopUp: Food & Beverage Note Pop-Up flag [True, False].
FB_Note: Text of the Food & Beverage Note Pop-Up.
RetailNotePopUp: Retail Note Pop-Up flag [True, False].
Retail_Note: Text of the Retail Note Pop-Up.
StoreName: Store name that this account is assigned to.

FILTERS

The right-side menu of this report provides various Filters to allow you to filter the data in a number of ways. Click on any of the Filter fields for basic and advance filter and search options. Note that selecting specific visuals on the page will provide additional filter selections.

Tips

Filters which are the gold back color controls on the report allow you to pick from a list. Hold down the Ctrl key on the keyboard to select multiple items.
If you want to search for a particular value, use the filters in the right pane menu. They will have a search box in addition to a list of the items.
Use the Advanced option in the right menu panel for advanced search options.
Use the three dots […] in the top right of a visual for more options like Export data.

Use the Help button to open the user guide for any given report .