Posts

Showing posts from August, 2021

Video Making, Publishing, Channel Optimizing Checklist

Video Idea Look at your competitor Which has more view - you can go with that Shorts Video Which has more view - you can go with that In Video  Start First Disclaimer 15-sec VVI 3 part in 15 sec Don't show logo, name in this 15 sec Middle 7 to 17 min Keyword in video say 1-2 times in the video Retention Open Loops Pattern Interrupts On-Screen Graphics B-Rolls End Ask for Like, comment, share, Subscribe Subscribe = if-then CTA Ask for press bell icon Introduce your website to go. and pitch why they go Site name spell and visible too Ask for specific comments and generic comments Give reply - it will give you more... End Screen 5-20 sec Still graphic Recommend video(s) Subscribe Clickable elements Publish Transcript Create and upload video transcript Title CTR - optimize Use number Use odd number Use bracket and parenthesis

Excel and Sheet Formula

Google Sheet Extract number from string and number   = VALUE ( REGEXREPLACE ( G104 , "[^[:digit:]]" , "" ) ) Microsoft Excel Xpath to get search result form google SERP //*[@id="result-stats"]/text() search result //*[@id="rso"] Full result