Social Networking Projects

Complete mktg strategy n implementation 2 get + clients

I am an Attorney in Law, and I also offer IT and AI-based automation solutions for people and businesses. I need a freelancer to design a clear marketing strategy and also execute it to help me attract qualified clients. The key tasks include: • Analyzing my current online presence (Facebook groups, social media, freelance platforms). • Defining my ideal client profiles and main value propositions. • Creating a simple, practical marketing plan focused on lead generation from Facebook groups and other organic channels (no expensive courses or memberships). • Setting up and testing outreach messages, follow-up sequences and basic tracking of results. Deliverables: • Written strategy document (2–4 pages) with channels, key messages and steps to follow. • Templates for posts and messages I can use in Spanish and English. • Initial implementation of the plan over an agreed period (for example 2–4 weeks), with a short report of what worked and what should be improved. I am looking for someone who has real experience in client acquisition for professional services (law, consulting, or similar), is comfortable working with Facebook groups, and can explain the strategy in simple terms. Spanish is a plus. my webpage https://gutierrezconsultores.base44.app

opportunity

Content Automation Dashboard for Existing Algorithm (BIG AL)

I'm looking for an experienced full-stack developer to build Stage 2 of my platform. I already have a working algorithm called Big AL that selects products for TikTok Lives and tracks analytics such as popularity, demand, sales history, conversion rates and live scheduling. I'm not looking to rebuild the algorithm. Instead, I need a developer to build a Content Engine and Approval Dashboard that reads Big AL's data and automatically generates branded social media content. The system should: Connect to an existing algorithm (API/Database/JSON) Read product selections and analytics Populate reusable templates automatically Generate graphics and short animated content Display everything in an approval dashboard Allow simple editing before export Export ready-to-use assets for TikTok, Instagram and my website This is intended to be the foundation of a larger content automation platform, so I'm looking for someone who enjoys designing scalable systems. A full project specification (PDF) is attached. Please include in your proposal: Similar projects you've completed Technologies you'd recommend Estimated timeline Estimated cost Suggestions for improving the architecture Long-term work is available for the right developer. "The existing algorithm developer is available for technical collaboration where required, so this project will involve integrating with an existing system rather than starting from scratch." - full design spec will be given to the right candidate. "How many hours do you think it would take to expose Big AL's data through an API or JSON feed so another application can consume it?" Please give a brief of your understanding, experience and how you would build it? If your interested please read the PDF and designs ideas.

opportunity

PR & Media Outreach Specialist Required for MAI Awards 2026

We are looking for an experienced UK PR and Media Outreach Specialist to build national awareness, credibility, and engagement for MAI Awards 2026. ## About MAI Awards 2026 MAI Awards 2026 is a nationwide campaign celebrating the people, businesses, craftsmanship, innovation, and rising talent behind the UK stone, worktop, kitchen, surface, and construction industries. We plan to travel across England and Wales, visiting fabricators, suppliers, workshops, showrooms, and industry professionals. The campaign will include interviews, factory visits, business stories, project case studies, videos, social media features, nominations, public voting, sponsor partnerships, and a final documentary. Our aim is to make MAI Awards 2026 a recognised national industry campaign. ## What We Want PR to Achieve We want PR to help us: * Build national awareness * Secure relevant UK media coverage * Increase nominations and public voting * Attract sponsors and industry partners * Increase website traffic and social media followers * Strengthen the credibility of MAI * Increase trader, fabricator, and supplier registrations * Generate genuine customer and business enquiries ## Target Media We are interested in: * National, regional, and local UK media * Construction and building publications * Stone, surface, kitchen, and bathroom media * Architecture and interior design publications * Manufacturing and engineering media * Business, technology, and AI publications * Trade magazines, podcasts, radio, and online news platforms ## Responsibilities The selected specialist will: * Develop a clear PR strategy * Identify relevant journalists, editors, podcasts, and publications * Build a targeted UK media database * Write press releases and personalised media pitches * Pitch award, founder, business, regional, and industry stories * Secure interviews, features, mentions, and media coverage * Create regional PR opportunities around business visits * Promote nominations and public voting * Create PR opportunities for sponsors * Identify podcast, radio, webinar, and speaking opportunities * Follow up with journalists and editors * Track outreach, responses, backlinks, and coverage * Provide regular reports and recommendations ## Possible Story Angles * MAI travelling across England and Wales to document the UK stone industry * The people behind Britain’s kitchens, worktops, and interiors * Family-run businesses and regional success stories * Rising stars, apprentices, and women in the industry * Innovation in fabrication, installation, and design * AI supporting the construction industry * Sustainability and responsible material use * Local businesses gaining national recognition ## Expected Deliverables Please explain what you can deliver each month, including: * PR strategy * Media database * Press releases * Personalised media pitches * National, trade, regional, podcast, and radio outreach * Journalist follow-ups * Coverage tracking * Monthly report Performance will be measured by: * Journalist responses * Interviews secured * Articles and features published * Trade and regional coverage * Podcast or radio appearances * Quality backlinks * Website traffic * Nominations and votes * Sponsor enquiries * New followers * Business registrations * Genuine customer enquiries ## When Applying, Please Include * Examples of successful PR campaigns * Media coverage you have secured * Experience with UK journalists and publications * Relevant experience in construction, manufacturing, interiors, technology, awards, or business PR * Your proposed strategy for MAI Awards 2026 * Your monthly deliverables and fee * Your expected timeline for securing initial coverage * How you measure PR performance * Any existing UK media relationships Please do not send a generic proposal. We are looking for a proactive PR partner who can generate genuine credibility, media coverage, nominations, followers, sponsor interest, website traffic, registrations, and enquiries. This is a long-term opportunity for the right freelancer who can demonstrate measurable results.

