Customer last visit report

[gsreddy]

@Jesse I want to create a report for lazy customers who not visited since a month or two or three so I can create a campaign and send them offers , or contact them if they not satisfied with our services . Can you please show a report how can I achieve this ? thanks

[pauln]

Hi @gsreddy I think this was done a few months back or so? Did you try searching that topic as I am sure I read some progress on that with kendash involved…

[gsreddy]

Hmm Tried but my key words not match my needs

[gerlandog]

there you go… search “customer report” and you will find a lot of info…

to get started

Ticket List by Customer report

This report lists tickets that have a selected customer and displays custom field values. ###@@XTicketListByCustomer select     T.TicketNumber,     min(convert(nvarchar,T.Date,105)) as Date,     min(convert(nvarchar,T.Date,108)) as Time,     COALESCE(min(TE.EntityName),'-') as [Entity Name],     COALESCE(min(cast(TE.EntityCustomData as nvarchar(4000))),'-') as [Custom1],     COALESCE(min(cast(TE.EntityCustomData as nvarchar(4000))),'-') as [Custom2],   min(T.TotalAmount) as TotalAmount from …

Customer Purchase History Reporting

This is a Report to show Historical Purchases on a per-Customer basis. You can select a Date Range to Report on and use Entity Search to load any Customer Purchase History. [image] This Tutorial uses to SQL scripts to pull data from the [Orders] table and the [Tickets] table. The data in the [Orders] table does not include Additional costs or Discount values that might be applied via Order Tag Prices, so the Item Total Prices could be incorrect (too high or too low). Note in th…

hope this helps

G