VidIQ Keyword Automation Part1

Automating UA-cam Keywords with VidIQ Score - Part 1
Starting with a list of keywords, we sort them by their VidIQ scores and select the top 8.
In the previous video ( • AI and Automation to a... ), we asked GenAI to give us 6-8 tags. In this case, we ask for 30 potential keywords that we will whittle down to 8. We start with those keywords in cell A1.
Step 1. We split the keyword list by the comma character and put each keyword into its own row
=TRANSPOSE(SPLIT(A1, ","))
Step 2. We lookup the VidIQ score for each keyword. If we don’t find the keyword, we return a score of -1. The first time we do this, every score will be -1 and we will take the first 8 keywords.
=ARRAYFORMULA(IF(B:B="", "", IFERROR(VLOOKUP(B:B, Keywords!A:B, 2, FALSE), -1)))
Step 3. For not we need to manually build the lookup table with VidIQ scores. We will automate this more in a future update. To make it a little easier, we build out links to lookup each keyword.
=ARRAYFORMULA(IF(B1:B(leftangle)(rightangle)"", "app.vidiq.com/..." & SUBSTITUTE(B1:B," ","%20") , ""))
Step 4. Sort the potential keyword by score.
=SORT(FILTER(B:B, B:B (leftangle)(rightangle) ""), FILTER(C:C, C:C (leftangle)(rightangle) ""), FALSE)
Step 5. Pick the top 8 and combine them back into the format required. You can copy and paste this into UA-cam or use the automatic update from the first video.
=TEXTJOIN(",", TRUE, E1:E8)
• The ultimate goal is to be able to update all the videos in a channel with the best keywords in a single step.
• I don’t know a lot of spreadsheet syntax. Bing Copilot did an amazing job building the formulas that I needed.