Sql group by jobs

...needs. Interested freelancers should have a vast understanding of mobile chat app development, and a keen attention to detail. Here are the key features needed: - Group Chats: The application should support communication among a group of people. A solid grasp on managing larger group dynamics within chat applications would be beneficial. - Emoji Support: The application should support the use of emojis for enhanced and fun interaction. Prior experience integrating emojis into mobile applications is highly preferred. Overall, this is a project that requires a specialised set of skills in mobile app chat development, experience in group chat dynamics, and knowledge in implementing emojis within these applications. Your vast experience and quick turnaround t...

I'm seeking the expertise of a seasoned developer to create a customized chat functionality for a project I'm currently running. After careful consideration, I've decided to focus on group text chat as the core communication channel. Here's what I'm envisioning: - Group Messaging: The core communication method in use will be group messages. I want the developer to build a robust system where users can create, engage, and manage group chats efficiently. Experience in building similar platforms will be a significant advantage. - Media Sharing: The chat interface should be modern and dynamic, capable of handling in-message media sharing. This means users should be able to share images, videos, and other rich media content within the chat...

I'm seeking a savvy digital marketer with a specialized knowledge of Googl...be crucial in this aspect. - Our target audience for these ads are young adults, specifically those aged between 18-24. Understanding this demographic, their interests, behaviors, and preferences will be vital in crafting compelling and effective ad copies. Ideal Candidate: - Proven experience with Google Ads, particularly in lead generation campaigns. - Sound understanding of the 18-40 age group and how to effectively engage and convert them. - Strong analytical skills to measure campaign success and make data-driven optimizations. If you're a performance-driven marketer with a solid track record in Google advertising and a knack for attracting and converting young adults into leads, I'...

I’m looking for an individual with a strong intermediate knowledge level of .NET to conduct training for a small group of 1 to 10 people. Here are the key details about the training to be conducted: - This role requires someone experienced with .NET Core and ASP.NET. Your primary focus will be these areas and you should be able to deliver training effectively on this. - As a trainer, you would need to have an excellent command of these concepts and the ability to explain them in a way that's easy for the participants to understand. - Previous experience with delivering .NET training is a significant plus. 1 day physially training for MIS level audience. location at Bandar Sri Damansara.

I'm looking for a Telegram bot expert to help me with several tasks. Please see attached document for specific instructions of job. Do not send a quote you are not able to do the job for!! - Automating Messages: I want the bot to send automated messages on my behalf - Resending Messages: You'll need to reword messages I receive and send them to my group While the project does not require any specific design or branding, it's crucial that you have a good understanding of how Telegram bots work and the ability to implement these features flawlessly. Ideal Skills: - Previous experience in creating Telegram bots - Proficient in Python and/or Node.js - Strong communication skills to ensure the bot functions as intended. - Must have great English skills and communic...

...infrastructure, including Windows Server (2019, 2016, 2012 R2, 2012, 2008 R2, 2003) and virtualization environments on both Hyper-V and vSphere, in addition to Citrix XenApp and/or XenDesktop, and Azure Virtual Desktop. Active Directory: Provides project design + implementation and high-level troubleshooting for Active Directory, including Azure Active Directory (Intra AD), Intune, AutoPilot, Group Policy, Access/Identity Management, AADS, Federation Services, Domain Controllers, etc. for medium to enterprise environments. Networking: Provides project design + implementation and high-level troubleshooting for networking infrastructure, including: Routing, switching, firewalls, WAPs, VPNs, load balancers, etc. in medium to larger LAN/WAN environments, including cloud environm...

I'm looking for seasoned artists for various types of concert appearances worldwide. Key Details: - The candidate should be competent in solo, band, and collaborative performances. - The performance duration sought is 2-3 hours. - The musical genre is strictly classical. Ideal Skills and Experience: - Extensive experience in classical music - Adept at solo and group performances - Prior experience in sizable concerts/events - Strong collaborative abilities - Stamina to perform for 2-3 hours. This is an excellent opportunity to showcase your talent on global platforms. Talented classical artists, please place your bids. Your existing portfolio would be highly appreciated.

