How to get Referral URL Links from Sitecore Analytics or DMS

Question

I would like to know is there any way to get the url links of referring sites.

For example: If someone shared an article link to my site on Facebook, using sitecore analytic is there a way for me to store or retrieve the link that was shared on Facebook, which brought the user to my site in the first place.

Any help will be much appreciated.

Thanks in advance,
Christina

Answer 1

Each visit in DMS stores the URL of its referrer (if any) as a field in the database.

For instance, here's an SQL query that returns a list of referrers for all first visits (i.e. the visits that brought each visitor to your site for the first time).

SELECT DISTINCT
  Referrer
FROM
  Visits
WHERE
  VisitorVisitIndex = 1
  AND Referrer <> ''