Social Media Content Formats and Fields in Airtable Tables

Yes, I understand you perfectly! You want a comprehensive summary of all the content formats we’ve discussed across all platforms, and for each format, you want a table defining the necessary fields for your database (likely in Airtable). This is an excellent request – it’s crucial to have a well-structured database to store and manage all the generated content elements.

This is a bigger-picture organizational task, bringing together everything we’ve done. I’ll create these tables for you, drawing from all our previous conversations and prompt development.

Here’s the plan:

1. List All Platforms: I’ll list all the social media platforms we’ve worked on.
2. List Content Formats per Platform: For each platform, I’ll list all the distinct content formats we’ve developed prompts for.
3. Create Database Field Tables: For each content format, I’ll create a table with the following columns:
   • Field Name: The suggested name for the field in your database (e.g., tweet_text, image_prompt, article_content).
   • Data Type: The recommended data type for the field (e.g., String, Array of Strings, JSON Object).
   • Description: A brief description of the field’s purpose and content.
   • Source: Where this data comes from (e.g., “Gemini Output,” “Airtable Input”).
   • Notes: Any additional notes or considerations about the field.
4. Consistency and Clarity: I’ll ensure the field names are consistent across different formats where possible, and I’ll provide clear descriptions to avoid any ambiguity.
5. Completeness: I’ll aim to be as comprehensive as possible, including all the fields we’ve discussed, even optional ones.

This will give you a clear and organized blueprint for building your database to store all the AI-generated content elements.

Let’s begin! This will be a longer response, as it involves summarizing a lot of information.

---

Content Formats and Database Fields Summary

Here’s a breakdown of the content formats we’ve developed prompts for, organized by platform, along with the recommended database fields for each format.

I. Instagram

A. Multi-Format Posts (Carousels & Image Posts)

Field Name	Data Type	Description	Source	Notes
format	String	“carousel” or “image_post”	Gemini Output	Used to distinguish between Carousels and Image Posts within the JSON array.
carousel_title	String	(Carousel only) Overall title for the Carousel.	Gemini Output	Only present if format is “carousel”.
carousel_description	String	(Carousel only) Overall description for the Carousel.	Gemini Output	Only present if format is “carousel”.
slides	Array of Objects	(Carousel only) Array of JSON objects, each representing a slide.	Gemini Output	Only present if format is “carousel”. Each object within slides has image_prompt and text_overlay keys.
image_prompt	String	(Image Post and Carousel Slide) DALL-E prompt for the image.	Gemini Output	Present for Image Posts, and within each slide object for Carousels.
text_overlay	String	(Carousel Slide only) Text to be overlaid on the image.	Gemini Output	Only present within each slide object for Carousels.
caption	String	(Image Post only) Caption for the Image Post.	Gemini Output	Only present if format is “image_post”.
hashtags	Array of Strings	Hashtags for the Carousel or Image Post.	Gemini Output
call_to_action	String	Call to action for the Carousel or Image Post.	Gemini Output
series_title	String	(Carousel only) title for the Carousel.	Gemini Output	Only present if format is “carousel”.

B. Reels

Field Name	Data Type	Description	Source	Notes
video_script	Array of Strings	Array of strings, each representing a section of the narrative script for the voice-over.	Gemini Output
music_suggestions	String	(Optional) Suggestions for background music.	Gemini Output
hashtags	Array of Strings	Hashtags for the Reel.	Gemini Output
call_to_action	String	Call to action for the Reel.	Gemini Output

II. Facebook

A. Multi-Format Posts (Image Posts, Text Posts, Carousels, “Did You Know?” posts) – NO VIDEO

Field Name	Data Type	Description	Source	Notes
format	String	“image_post”, “text_post”, “carousel”, or “did_you_know”	Gemini Output	Used to distinguish between the different post formats within the JSON array.
image_prompt	String	(Image Post and Carousel Slide) DALL-E prompt for the image.	Gemini Output	Present for Image Posts, and within each slide object for Carousels, and optionally for “Did You Know?”.
caption	String	(Image Post only) Caption for the Image Post (including link to article).	Gemini Output	Only present if format is “image_post”.
post_text	String	(Text Post only) Text content for the Text Post (including link to article).	Gemini Output	Only present if format is “text_post”.
carousel_title	String	(Carousel only) Overall title for the Carousel.	Gemini Output	Only present if format is “carousel”.
carousel_description	String	(Carousel only) Overall description for the Carousel.	Gemini Output	Only present if format is “carousel”.
slides	Array of Objects	(Carousel only) Array of JSON objects, each representing a slide.	Gemini Output	Only present if format is “carousel”. Each object within slides has image_prompt and text_overlay.
text_overlay	String	(Carousel Slide only) Text to be overlaid on the image.	Gemini Output	Only present within each slide object for Carousels.
fact_text	String	(“Did You Know?” post only) Text content for the “Did You Know?” fact.	Gemini Output	Only present if format is “did_you_know”.
hashtags	Array of Strings	Hashtags for the post/carousel.	Gemini Output
call_to_action	String	Call to action for the post/carousel.	Gemini Output