I'm looking for an artist who can perfectly capture my traditional-style home in a pencil sketch. I want a real sense of warmth and welcome to exude from the piece, with my family of 3 or more people included...welcome to exude from the piece, with my family of 3 or more people included on the front porch. Ideal Skills and Experience: - Expertise in pencil sketching - Experience in architectural drawings, particularly traditional-style homes - Ability to sketch people with realistic detailing and proportions Your task would involve: - Creating a pencil sketch of a traditional-style house - Including a group of 3 or more people in the sketch, placed on the front porch - Capturing our home's unique qualities and charm Anyone interested in creating this custom piece ple...

I am in need of a professional website designer to create a website for our new company, Econo Group. The primary goal of the website is to generate leads for our services in plumbing and pressure cleaning and excavation. Key Features: - Service Descriptions: The website should clearly outline the range of services we offer in plumbing and pressure cleaning and excavation. It's important that potential customers understand the quality and scope of our services. - Before and After Photos: We would like to include a gallery of before and after photos showcasing the outcomes of our services. These images should be prominently displayed in a way that highlights the effectiveness of our work. - Contact Information: It's essential that users can easily find our contact inform...

...Overview Premier Property Group is launching a contest to find a highly skilled and creative consultant to develop a complete brand identity for our new subsidiary. This contest will involve the creation of a new company name and logo. We aim to establish a distinct and memorable brand image that aligns with our vision and values while differentiating the subsidiary from the parent company. PLEASE READ!!!! We are looking for a company name and logo for the new subsidiary. Not a logo for Premier Property Group. We need a new company name and logo for the subsidiary Premier Property Group builds single-family and multi-family homes in the United States, primarily in the Southeast region. The market is characterized by growing demand for affordable yet qualit...

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

I'm seeking a skilled social media marketer to promote my product, with an emphasis on generating sales leads. Our brand is "life wild foods". "Organic" superfoods we have the rainbow, Oriental Green, Mediterranean Reds, Rainforest Amber. Key Tasks: -...to 40. - Use social media platforms, including TikTok, to drive engagement and eventually lead generation. Ideal Skills: - Proven experience in social media marketing, especially with a focus on lead generation. - Deep understanding of the nuances of different social media platforms, particularly TikTok. - Proficient in market research and audience targeting, especially for the specified age group. I am looking for an individual who can deliver a comprehensive marketing strategy and execute it through...

...interest and fun for the children. - Interactive Icons: The menu should include interactive icons, encouraging young users to explore and interact with different elements. Style: - The overall theme of the menu should be childlike and engaging. The design should be simple, playful, and easy to navigate. - The game is targeted at a very young age group (3-5 years old). The menu design should, therefore, be appropriate and appealing to this age group. Ideal Skills: - Proficiency in Unity and C# for mobile game development - Prior experience in designing UI for children's games - Ability to create engaging, colorful, and interactive UI elements - Understanding of the specific needs and preferences of a 3-5 years old audience. Looking forward to seeing your portfolio...

I need you to create a 3D model of a bumper I created in Photoshop for a personal project. The bumper should match the shape of the car. I‘ll provide the 3D model for the car and the picture of the design to help you creating the 3D model. Little modification may be possible as we see the finished result like the depth of the bumper and diffusor. I am well aware to not exaggerate with extra wishes as I want to stay respectful to your time. Thank you

...a paid sponsor. Also need help on strategy. Such as what to include in pitch deck and best approach when contacting companies. Event Location: New York Hosted by: The page is a social media account that posts popular millennial Black culture memes, quotes, funny videos. Recap video of party will be displayed on the IG account & will include coverage/product placement of sponsors. Here is an example of last years party recap video: Party will be in same location, and similar vibe. The crowd will consist of young black millennial socialites, ages 25-40. In the group will be creators, influencers, black professionals. I'm not sure what type of brands to attempt to involve. But my initial thoughts are... A speaker Brand. JBL

