Articles on Neo4j

I haven’t written to the email list in years. This is what I’m working on. Please feel free to unsubscribe below. This is part 1? in a series on tackling the most audacious of problems in using GPT/LLM style tools against data sources. I’m thinking/learning out loud on a lot of this and sharing here.… Read more: LLMs and Semi-Automated Knowledge Graph Enrichment [Day 1]: Tackling Entity Disambiguation

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… Read more: Refactoring node properties as labels and relationships in Cypher for faster querying [Neo4j]

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… Read more: the science of (long) big game hunting

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… Read more: Per Page Link Profile Similarity + Label Propagation for Website Analysis

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… Read more: How to move graph databases from one Project folder to another in Neo4j Desktop

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… Read more: Creating a summary relationship from multiple relationships between nodes

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… Read more: “word” gap analysis between GSC keyword data and page content

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… Read more: Troubleshoot common plesk issues

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… Read more: My content analysis workflow – part 1

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… Read more: Get a list of published posts by word count in WordPress database

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… Read more: Get a list of posts with word counts into a spreadsheet

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… Read more: Crawl and scrape sites that require your login

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… Read more: Website audit with ScreamingFrog crawl data and Neo4j

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… Read more: Visualizing a website with Neo4j and Screaming Frog crawl data

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