Use LogParser to Search SemRush CSV Files

After both Log Parser, and Log Parser Lizard have been installed, start up Log Parser Lizard.
On the left hand side, notice the menus, “Active Directory” etc. There is a minimize arrow to hide these menus. Click that. It’s good to get the unrelated stuff off the screen.



At the top are the tabs you want to pay attention to, namely Home and Query.

When you click on the home tab, there will be a green button “New Query”. Click that, and it opens the Query window tab. Go to the top and select comma separated value from “Input Log Format”.
Here you can click in the Query window and add any SQL statement to search through your CSV files. After you click “Run Query” button, a grid of information will display on top. It will always tell you in real time at the bottom how many seconds elapsed and how many rows are parsed.

Here are some of the SQL queries I’ve used to search through exported semrush CSV files.
Count Specific Ad Keywords
– Ad Position 1-4
– Past 12 Months
SELECT Keyword, count(*) AS counts 
FROM 
'D:\path\to\semrush\data.csv' WHERE Keyword LIKE '%keyword-phrase%' 
AND Position < '5' 
GROUP BY Keyword 
ORDER BY counts DESC
Best Specific (Pos=1, Months=Any)
SELECT Keyword, count(*) AS counts 
FROM 
'D:\path\to\semrush\data.csv' WHERE Keyword LIKE '%keyword-phrase%' 
AND Position = '1' 
GROUP BY Keyword 
ORDER BY counts DESC
Best Position, Any Months (Pos=1, Months=Any)
SELECT Keyword, count(*) AS counts 
FROM 
'D:\path\to\semrush\data.csv' WHERE 
Position = '1' 
GROUP BY Keyword 
ORDER BY counts DESC
Best Position, 6 Months (Pos=1, Months>=6)
SELECT Keyword, count(*) AS counts 
FROM 
'D:\path\to\semrush\data.csv' WHERE 
Position = '1'
GROUP BY Keyword 
HAVING counts >= 6

Log Parser Lizard asks you to upgrade if you like the product. However, the free version Export options allow you to export a CSV file of the query results.

Enter Your Email Address