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

swetank26061992
Community profile swetank26061992 Level 1
Job title here
Location here
0 BADGES
Level 1

Level 1

Learn more
Joined the community 13-04-2018 10:22:55 AM
Offline
Top badges earned by swetank26061992
Customize the badges you want to showcase on your profile
Re: How to calculate Bounces and Bounce rate from data Feed (clickstream data)
Avatar
Level 1
swetank26061992
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
swetank26061992
- Adobe Analytics
What do you mean by "Lookout for visits in the data feed and that should give you Bounces."What is wrong with the below query?SELECT TOP 10visit_num,visit_page_num,post_page_event,post_evar29,COUNT(distinct concat(post_visid_high,post_visid_low,visit_num,visit_start_time_gmt)) as BFROM DB_ERDL_Staging.STG_ADB_AGG_TEST main_data_tableWHERE TRY_CAST(visit_page_num AS INTEGER) = 1AND TRY_CAST(post_page_event AS INTEGER) = 0GROUP BY post_evar29,visit_num,visit_page_num,post_page_eventORDER BY B Desc...

Views

186

Likes

0

Replies

0