Follow

kontextURL CSV export - Counting Unique Rows

In the kontextURL csv export, there is a column (E) which identifies the unique cookie associated with the click. If you wish to identify which rows contain unique cookies you can use the following format in a new column

Formula in cell F2  = COUNTIF(E$2:E2,E2)=1

you can then replicate that formula for all cells in that column.  if you which to calculate the total number of unique rows, then you can use the formula  

 

=sum(F2:F99999)

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk