For <<BRAND>>. <<Last 30 Days>> Performance. <<Linear Touch>> Attribution.

PART 1

- Fetch all video creatives that are currently tagged.
- Out of these creatives, select the top 20% performance creatives by true ROAS and the bottom 20% performance creatives by ROAS:
- Highlight what's the common message patterns across them.

PART 2

- Use the voiceover transcript to Filter out the message in the first few seconds for hook rate and the extended transcript for hold rate.
- Sort all creatives by hook rate and hold rate to identify which creatives have a high engagement.
- For videos with high hook rate and high hold rate - Find the common attributes & messaging patterns across
- For videos that have high hook rate but low hold rate - Find out what messaging is able to capture them, but follow-up messaging is not able to hold them.

Make a visual HTML report that I can share and download.