Community Marketing & Brand Growth Specialist (Skincare)

Overview I'm launching a skincare brand and am looking for an experienced freelance marketer who specializes in community-based marketing and organic customer acquisition. The goal is to build awareness, drive qualified traffic, and generate sales through authentic engagement in online communities. Responsibilities Identify relevant Facebook groups, Reddit communities, forums, and other skincare-related communities. Participate in discussions by providing helpful, informative, and valuable responses. Recommend our products only when appropriate and in accordance with each community's rules. Create engaging posts that educate and spark discussion. Develop strategies for increasing brand awareness organically. Suggest opportunities for influencer partnerships and community collaborations. Track traffic, engagement, and conversions from each marketing channel. Provide weekly reports outlining activities, results, and recommendations. Requirements Proven experience marketing skincare, beauty, health, or wellness brands. Strong written English. Familiarity with Facebook Groups, Reddit, Instagram, TikTok, and other social platforms. Understanding of community guidelines and ethical marketing practices. Ability to create engaging, educational content rather than promotional spam. Experience with Shopify or ecommerce brands is a plus. Deliverables Community research and outreach plan. Weekly activity reports. Content ideas and posting schedule. Recommendations for improving conversion and customer engagement. Monthly growth strategy. Success Metrics Qualified website traffic. Community engagement. Email subscribers. Sales generated. Customer acquisition cost. Return on marketing investment.

Weight loss Pill Leaflet

We are looking for an experienced graphic designer with healthcare or pharmacy marketing experience to create a premium, engaging, and professionally designed A4 leaflet promoting our UK online weight loss treatment service. The leaflet should have a modern, trustworthy, and clinical feel while remaining visually striking and easy to read. The objective is to encourage eligible patients to complete an online consultation through 123meds.com. Our branding assets (logo, colour palette and design inspiration) are attached and must be incorporated throughout the design. Deliverables A5 leaflet = A3 poster Print-ready PDF (300dpi with bleed) Editable Canva file Editable Adobe Illustrator or InDesign source file (preferred) All fonts and linked assets used Branding Requirements The design must: Use the supplied 123meds.com logo. Follow the attached brand colour scheme. Maintain a clean, premium healthcare aesthetic. Be consistent with our existing branding. Use modern typography and clear visual hierarchy. Target Audience Adults in the UK who may be eligible for prescription weight loss treatment and are looking for a trusted online pharmacy. The design should inspire confidence, professionalism and accessibility. Design Style We are looking for something similar in quality to leading UK online pharmacy and private healthcare marketing materials. We are looking for a designer who can combine strong visual creativity with healthcare professionalism to produce a leaflet that is both engaging and compliant. Examples of similar healthcare or pharmacy marketing work. Estimated turnaround time. Number of revision rounds included. We are looking to establish a long-term relationship with a designer for future marketing materials, including brochures, posters, social media graphics, digital adverts and patient information leaflets.

opportunity

Adult Creator Lead Researcher for Direct Fan Messaging App

