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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

RaulOcana
Level 4
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
wodnicki
Correct answer by
Community Advisor
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

1 Reply
wodnicki
Correct answer by
Community Advisor
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