Statistics by OS, Device, Browser and Domain for a whole year

Avatar

Avatar
Give Back
Level 3
RaulOcana
Level 3

Likes

14 likes

Total Posts

58 posts

Correct reply

4 solutions
Top badges earned
Give Back
Validate 25
Validate 10
Validate 1
Boost 5
View profile

Avatar
Give Back
Level 3
RaulOcana
Level 3

Likes

14 likes

Total Posts

58 posts

Correct reply

4 solutions
Top badges earned
Give Back
Validate 25
Validate 10
Validate 1
Boost 5
View profile
RaulOcana
Level 3

21-04-2020

Hi guys, I know there is a report Open tracking which shows the statistics for OS, Device, Browser and email Domain, but it doesn't work when I pick several deliveries.

 

Is there an option, through a Query, to get this information for a whole year?

 

Regards,

Raúl

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

21-04-2020

Hi,

 

Raw data's in nms:trackingLogRcp, cube aggregates are stashed in nms:group.

You can duplicate opensByUserAgent report and change to match new reqs, though prob easier to just do a manual count/group-by on the log table directly.

I wonder how the cubes are impacted by retention windows, default for trackingLogRcp is 360 days fwiw.

 

Thanks,

-Jon

Answers (0)