Search results

  1. ryandiscord

    Getting TF-IDF Weight

    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...
  2. ryandiscord

    Getting TF-IDF Weight

    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.
  3. ryandiscord

    Automate Google Sheets - Javascript Help

    This is where I'm trying to get it to show on the last row: var last_row = ts.getLastRow(); ts.insertRowAfter(last_row);
  4. ryandiscord

    Automate Google Sheets - Javascript Help

    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...
  5. ryandiscord

    Why you do this Adwords?

    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...
  6. ryandiscord

    Was i hit by google fred?

    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.
  7. ryandiscord

    New Wordpress Update April 2017: "noopener noreferrer"

    Run wordfence and you'll see many hack attempts. It's non-stop. They're relentless. It's really only a matter of time.
  8. ryandiscord

    Adwords ( and other PPC ) Master Thread

    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...
  9. ryandiscord

    Adwords ( and other PPC ) Master Thread

    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.
  10. ryandiscord

    How to get good at quoting prices?

    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...
  11. ryandiscord

    Amazon Pricing Strategies

    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...
Back