DataFeed - Removing Excluded Hits

[RajRao]

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_url, pagename, page_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?

TIA

[Garretth · Accepted solution]

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 

[RajRao]

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

[Garretth]

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 customercare@adobe.com should get it in front of the right people to get edited. 

Thanks for the help!

[RajiReguraman]

Has this been rectified? I see the latest post/documentation dated this year that contradicts the discussion here

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

[GarrettHartley]

It has been updated now! Thanks for the follow up 😄