We are looking for a creator outreach / lead research specialist to help us find adult-friendly content creators for a new direct fan messaging app. The app is built for creators who want to communicate directly with their fans, monetize private conversations, and keep more control over their audience — without fans feeling like they are talking to an agency, bot, or fake operator. We are looking for creators from platforms and communities such as: * OnlyFans * Fansly * Fanvue * Webcam creator communities * Instagram * X/Twitter * TikTok * Reddit creator communities * Link-in-bio creator profiles * Adult-friendly influencer communities Your main task will be to find qualified creators and build a clear lead list. For each creator, we need: * Creator name / handle * Country or language if visible * Platform links * Main social profile * Contact method * Follower count if available * Creator type: OnlyFans, Fansly, webcam, Instagram, etc. * Notes on why they could be a good fit * Whether they seem suitable for direct fan messaging You may also help with outreach using our approved message, but the first priority is high-quality research and lead generation. Important rules: * Only 18+ creators. * No minors or questionable accounts. * No scraping private information. * No fake reviews. * No spam. * No misleading messages. * No pretending to be an independent user. * Respect the rules of every platform, subreddit, group, and community. Ideal candidate: * Experience with influencer research, creator outreach, adult creator recruitment, webcam creator research, or social media lead generation * Comfortable working around adult/NSFW creator communities * Good English * Able to work independently * Able to provide clean daily updates in a spreadsheet * Knowledge of OnlyFans, Fansly, webcam, Reddit, X/Twitter, Instagram, TikTok, Telegram, Discord, or Facebook creator groups is a plus First test milestone: Please quote your price for: * 100 qualified creator leads * 20 relevant communities, groups, forums, or subreddits where creators can be found or researched * 20 manually contacted creators using our approved outreach message * A short report explaining which markets look most promising and why When applying, please answer: 1. Have you done creator or influencer outreach before? 2. Have you worked with adult/NSFW creators before? 3. Which platforms would you use to find creators? 4. Which markets do you know best? USA/UK, Latin America, Romania/Eastern Europe, or other? 5. How many qualified creator leads can you find per day? 6. Can you contact creators manually and track everything in a spreadsheet? 7. Do you understand that we do not want spam, fake reviews, fake testimonials, or rule-breaking outreach? 8. What is your price for the first test milestone?

SLR Screening Assistant Needed (Media/Linguistics PhD)

I'm a PhD candidate conducting a systematic literature review as part of my doctoral thesis, in Critical Discourse Analysis of English-language online news reporting. I'm looking for a freelancer to support the mechanical/administrative side of the SLR process. This is NOT a request to write or synthesise the literature review. All inclusion/exclusion decisions, quality appraisal, and synthesis are done by me. Tasks include: Running literature searches across specified databases (Scopus, Web of Science, Google Scholar and Elicit) using search strings I provide Exporting and organising search results into a shared spreadsheet Logging hit counts per database/string for PRISMA reporting Extracting basic bibliographic and methodological details from articles into a template I provide (author, year, method, findings summary) Applying my stated inclusion/exclusion criteria to flag candidates for my review (final decisions remain mine) Ideal candidate: Experience with systematic reviews or PRISMA methodology preferred Familiarity with Critical Discourse Analysis or discourse-based methods is a plus but not essential Comfortable reading academic abstracts in media/communication studies or applied linguistics Comfortable working from detailed instructions and templates Strong attention to detail and organisation Background in social sciences, media studies, or linguistics welcome but not required What I will provide: Search strings and database list Inclusion/exclusion criteria Quality appraisal template Data extraction template Timeline: 3–4 weeks from start date, with a brief check-in at the halfway point.

Shopify development page

