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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

DataFeed - Removing Excluded Hits


Level 1

According to the "Calculate Metrics" page, it states: "Use exclude_hit > 0 to remove excluded hits from queries on raw data"


According to the "Data column Reference" page, regarding Exclude Hit:

Flag indicating that the hit is excluded from reporting. The visit_num column is not incremented for excluded hits.
1: Not used. Part of a scrapped feature.
2: Not used. Part of a scrapped feature.
3: No longer used. User agent exclusion
4: Exclusion based on IP address
5: Vital hit info missing, such as page_urlpagenamepage_event, or event_list
6: JavaScript did not correctly process hit


Based on the values for "Exclude_Hit", it feels like the right way to exclude hits would be: "Use exclude_hit <= 0 to remove excluded hits....". Can you please confirm if thats how one should be excluding hits?




3 Replies



If exclude_hit is equal to 0 this means the hit was not excluded. So you want to include hits where exclude_hit is 0. You are correct the document is misleading. If it were to say "hits are excluded when exclude_hit > 0" this would be correct, but if you were writing a query you wouldn't want to use that condition.

If you were writing a query in sql along the lines of 

select * from db where exclude_hit > 0 

This would be a list of excluded hits


If you wanted a query that included non excluded hits

select * from db where exclude_hit = 0 


Level 1

How does one bring this to the notice of the documentation admins, so that it can be corrected?



I've noted this doc and will be presenting it to the documentation team for correction. In the future if you find something incorrect with the documentation opening a ticket with should get it in front of the right people to get edited. 


Thanks for the help!