B. Video Series

Field Name	Data Type	Description	Source	Notes
video_type	String	“overview” or “deep_dive”	Gemini Output
video_script	Array of Strings	The complete, narrative, keyword-rich script for the video, suitable for a professional voice-over. This script will also drive Pictory AI’s visual selection.	Gemini Output
music_suggestions	String	(Optional) Suggestions for background music.	Gemini Output
hashtags	Array of Strings	Relevant hashtags for the video.	Gemini Output
call_to_action	String	A clear call to action for the video.	Gemini Output

III. X (Twitter)

A. Individual Tweets (Bite-Sized, Ethical Product, Call to Action, Visual Storytelling)

Field Name	Data Type	Description	Source	Notes
tweet_text	String	The complete, ready-to-publish X (Twitter) Tweet text (including hashtags and call to action).	Gemini Output
image_prompt	String	(Optional) A concise DALL-E prompt to generate a relevant image for the Tweet (leave empty string “” if no image prompt is relevant).	Gemini Output

B. Threads

Field Name	Data Type	Description	Source	Notes
thread_title	String	A concise and engaging title for the overall thread.	Gemini Output
tweets	Array of Objects	Each object in the array represents a SINGLE Tweet within the thread and MUST contain…	Gemini Output
tweet_text	String	The complete text content of the Tweet.	Gemini Output
image_prompt	String	A concise DALL-E prompt to generate a relevant image for the Tweet (leave empty string “” if no image prompt is relevant).	Gemini Output
hashtags	Array of String	hashtags for the Tweet	Gemini Output

IV. Pinterest

A. Image Pin Series

Field Name	Data Type	Description	Source	Notes
series_title	String	title for the Pin series.	Gemini Output	Included on the first object only.
pin_title	String	The complete, ready-to-publish X (Twitter) Tweet text (including hashtags and call to action).	Gemini Output
image_prompt	String	A concise DALL-E prompt to generate a relevant image for the Tweet (leave empty string “” if no image prompt is relevant).	Gemini Output
pin_description	String	A concise and actionable DALL-E prompt to generate a relevant data visualization (infographic, chart, simple data image) to MAXIMIZE DATA IMPACT for each Tweet. If no image is needed, use an empty string “” for the image_prompt value.	Gemini Output

B. Carousel Series

Field Name	Data Type	Description	Source	Notes
series_title	String	The overall title or theme of the ENTIRE Pin series (SHOULD be added to the FIRST object only).	Gemini Output
carousel_type	String	Indicates whether the Carousel is an “overview” or a “deep_dive”. The FIRST object MUST have “carousel_type”: “overview”. Subsequent objects MUST have “carousel_type”: “deep_dive”.	Gemini Output
carousel_title	String	Overall title for THIS specific Carousel Pin.	Gemini Output
carousel_description	String	Overall description for THIS specific Carousel Pin (including website CTA).	Gemini Output
slides	Array of Objects	Each object in the array represents a single slide within THIS Carousel and MUST contain…	Gemini Output
image_prompt	String	Image prompt for that specific slide.	Gemini Output
text_overlay	String	Text overlay for that specific slide.	Gemini Output
hashtags	Array of Strings	Hashtags for THIS specific Carousel Pin.	Gemini Output
call_to_action	String	Call to action for THIS specific Carousel Pin.	Gemini Output

C. Video Pins

Field Name	Data Type	Description	Source	Notes
video_type	String	“overview” or “deep_dive”	Gemini Output
video_script	Array of Strings	The complete, narrative, keyword-rich script for the video, suitable for a professional voice-over. This script will also drive Pictory AI’s visual selection.	Gemini Output
music_suggestions	String	(Optional) Suggestions for background music.	Gemini Output
hashtags	Array of Strings	Relevant hashtags for the video.	Gemini Output
call_to_action	String	A clear call to action for the video.	Gemini Output

V. LinkedIn

A. Multi-Format Posts (Text Posts, Image Posts, Carousels) – NO VIDEO

  | Field Name          | Data Type        | Description                                                                                                                                | Source          | Notes                                                                                                 |