Shopify Development Brief – Ambassador Programme Redesign Project Overview I would like to redesign my existing Shopify Ambassador Programme to increase conversions and reduce abandoned checkouts. Currently, customers choose 4 free jewellery pieces and only discover the shipping charge at checkout. This results in a high number of abandoned carts. The new system should remove the separate shipping charge and instead sell an "Ambassador Starter Pack" with free shipping included. --- Current Process Current customer journey: 1. Customer visits Ambassador page. 2. Chooses 4 free jewellery items. 3. Goes to checkout. 4. Shipping fee is added (currently around $57). 5. Many customers abandon checkout. --- New Customer Journey Instead of offering free jewellery plus shipping, I want customers to purchase an Ambassador Pack. Example: Starter Pack Price: $39.99 Includes: - Choose any 2 jewellery pieces - Free worldwide tracked shipping - Ambassador account - Personal discount code - 25% commission - Ambassador welcome information Shipping at checkout should display as FREE. --- Premium Pack (Most Popular) Price: $56 Includes: - Choose any 4 jewellery pieces - Free tracked shipping - Ambassador account - 25% commission - Featured on social media --- VIP Pack Price: $69 Includes: - Choose any 6 jewellery pieces - Premium gift box - Faster shipping - VIP Ambassador badge - Priority support --- Required Functionality I would like the entire process to be automated. After purchasing an Ambassador Pack, the customer should be able to receive the correct number of jewellery items included in their chosen package. Examples: Starter Pack → choose any 2 items from the Ambassador Collection Premium Pack → choose any 4 items VIP Pack → choose any 6 items The customer should not pay separately for these items. --- Shopify Requirements Please recommend the best way to achieve this. Possible options include: - Shopify Functions - Shopify Scripts (if applicable) - Shopify apps - Custom Shopify app - Cart validation - Automatic discounts - Bundle app - Shopify Flow I am open to whichever solution is the most reliable. --- Important Requirements ✔ Shipping should always show as FREE. ✔ Customers should feel they are purchasing an Ambassador Starter Pack rather than paying for shipping. ✔ The process should require as little manual work as possible. ✔ The system should work automatically after payment. ✔ It must be easy for me to change prices or create new Ambassador Packs in the future. --- Additional Questions Please provide: - Recommended implementation method - Estimated cost - Estimated development time - Any Shopify apps required - Ongoing monthly costs (if any) I am looking for a clean, scalable solution that improves conversion rates and reduces abandoned checkouts.

Creative Video Editor Needed – Vertical Drama Edit /Teasers

We are looking for a talented and passionate editor to transform a professionally filmed sample episode from an independent, dream-like romantic TV show into a 90-second vertical drama teaser. The goal is to create two different versions of a vertical reel with strong film trailer vibes- something that instantly hooks viewers and leaves them wanting more. I'll provide the full-length sample episode, and I'm looking for someone with exceptional cinematic editing skills, a great sense of pacing, and a creative eye for storytelling. Experience with vertical drama editing is a big plus, but not essential if your portfolio demonstrates originality and high-quality work. The edit should go beyond simple cutting. I'm looking for someone who can elevate the footage with creative motion graphics, stylish visual effects, AI-assisted tools where appropriate, animated typography, and other cinematic enhancements to create a premium, eye-catching result. This is a fun project with plenty of creative freedom. The story is playful, romantic, and visually cinematic, so there's lots of potential to craft something truly engaging. I'm looking for someone who understands how to create curiosity, emotion, and a compelling hook within the first few seconds. If you're passionate about creating eye-catching, cinematic social content and think you'd enjoy bringing this project to life, I'd love to see your portfolio and hear from you!

opportunity

Spanish or Romanian Speaking Creator Outreach Specialist

We are looking for a Spanish, Portuguese, Romanian, or Eastern European creator outreach specialist to help us find adult-friendly content creators for a new direct fan messaging app. The app helps creators monetize direct fan conversations, manage private fan communication, and keep more control over their audience. We are especially interested in creators from: - Latin America - Romania - Eastern Europe - Spain - Portugal - Brazil - Colombia - Mexico - Argentina - Webcam creator communities - OnlyFans / Fansly / Fanvue creator communities - Instagram, TikTok, X/Twitter creator communities You do not need to cover every market. If you are strong in one specific region, please tell us which one. Main tasks: 1. Find qualified creators Search for adult-friendly creators who may be interested in a direct fan messaging app. 2. Build a lead list For each creator, we need: - Creator name / handle - Country or language - Main platform links - Social media links - Contact method - Follower count if available - Creator type: OnlyFans, Fansly, Fanvue, webcam, Instagram, TikTok, etc. - Notes on why they could be a good fit - Whether they are suitable for direct fan messaging 3. Outreach You may also help us contact creators manually using our approved message. 4. Market research Tell us which regions, platforms, and communities look most promising and why. First test milestone: Please quote your price for: - 100 qualified creator leads - 20 relevant creator communities, forums, groups, or platforms - 20 manually contacted creators using our approved message - A short report explaining which market looks strongest and why Important rules: - Only 18+ creators. - No minors or questionable accounts. - No spam. - No fake reviews. - No fake testimonials. - No misleading messages. - No pretending to be an independent user. - Respect every platform, subreddit, group, and community rule. - Track everything clearly in a spreadsheet. Ideal candidate: - Experience with creator outreach, influencer outreach, adult creator research, webcam creator research, or social media lead generation - Comfortable working around adult/NSFW creator communities - Strong knowledge of at least one of these markets: Latin America, Romania, Eastern Europe, Spain, Portugal, or Brazil - Spanish, Portuguese, Romanian, or Eastern European language skills are a strong plus - Able to work independently and provide daily updates When applying, please answer: 1. Which market do you know best? 2. Which languages do you speak? 3. Have you worked with adult/NSFW creators before? 4. Have you done creator or influencer outreach before? 5. Which platforms would you use to find creators? 6. How many qualified creator leads can you find per day? 7. Can you contact creators manually and track everything in a spreadsheet? 8. Do you understand that we do not want spam, fake reviews, fake testimonials, or rule-breaking outreach? 9. What is your price for the first test milestone?

