Now that the export button for the Searches with no results report is no longer available on the Reporting tab of Support, I needed to export from Explore. I've tried via the Guide Dashboard and via the Reports Library and the exported Excel file requires a lot of clean up (removing quotations around each search query, removing "Searches with no results" after each search query, and removing a carriage return after each search query). I use the exported version so I can do a vlookup against all previous months searches without results (which I have in a spreadsheet) since your report builder freaks out at 1000 count. Is there another way to get this data comparison or can the report or Dashboard export be cleaned up?
Please sign in to leave a comment.