I'd like to use your help to better understand the desired skills and keywords for the social media industry. For this purpose, I'll provide you with three job posts. After I've pasted those in, you'd assess what are the most common skills - among both the requirements and qualifications - and rank those based on frequency. Do you understand what you're supposed to do?

Here is job post 1: Rolling Stone: Social Media Editor Rolling Stone is looking for a Social Media Editor to help grow our social audience of nearly 20 million. They must bring the latest insights, trends, and best practices to Rolling Stone as it covers music, entertainment, politics, internet culture, true crime, and more. The editor will serve as an active member of Rolling Stone’s editorial team. The ideal candidate will be creative, detail-oriented, and be ready to dive into the day-to-day work of programming our social channels. They’ll also understand industry shifts in video, and the ways that video is distributed is changing across Twitter, Facebook, Instagram, TikTok and more. Responsibilities: Maximize our audiences on Twitter, Instagram, TikTok, Facebook and more Manage, schedule, optimize and publish content across social platforms Develop strategies to roll out major stories, covers, lists, and more Edit social video for across platforms, sizing for optimization according to industry best practices Analyze social data Cover breaking news and live events Identify opportunities to recirculate evergreen content Work with our sales and marketing teams Requirements: 2-4 years of experience managing social media accounts for a brand or publisher Ability to juggle multiple requests in a fast-moving environment Attention to detail and an intuitive understanding of how people interact with content on different social platforms Photo, graphic, and video editing skills (Adobe Suite) Understanding of pressing topics for diverse cultures and communities Excellent news judgment and nose for breaking stories and trends Experience with social media management and analytics tools (SocialFlow, Sprout Social, Creator Studio, etc) We believe our newsroom should represent the communities we cover and our readership. Women, people of color, and LGBTQ+ candidates are strongly encouraged to apply. Please stand by while I provide you with job post 2.

Here is job post 2: This is the second job post: SOCIAL MEDIA ASSISTANT Responsibilities Within delegated authority, the incumbent is responsible for the following duties: Assists in public information/outreach and engagement with the public, such as outreach to schools, Model UNs, the media and think tanks, putting together exhibits based on materials from UNHQ, presentations, etc. Assists in the implementation of global communication strategies and campaigns on social media platforms to engage with local audiences on UN priority issues and/or major events, including the coordination of activities, monitoring and reporting on progress, taking appropriate follow-up actions, and analyzing the outcomes. Provides specialized assistance in the production and delivery of information communications products and services on social media platforms. Researches a broad scope of information sources, printed and electronic; compile and present information for use in the preparation and production of communications products/services for external audiences on social media platforms. Assists in the organizing and implementing of social media-related campaigns and events, coordinating with diverse partners. Collects and produces content for social media platforms, including various formats (e.g. infographic, video, etc.), including proposing topics, undertaking research, writing drafts, production of content (graphic design, audio/video editing, etc), obtaining clearances, editing copy, and coordinating design approval, translation procedures and distribution. Participates in the planning and implementation of communication campaigns on social media platforms by selecting appropriate and relevant excerpts of speeches and statements and coordinating the translation/adaptation of materials from other sources. Assists in managing the development and updating of internal databases; updates content on social media platforms; generates a variety of standard and non-standard statistical and other reports from various databases. Assists in the monitoring and reporting of activities and evaluating activities. Acts as focal point on social media matters, monitoring and reporting on the latest trends and developments, responding to queries, and participating in the monitoring and evaluation on the impact of the UN campaigns on social media. Provides communication support as needed. Performs related general administrative duties, as required, including the identification of office technology needs and maintenance of equipment, software and systems. Provides guidance to, and may supervise, junior colleagues, including other local staff, consultants, and/or interns. Perform other duties as required. Competencies • PROFESSIONALISM: Knowledge of utilizing digital and social media communications tools; ability to collect data and analyze data to prepare reports on effectiveness of outreach activities. Ability to research, gather, analyze and synthesize information from a variety of sources. Knowledge with building and maintaining databases. Shows pride in work and in achievements; demonstrates professional competence and mastery of subject matter; is conscientious and efficient in meeting commitments, observing deadlines and achieving results; is motivated by professional rather than personal concerns; shows persistence when faced with difficult problems or challenges; remains calm in stressful situations. Commitment to implementing the goal of gender equality by ensuring the equal participation and full involvement of women and men in all aspects of work. COMMUNICATION: Speaks and writes clearly and effectively; listens to others, correctly interprets messages from others and responds appropriately; asks questions to clarify, and exhibits interest in having two-way communication; tailors language, tone, style and format to match audience; demonstrates openness in sharing information and keeping people informed. PLANNING AND ORGANIZING: Develops clear goals that are consistent with agreed strategies; identifies priority activities and assignments; adjusts priorities as required; allocates appropriate amount of time and resources for completing work; foresees risks and allows for contingencies when planning; monitors and adjusts plans and actions as necessary; uses time efficiently. Education A high school diploma or equivalent is required. Work Experience A minimum of five (5) years of experience in social media, public information, public relations or related field is required. A minimum of two (2) years of experience creating content for digital publishing formats and/or platforms, including adapting briefing notes, press releases and speeches for social media and/or websites, is required. Experience working with social media platforms is required. Experience engaging with academia, think thanks, the media and youth, is desirable. Experience in graphic design and/or desktop publishing utilising Adobe Photoshop, Adobe InDesign, and/or comparable computer software is desirable. Experience in digital photography/video is desirable. Languages English and French are the working languages of the United Nations Secretariat. For the post advertised, fluency in English is required. Knowledge of another official United Nations language is desirable. Please stand by while I provide you with job post 3.

