How to get the "Referrer Types" from the data feed | Community
Skip to main content
K
kentxin
Level 1
July 22, 2019
Solved

How to get the "Referrer Types" from the data feed

  • July 22, 2019
  • 3 replies
  • 5208 views

Hi all.

We are trying to get the segment "Referrer Types", which exists in the Adobe Analytics Workspace, from the row hit data in the data feed.

There seems to be many columns corresponding to "Referrer Types" such as ref_type, visit_ref_type and first_hit_ref_type and these columns contains the values which are not in the value in the "Referrer Type" such as "Inside your Site", "Email" and "No JavaScript".

Which columns should I use and how can I get exact the same segment as "Referrer Type" ?

I read the official document about it but I can't  understand the concrete process how "Referrer Type" are derived.

I would appreciate if you could answer my question.

Thanks.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by sucagarw

    Hi Kentxin,

    To extract Referrer Type from Data Feeds kindly referrer to the column name "ref_type" which has a numeric ID representing the type of referral for the hit. Below are the look values for the same.

    1: Inside your site

    2: Other web sites

    3: Search engines

    4: Hard drive

    5: USENET

    6: Typed/Bookmarked (no referrer)

    7: Email

    8: No JavaScript

    9: Social Networks

    Here is a link document mentioning the same Data column reference.

    3 replies

    Balaji_V
    Balaji_V
    Level 4
    July 24, 2019

    Hi Kentxin,

    Are you looking this kind of output?

    Can you share some image of your output.

    Thanks,

    Balaji

      sucagarw
      Adobe Employee
      sucagarwAdobe EmployeeAccepted solution
      Adobe Employee
      July 24, 2019

      Hi Kentxin,

      To extract Referrer Type from Data Feeds kindly referrer to the column name "ref_type" which has a numeric ID representing the type of referral for the hit. Below are the look values for the same.

      1: Inside your site

      2: Other web sites

      3: Search engines

      4: Hard drive

      5: USENET

      6: Typed/Bookmarked (no referrer)

      7: Email

      8: No JavaScript

      9: Social Networks

      Here is a link document mentioning the same Data column reference.

        K
        kentxinAuthor
        Level 1
        July 29, 2019

        Dear Balaji

        Yes, I supposed that output.

        This is the output from Adobe Analytics workspace,

        (1)

        and this is the output from my SQL code. What the SQL do is just aggregate page view count , visits, unique visitors group by ref_type.

        (2)

                                                                            

        ref_typenamePage ViewVisitsUnique Visitors
        9SNS973816792
        3Search   Engine240778152928136938
        8No   Javascripts467192082316609
        2Other   Web Sites732754944445166
        6Typed/Bookmarked379125375899304419
        1Inside   Your Site3828161390671312916

        I wonder why these values are different and some ref_type in (2) does not appear in (1), though sum of the page view is same.

        Thanks,

        Kentxin

          danielk42559921
          Adobe Employee
          danielk42559921Adobe Employee
          Adobe Employee
          November 17, 2021

          Not all referrer types provided in Data Feeds are used/displayed in Workspace or Analytics reports.  For example, the 'no javascript' ref type is not included.  This is not mapped to 'typed/bookmarked', it is just not included in Analytics.

          Terms & ConditionsAccessibility statement

          Loading footer...