Statistics by OS, Device, Browser and Domain for a whole year | Community
Skip to main content
RaulOcana
RaulOcana
Level 3
Apr 21, 2020 9:32 PM UTC
Solved

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Apr 22, 2020 6:33 AM UTC

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 reply

1 reply

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
Apr 22, 2020 6:33 AM UTC

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...