Newsletter reports

Results screen 

Wise creates a results report for each newsletter sent. This function provides a count of the number of newsletters sent and how many times the newsletter is opened. 

 Note: Views are counted based on how often the header image of the newsletter is accessed. Customers who have images turned off in their email program will not access the image, which means they will not be counted.

Query browser 

There are several ways to query the system for newsletter results. Use the following queries to see newsletter results:

select * from messages where kind = 'BKA';
select * from messages where kind = 'BSA';
select * from messages where type = 'BSM';
select * from messages where kind = 'BKM';
 

The messages that still need to be sent display with the status '0'

Sent messages appear with status B.

Sent messages are stored in the folder home/bxmas/messages, and sent messages are stored in folders based on their branch. Sent messages are saved for two weeks. The Fri/Mon/Tue folders contain messages from the previous week. To determine which message relates to the query results, look at the file name, the bericht_job shares the same number as the newsletter file name.

Dashboard 

Once a newsletter is created, a report is generated in the Dashboard in the Wise configuration manager. If you are authorized to access the Wise configuration manager, go to systemWise > Dashboard and select the Reports tab. Click Report next to the newsletter report you want to view. Newsletter reports apepear as "bericht_inlever_verzamel_<date>". The report displays the number of viewed and canceled newsletters, and the number of undeliverable messages per location.

Message number 

Message numbers are used to capture undelivered messages. The message number is labeled with the x-tag "Message ID" so that the email bouncer can find and recognize the messages. The message number must be included in the message. The message number can be included in the following ways:

• In the subject line
  The message number can be inserted in the subject line of a newsletter in brackets [ ]. This prevents email services from grouping messages into a single conversation so that new messages appear separately. 

   Note: Some mail programs cannot handle a number in the subject line. If you select this method, the option mailer.berichtNummer=true must be added to the /etc/bwise/bxmas/bwise.properties file. A message number is set per system. For the bouncer the message number is present in the X-tag.

• In the footer
  All messages sent from Wise include the message number in the footer. Newsletter numbers always begin with the letter N. In the staff client, you can search for customers who received a specific newsletter by entering the message number in the Message number field.

View newsletters sent to a specific customer 

In the Customer administration screen of the staff client, you can see which newsletters a customer has been sent. 

1. In the staff client, search for a customer.
2. In the Customer administration screen, go to Customer > Customer correspondence > Newsletters. A table of all newsletters sent to the customer displays.
3. Double click on a newsletter line to see which text items the newsletter contained. The newsletter cannot be opened from this screen.