Posted on 06/10/2020 11:06:41
Hi Martin
Dynamicweb will track IPs unless you disable it. But it is against the GDPR regulations to do so without prior explicit consent. See the new tracking section here: https://doc.dynamicweb.com/documentation-9/platform/platform-tools/tracking
Also I think GA will track IPs unless you enable Privacy mode, see https://support.google.com/analytics/answer/9019185?hl=en
There is currently no report that show what you require - if you have an example in a screendump of what you are looking for, we can see if a report can be added.
You can do something like this:
This will find the first 1000 visits from visitors that are returning visitors in the past 30 days with more than 1 visit in the 30 day period (and less than 5 visits - usually your self)
select top 1000 * from trackingsession where TrackingSessionVisitorId in (
SELECT TOP (1000) TrackingSessionVisitorId
FROM TrackingSession
where TrackingSession.TrackingSessionVisitorIsReturning = 1 and TrackingSession.TrackingSessionTimestamp > DATEADD(DAY, -30, getdate())
group by [TrackingSessionVisitorId]
having count(TrackingSession.[TrackingSessionId]) >1 and count(TrackingSession.[TrackingSessionId]) <5
)
order by TrackingSession.TrackingSessionId desc
You can run this on a datalist or the SQL widget.