/*@jsxRuntime automatic @jsxImportSource react*/ const {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0]; const {useMDXComponents: _provideComponents} = arguments[0]; function _createMdxContent(props) { const _components = Object.assign({ p: "p", ul: "ul", li: "li", code: "code", a: "a", strong: "strong", h2: "h2", img: "img", ol: "ol", h3: "h3", pre: "pre", blockquote: "blockquote" }, _provideComponents(), props.components); return _jsxs(_Fragment, { children: [_jsx(_components.p, { children: "There’s a ton of information about everything on the internet. Users are constantly looking for the signal in the noise. You can turn visitors into customers by collecting and curating data in collection pages like:" }), "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["Top 10 books to read for ", _jsx(_components.code, { children: "{{Job Type}}" })] }), "\n", _jsxs(_components.li, { children: ["Hire the 5 best private chefs in ", _jsx(_components.code, { children: "{{Location}}" })] }), "\n", _jsxs(_components.li, { children: ["Top VC Funds that invest in ", _jsx(_components.code, { children: "{{Industry}}" }), " startups"] }), "\n"] }), "\n", _jsx(_components.p, { children: "Creating these kinds of pages in Engyne is now easier than ever." }), "\n", _jsxs(_components.p, { children: ["Instead of creating each row by hand, we can make use of ", _jsx(_components.a, { href: "https://www.airtable.com/guides/build/connect-data-with-linked-records", children: "Airtable's Linked Records" }), " to split up information across multiple tables, create dynamic relationships between them, and then bring it into Engyne."] }), "\n", _jsxs(_components.p, { children: ["In this guide, we will create category pages like \"Top 10 books to read for ", _jsx(_components.code, { children: "{{Job Type}}" }), "\" for a fake SaaS business ", _jsx(_components.strong, { children: "Bookify" }), ". Bookify lets you listen to key insights of business books as a short audio clip - very similar to ", _jsx(_components.a, { href: "http://blinkify.com/", children: "blinkify.com" }), "."] }), "\n", _jsx(_components.h2, { children: "Final Result" }), "\n", _jsx(_components.p, { children: "By the end of this guide, you’ll be able to create Programmatic SEO pages that have collections of items per page categorized in an Airtable." }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/final-demo.png", alt: "Final Demo screenshot in Engyne" }) }), "\n", _jsx(_components.h2, { children: "Step 1: Prep data" }), "\n", _jsxs(_components.p, { children: ["Log in to ", _jsx(_components.a, { href: "https://airtable.com", children: "Airtable" }), " and create a new base with two tables: ", _jsx(_components.strong, { children: "All Books" }), " and ", _jsx(_components.strong, { children: "Collections" }), "."] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.strong, { children: "All Books" }), ": This table will contain relevant information about a particular book per row - title, author, summary, image, link to buy."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.strong, { children: "Collections" }), ": This table will have the job type we are curating the books for and the information on 5 books that we think are relevant. The books will come from the ", _jsx(_components.strong, { children: "Books" }), " table."] }), "\n"] }), "\n", _jsx(_components.h3, { children: "Create the All Books table" }), "\n", _jsx(_components.p, { children: "To make this easier, I've already prepped the data for you to import into Airtable." }), "\n", _jsxs(_components.p, { children: ["For the ", _jsx(_components.strong, { children: "All Books" }), " table:"] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Click on ", _jsx(_components.strong, { children: "Add or Import" }), " > More Sources > Paste table data"] }), "\n", _jsx(_components.li, { children: "Paste the entire block of data below:" }), "\n"] }), "\n", _jsx(_components.pre, { children: _jsx(_components.code, { children: "Book Title,Summary,Why read this,Why to not read this,Buy Link,Category,Book Cover\n$100M Offers: How To Make Offers So Good People Feel Stupid Saying No,\"This book is a must-read for anyone looking to make offers that are too good to refuse. Written by experienced entrepreneur and investor, David Finkel, $100M Offers: How To Make Offers So Good People Feel Stupid Saying No provides readers with the tools and strategies to craft offers that are irresistible. Finkel shares his own experiences and insights to help readers understand the psychology of making offers, as well as how to craft offers that are too good to pass up. He also provides practical advice on how to negotiate and close deals, as well as how to handle objections. With this book, readers will be able to make offers that are so good, people will feel stupid saying no.\",\"- Understand the psychology behind why people accept or reject offers.\n - Learn how to craft offers that are too good to refuse.\n - Discover the strategies to make offers that are irresistible.\",\"- May not apply to small startup\n - Too focused on high-value deals\n - May not be relevant to SaaS\", Sales,\nThe Brain Audit: Why Customers Buy (and Why They Don't) by Sean D’Souza,\"The Brain Audit: Why Customers Buy (and Why They Don't) by Sean D’Souza is a must-read for any business owner or marketer. It provides a comprehensive look at the psychology of why customers buy, and why they don't. It covers topics such as the seven triggers of buying, the three questions customers ask before buying, and the four steps to creating a successful marketing message. It also provides practical advice on how to use these principles to increase sales and build customer loyalty. The book is written in an easy-to-understand style, making it accessible to readers of all levels. It is an invaluable resource for anyone looking to understand the psychology of customer buying behavior and increase their sales.\",\"- Understand the psychology behind why customers buy and why they don't.\n - Learn how to create a customer-centric marketing strategy.\n - Discover how to create a memorable customer experience.\",\"- May not be relevant to SaaS\n - Focuses on offline businesses\n - Limited case studies on SaaS\", Sales,\nBehind the Cloud by Marc Benioff & Carlye Adler,\"Behind the Cloud is an inspiring story of how Marc Benioff and Carlye Adler built Salesforce, one of the world’s most successful cloud computing companies. The book chronicles their journey from the early days of the company to its current success. It provides an inside look at the strategies and tactics they used to build a successful business. It also offers valuable lessons on how to create a culture of innovation and how to stay ahead of the competition. The book is filled with inspiring stories of how Benioff and Adler overcame obstacles and achieved success. It is an inspiring read for anyone looking to build a successful business.\",\"- Provides insight into the strategies and tactics used to build a successful SaaS business.\n - Explains the importance of customer service and how to create a culture of innovation.\n - Highlights the importance of staying ahead of the competition and how to use technology to drive growth.\",\"- Limited focus on sales and marketing\n - More focused on the story of Salesforce\n - may not be relatable to other SaaS companies\", Sales,\nChallenger Sale by Brent Adamson and Mathew Dixon,\"Challenger Sale is a book written by Brent Adamson and Mathew Dixon that provides an in-depth look into the sales process. It explains how salespeople can use the Challenger Sale approach to create value for their customers and build strong relationships. The book outlines the five steps of the Challenger Sale process, which include teaching, tailoring, taking control, challenging, and demonstrating. It also provides strategies for salespeople to use to effectively engage customers and close deals. Additionally, the book provides insights into how salespeople can use data to better understand their customers and create tailored solutions. Overall, Challenger Sale is an invaluable resource for salespeople looking to improve their sales process and close more deals.\",\"- Understand the importance of challenging customers to think differently about their business.\n - Learn how to create a successful sales process that is tailored to the customer's needs.\n - Develop the skills to build relationships with customers and create a lasting impact.\",\"- May not be relevant to all SaaS sales strategies\n - Focuses on enterprise level sales\n - May not be relatable to other SaaS companies\", Sales,\nHow to Win Friends and Influence People,\"How to Win Friends and Influence People is a timeless classic written by Dale Carnegie. It is a book that has been helping people to build relationships and improve their communication skills since it was first published in 1936. The book provides practical advice on how to make friends, how to influence people, and how to handle difficult conversations. It also offers tips on how to be a better listener, how to be more persuasive, and how to be more confident. The book is filled with stories and anecdotes that illustrate the principles of effective communication. It is an invaluable resource for anyone looking to improve their relationships and communication skills.\",\"- Learn how to build relationships with customers and colleagues to increase trust and loyalty.\n - Understand how to effectively communicate with others to create positive outcomes.\n - Develop the skills to influence people and create a successful business.\",\"- Focuses on personal relationships rather than business\n - May not be relevant to SaaS\n - Limited focus on sales and marketing\", Sales,\nHacking Growth,\"Hacking Growth is a book that provides readers with a comprehensive guide to growth hacking. It covers the fundamentals of growth hacking, from understanding the customer journey to developing a growth hacking strategy. It also provides practical advice on how to use data to drive growth, how to use A/B testing to optimize user experience, and how to use automation to scale growth. Additionally, the book provides case studies of successful growth hacking campaigns, as well as tips and tricks for getting the most out of growth hacking. Hacking Growth is an essential resource for anyone looking to take their business to the next level.\",\"- Understand how to use data to drive growth and optimize customer acquisition.\n - Learn how to use experimentation to test and validate growth strategies.\n - Discover how to use viral loops and referral programs to increase user engagement.\",\"- Not focused on SaaS businesses\n - No advice on pricing strategies\n - No guidance on customer acquisition\",\n\n" }) }), "\n", _jsx(_components.h3, { children: "Create the Collections table" }), "\n", _jsxs(_components.p, { children: ["Let's now create the ", _jsx(_components.strong, { children: "Collections" }), " table:"] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsx(_components.li, { children: "Create a new table." }), "\n", _jsx(_components.li, { children: "Delete all columns, expect for the first one." }), "\n", _jsxs(_components.li, { children: ["Name the first one - ", _jsx(_components.code, { children: "Job Title" }), "."] }), "\n", _jsxs(_components.li, { children: ["Add a new column. Call it \"Books\". Make it ", _jsx(_components.strong, { children: "Link to another record" }), ". Select ", _jsx(_components.code, { children: "All Books" }), " table to link from. Make sure the \"Allow linking to multiple records\" option is enabled. Click ", _jsx(_components.strong, { children: "Save" }), ". If it prompts you to ", _jsx(_components.code, { children: "Add lookup fields?" }), ", click ", _jsx(_components.strong, { children: "Skip" }), "."] }), "\n"] }), "\n", _jsx(_components.p, { children: "We can use this column to link to book items in the \"All Books\" table." }), "\n", _jsx(_components.h3, { children: "Populate the Collections table" }), "\n", _jsx(_components.p, { children: "I'll add a few rows for 3 job types (Sales, Marketing, Leadership) in the Collections table like below. Feel free to switch it up." }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/airtable-collections-initial.png", alt: "Set up Airtable Collection table" }) }), "\n", _jsx(_components.h2, { children: "Step 3: Format each Book item" }), "\n", _jsx(_components.p, { children: "If we look back at our demo page, we want each book item on our page to have the book title, summary and the buy link." }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/book-item.png", alt: "Highlighted Book Item" }) }), "\n", _jsx(_components.p, { children: "Airtable Formulas are perfect for this." }), "\n", _jsxs(_components.p, { children: ["In the ", _jsx(_components.strong, { children: "All Books" }), " table:"] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Create a new column called ", _jsx(_components.code, { children: "Book Formatted" }), " of type: ", _jsx(_components.strong, { children: "Formula" }), "."] }), "\n", _jsxs(_components.li, { children: ["Add this formula and click ", _jsx(_components.strong, { children: "Save" }), "."] }), "\n"] }), "\n", _jsx(_components.pre, { children: _jsx(_components.code, { children: "CONCATENATE({Book Title}, {Summary}, {Buy Link})\n" }) }), "\n", _jsxs(_components.p, { children: ["This formula brings the three values we need into a single column which we can import into the ", _jsx(_components.strong, { children: "Collections" }), " table."] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/create-formula-field-all-books.png", alt: "Creating a formula field in Airtable" }) }), "\n", _jsxs(_components.p, { children: ["Switch to the ", _jsx(_components.strong, { children: "Collections" }), " table:"] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Create a new ", _jsx(_components.strong, { children: "Rollup" }), " field called ", _jsx(_components.code, { children: "Books Formatted" }), ". Configure the settings as shown in the screenshot below. Choose ", _jsx(_components.code, { children: "Books Formatted" }), " and add this Aggregation formula:"] }), "\n"] }), "\n", _jsx(_components.pre, { children: _jsx(_components.code, { className: "language-plain", children: "ARRAYJOIN(values, \"\\\\n\\\\n\")\n" }) }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/rollup-field-in-collections.png", alt: "Rollup field in the Collections table" }) }), "\n", _jsx(_components.h2, { children: "Create the Engyne Project" }), "\n", _jsxs(_components.blockquote, { children: ["\n", _jsxs(_components.p, { children: ["If this is the first time you're using Engyne, try following ", _jsx(_components.a, { href: "https://launchman.com/blog/getting-started", children: "the Getting Started guide" }), " before continuing."] }), "\n"] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Sign up and log in to ", _jsx(_components.a, { href: "https://app.launchman.com", children: "Engyne" }), "."] }), "\n", _jsxs(_components.li, { children: ["Create a new ", _jsx(_components.strong, { children: "Collection." }), " Name it: ", _jsx(_components.code, { children: "Book Collections for Job Type" }), "."] }), "\n", _jsxs(_components.li, { children: ["Connect your Airtable by copy/pasting the API key and the base URL for the ", _jsx(_components.strong, { children: "Collections" }), " table."] }), "\n"] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/correct-url-to-copy-launchman.png", alt: "Correct Base URL to copy to Engyne" }) }), "\n", _jsxs(_components.blockquote, { children: ["\n", _jsxs(_components.p, { children: ["Make sure that you copy the entire URL for the ", _jsx(_components.strong, { children: "Collections" }), " table from Airtable and not the ", _jsx(_components.strong, { children: "All Books" }), " one."] }), "\n"] }), "\n", _jsxs(_components.ol, { start: "4", children: ["\n", _jsxs(_components.li, { children: ["Click on ", _jsx(_components.strong, { children: "Sync Items." }), " All the records from the ", _jsx(_components.strong, { children: "Collections" }), " table should now be synced over."] }), "\n"] }), "\n", _jsx(_components.h3, { children: "Create a Page Template" }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Open up the Page Designer by clicking the ", _jsx(_components.strong, { children: "Design your Page" }), " button on the top right of the Engyne dashboard."] }), "\n", _jsxs(_components.li, { children: ["Create a new ", _jsx(_components.code, { children: "Text" }), ". Paste this in:"] }), "\n"] }), "\n", _jsx(_components.pre, { children: _jsx(_components.code, { children: "# 3 books to read if you're in {{Job Title}} [2023]\n\n{{Books Formatted}}\n\n" }) }), "\n", _jsxs(_components.p, { children: ["Engyne will automatically populate the pages with the Airtable data. This is what my ", _jsx(_components.code, { children: "Sales" }), " page looks like:"] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/sync-collections-1.png", alt: "Synced items in Engyne dashboard" }) }), "\n", _jsx(_components.p, { children: "If you look closely, each book item is coming through (the book title, summary and link are all there) but they aren’t styled correctly. We will fix in the next step with Markdown." }), "\n", _jsx(_components.h2, { children: "Add Markdown to style each Book item" }), "\n", _jsxs(_components.p, { children: ["Engyne uses Markdown to format text. You can find a ", _jsx(_components.a, { href: "https://launchman.com/blog/markdown-cheat-sheet", children: "cheat sheet on this here" }), "."] }), "\n", _jsxs(_components.p, { children: ["Update the ", _jsx(_components.code, { children: "Book Formatted" }), " formula in the ", _jsx(_components.strong, { children: "All Books" }), " collection with this formula below. There might be a warning \"Changing this field’s configuration will impact 1 dependency.\" that might show but you can safely ignore that."] }), "\n", _jsx(_components.pre, { children: _jsx(_components.code, { children: "CONCATENATE(\"## \", {Book Title},\"\\\\n\\\\n\", {Summary}, \"\\\\n\\\\n[Buy this book ->](\", {Buy Link}, \")\")\n" }) }), "\n", _jsxs(_components.p, { children: ["Head over to your Engyne collection and click ", _jsx(_components.code, { children: "Sync Items" }), " to import newly made changes."] }), "\n", _jsx(_components.p, { children: "Open up the Page Designer and you should see the page look a lot better." }), "\n", _jsx(_components.h2, { children: "Publish pages" }), "\n", _jsx(_components.p, { children: "The last thing to do before we push these Programmatic SEO pages into production is customize the SEO tags - title, description and most importantly the URL." }), "\n", _jsxs(_components.p, { children: ["In the ", _jsx(_components.strong, { children: "SEO" }), " tab:"] }), "\n", _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Update Slug URL to be: ", _jsx(_components.code, { children: "/summary/{{Book Title}}" })] }), "\n", _jsxs(_components.li, { children: ["Update Meta Title to be: ", _jsx(_components.code, { children: "{{Book Title}}" })] }), "\n", _jsx(_components.li, { children: "Update Description to be:" }), "\n"] }), "\n", _jsx(_components.pre, { children: _jsx(_components.code, { className: "language-text", children: "{{Book Title}} is a great book to read for any budding new founder out there. Sign up for Bookify for more book summaries.\n" }) }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "/how-to-use-airtable-linked-records/set-up-seo-in-launchman.png", alt: "Set up SEO in Engyne" }) }), "\n", _jsx(_components.p, { children: "There we have it! Our amazing collection of Programmatic SEO pages put together in Airtable." })] }); } function MDXContent(props = {}) { const {wrapper: MDXLayout} = Object.assign({}, _provideComponents(), props.components); return MDXLayout ? _jsx(MDXLayout, Object.assign({}, props, { children: _jsx(_createMdxContent, props) })) : _createMdxContent(props); } return { default: MDXContent };

Everything you need to know about Programmatic SEO

.css-1hnz6hu{position:static;}.css-1hnz6hu::before{content:'';cursor:inherit;display:block;position:absolute;top:0px;left:0px;z-index:0;width:100%;height:100%;}Maximizing Revenue: How to monetize your Programmatic SEO Pages

I experimented with creating a Programmatic SEO website

Getting Started

How to create Collection Pages with Airtable Linked Records in Engyne

Markdown Cheat Sheet for Engyne

How Engyne will take over the world

Top 18 tools to use for your next Programmatic SEO project

Maximizing Revenue: How to monetize your Programmatic SEO Pages