|
Post by account_disabled on Feb 21, 2024 22:59:04 GMT -8
The bottom. This opens up a new sheet with a blank table. On the right are some slightly cryptic options. Under Rows Im going to add Top Ranking URL. This tells Google Sheets that each row in the pivot table should be a unique grouped URL from the top ranking URLs. Next Ill select the Values The COUNTA function just tells Google Sheets to return the total count for each URL for some reason COUNT only works on numeric values.
Them Whiteboard Friday Read this post What I Have Learned From Conducting America Mobile Number List Over Website Migrations What I Have Learned From Conducting Over Website Migrations Read this post Comments Please keep your comments TAGFEE by following the community etiquette Comments are closed. Got a burning question Head to our QA section to start a new conversation. Contact Community Free Trial Terms Privacy Accessibility Jobs Help News Press MozCon SEOMoz Inc. a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz Inc. Im going to stick to raw keyword count. Heres just a sample Obviously theres a ton here to dig into but right away I noticed that two of the posts in the top seemed to have some connection to graphics andor image search. This stood out because its not a topic we write about a lot. Turns out the first one is a video from May so not a great candidate for an update. The second however highlighted is a tools post from early . This post was surprisingly popular and given how many new tools have come out in the past years is a perfect candidate to rewrite. Heres a link to the full Google Sheet. Feel free to make a copy and play around. Step.
|
|