Statistics by OS, Device, Browser and Domain for a whole year | Community
Skip to main content
RaulOcana
RaulOcana
Level 3
April 21, 2020
Solved

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

  • April 21, 2020
  • 1 reply
  • 3193 views

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.
Best answer by Jonathon_wodnicki

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
April 22, 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

Terms & ConditionsAccessibility statement

Loading footer...