Data Cleaning: Get Top "N" Values for Specific Dimension from CSV Data (Tool Demo)
Jason Melman
Sep 28, 2023
Featured:
Video Walkthrough
Description
Purpose of the Tool
The "Top N per Dimension" tool in SEO workflows allows users to input any CSV data and refine it to display the top 'N' values based on a selected dimension. The tool's name refers to its ability to show the top 'N' (any number) values for a given dimension.
How the Tool Works
- Users can drop any CSV into the tool.
- The tool identifies dimensions (categorical data like words) and metrics (numerical data) from the CSV.
- Users can select a dimension (e.g., URL) and a metric (e.g., traffic) and specify how many top values they want to see.
- The tool then filters the data to show only the top 'N' values for the selected dimension based on the chosen metric.
Example
Using an export from SEMrush, the tool can filter the data to show the top 5, 10, or any number of keywords for each URL based on traffic. For instance, if a user selects the dimension 'URL' and the metric 'traffic' and specifies '5', the tool will display the top 5 keywords for each URL based on traffic.
Use Cases
- One potential use case is keyword mapping. If a user wants to see the top keywords for a page without sifting through excessive data, this tool can help by showing only the top keywords based on a metric like traffic.
- The tool can be used in various scenarios where users need to pare down a dataset to see the top values based on a specific dimension.
Tips and Notes
- Users should avoid having a '0' in the input field as it can cause errors.
- If there are glitches or issues, users can hit the 'reset input' button to start over.
Conclusion
The "Top N per Dimension" tool in SEO workflows is a versatile tool that helps users refine large datasets to display only the top values based on a chosen dimension and metric.
It's especially useful for tasks like keyword mapping and data analysis.
Have questions or feedback? Don't hesitate to reach out on LinkedIn!
