DataFeed - Removing Excluded Hits | Community
Skip to main content
R
RajRao
November 4, 2021
Solved

DataFeed - Removing Excluded Hits

  • November 4, 2021
  • 1 reply
  • 2675 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Garretth

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 


1 reply

G
Adobe Employee
GarretthAdobe EmployeeAccepted solution
Adobe Employee
November 5, 2021

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 


    R
    RajRaoAuthor
    November 5, 2021

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

    G
    Adobe Employee
    GarretthAdobe Employee
    Adobe Employee
    November 5, 2021

    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!

      Terms & ConditionsAccessibility statement

      Loading footer...