The Top Referrers report only shows top 10 users: /admin/reports/top_referrers Can I customize the number of entries in the table in any way?

AshtonJ took the code from the dashboard, for easy modding as a Data Explorer (very cool plugin you’ll probably like) query: [image] Top 10 referrers over the last month Data & reporting Another one I can’t take any credit for - ripped directly out of DC’s das…

Thanks, but this query " Top 10 referrers over the last month" does not produce what I asked about. [image] maiki: very cool plugin you’ll probably like Which one?

The Data Explorer plugin allows you to query the data kept in Discourse.

If you add that now its missing, can you please copy paste the query you have so others can create/import that function?

[image] maiki: The Data Explorer plugin allows you to query the data kept in Discourse. Yes that’s what I wanted to do in case no setting is available. Does anyone have a SQL query for the subject?

Isn’t what you want simply what maiki linked to except with the “LIMIT 10” tweaked up to a sane higher limit?

[image] Mittineague: Isn’t what you want simply what maiki linked to except with the “ LIMIT 10 ” tweaked up to a sane higher limit? Nope. What I need is the data shown by this link /admin/reports/top_referrers. Users listed by number of clicks on links they have shared.

How to include more entries in the "Top Referrers" report

Community Building Data & reporting

meglio (Anton) December 22, 2019, 2:06am 6

Yes that’s what I wanted to do in case no setting is available.

Does anyone have a SQL query for the subject?

Topic		Replies	Views
Is the info Top Referred Topics/ Top Traffic Sources stored in a table in the database? Data & reporting sql-query	6	1465	March 16, 2022
Dashboard Report - Top Referrers Data & reporting sql-query , dashboard-reports , dashboard-sql	0	384	December 12, 2023
Top Referred Topics (Last 30 Days) Data & reporting dashboard-reports	4	1744	April 23, 2015
Dashboard Report - Top Traffic Sources Data & reporting sql-query , dashboard-reports , dashboard-sql	2	572	December 14, 2023
What does 'top referred topics' measure? Data & reporting	10	1535	April 9, 2024

How to include more entries in the "Top Referrers" report

Related topics