Lead Researcher — Verified Cross-Border Service Providers

Hi — thank you for your interest. We operate a curated trust platform that helps people find verified services across borders. We need an experienced web researcher to source and verify 100 service providers that serve specific diaspora corridors. What you will do: Identify real businesses in the following categories serving UK ↔ Nigeria or UAE ↔ India corridors: Logistics & Shipping Real Estate / Property Legal / Immigration Financial / Money Transfer Relocation / Removals Business Setup / Consulting Fill our tracking spreadsheet with accurate business data. Verify each business using at least two independent signals (e.g., official registry, active website, public social media, press mention, listed phone answered by the business). Please review the attached specification before sending a proposal. It covers scope (100 verified cross-border listings in one corridor), the 12 required columns, the 3-signal verification standard, and the checkpoint structure. To be considered, please reply with: Two sample rows from a corridor of your choice (UK↔NG, UAE↔IN, or US↔NG), filled to the spec. Your preferred corridor for the full 100. Your turnaround time. Proposals without sample rows won't be reviewed. Sample rows that use templated or undated verification text will be declined.

Edit 6 Real Estate Videos

I am looking for an experienced video editor to edit 6 real estate videos, each around 90 seconds long. SAMPLE VIDEO https://www.facebook.com/reel/1290158776540805 This is a paid test project. If the work is a good fit, this can turn into consistent weekly editing work for the same type of real estate videos. All assets will be provided, including: Raw video footage Music/song Graphics Storyboard Any notes or brand direction needed The project will be managed through Frame.io, where the footage and assets will be uploaded. I will provide feedback there as well. I expect 1 round of revisions after the first draft is delivered. What I Need Each video should be edited in a clean, polished real estate style, with good pacing, smooth transitions, music timing, and attention to detail. The final videos should feel professional and ready to post online. Deliverables 6 edited real estate videos Each video approximately 90 seconds long Final export in high-quality MP4 format 1 round of revisions included Final delivery required within 48 hours of receiving all assets Ideal Candidate I am looking for someone who: Has experience editing real estate, property, lifestyle, or social media videos Can follow a storyboard and brand direction Works well with Frame.io Can deliver on time Communicates clearly Is interested in ongoing weekly work if the test project goes well To Apply Please send: Examples of similar real estate or property videos you have edited Your availability for a 48-hour turnaround Your fixed price for editing all 6 videos Confirmation that 1 round of revisions is included Looking forward to finding someone reliable for ongoing weekly work.

opportunity

Linkedin Content Strategist & Daily Engagement Partner

