Adobe Analytics

RajRao · 11/4/21

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 · 11/5/21

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

Garretth · 11/5/21

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 · 11/5/21

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

Garretth · 11/5/21

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!