Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 5
Level 2
kentxin
Level 2

Likes

5 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Level 2
kentxin
Level 2

Likes

5 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
kentxin
Level 2

21-07-2019

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Employee
suchia77384744
Employee

Likes

7 likes

Total Posts

18 posts

Correct Reply

10 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Employee
suchia77384744
Employee

Likes

7 likes

Total Posts

18 posts

Correct Reply

10 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
suchia77384744
Employee

23-07-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.

Answers (2)

Answers (2)

Avatar

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct Reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct Reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile
Balaji_V
Level 4

23-07-2019

Hi Kentxin,

Are you looking this kind of output?

1798646_pastedImage_0.png

Can you share some image of your output.

Thanks,

Balaji

Avatar

Avatar
Boost 5
Level 2
kentxin
Level 2

Likes

5 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Level 2
kentxin
Level 2

Likes

5 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
kentxin
Level 2

28-07-2019

Dear Balaji

Yes, I supposed that output.

This is the output from Adobe Analytics workspace,

(1)

ref_type_AA.jpg

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)

1801754_pastedImage_3.png

                                                                    

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