Skip to main content

Moz rankings export is creating duplicate keywords

I can't create a direct data pull from Moz to data studio, so I have been exporting the rankings from Moz and putting them into a Google sheet and then pulling that sheet data into data studio. Problem is when I export my 126 keywords from Moz, the cvs has like over 1,000 keywords in it and they duplicate a ton, but not all. How do I stop Moz from adding in the duplicate keywords when exporting? Or what is causing them to duplicate?

submitted by /u/Ktmhocks37
[link] [comments]

from Search Engine Optimization: The Latest SEO News https://ift.tt/VHWbdiS

Comments

Popular posts from this blog

Local seo vs. natiowide seo?

I've done SEO for local businesses but I recently got my first client that sells an item nation wide. ​ Any suggestions for doing nationwide SEO? ​ I am used to making geopages for local towns. I was going to do the same with some input from the client about what cities or towns he would like to show up in? submitted by /u/Letmeinterviewyou [link] [comments] from Search Engine Optimization: The Latest SEO News http://bit.ly/2JHy0k0

GMB territory inching with service company

Seeking advice on extending our service area, while our main GMB profile states SD County, we only rank in our neighborhood but we have the team to service much more jobs. The boss wants us to get addresses in these hot territories within the county and use call rail numbers to validate the GMB profile. Question: Does this still work? Will it catch up with us? OR is there a better way to rank in a territory for a service. We are 4.9 stars with 120+ reviews submitted by /u/SoCal619TradesPro [link] [comments] from Search Engine Optimization: The Latest SEO News https://ift.tt/9RWmh6i