Hello guys,

Today I wanted to share a more in depth view on how to create PSEO pages fast.

PSEO stands for programmatic search engine optimization and the importance of these pages is strictly to get more people to your website.

These pages are generally targeting a very long tail keyword that is usually something that is not searched for often.

The approach is that by mass creating pages that target very niche, specific search queries, then we can be sure to showup in the results, and also receive more high intent clicks to our site.

So without further ado, we are going to walk you through the complete process of creating 100 PSEO pages. Buckle up because we are going fast.

Before we get started, you need:

Webflow Website on CMS plan

Airtable

Whalesync

There really isn’t any way around this. Once you have these, then you can mass create pages.

Step 1: Create an Airtable Base.

In this example we are going to create 100 pages for “Optimize Your Marketing in [City]”.

We will create some fields that will include the target keyword (which in this case is just “Optimize Your Marketing in [City Name]”), the city excerpt, city image, and last but not least the URL slug.

‍

‍

Once this is done, you are almost completely done with airtable.

Some tips for filling this out would be to use ChatGPT to write a few sentences for your excerpt field, and to use Google Images to quickly find images that are super relevant to your target keyword. 

It’s important to keep these as single line fields because we will need to pull them into Webflow that way.

Step 2: Create a Webflow collection.

When we are in Webflow, we are going to navigate to the collections tab on the left hand side of screen and select create a new collection.

Please note, you will need the CMS plan or at the very least, a starter plan to create these pages.

At this point, all you need to do is copy over the same field headers into this collection.

 All of your info from Airtable will be sent over to Webflow once you create the Whaleysnc. We will be getting to that step soon, but first, we need to do one more thing.

Step 3: Design your Webflow Template page.

Webflow excels at creating a CMS page where you can place dynamic content in pages.

It’s super important to create the collection first, that way when you go into your pages tab, then you can see the new dynamic page that will be pulling info from the collection you just created.

So go through and design the page.

Once you have a page designed the way that you want - now it’s time to place the collection items into the page.

I recommend that you place the longtail keyword in the H1 Text, and have it listed at least one more time in the excerpt.

Ideally, you are able to place the longtail keyword in an H1, H2, H3, and paragraph - but that would be a bit more writing on your part in the Airtable base.

It is completely up to you - but the reason why we like these PSEO pages is because it is done very quickly.

The less things that need added to the Airtable, the faster the process.

Publish your site. 

Now, let’s move on to the second to last step!

‍

Pro tip: Create 5 sample items in your collection to see content on your page once you map the items to your collection. After you do that, then you can delete them and publish your site.

Step 4: Create a Whalesync account and create a sync between Airtable and Webflow.

Using the Whaleysnc account, you can quickly map the fields from the Airtable to the collection fields in Webflow.

Be sure to have your site published before you go through with the sync, otherwise you will get an error that the collection isn’t published.

‍

Pay particular attention to the sync in the middle.

In my experience, it is safer to sync from Airtable to Webflow only - simply because if you mess up your sync, then you Airtable isn’t completely erased.

In fact, the first couple times you do this, definitely duplicate your Airtable base before the sync just in case there are any issues.

With that being said, once you have the sync ready to go - then hit sync!

Step 5: Check Webflow and publish!

Now all you need to do is check if all the Airtable items made it to Webflow!

Most of the time there are no issues if the site was published before the sync occurs - so in this case we are pretty much done.

So depending on the number of Airtable fields you created, you could have made 100s of PSEO pages with this process.

Really cool.

This is something that we do with all of our clients because SEM is so important.

If you have any questions, please don t hesitate to reach out.

Until next time…

To your success,
Ian “Your Favorite Growth Hacker” Binek