| :—————— | :————— | :—————————————————————————————————————————————– | :————– | :—————————————————————————————————- | | format | String | “image_post”, “text_post”, “carousel”, or “did_you_know” | Gemini Output | Used to distinguish between the different post formats within the JSON array. | | image_prompt | String | (Image Post and Carousel Slide) DALL-E prompt for the image. | Gemini Output | Present for Image Posts, and within each slide object for Carousels, and optionally for “Did You Know?”. | | caption | String | (Image Post only) Caption for the Image Post (including link to article). | Gemini Output | Only present if format is “image_post”. | | post_text | String | (Text Post only) Text content for the Text Post (including link to article). | Gemini Output | Only present if format is “text_post”. | | carousel_title | String | (Carousel only) Overall title for the Carousel. | Gemini Output | Only present if format is “carousel”. | | carousel_description| String | (Carousel only) Overall description for the Carousel. | Gemini Output | Only present if format is “carousel”. | | slides | Array of Objects | (Carousel only) Array of JSON objects, each representing a slide. | Gemini Output | Only present if format is “carousel”. Each object within slides has image_prompt and text_overlay. | | text_overlay | String | (Carousel Slide only) Text to be overlaid on the image. | Gemini Output | Only present within each slide object for Carousels. | | fact_text | String | (“Did You Know?” post only) Text content for the “Did You Know?” fact. | Gemini Output | Only present if format is “did_you_know”. | | hashtags | Array of Strings | Hashtags for the post/carousel. | Gemini Output | | | call_to_action | String | Call to action for the post/carousel. | Gemini Output | |

B. Video Series

  | Field Name          | Data Type        | Description                                                                                                                                                       | Source          | Notes |

| :—————— | :————— | :—————————————————————————————————————————————————————- | :————– | :—- | | video_type | String | “overview” or “deep_dive” | Gemini Output | | | video_script | Array of Strings | The complete, narrative, keyword-rich script for the video, suitable for a professional voice-over. This script will also drive Pictory AI’s visual selection. | Gemini Output | | | music_suggestions | String | (Optional) Suggestions for background music. | Gemini Output | | | hashtags | Array of Strings | Relevant hashtags for the video. | Gemini Output | | | call_to_action | String | A clear call to action for the video. | Gemini Output | |

C. LinkedIn Articles

Field Name	Data Type	Description	Source	Notes
article_title	String	The headline of the LinkedIn Article.	Gemini Output
article_content	String	The complete, Markdown-formatted text content of the LinkedIn Article, ready for publishing.	Gemini Output
image_prompts	Array of Strings	A SEPARATE ARRAY containing concise DALL-E prompts to generate relevant images for the Article and its sections.	Gemini Output	First element is a general image prompt; subsequent elements are for each section.

VI. Medium

A. Medium Articles

Field Name	Data Type	Description	Source	Notes
article_title	String	The headline of the Medium Article.	Gemini Output
article_content	String	The complete, Markdown-formatted text content of the Medium Article, ready for publishing.	Gemini Output
image_prompts	Array of Strings	A SEPARATE ARRAY containing concise DALL-E prompts to generate relevant images for the Article and its sections.	Gemini Output	First element is a general image prompt; subsequent elements are for each section.

VII. PODs A. POD Quote and Design

Field Name	Data Type	Description	Source	Notes
quote	String	The newly generated quote.	Gemini Output
quote_tone	String	A description of the intended tone.	Gemini Output
design_prompt	String	A general design prompt for the POD product	Gemini Output
font_suggestions	Array of Strings	Suggested font pairings or individual fonts	Gemini Output
image_prompt	String	(Optional) A DALL-E prompt	Gemini Output
product_suggestions	Array of Strings	Suggested POD products that would be suitable for this quote and design	Gemini Output

VIII. Input Parameters (Airtable)

These are the fields you’ll need in your Airtable base to provide the necessary input to the various prompts:

Field Name	Data Type	Description
Innovarius VP-Article Title	String	The title of the Knowledge Article.
brief_description	String	A brief description or summary of the article.
target_audience	String	The intended target audience for the article and generated content.
call_to_action	String	The desired call to action (to be used consistently across platforms).
ethical_product_connection	String	(Optional) Information about a relevant ethical product or brand to be integrated.
keywords	String	A list of relevant keywords and synonyms (comma-separated or space-separated).
Research Report for Knowledge Article	String	The full text content of the Knowledge Article.
Research Report for Facts & Figures Article	String
Research Report for Case Studies Article	String
Pinterest Based Article	String	The full text content of the Knowledge Article.
Validated SEO-Friendly Slug	String	The SEO-friendly slug for creating the article URL. Required for generating dynamic links.
Number of Swaps	Integer	(Optional, but HIGHLY RECOMMENDED for articles with numbered lists) The number of key elements/swaps/tips in the article.

This comprehensive table structure should give you a very clear roadmap for setting up your Airtable database to store all the generated content elements. Remember to adjust field types as needed based on Airtable’s specific options. This structure is designed for maximum flexibility and future scalability. By using JSON arrays and consistent field names, you’ll be able to easily manage and repurpose your content across multiple platforms.