What does 'top referred topics' measure?

j.jaffeux · December 20, 2019, 12:46pm

This report is using IncomingLinksReport model:

app/models/incoming_links_report.rb

main


      
            per_user(
              start_date: start_date,
              end_date: end_date,
              category_id: category_id,
              include_subcategories: include_subcategories,
            ).joins(:post).count("DISTINCT posts.topic_id")
          end
          
          # Return top 10 domains that brought traffic to the site within the last 30 days
          def self.report_top_traffic_sources(report)
            report.y_titles[:num_clicks] = I18n.t("reports.#{report.type}.num_clicks")
            report.y_titles[:num_topics] = I18n.t("reports.#{report.type}.num_topics")
            report.y_titles[:num_users] = I18n.t("reports.#{report.type}.num_users")
          
            num_clicks =
              link_count_per_domain(
                start_date: report.start_date,
                end_date: report.end_date,
                category_id: report.category_id,
                include_subcategories: report.include_subcategories,
              )

The query is basically:

Count of all IncomingLink in topics with archetype being Archetype.default
In a given category if specified
Between two dates
grouped by topic_id
keep a limited amount of the highest counts

An IncomingLink is created on topic show:

github.com/discourse/discourse

app/controllers/topics_controller.rb

main


      
                      .pluck(:name)
                      .join(", ")
          
                  if group_names.present?
                    json.merge!(errors: [I18n.t("topic_invite.failed_to_invite", group_names: group_names)])
                  end
                end
          
                render json: json, status: :unprocessable_entity
              end
            rescue Topic::UserExists, Topic::NotAllowed => e
              render json: { errors: [e.message] }, status: :unprocessable_entity
            end
          end
          
          def set_notifications
            user = fetch_target_user
          
            topic = Topic.find(params[:topic_id].to_i)
            guardian.ensure_can_see!(topic)
            TopicUser.change(user, topic.id, notification_level: params[:notification_level].to_i)

The only operations that I’m aware of on IncomingLink are updating ip/owner. IncomingLink destruction happens only if you use destroy_task.

I might be missing a where clause, but AFAIK destroying a post won’t remove the IncomingLink record.

Topic		Replies	Views
Top Referred Topics (Last 30 Days) Data & reporting dashboard-reports	4	1734	April 23, 2015
How to see exact link of ‘top referred topics’ Data & reporting sql-query , dashboard-reports	5	770	September 29, 2023
Dashboard Report - Top Referred Topics Data & reporting sql-query , dashboard-reports , dashboard-sql	0	376	December 12, 2023
Dashboard Report - Top Referrers Data & reporting sql-query , dashboard-reports , dashboard-sql	0	379	December 12, 2023
What does the "Top Referrers" table mean? Data & reporting	1	1364	June 22, 2015

What does 'top referred topics' measure?

Related topics