CSV Optimization Prompting Artifacts

Source Summary

Optimization Prompting Guide ive the following prompt to cursor chat: manually optimize the CSV by reviewing each row, researching the artist and artwork, and then creating new titles and descriptions that follow SEO best practices and ecommmerce best practices. If no artist is listed in the artist column, and if no artist name is mentioned in the title o

Imported Context

Optimization Prompting Guide

ive the following prompt to cursor chat: manually optimize the CSV by reviewing each row, researching the artist and artwork, and then creating new titles and descriptions that follow SEO best practices and ecommmerce best practices. If no artist is listed in the artist column, and if no artist name is mentioned in the title or keywords, do additional research, including an image search in combination with the relevant title and keywords to figure out who the artist is, and fill in the artist column with the artist's name.

or: update the titles, descriptions, and artist columns in products.csv as follows:

1. New SEO-optimized titles (≤ 60 characters).

2. New SEO-optimized descriptions (≤ 155 characters). Titles and descriptions should be optimized for digital downloads, not physical art prints. Should follow Google’s formatting guidelines (concise, keyword-rich, descriptive, natural).

3. Fill missing Artist column where possible. Requires research (based on title/keywords/images). If artist isn’t identifiable, set as Unknown. Then, for rows where Artist = Unknown, do a targeted lookup (title + keywords + image search) to identify the artist and update the column.

Recommended Title structure: Start with artist (if known), then artwork subject, then keywords like “Digital Download”. Example: Bill Traylor – Drinking Man & Dog Digital Download

Descriptions: Focus on digital file format, style, subject matter, and use case (e.g. printable wall art, instant download). Example: Instant download of Bill Traylor’s folk art drawing. Printable digital file for wall decor, unique American outsider art.

Artist Research: For rows where Artist = Unknown, I’ll do a targeted lookup (title + keywords) to identify the creator and update the column.

Provenance

• Source file: rps-digital/external-integrations/digital-product-pipeline/scripts/csv_optimization_prompting_guide.md
• Source URL: https://github.com/maggielerman/rps-digital/blob/main/external-integrations/digital-product-pipeline/scripts/csv_optimization_prompting_guide.md