I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.

I am looking for a mobile app that will serve as a central communication hub for my large family. Key Features: - Messaging: The app should support both individual and group messaging. It should be intuitive and easy to use, as we have family members of all ages. - Video Calls: Though I didn't select this as my top priority, video calls are important to us. We often have family members who live far away and we want to be able to connect visually. Other Requirements: - The app should be lightweight and user-friendly, as not all family members are tech-savvy. - It should have a secure login system to protect our privacy. - As we are a large family, it's important that the app can handle a substantial number of users. Ideal Freelancer: - Proven experience in developing an...

As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - Develop a feat...

I'm looking for a skilled web developer who can assist in updating my landing page. The main goal of this page is to attract and collect information from young adults, so it's crucial that the design is appealing and user-friendly for this demographic group. Key Tasks: - Update the layout: The current layout needs a refresh to make it more engaging and intuitive. - Change the color scheme: A new color palette is needed to better resonate with the target audience. - Add new content: The page needs additional content to better inform and engage young adult users. Ideal Skills and Experience: - Proficient in web development - UI/UX design experience - Understanding of young adult preferences - Strong communication skills - Ability to work collaboratively - Previous expe...

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

I'm looking to partner with an experienced social media marketer to execute a paid media campaign on Facebook and Instagram. The campaign will primarily: - Focus on increasing brand awareness and gener...and Instagram. The campaign will primarily: - Focus on increasing brand awareness and generating leads - Target an audience comprising of individuals aged between 25 to 44 years The ideal candidate for this job should possess: - Proven experience in crafting and executing paid media promotions on Facebook and Instagram - A solid understanding of identifying and reaching out to the target age group effectively - Innovative strategies to increase brand visibility and generate quality leads Please share relevant past work examples and strategies you think will work best fo...

Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project...

I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI

I'm in need of a talented marketer who can develop a comprehensive strategy aimed at enhancing brand awareness. The project i...creative flair and an analytical mindset. Key details: - Task: - The primary task for this project entails developing a robust marketing strategy. - The focus of the strategy should be on increasing our brand's visibility within the professional demographic (aged between 25-40). - Goal: - The end goal of this strategy is to significantly boost our brand awareness within the target age group. - Skills Needed: - Proficient in marketing strategy development. - Previous experience with brand awareness campaigns. - Understanding of the professional demographic's tastes and behaviors. - A proven track record of successful, innovat...

We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, ...

I'm looking ...explainer video specifically catered towards business professionals. Key Requirements: - Length: The explainer video should be precisely 1 minute. - Animation Style: The video should be a 2D animation. - Target Audience: It is crucial that the content of the video is tailored for a business professional audience. The content should be informative, engaging, and align with the expectations of this group. Ideal Skills & Experience: - Proven experience in creating 2D animations, preferably for a business audience. - Ability to distill complex ideas into clear, concise, and visually appealing content. - Strong understanding of storytelling and pacing to keep the audience engaged. - Excellent communication skills to understand my vision and deliver the desired m...

I'm seeking a Google Ads expert to help me run a campaign to generate leads from the professional segment (ages 25-54) on an international scale. Key Responsibilities: - Create and manage the Google Ads campaign with a focus on lead generation. - Tailor the campaign to cater specifically to professionals in the 25-54 age group. - Utilize a strategic approach to ensure the campaign's success in an international context. Ideal Skills and Experience: - Proven track record in Google Ads campaign management, particularly in lead generation. - In-depth understanding of targeting strategies for different demographics, with a specific focus on professionals. - Experience in managing international campaigns and adjusting them to suit different markets is desirable. This projec...

I'm looking to develop a comprehensive and engaging trainer program geared towards advanced-level participants, focusing on training skills Key Requirements: - Free Training program by Malaysian Government for those who have started working from 1st January 2024 -Self employed and freelancers are welcomed! - The program will be delivered through a mix of online modules and in-person workshops. You should be able to structure the content to be engaging and effective in both formats. - Leadership Training: The main focus of this program will be training in leadership skills. Your experience in leadership development and training is essential. Ideal Skills and Experience: - Proven experience in creating and delivering leadership training programs - Expertise in structuring and...