This is the third job post: Social Media Video Producer (Educator Audiences)- job post Scholastic Job Description: THE OPPORTUNITY We are looking for a producer who will be responsible for telling our story, primarily via video, to our educator and administrator audiences on our social media channels. Reporting to the Director, Social Media Content (Educator and Administrator Audiences), the Senior Social Media Video Producer will create and curate engaging content in line with our overall social media unification strategy and content calendar. RESPONSIBILITIES Create engaging short-form videos for social media: Set-up, film, and conduct video shoots. Utilize compositing skills and a strong sense of design to craft compelling narratives using stock footage and interviews. Produce and edit videos fit for the unique strengths and capabilities of each social media platform. Work with team members to develop narratives, storyboards, and shot lists. Collaborate with other editorial and video teams at Scholastic to help shape video concepts. Leverage data and insights in concepting. Conduct photo, video, and audio research to complement each video. Create production budgets based on resource availability and project specifications. Manage social media video projects: Successfully manage numerous projects, with overlapping deadlines. Manage production schedules, and workflows, from footage ingest to final delivery. Secure locations, permits, logistics and project crew and serve as the primary point of contact on the project. Repurpose video created in other formats and edit them so they are fit for social media. Engage with our lines of business to create engaging videos that highlight the benefits of our programs and offerings: Listen to stakeholder needs and manage expectations. Explain design decisions and the capabilities and limits of video on social media channels. Demonstrate leadership and accountability of initiatives, ensuring satisfied internal stakeholders. Proactively identify issues and recommend solutions. Coach and mentor staff in videography techniques, skills, and processes. Establish trust and confidence of business partners and interact with them without oversight. Establish a visual style for Scholastic video on social media that reflects the needs of our audiences and adheres to our brand guidelines. Support the content calendar creation in partnership with each line of business: Participate in planning sessions for new content ideas and campaigns. Iterate on the content calendar in a responsive fashion. Partner with Scholastic teams who are instrumental to the experience we provide to our audiences on social media: Align with other subject matter experts across the company. Collaborate with the Search and Media Paid Planning team to drive the interplay between paid and social media. Work closely with partners and support functions to leverage social video to address specific emerging needs. Select and manage outside specialist videographers, photographers, animators, motion designers, and agencies etc. Utilize and maintain our tools for content management, tagging, digital asset management, and project task calendaring. Be well-versed and attuned to the business models, opportunities, and best practices of social media platforms and modern brands. And help develop Scholastic’s overall social media competencies: Deliver training, best practices, and tools to our internal stakeholders ensuring we are continuously improving while social media evolves. Promote a culture of learning and development.HOW YOU CAN FIT - Qualifications Lover of books and reading. 3-5 years’ experience as a video editor in social media. Preferred: professional experience in the education sector Experience creating engaging video content on Instagram, YouTube, TikTok. A portfolio of high-quality, engaging video work. Technical understanding of pre-production, production, post-production process and workflows. Ability to manage competing priorities, exceptional multitasking and organizational skills. Strong project management skills, with the ability to be kind, flexible, and adaptive in a fast-paced environment. Strong written and verbal communication skills are a must. Ability to create and deliver effective presentations. Proficient in media production software (e.g. Premiere Pro, After Effects, and Adobe Creative Suite). Experience with color correction, audio mixing, and motion graphics. Ability to set-up gear, film, and direct simple video shoots. Experience managing freelancers and vendors. Now I want you to use all three job adverts to determine what the most common skills for social media are - using both the adverts' requirements and qualifications - and rank those based on frequency.