I’m the Retail Director at a UK-based freight forwarding company. I want to build a strong, authentic personal brand on LinkedIn in the freight, logistics and supply chain space — with a particular focus on retail sector challenges and solutions. My goals: • Become a recognised voice and thought leader • Grow my follower base with the right people (retailers, supply chain/procurement professionals, logistics peers, decision-makers) • Increase meaningful engagement and inbound opportunities • Stay super active and visible in a smart, sustainable way I already create my own posts and graphics. I’m looking for a strategic partner who will guide the “what” and “when”, while also handling the heavy lifting on daily engagement. What you’ll be responsible for: 1. Content Strategy & Storyboarding Develop clear content pillars tailored to a Retail Director in freight forwarding. Create weekly/bi-weekly content calendars with post ideas, recommended formats (carousels, text, polls, short video, documents, etc.), strong hooks, and calls-to-action. Provide outlines or suggested copy (I will write the final versions and create all graphics). 2. Posting Schedule & Activations Recommend the best days/times for a UK B2B audience in 2026. Advise on LinkedIn algorithm best practices, what “activations” actually move the needle (polls, carousels, series, commenting strategies, etc.), and how to maximise reach and engagement. 3. Daily Niche Engagement (core part of the role) Thoughtfully comment on 20–50 relevant LinkedIn posts per day in the freight, logistics, supply chain, retail, and import/export space. Comments must be high-quality, value-adding and non-spammy (sharing insights, asking smart questions, adding perspective). This is manual work only. The goal is visibility, relationship-building and algorithm love. You’ll report on activity and results. 4. Follower Growth & Overall Strategy Give ongoing advice on profile optimisation, networking, content repurposing, and how to best use my current Botdog automation tool alongside organic activity. Help me market myself effectively and accelerate follower growth in a compliant way. 5. Reporting & Collaboration Weekly or fortnightly check-ins (Zoom or async) to review LinkedIn analytics, discuss what’s working, refine the strategy, and plan ahead. Track progress against clear KPIs (follower growth, engagement, profile views, quality of comments, etc.). What I will handle: • Writing and publishing all final posts + creating graphics • Day-to-day posting on my profile • Giving you any sector-specific insights you need Ideal freelancer: • Proven experience helping B2B executives or professionals grow their LinkedIn presence through content strategy + daily engagement (please share real results or case studies). • Strong understanding of current LinkedIn best practices (2026 algorithm, personal branding, what actually works for B2B service/industry profiles). • Excellent at crafting professional yet conversational B2B content ideas — especially in freight, logistics, supply chain or retail (prior experience in these sectors is a big plus). • Reliable and disciplined with daily engagement work. You enjoy being active on LinkedIn and know how to comment in a way that builds genuine connections. • Comfortable working with or advising on tools like Botdog. • UK/EU timezone preferred (or very flexible). • 100% committed to staying within LinkedIn’s Terms of Service (manual, high-quality commenting only — no automation for comments). How we’ll work: This is an ongoing role. I’d like to start with a 4-week trial, then move to a monthly retainer if it’s a good fit. Please include in your proposal: • Why you’re the right person for this (and any relevant niche experience) • Your approach to daily commenting (include 2–3 examples of strong vs weak comments in a B2B context) • 3–5 suggested content pillar/theme ideas specifically for a Retail Director in freight forwarding • A sample 1-week content idea list (5–7 post concepts) • Your proposed weekly time commitment and rate (hourly or monthly package) • Links to relevant work, portfolio, or your own LinkedIn profile so I can see your style and results Indicative budget: £800 – £1,100 per month (depending on experience, hours and results). Quality and reliability are more important than the lowest price. Realistic proposals welcome. I’m looking for a long-term partner who is proactive, strategic, and excited about helping me become consistently visible and valuable on LinkedIn. Looking forward to your proposals

Micro Influencer Outreach

