[Evergreen-general] [External] Re: counting OPAC logins

[Murphy, Benjamin]

If you have SQL access to your database, we also use queries like this:

select (EXTRACT(YEAR FROM aua.event_time) || '-' || LPAD(EXTRACT(MONTH FROM aua.event_time)::text,2,'0')) AS "Month", count(*) as CNT
from actor.usr_activity aua
join actor.usr au on (au.id=aua.usr)
where etype in(15)
group by 1
order by 1

A few other criteria you can add to the WHERE statement:

-- if you want to limit by time period
and event_time between '2021-07-01'::date and '2022-06-30'::date

-- if you want to limit by specific permission groups
and au.profile = 86

-- if you want to limit by Org Unit System
and au.home_ou in (select id from actor.org_unit_descendants(459))



Benjamin Murphy
NC Cardinal Program Manager
State Library of North Carolina
benjamin.murphy at dcnr.nc.gov<mailto:benjamin.murphy at ncdcr.gov>  | https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal
109 East Jones Street  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
The State Library is part of the NC Department of Natural & Cultural Resources.
Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.
Please note new email address


________________________________
From: Evergreen-general <evergreen-general-bounces at list.evergreen-ils.org> on behalf of Susan Morrison via Evergreen-general <evergreen-general at list.evergreen-ils.org>
Sent: Thursday, August 31, 2023 12:26 PM
To: Evergreen Discussion Group <evergreen-general at list.evergreen-ils.org>
Cc: Susan Morrison <smorrison at georgialibraries.org>
Subject: [External] Re: [Evergreen-general] counting OPAC logins

CAUTION: External email. Do not click links or open attachments unless verified. Report suspicious emails with the Report Message button located on your Outlook menu bar on the Home tab.

Hi Diane,

There is a User Activity source in reports that can be used to show a count for User Activity Type "OPAC Login (tpac)."

Here is a generalized/pared down example of one of the templates we've used:

-
Source: User Activity. Nullability enabled.

Display Fields:
User Activity -> (None nullable) User -> (None nullable) Home Library -> Short (Policy) Name as "Home Library"
User Activity -> (None nullable) Activity Type -> Label as "Activity Type"
User Activity -> ID (Count) as "Count"

Filters:
User Activity -> Event Time (Date) (Between)
-

Hope that helps!

Susan

On Thu, Aug 31, 2023 at 12:11 PM Diane Disbro via Evergreen-general <evergreen-general at list.evergreen-ils.org<mailto:evergreen-general at list.evergreen-ils.org>> wrote:
Good morning -

Does anyone use something other than Google Analytics to track OPAC logins?

Thanks.
Diane Disbro
Pronouns: she/her
Circulation and Special Projects Coordinator
Scenic Regional Library
251 Union Plaza Drive
Union, MO 63084
(636) 583-0652 ext  110
ddisbro at scenicregional.org<mailto:ddisbro at scenicregional.org>

_______________________________________________
Evergreen-general mailing list
Evergreen-general at list.evergreen-ils.org<mailto:Evergreen-general at list.evergreen-ils.org>
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general


--

[https://lh6.googleusercontent.com/lPbI_YgydcvRtZ9TiwKuc1KfifkdEMC3-KfRl4QTdqN-h28Z9PPyHJezIll2SZ58xvcMUDn6ucjj3UMF5z5PXUWXYwqkzKnaPC-Nn-BC7KEUI-ObVQoRjK-V5cHvzk7hJb4Gsz9n]

Susan Morrison, PINES Operations Analyst

________________________________

Georgia Public Library Service | University System of Georgia

2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341

(404) 235-7142 | smorrison at georgialibraries.org<mailto:smorrison at georgialibraries.org>


[https://lh3.googleusercontent.com/l6IV_xNXIf2-f-NiUMiNpHTgeGTNM3K_Ff1h8g1LtzWypBjnioc4TjSEb7iNx1MMhT6yGrx3M9dHF3RGUXixqaoUAvcYGfFHtNx6Jdp7f-Z5dIrZTgDxkTYCBRFzBGtIpqBLEfBa]<https://www.facebook.com/georgialibraries>[https://lh5.googleusercontent.com/mXs3mKgms5_2bKwJK2DCc0Uujst62CeFzq0CNM6zSaCV6s0poJ-aXnPN6o5s-NiId4uuD-48wZJIsEXVPF2mI10M83fGO-TpZ3lGL5hfNWFOQm6mE_AZSNHfFzOcfQAsmoXHUddy]<https://www.twitter.com/georgialibs>[https://lh5.googleusercontent.com/1IT0gQU4FoKazU6kP8fw5PsE4y0xa7cbJw6M2EKJi_czDOILYvAotp-raDZyEXHFqOFQ6Y-W74qHjbDHQEuozu5_F8r08x9dlFpCgvlwDSu4gc3nRGqggMaTo9VjXyxMVe4o6DxM]<https://www.instagram.com/georgialibraries/>


Join our email list<http://georgialibraries.org/subscription> for stories of Georgia libraries making an impact in our communities.

________________________________

Email correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized state official.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20230831/09d44f1c/attachment-0001.htm>