...receive HTTP POST requests containing specific data. Extract relevant details from the POST request body to initiate alert notifications. Azure Alert Integration: Integrate with Azure Monitoring to create alert rules based on the received data. Configure alert thresholds and conditions according to project requirements. Voice Call Notification Action: Implement a voice call notification action group within Azure. Configure the system to trigger voice calls as part of alert notifications. Message Playback: Capture the body details from the HTTP POST request. Play back these details during the voice call notification. User Interface (Optional): Develop a user-friendly interface to submit data for alert notifications. Provide feedback on the status of alert creation and voice ca...

I'm looking to integrate artificial intelligence into the marketing strategy of my fitness studio. The primary objective of this campaign is to boost membership sign-ups. The strategy should be versatile enough to engage our main target group, working professionals. Key Requirements: 1. Development and execution of AI-driven marketing campaigns across multiple platforms. 2. Marketing should be all-inclusive covering social media, email, and search engine optimization. Ideal Candidate Qualifications: 1. Proven experience in implementing AI-driven marketing campaigns. 2. A deep understanding of working professionals' needs within the fitness sector. 3. Demonstrated proficiency with Social Media Marketing, Email Marketing, and Search Engine Optimization. Your task will...

I'm looking to have a chat feature added to my online tutoring platform to facilitate both one-on-one and group conversations between tutors and students. The primary purpose of this chat function is for instant messaging. Key Features Needed: - Instant Messaging: A real-time chat functionality that allows tutors and students to communicate seamlessly. - Group Conversations: The chat should support group conversations as well as one-on-one chats. - Message Read Receipts: The ability for users to know if their message has been read by the recipient. - Typing Indicators: This feature will show when the other person is typing to enhance real-time communication. - Offline Messaging Capability: The chat should allow users to send messages even when the recipien...

I'm in need of seasoned Red Hat Certified & Licensed Trainers to conduct training on Linux Administration, Networking and Security. The ideal candidate would have a depth of knowledge in these areas and be able to effectively deliver this information to a diverse group of learners. Key responsibilities will include: - Structuring and delivering engaging, interactive training sessions on Linux Administration, Networking and Security. - Conducting practical exercises to reinforce learning and ensure understanding of the concepts. - Providing clear and concise explanations of complex technical information. - Adapting the course content to suit a hybrid (Combination of In-person and Online) delivery format. Skills and Experience required: - Red Hat Certified Engineer (RHCE) ...

I am in need of an online business advertiser to target young adults for my service-based enterprise. Although I did not specify tasks in the beginning, versatility in the following areas is desirable: - Social Media Marketing: Leveraging platforms popular among young adults would be instrumental. Experience creating engaging content that resonates with this age group would be beneficial. - Search Engine Optimization: Enhancing the visibility of my online business on search engines for relevant queries is a must. Proficiency in keyword research and optimization is expected. - Email Marketing: Designing, implementing, and analyzing email campaigns targeted at young adults is a task that could vastly impact the project's success. The ideal freelancer should have a proven track ...

Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...

I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.

Please Sign Up or Login to see details.

I need a creative genius to design a full brand identity for my brand. Envision a design that resonates with the concept of 'creativity', infusing the following core elements: - Logo design: Create an innovative and creative logo that stands out. - Color palette: Develop a unique color scheme, portraying creativity. - Typography: Deliver distinctive typography that breathes life into the brand. - Social Media: Assist in the adaptation of these designs for various social media platforms. The perfect freelancer for this task possesses a knack for creativity with a proven track record in brand design. Experience with designing for social media will be a plus. Please note, examples of successful previous work will be highly regarded during the selection process. Let's create s...

