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

user95087
Community profile user95087 Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 12-10-2020 1:29:21 PM
Offline
Top badges earned by user95087
Customize the badges you want to showcase on your profile
Re: How to apply your segments to the adobe raw data feed?
Avatar
Boost 1
Level 1
user95087
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
user95087
- Adobe Analytics
Date is referenced from the date_time field from the data feed. I was not aware that page name also had a post_ version. I have replaced it with post_pagename but the numbers are still not matching with what we're seeing in adobe analytics.

Views

162

Likes

0

Replies

0
How to apply your segments to the adobe raw data feed?
Avatar
Boost 1
Level 1
user95087
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
user95087
- Adobe Analytics
We are trying to build certain metrics from the adobe raw files that we export through the data feed. We have been successful in calculating visits and page views. But when we try to apply logic that we have in a segment (Ex: page = x OR page = y) we don't seem to get the same number of visits we see in adobe analytics. For Example: In adobe analytics, there's a segment called "Contact Us" and in the segment we have rules that include visit if page = x or prop1 = y To calculate the same visits u...

Views

200

Likes

0

Replies

2
Re: Reporting Interface vs Data feeds - Visits metrics
Avatar
Boost 1
Level 1
user95087
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
user95087
- Adobe Analytics
Hi, this is the code we used and it gave us correct numbers. I see you are missing the exclusion of hit_source 5,7,8&9.SELECT count(distinct concat(post_vis_id_high,post_vis_id_low,CAST(visit_num AS VARCHAR),CAST(visit_start_time_gmt AS VARCHAR)))Visits, batch_date FROM "adobe_data_feed"WHERE exclude_hit = 0AND hit_source NOT IN (5,7,8,9))

Views

60

Like

1

Replies

0
Likes from