Expand my Community achievements bar.

SOLVED

DataFeed - Removing Excluded Hits

Avatar

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?

 

TIA

 

1 Accepted Solution

Avatar

Correct answer by
Employee

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 


View solution in original post

5 Replies

Avatar

Correct answer by
Employee

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 


Avatar

Level 1

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

Avatar

Employee

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!

Avatar

Level 1

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....