Custom reporting can give you insights into your users and hope they interact with your content
Introduction
What could this look like
Methods of delivery
Alternative considerations
Introduction
Custom reporting is designed to give you insight into your users, and how and when they interact with or purchase rights to your content. Delivered in formats compatible with excel and open office.
Example query:
/*
Title : frequent_search_terms
Description : Simple Searches ( by search frequency ) within the last month.
Columns : | Search Terms | Total |
Range : One month
Start : (script execute time) - 1 month
End : (script execute time)
*/
SELECT
t1.notes AS 'Search Terms', COUNT(*) AS 'Total'
FROM
event_log t1
WHERE
type = 'search_simple'
AND logged_at > (DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
GROUP BY t1.notes
ORDER BY Total DESC;
Example output:
| Search Terms | Total |
| * | 18 |
| Mustang | 6 |
| cars | 4 |
| blue car | 1 |
| red car | 1 |
What could this look like
Storage
Content Ingested
Records created
Site content
Collections created
Manage
User signup report
Monetisation
Media downloads
Clip orders
Expired subscriptions
Analytics
Search terms by users
Downloads by users
Record views by users
Methods of delivery
Comma-separated values (CSV)
JavaScript Object Notation (.JSON)
Excel Spreadsheet (.XML)
Alternative considerations
💡Pro tip: you may also consider using Google Analytics to gain insights into your usage data