I'm looking to recreate the way OnPage takes the first 15 results for a seed keyword and gets the TF-IDF. It's possible this is overkill and I could just stick with OnPage for now but, I'd really like to become less reliant on services if it could be done on my own.
So far I've been feeding...
How do you get TF-IDF? I've got some ideas how to manually do it with Screaming Frog and Excel but I see others using Python scripts. Anybody have any experience with this, what direction should I go? This might be a good reason to learn some python.
I have a Google sheet that pulls data in one tab "GA Data" and I have it copy (currently after pressing the Copy Historic Data button in the header) to another tab "Historic Data" but the problem is when I copy it over it overwrites the whole range. I'm trying to figure out how to get it to copy...
Broad match will find synonyms and variants that broad match modified won't. Check your search terms, you may have had converting variants that are now cut off with the broad match modified keywords. Those variants may also have a lower CPC.
In the short term, you could turn the broad match...
Fred rolled out 3/8/17. Do you see a drop in Google traffic that lines up with that time frame? There's already a Google Fred thread going so make sure to give that a look.
Thanks! Would you build that out in the account or Adwords Editor?
It depends on the match type. I've used broad match for research, when I collect enough search term data, I'll add new phrase match keywords and kill the broad. If the broad term converts, I'll keep running it and extracting...
How do you approach a client who is looking to use PPC only for awareness? They're currently happy just knowing that people visit the site. Do you aim for cheap CPCs and traffic volume? Or do you try to get them to shift their focus on converting that traffic into email signups, lead captures, etc.
I've wondered this myself, if I've been going about it right.
I determined what one hour of my time is worth. I based this off of my experience level, what others charge and ultimately what would make me happy to do the work.
Then from past experience determine how long it will take to...
I have some general questions about pricing / repricing for anybody selling on Amazon.
What pricing strategies are you using? Do you target gross margin on a category or item level, Go for buy box no matter what as long as there positive ROI?
At what point do you decide that price alone isn't...