Articles on Neo4j

In this use case, a node property is generated to assign a node to a community. You can learn about how we identify pages with similar link profiles by generating a similarity score based on links relationships to page nodes, and then running label propagation to group those similar, with the community ID written as […]

In marketing, there are a very simple and reliable approaches to big game hunting (as long as big game exists). You see it with wild budgets being spent on bus and billboard ads for personal injury attorneys where they only need one big wrongful death case to pay for 20 billboards for five years. You […]

I am exploring how combining graph algorithms can help with more quickly analyzing a site’s structure or labeling it’s content/pages. This is a proof of concept for using a similarity algorithm and then applying labels with another algorithm based on URLs sharing similar internal link profiles using GDS plugin with Neo4j graph database using a […]

This question was answered by Elaine R. on the Neo4j community forum, but with the newer versions of Neo4j Desktop (Neo4j Desktop 1.4.3 with 4.x.x databases), there is a quick four step drag and drop way to re-organize your databases across Project folders. The quick steps / TL;DR Take a dump of the database Drag […]

In order to query time series data, I felt like I had to model my google search console data this way in Neo4j: each day of data with clicks, impressions In Google Search Console there are (for our purposes) three dimensions and four metrics: dimensions date url keyword metrics clicks impressions ctr avg. position And […]

We can do a lot of neat stuff with Google Search Console data to improve existing rankings or further optimize pages already seeing traffic or impressions from a given series of related terms. GSC data gets a lot more valuable as soon as we can connect it to oother data types. For example, we’re able […]

Error 521 from Cloudflare when trying to access site using Plesk From Cloudflare error: What happened?The web server is not returning a connection. As a result, the web page is not displaying.What can I do?If you are the owner of this website:Contact your hosting provider letting them know your web server is not responding. Additional troubleshooting […]

Last Modified:2020-11-19 14:47:30

Table Of Contents 1. Review site manually, get a lay of the site and typical page template structures 2. Crawl and extract text, meta data, metrics with ScreamingFrog ScreamingFrog’s API integrations Google Analytics Google Search Console Ahrefs 3. Collect and preprocess data from APIs and CSV exports, mostly with Python Do NLP keyword extraction things […]

Last Modified:2020-08-04 19:36:50

How to generate a list of your published WordPress posts by word count in SQL (PHPMyAdmin) So to get started, you will just need to drag-n-drop the How-to Schema block in the Gutenberg editor. The How-to Schema block can be used on pages that contain a How-to in their title and describe steps to achieve […]

You have a few options here: Table Of Contents Option 1: Use a word count WordPress plugin and copy/paste the posts list into a spreadsheet Option 2: Crawl a list of your posts with Screaming Frog and export to a spreadsheet Option 3: Run a SQL query in PHPMyAdmin to generate a list of posts […]

This guide is for logging into a platform and scraping the data you want from it. The use case we are following is logging into my email software (ConvertKit) and scraping the engagement data from it. I provide tips, examples, and alternative options for how to find what you might be looking to scrape as […]

This is a nice peek into how powerful graphs are for site audits and how these capabilities are coming along for those interested in content audit + ongoing recommendations service. I’m chipping away at feature parity with some of the existing smart crawl tools out there. If you aren’t familiar, the term “feature parity” just […]

Last Modified:2020-07-06 13:27:54

This is the absolute path of least resistance I could come up with for running a SF crawl and getting a visual for how pages are linked in Neo4j. TL;DR Download Bulk Export > Inlinks and Internal HTML Export CSVs from your crawl Use this CQL snippet below to load the inlinks data first which […]

Last Modified:2020-07-06 13:25:21

Last Modified:2020-08-12 15:07:03

Last Modified:2020-07-06 13:27:55

Last Modified:2020-04-09 16:57:19

Last Modified:2020-02-08 1:07:46

Last Modified:2020-07-05 15:32:52

Last Modified:2020-01-15 13:12:37

Last Modified:2020-01-15 13:12:21

Last Modified:2020-07-30 16:31:48