...could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can import and work with to make these changes. Simply import these folders in the zip to WP Local, which can be downloaded at or use any other software you choose. The maximum deadline where all files should be handed back by is Friday 24th May 2024 at 23:59 BST....

I am looking for a creative and engaging PowerPoint presentation (5-6 slides) for Year 1 kids, aged 5-6 years old. This project revolves around the theme "Keeping ourselves fit and healthy". It should cover key aspects of personal health: - Exercise and Physical Activity: Illustrate the benefits and types of physical activities suitable for this age group. Showcase how these activities can be fun and engaging. - Healthy Eating: Discuss various food groups, their importance, and how they contribute towards maintaining fitness and health. - should be more visual and less text so making it easy for the kid to present. Ideal Skills: - Experience in creating child-friendly educational content - Understanding of health & fitness topics for kids - Excellent PowerPoint ski...

I'm seeking a skilled graphic designer with experience in creating engaging Facebook ads graphic showing a tall skinny man stepping over a shorter chubby "middleman" to reach a group of people representing their ideal customers Key points: - Objective: The graphic should show the business owner who is a contractor or home service provider. Stepping over Angie list...which is a third party lead seller. And reaching their ideal clients with their hand reaching out as if to shake the hands of the the customers. We are offer to build a marketing system that they own so they can eliminate the middleman...."Angie List"

We would like to arrange complaints in such an order that a facebook group would be closed. either by complaints or by posting non-compliance posts

I need a skilled copywriter who can create an engaging email to drive up attendance and engagement for an upcoming active sports event. - Target Audience: The email will be sent to our current customers, so it's crucial that the copy resonates with this specific group. - Desired Actions: The email should encourage recipients to share the event on social media, refer a friend to attend, and ultimately purchase a ticket. Content should be about the event - a skiing and snowboarding Expo and Giant $5 million equipment, clothing and accessory sale. The candidate will he hired for 12= emails all with different copy. Ideal candidates should have a keen understanding of persuasive copywriting and the ability to tailor messages to specific audiences. Experience in event promot...

...speech recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...

...Responsibilities: - Create, manage and optimize ad campaigns to increase sales on my eCommerce store. - Tailor the ads for platforms such as Facebook/Instagram, Google, and TikTok. - Identify and target the right audience within the 25-44 age group. Ideal Skills and Experience: - Proven track record in managing eCommerce ads, with a focus on increasing sales. - In-depth knowledge and hands-on experience with Facebook/Instagram, Google, and TikTok advertising platforms. - Understanding of audience segmentation and targeting, particularly for the 25-44 age group. - Strong analytical skills to monitor and optimize ad performance. - Experience in the eCommerce sector is a plus. If you have a solid background in eCommerce ads, a keen eye for detail, and a strategic approach t...

...inheritance disputes. Key Requirements: - Experience with running lead generation campaigns on Facebook - Familiarity with the legal industry, particularly family law - Proven track record of successful lead generation in the services sector Target Audience: - People in need of family law services, particularly those dealing with divorce, child custody, alimony, adoption, or inheritance disputes - Age group: Advocacia na área de Família: divórcios, pensões, guarda de filhos etc. Your responsibilities include: - Developing a comprehensive Facebook Ads campaign with a focus on generating high-quality leads - Regularly monitoring the performance of the ads and optimizing them for better results - Providing detailed reports on the progress and effecti...

...cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on the job. Single or multiple employees may work on one job with the ability to add 'batch...

...young adults, and I need an advertisement expert to help me create an engaging product promotion ad that's focused on lifestyle. The main goal is to generate interest and drive sales among the 18-24 age group. Key Responsibilities: - Creating a product promotion ad for a T-Shirt startup. - Ensuring the advertisement is lifestyle-focused, appealing to the target audience. Skills and Experience: - Proven track record in creating successful product promotion advertisements. - Strong understanding of Instagram and Facebook advertising. - Experience in targeting and engaging with the 18-24 age group. - Must have a creative eye for lifestyle-focused content. - Ideal if you have experience in working with startup brands. I am looking for someone who can bring their expe...