This query will search for the incoming hits on a website. The hits can be on the Search Results Page (SRP) or View Details Page (VDP). The query has several conditions to search by a website host name (external data) or a specific VIN (internal data).

Tools: Oracle SQL.