Developer forum

Forum » Ecommerce - Standard features » Identify referral for abandoned carts

Identify referral for abandoned carts

E-mail notifications
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply
Posted on 28/07/2022 13:29:24

Hi guys,

Is there any way I can identify the source of traffic for abandoned carts?

I have to create a report for one of our customers. I can handle SQL queries, I just need a point in the right direction. How I can connect the dots.

Thank you,
Adrian

 


Replies

 
Shiwanka Chathuranga Dynamicweb Employee
Shiwanka Chathuranga
Posted on 29/07/2022 08:55:24
Reply

Hope this helps

SELECT        dbo.Statv2Session.Statv2SessionRefererUrl, dbo.Statv2Session.Statv2SessionRefererDomain, dbo.Statv2Session.Statv2SessionRefererTld, dbo.Statv2Session.Statv2SessionRefererSearchWord, 
                         dbo.Statv2Session.Statv2SessionRefererSearchWordRank, dbo.Statv2Session.Statv2SessionRefererSearchKeywords
FROM            dbo.EcomOrders INNER JOIN
                         dbo.Statv2Session ON dbo.EcomOrders.OrderVisitorSessionId = dbo.Statv2Session.Statv2SessionSessionId
WHERE        (dbo.EcomOrders.OrderCart = 1)

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 29/07/2022 12:47:22
Reply

Hi Shiwanka,

Just what I needed.

Thank you very much!

 

Adrian

 

You must be logged in to post in the forum