I read this article on how nomadlist.com uses its crowdsourced data to automatically create individual pages to be visibile for longtail seo-keywords. The author states that they use a php-template, but I'm not sure what he bases that statement on.
Our project collects crowdsourced data and I'm struggling a bit to replicate this.
Especially since I don't have any control over the number of data-points to build pages from.
One example would be written travel-experiences for any location in newzealand.
In this example we collect a location, a mood and a written text whenever a user posts something.
User A: Location(City): Auckland, Mood: Happy, Text: "..."
User B: Location(City): Wellington, Mood: Sad, Text: "..."
User C: Location(City): Christchurch, Mood: Angry, Text: "..."
The "Location" is collected via mapbox api and then saved to our database.
The "Mood" is collected via radio-buttons and has a known number of predefined choices.
1. How can I generate pages/urls with titles like: "10 (Happy) Experiences from (Auckland)"?
I dont know how to achieve this technically and am specifically struggling with the unknown number of possible locations and the page should only be available if we actually have a minimum of 10 (Happy) entries for (Auckland).
2. How can I make searchengines recognize these "pages" if they are not "physically" created, but only made available via urls?
Any push in the right direction is appreciated, since I'm completely new to these kind of generated content pages.
Addition 1 - How the system captures data:
Data is captured via a chatbot created with botman.
A user can trigger the creation of a new entry via a typed command. The chatbot then asks 5 questions (e.g. mood and location) and writes the users answers to the database when the final question in the sequence has been answered.
Addition 2 - How the system stores data:
An entry is saved as a custom post type in the wp_posts table. So main fields like post ID, date, post image and content come from there.
Additional information is saved to the wp_postmeta table with the following fields: Meta_ID, Post_ID, meta_key, meta_value. So things like mood, location or weather each have their own row in the wp_postmeta table and are assigned to an entry from there.