Produce a public OilPriceAPI Google Sheets tutorial for YouTube discovery

[karlwaldman]

Bottom line up front, more work to be done.

Verification note (2026-08-04): The ticket is framed as an investigation or decision and does not yet contain enough evidence to turn it into implementation scope.

---

Outcome

Publish a polished public YouTube tutorial that demonstrates OilPriceAPI with Google Sheets, attracts qualified search traffic, and measures resulting visits, signups, and first API activations. This is separate from the Unlisted OAuth reviewer video.

Source plan

Follow YOUTUBE_PROMOTION.md from PR #23: #23

Requirements

• Decide whether to publish the pre-approval version with an accurate “Marketplace publication pending” CTA or wait for Marketplace approval and demonstrate installation
• Record a clean workbook flow: install/open, configure a masked test key, verify connection, fetch prices, enter a working custom formula, and show the result
• Use descriptive Google Sheets™ references only; do not imply Google endorsement
• Include the trademark disclaimer from YOUTUBE_PROMOTION.md
• Use a search-oriented title, description, thumbnail, and chapters
• Put tagged landing-page and signup URLs in the description using the documented UTM campaign
• Publish as Public and add the video to the integration/listing content where appropriate
• Confirm links work from the public watch page and no API key, email, browser profile, or private tab is visible

Measurement

Track YouTube impressions, YouTube Search traffic, click-through rate, audience retention, GA4 sessions, attributed signups, first API activation, activated workbooks, and paid conversions.

Initial 90-day success threshold: achieve at least one of:

• 100 qualified YouTube-referred sessions
• 10 attributed signups
• 3 first API activations

North-star metrics:

• Activated accounts per 1,000 video views
• Activated workbooks per 100 YouTube-referred sessions

Notes

Treat this as a measurable discovery and conversion channel. Do not represent the YouTube description link as guaranteed high-authority SEO link equity.

[karlwaldman]

Closing as not planned in the current product queue. This is a marketing-channel experiment with no recorded economics, low inaction risk, and no dependency for the already-live Sheets listing. If YouTube becomes an evidence-backed acquisition channel, open a new bounded experiment with an owner, budget, and measurement window rather than carrying this indefinitely.