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 apply your segments to the adobe raw data feed?

Avatar

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

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
Level 1

04-11-2020

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 using adobe raw data feed, we use the following code, but it doesn't give us numbers that match when we see visits to that segment in adobe analytics:
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, date FROM "adobe_data_feed"
WHERE exclude_hit = 0
AND hit_source NOT IN (5,7,8,9))

AND (page = x OR post_prop1 = y)
group by date
order by date

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
valerie_anders
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
valerie_anders
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
valerie_anders
Level 1

10-11-2020

In data feeds, the "page" is called "pagename" so you probably want to use post_pagename.  I don't know why you have a field named "date".  The field in our datafeeds is "date_time" and it is set to the same date_time that our reportsuite is set to.  So we pull date(date_time) as dt when we need to group data by the same 'day' that we see in SiteCatalyst.  

 

https://experienceleague.adobe.com/docs/analytics/export/analytics-data-feed/data-feed-contents/data...