# Freelance Creator Outreach & Community Manager (EU Skincare Brand) ## About Us We're launching a premium European certified organic skincare brand focused on high-quality ingredients, transparency, and sustainable beauty. Our initial growth strategy is centered around authentic creator partnerships rather than traditional influencer advertising. We're looking for someone who enjoys building genuine relationships with skincare content creators and can help us establish a strong community before launch. --- ## Role Overview We're looking for an experienced freelance Creator Outreach & Community Manager to identify, contact, and build relationships with micro creators across Europe. Your primary goal is to secure product seeding opportunities with creators who produce authentic skincare content and can generate honest reviews, UGC, and social content. This is a relationship-building role—not a mass outreach position. --- ## Responsibilities ### Creator Research * Identify relevant skincare, beauty, wellness, and lifestyle creators across: * Instagram * TikTok * YouTube Shorts * Focus primarily on creators located in: * Germany * United Kingdom * Netherlands * Sweden * France * Denmark * Evaluate creators based on: * Audience quality * Engagement rate * Content quality * Brand fit * Authenticity ### Outreach * Write personalized outreach messages. * Contact creators via email or direct message. * Build genuine relationships. * Answer creator questions professionally. * Coordinate shipping information. * Follow up with creators after delivery. * Encourage honest product reviews (never request only positive reviews). ### Campaign Management Maintain a creator database including: * Contact details * Platform * Country * Follower count * Engagement rate * Outreach status * Shipping status * Content received * Permission to reuse content * Future collaboration opportunities ### Reporting Provide a weekly report covering: * Creators researched * Outreach sent * Response rate * Products shipped * Content created * UGC received * Opportunities and recommendations --- ## Requirements * Experience working with beauty, skincare, wellness, or lifestyle brands. * Strong written English. * Excellent communication skills. * Highly organized. * Comfortable using spreadsheets or Airtable. * Experience with Instagram and TikTok outreach. * Able to identify authentic creators rather than relying solely on follower count. Preferred: * Experience with European skincare brands. * Knowledge of organic or natural beauty. * German, French, Dutch, or Swedish language skills are a plus. --- ## Success Metrics (KPIs) Weekly: * Research 100–150 qualified creators. * Send 50–75 personalized outreach messages. * Achieve a response rate of at least 20%. * Secure 10–15 product seeding agreements. Monthly: * Ship products to 30–50 creators. * Receive 20+ pieces of user-generated content. * Obtain permission to reuse content from participating creators. * Build a pipeline of creators interested in future collaborations. --- ## What We're Looking For We're not looking for someone who sends hundreds of generic messages. We're looking for someone who enjoys building long-term relationships with creators who genuinely align with our brand and values. You should be proactive, detail-oriented, and passionate about skincare and community-building. --- ## To Apply Please include: * A brief introduction about yourself. * Your experience with influencer or creator outreach. * Examples of campaigns you've managed. * Any results you've achieved (response rates, UGC generated, partnerships, etc.). * The tools you use for creator research and campaign management. * Your hourly rate or preferred pricing model. * Your availability.

opportunity

Excel automate, Power Query, data mapping, dashboard development

I am looking for an experienced Excel and Power Query specialist to complete a multi-level governance and assurance system for a health and social care organisation. The organisation has five service divisions. The workbooks, registers and overall structure have already been designed; I am not looking for someone to start again. I need someone who can review the existing files, improve the formulas and functionality, make the registers smarter and create reliable connections across the system. The required reporting flow is: Service/Practice Observation → Regional Governance → Divisional Governance → Group Governance/Master Dashboard Each division requires its own governance workbook and dashboard. Service and regional information must feed into the relevant divisional workbook, with key information from all five divisions feeding into one Group-level Master Dashboard. Smart governance registers The project includes a suite of existing registers covering areas such as: Risk Safeguarding Incidents and serious incidents Complaints and compliments GDPR and data breaches Restrictive practice Governance actions Service user feedback Audits and improvement Regulatory actions Training and workforce compliance The exact number of files will be confirmed with the successful freelancer following an initial review. The registers need to become functional, consistent and easy to use, rather than simply formatted spreadsheets. Depending on the register, this may include: Unique reference numbers Automated status calculations Open, closed and overdue indicators Due-date and review alerts Automated risk ratings and RAG indicators Dropdown lists and controlled data entry Conditional formatting Automated totals and summary metrics Monthly, quarterly and annual reporting Filtering by service, region, division, category, status and reporting period Identification of themes, recurring issues and required escalations Formula protection without restricting data entry Summary pages or dashboards Connections to the appropriate regional, divisional and Group dashboards The registers will remain the source of truth for individual records. Only relevant totals, themes, trends, risk ratings and outstanding actions should feed into higher-level dashboards. Main requirements The successful freelancer will be required to: Review and inventory the existing workbooks and registers Produce a clear data map showing how information should move through the system Make the registers smarter, more automated and easier to maintain Add, correct and protect formulas across multiple files and tabs Standardise dropdowns, identifiers, categories and reporting periods where required Create calculated metrics, alerts and RAG indicators Link Practice Observation data to Regional Governance workbooks Link Regional Governance workbooks to the relevant Divisional Governance workbook Complete dashboards for each of the five divisions Link all five Divisional Governance workbooks to the Group Master Dashboard Link relevant register data to the correct reporting level Use Power Query or another reliable Excel-based method where appropriate Ensure files work reliably within Microsoft 365/SharePoint Reduce the risk of broken links when files are moved, updated or refreshed Test the complete data flow from source registers through to the Master Dashboard Ensure the system is straightforward for managers with varying levels of Excel experience Deliverables Smart, functioning governance registers Functional Practice Observation templates Regional Governance and Assurance workbooks Five Divisional Governance workbooks and dashboards One Group Governance workbook and Master Dashboard Reliable connections between all relevant files Working formulas, validation, dropdowns, alerts and RAG ratings A complete data map/data dictionary Testing of the full reporting flow Simple refresh and maintenance instructions Final handover and correction of any errors identified during testing Confidentiality The work relates to confidential organisational systems. A Non-Disclosure Agreement must be signed before any files are shared. Anonymised or test data will be used wherever possible. Please include in your proposal: Your experience of creating smart Excel registers and trackers Your experience of linking Excel files stored within SharePoint/Microsoft 365 Your Power Query experience How you would minimise broken connections How you would approach mapping and testing this system Examples of comparable work What you can deliver within the approximate £1,000 budget

