Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

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