02/09/2024 - Update email from Tristan
As a quick Friday update, I wanted to share that we completed pulling down the query run logs for TUSMGP from the past six months and have started to combine that usage data with the query details, bases, and filters/exports.
A few top level findings so far:
The ratio of CJ - Application query runs to Local - Applications runs is roughly 11:1 (4981 to 459)
Person to Prospects was closer at roughly 6:1 (349 to 61)
In total, you logged 8245 query runs (including 'preview results') during the period, roughly a quarter of which were quick queries (where the base and other details are no longer available)
These were the distinct saved queries on the Prospects base, with the number of individual runs per query:
These were the Applications saved queries that had at least five runs:
Next up, we'll drill down into the filters and exports that are used most commonly across those queries.
This is looking at any cases where a URI was accessed where the path included '/manage/query/run?id=' (then we're extracting the id to look up the query itself, and from there if the query GUID still exists, looking up details about the base). A recipient list query would only be included if someone manually clicked 'Run Query' as opposed to scheduling the mailing to run.
I did look into the user question, but the access logs track the IP addresses rather than the specific user. I was seeing a fair number of shared IP addresses on the [user.login] table where different users were accessing Slate on the same day from the same IP address. We could probably make educated guesses in most cases based on the timing of the login and the timing of the query run, but I suspect there would still be some ambiguous cases. Happy to pursue that further though if you'd find it helpful—for the runs on the local bases, we could list the distinct IP addresses and any users who logged in using that IP address where the login date was the same as the run date.
Add Comment