Is there any tool that can sort all keywords by total PPC traffic value? i.e. CPC*Volume

With Ahrefs you can sort by CPC, and also filter by Volume, but I don't see any way to multiply the two columns together and sort:


That's a screenshot of what I get in the dashboard. Is there any way to sort by say Volume*CPC in Ahrefs? Is there any other tool or service where you can do this?

I know you can download selected data from Ahrefs and multiply the columns manually in a spreadsheet, but that uses up your rows, and you can't access their whole dataset when you do that.

Export csv and multiply with excel. You can filter vol=0 and cpc=0 before you export it bc it will just result in a 0

RoyDanino said:

Export csv and multiply with excel. You can filter vol=0 and cpc=0 before you export it bc it will just result in a 0

Click to expand...

Thanks. The problem there is that you need to use up export rows, you can't access their whole dataset. I noted this in my opening post below the screenshot, think that was a mistake as people will probably miss it

When you export, it just exports the top rows by the value you sorted by. So if you sort by Volume, or by CPC, you can export say the top 5,000 (in my plan - in higher plans you can export 100,000). But that would give a very limited dataset, it wouldn't tell you the top Volume*CPC keywords overall for the whole Ahrefs dataset.

Daemon said:

Thanks. The problem there is that you need to use up export rows, you can't access their whole dataset. I noted this in my opening post below the screenshot, think that was a mistake as people will probably miss it

When you export, it just exports the top rows by the value you sorted by. So if you sort by Volume, or by CPC, you can export say the top 5,000 (in my plan - in higher plans you can export 100,000). But that would give a very limited dataset, it wouldn't tell you the top Volume*CPC keywords overall for the whole Ahrefs dataset.

Click to expand...

That's why I advised you to get rid of all the 0s. After these 2 filters you are most likely to have a report with less than 5k words.

RoyDanino said:

That's why I advised you to get rid of all the 0s. After these 2 filters you are most likely to have a report with less than 5k words.

Click to expand...

Thanks, but I don't want a report with less than 5K rows, I would like to know what the results would be for their whole keyword database if you sorted by Volume*CPC. Sorting by one or the other doesn't tell you that, regardless of what filter you use or what math you can do in a spreadsheet with the exported data.

I don't know if you can get such data with Ahrefs, but maybe some other tool has such a sort feature. Perhaps some more PPC specific tool?

Does anyone know if KeywordSpy or Spyfu has any feature where you can sort by total search value, rather than just volume or CPC?