Moving to Marketing from Advertising

Hey there, I've 5 years of experience working as a content strategist in Advertising Agencies. I've worked on multiple marketing campaigns for 25+ brands. However, I now want to transition to a full time marketing role with a blend of analytics and creativity without opting for an MBA. Here are some of the skills I plan on getting certifications in to land a role: SQL, Tableau, Excel (pivot tables, charts, v lookups), Marketing Strategy Project Management Media Planning I already have a strong background in copywriting, design, managing cross-functional teams and stakeholders. Do you have any tips or advice that can help me in this journey? Do you recommend any courses or certifications I should undertake to highlight the above mentioned skills? How do I pitch myself as the perfect candidate without having an actual job experience in marketing management roles? Thanks for your time :)