AI Video Expert for Photorealistic Skincare Product Reels

ChatGPT generated applications will be ignored - please write to me in your own words. We are looking for an experienced AI video generation specialist to create approximately 20 short, photorealistic video clips, each around 2–4 seconds long, for a professional skincare and post-treatment product range. These clips will later be edited together into short Instagram and TikTok reels. This role is focused on generating the individual cinematic clips rather than editing one complete reel from start to finish. This is not suitable for someone who has only experimented casually with AI video. We need a specialist who understands how to select and use different AI video models depending on the scene, achieve realistic human movement and skin texture, maintain accurate product proportions and create polished footage that does not look obviously AI-generated. The type of footage required The clips will include a mixture of: Cinematic skincare product reveals Luxury product shots using supplied reference images Realistic cream textures and application Clients resting after professional skin treatments Naturally flushed post-treatment skin Practitioners working in professional clinic environments Close-up treatment and aftercare moments Products being placed into aftercare bags or handed to clients Slow, premium camera movements suitable for luxury skincare advertising The overall aesthetic must feel: Photorealistic, cinematic, premium, professional and believable. We do not want plastic-looking skin, distorted hands, unrealistic anatomy, warped packaging, altered labels or generic “AI spa” footage. Branding and creative direction We will provide: Product images and packaging references Brand logos Website links Existing carousel graphics and AI-generated imagery for visual inspiration Colour palettes and brand direction A detailed description of each required clip Prompts and key instructions for the scenes You will be expected to follow the supplied branding closely and maintain visual consistency across all clips. The product packaging must remain recognisable and correctly proportioned. Bottle shapes must not be shortened, widened or distorted, and sachets must appear at an accurate scale beside larger products. All written overlays, logos and final captions will normally be added during editing, so the generated footage should be clean and suitable for text placement. Essential experience You must have strong practical experience using several leading AI video-generation models and understand which model is best suited to different types of footage. Experience with tools and models such as the following is highly desirable: Google Veo Kling Runway Adobe Firefly Sora Luma Hailuo Seedance Other photorealistic image-to-video and text-to-video models You should understand: Text-to-video and image-to-video workflows Reference-image consistency Product animation Realistic skin and facial detail Natural hand and body movement Cinematic lighting Camera movement and framing Vertical 9:16 social-media production Negative prompting and artefact reduction How to identify and reject visibly distorted generations How to create several variations and select the strongest result Experience producing content for skincare, cosmetics, beauty, aesthetics, PMU, tattooing or professional treatments would be particularly valuable. Need: Approximately 20 finished video clips Each clip approximately 2–4 seconds long Vertical 9:16 format High-resolution output suitable for Instagram Reels and TikTok Clean footage without added captions unless specifically requested Consistent colour grading and visual style Organised, clearly labelled files Reasonable revisions where anatomy, packaging or movement is visibly incorrect The final number of clips may change slightly as the project develops. Quality expectations The footage must not look obviously AI-generated. We will not accept clips containing: Distorted or changing product packaging Incorrect logos or altered labels Squashed or widened bottles Extra or fused fingers Unnatural hands or limbs Plastic-looking skin Strange eye or facial movement Overly dramatic or surreal movement Generic, fake-looking clinical environments Inconsistent products between clips Attention to detail is essential. When applying Include: Examples of your best photorealistic AI-generated videos Examples of skincare, beauty, product or human-focused work The AI video models you use most confidently Your preferred workflow for maintaining product consistency Confirmation that you can work from supplied reference images and detailed prompts Your estimated cost for approximately 20 clips of 2–4 seconds each Turnaround time Whether your price includes generation credits and revisions Please do not apply with generic AI showreels full of fantasy scenes, animation or dramatic visual effects. We specifically need someone who can produce subtle, realistic, premium commercial footage.