Developer forum

Forum » CMS - Standard features » Email Marketing Statistics

Email Marketing Statistics

E-mail notifications
Melissa Borgmann
Melissa Borgmann
Reply
Posted on 23/04/2024 01:19:33

ello!

I've looked through forum history and documentation and have not been able to find answers to the following questions relating to email marketing statistics:

  1. Do email statistics require 'Statistics' (deprecated) and/or 'Tracking' to be enabled on the solution?
  2. What are the formulas utilized to create the 'Order rate' and 'Total orders' metrics found in email statistics? (Fig. 1)
  3. Is it possible to see abandoned cart conversion statistics anywhere out of the box, or is a workaround like this necessary?
  4. User smart searches don't seem to pull back any results relating to email activity (see https://app.screencast.com/1odP4JV83kpnf). Do these parameters require 'Statistics' (deprecated) and/or 'Tracking' to be enabled on the solution?

Note: Looking at solutions running 9.16+

Figure 1


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 23/04/2024 16:23:24
Reply
This post has been marked as an answer

Hi Melissa

1) Yes, you need the old statistics enabled in order to get these numbers recorded.

2) When a user visits the website, a IIS session start and a SessionID is given to a user - that session is recorded on the statv2 table. When the visit starts from a link in the email, the link click is recorded with that sessionid on it in the OMCLink table. When orders are placed, the sessionID is recorded on the statv2object table.

Total orders is the number of orders placed with sessionids that matched links clicked for that specific email.

Order rate is total orders out of the number of recipients of an email. i.e. you get 2 orders from users clicking links in an email send to 100 users, equals an order rate = 2%.

3) It is not possible.

4) Yes, smart searches also rely on statv2

BR Nicolai

Votes for this answer: 1
 
Melissa Borgmann
Melissa Borgmann
Posted on 23/04/2024 17:45:53
Reply

Nicolai,

Great, thank you for the prompt reply and helpful information! Exactly what I was looking for.

 

You must be logged in to post in the forum