Base Setup Steps

Update .env with base ID

Add the sitemap to the base `node airtable/sitemap-parser.js sitemap-url.xml

Get titles of posts node tools/get-title.js csv/input-urls.csv csv/output-titles.csv

Match titles found to titles in our database node tools/find-url-from-title.js csv/output-titles.csv csv/input-titles.csv csv/output-match.csv

Upload keywords for urls node airtable/keyword-matcher.js csv/output-match.csv

Upload KD from Ahrefs Export

Fill in DA in formula in Keywords table Generate and import rankchecker.

Matching URLs to keywords

Get the titles of all posts, input is a csv of all urls node tools/get-title.js csv/site-urls.csv csv/site-titles.csv
Match the titles from the site with the titles from our system node tools/find-url-from-title site-titles.csv our-data.csv output.csv

Name		Name	Last commit message	Last commit date
Latest commit History 69 Commits
.vscode		.vscode
SQL Scripts		SQL Scripts
airtable		airtable
archive		archive
tools		tools
.gitignore		.gitignore
airtable_schema.good.json		airtable_schema.good.json
airtable_schema.json		airtable_schema.json
cannibalization-checker.js		cannibalization-checker.js
create-base.js		create-base.js
credential-store.js		credential-store.js
credential-store.test.js		credential-store.test.js
dashboard-monitor.js		dashboard-monitor.js
dummy.js		dummy.js
dump-serp.js		dump-serp.js
index-checker.js		index-checker.js
ingest-schema.js		ingest-schema.js
package-lock.json		package-lock.json
package.json		package.json
rank-checker.js		rank-checker.js
rankfile.js		rankfile.js
rankfile.test.js		rankfile.test.js
readme.md		readme.md
scratch.js		scratch.js
scratch2.js		scratch2.js
search-result.js		search-result.js
search-result.test.js		search-result.test.js
serp.js		serp.js
serp.test.js		serp.test.js
traffic-monitoring.js		traffic-monitoring.js
url-parser.js		url-parser.js
url-parser.test.js		url-parser.test.js
zero-alert.js		zero-alert.js