
Oliver Spratt RomeroVerified creator
@olisr
Fundador y CEO de Nebular Group. Comunicador, creador y estratega de redes sociales, contenido corto y producción audiovisual. En redes desde 2012.
- views
- 3.1K
- downloads
- 478
- saves
- 194
A free Canva that runs on your own computer: designing with Excalidraw locally
What you can design without a subscription using Excalidraw locally, why it matters that the output stays editable, and the cases where Canva still wins.
Free video editor with no watermark: what you gain and what you give up
CapCut and Canva are free until you export. Here is what each one actually limits, what a local editor built on OpenCut offers, and the cases where it still is not the right pick.
Free transcription and dictation on your own computer: Whisper locally, no internet
How transcription with local models works, what computer you actually need, how the cost compares to per-minute services, and what you give up by not using the cloud.

Client content approval: how to stop the endless change requests
Why approvals stall, what the flow needs, a message template for sending work to review, and how to cap the number of rounds.

Producing social content faster: seven steps, and where AI fits
The bottleneck is rarely creativity. Seven operational steps, what to hand to AI, and how to know you are genuinely faster.

How to choose management software for an agency
The three tool categories that get confused, the criteria that actually matter, and a scorecard to compare before you sign.

DAM for social media agencies: what it centralises and what it does not
The difference between scheduling and operating content, what a shared archive with API and MCP access solves, and who it fits.

Automating social with AI: what to delegate and what not to
What AI does well today, what you should not automate blindly, how to evaluate a tool, and a matrix for deciding case by case.

Working from home as a creative: four modes of work
Separate production, calls, admin and rest; design an end to the day; and stop keeping the project archive on your laptop.

Designing inside a team: briefs, versions and approvals
Which skills matter now, how to read an incomplete brief, and how to hand off so the next person can pick it up.

Sales enablement: the material sales needs to close
Deck, cases, demos and objection answers, approved and findable. How to stop someone sharing a price list from eight months ago.

From customer journey map to editorial calendar
What a map needs to be useful, how to move from stages to concrete pieces, and how to prioritise what is missing.

Creative operations in agencies: the five-layer framework
How to tell your operation is broken, the intake-to-publication framework in five layers, and a 30-60-90 implementation plan.

Google Analytics 4 for agencies: client measurement and reporting without overcomplicating it
Google Analytics 4 for creative agencies: how to set it up and build your clients' reporting without overcomplicating it, with its history and the most common mistakes.

What is 4K, and when is it worth recording?
What 4K means, how it compares with Full HD, and when its resolution justifies extra storage, transfer, and post-production.

YouTube history: what changed in each phase, and why it matters
From technical file sharing to MCNs and brand video. The four phases of the platform and what each one implies for what you produce today.

What is content? A strategy for agencies
What content is and how an agency turns it into a useful, differentiated, measurable strategy with reusable assets.

What an influencer agency should actually deliver
The services that define a serious agency, how it works internally, which KPIs to demand, and when outsourcing pays off.

How to close a feedback round without contradictions
One person consolidating, one channel, one deadline, one closed round. How to stop WhatsApp, email and the call saying different things.

Open-plan offices for creative teams: zones, noise, and assets
How to organize an open-plan office so a creative team can talk, focus, and work without letting noise or scattered assets create chaos.

Reusing Instagram UGC: rights, archiving, and the DAM workflow
How to reuse Instagram stories and UGC without legal trouble: copyright, GDPR, permissions, archiving, and the DAM workflow professional teams rely on.

From the marketing plan to this week's calendar
Objectives, channels, budget and owners. Plus the step almost nobody documents: which material has to be produced to deliver it.

Define the target in every creative brief: an actionable audience per piece
How to define each piece's target in the creative brief so it's actionable, and why a generic target produces generic pieces that don't convert.

From vertical to horizontal: adapt a video to all your client's channels
Creative techniques for an agency or freelancer to adapt a client's vertical video to horizontal and deliver it ready for all their channels: blurred background, graphics, mockups, and AI.
More publications
- Managing raster and vector images: formats, versions, and brand assets
- Frames and timecode: how to review video without ambiguous feedback
- Gestalt applied to reviewing creative work
- How to organize and version your Adobe Illustrator files
- Setting up a creative studio without wasting money on decor
- FAQ pages that convert and rank: a guide for content teams
- Changing prices without leaving contradictory versions behind
- Sales promotion techniques that do not destroy your margin
- Downloading images from a website: what is legal
- The copywriting process, from brief to sign-off
- Video production flow: 8 phases with approval points
- SEO content: seven steps so it also converts
- Organic post vs. ad: when to use each in client accounts
- Video pre-production workflow: planning and approvals
- YouTube Analytics for managing your client's brand channel
- Emotional marketing: where the line with manipulation sits
- TV spot: from one shoot to ten reusable pieces
- What the law says about subliminal advertising
- How to sell design services: 3 strategies with traction
- How to scale a micro-influencer campaign
- From content strategy to the editorial calendar
- Company profile as a brand asset: a single source and consistent versions per channel
- Managing a brand domain portfolio
- What content a chatbot needs to stop failing
- Moving your creative archive to the cloud in eight steps
- How long does video production take? A phase-and-review template
- How to choose a video production company and receive a reusable archive
- How to have more ideas you can actually build
- The few marketing KPIs that survive a client meeting
- From a social media plan to business results
- YouTube privacy: how to share videos in review with clients
- What press material is worth having ready
- Content engagement metrics: what to measure and how it feeds your creative production
- How to set up a growth experiment cycle
- How to design viral content for brands: from STEPPS to TikTok
- Brand archetypes for a consistent client identity
- How a place brand actually gets built
- Content formats and which role produces each one
- Selling creative services online before you drop your price
- Jim Edwards' VSL structure, step by step
- Production services: what to hire when a campaign shoot needs it
- How to choose an office for a creative studio working with assets and AI
- Product launch: coordinating NPD with content operations
- Video length by channel: plan a master and cuts instead of copying rules
- UGC: getting permission and reusing it without risk
- First-party data: what to collect and what to use it for
- Shooting in 4K to reuse: the operational call on archive and channel versions
- How to organize a video production day: an operational guide for teams
- X threads: structuring one that survives the feed
- From loose file to asset: what your files are missing
- What makes people join a TikTok challenge
- 360 video: the cases where it genuinely adds something
- Corporate gifts: when they pay off and how to coordinate them
- YouTube copyright: Content ID, fair use and what is a myth
- Spotting greenwashing before you sign off the campaign
- What 3D material a virtual try-on actually needs
- Media kit: what to include so a brand actually books you
- What you are actually buying in a coworking space
- What an embed is and how to manage it for client content
- The first 48 hours of a reputation crisis
- Digitising an archive so you can still find things later
- Does your campaign actually need its own hashtag?
- Unboxing: one recording, many pieces
- From making content to running a creator business
- Gaming marketing: entering games without looking like an intruder
- Signs your team's communication is costing you money
- How to make the wow effect repeatable
- Why growing with bots ruins your client's brand (and how to protect it)
- The STAR method: writing up a project so it stays useful
- How to vet an influencer before you propose them to a client
- How an advertising campaign really works
- YouTube ad formats and what each one demands
- How to answer a negative comment without making it worse
- WordPress, Webflow, Ghost or headless: how to choose
- What to capture in a making-of so it stays useful
- How much it costs to maintain a website per year
- Producing video at scale without losing brand control
- H1-H3 heading hierarchy: structure your clients' content for SEO
- Leaving a brainstorm with something you can build
- Starting on YouTube: your first ten videos and first revenue
- What a piece of graphic communication has to deliver
- What to protect when the marketing budget gets cut
- Price skimming: launching high and stepping down in phases
- Overlays and motion templates: brand consistency across formats
- How to produce recipe reels in batches
- Instagram AR filters: from idea to published effect
- Video delivery and archiving: masters, formats, and naming for reuse
- Brief or contract: what belongs in each document
- Consumer protection for agencies: what your team must know before launching a campaign
- The 7 phases of an advertising campaign
- UTMs: a naming convention that still works six months later
- When an X thread beats a single post
- Types of engagement, and which one matters for your objective
- Generalist or specialist freelancer: how to decide
- Sales pitch for freelancers and agencies: how to sell creative services
- Instagram polls: what to ask and what to do with the answers
- How to build a visual communication strategy
- How you make money on YouTube: 7 routes and which fits
- Camera lenses: focal length, aperture, and a repeatable visual recipe
- Apps and templates for making Instagram Stories
- Creative deliverables: how to define and manage them without rework
- Your site as a campaign hub, not a brochure
- How to spot a bad graphic designer before you hire them
- TikTok for brands: how to sustain weekly production
- The real difference between a typeface and a font
- What managing a client's social accounts really involves
- Internal communication in creative teams: what goes where
- Producing content per target segment at scale (actionable targeting)
- Memes for brands: how to produce them without losing context
- When a company blog genuinely generates business
- Gimbal or Steadicam: how to plan moving shots
- Integration plan: connecting teams, tools and content
- Managing creative projects with a WBS: scope, deliverables, and owners
- Followers or engagement: which metric to promise a client
- Color theory: how to set a brand palette
- How to structure marketing messages that convert (an agency guide)
- Viral marketing: what actually makes something get shared
- What to maintain each week in Google Business Profile
- How to reuse and adapt content per platform without duplicating work
- Sampling: validate client audiences without surveying everyone
- Digital presence: choosing where to be
- A career in digital marketing: real routes and what each demands
- Projects with too many stakeholders
- Fiverr, Upwork or Freelancer: which one fits your profile
- Running a webinar that still pays off six months later
- Bringing freelancers into an agency without losing margin
- Free tools for running a YouTube channel
- 8K vs 4K: when reframing room justifies the cost
- Rendering video and 3D: avoid failed exports and preserve the master
- Old SD video: how to digitize, document, and reuse it
- When a platform kills a format: what to do with what you made
- How Gen Z discovers and buys
- Media plan: where, when and how often you invest
- 5 product launch types and when to use each one
- Where misleading advertising begins in food photos
- Bad reputation on social: diagnose before you reply
- Which licence you need to use music in a video
- Voiceover: how to write narration scripts for brand videos
- Closing, deactivating or migrating a brand Instagram account
- Verbal and non-verbal code: build brand messages that truly communicate
- Posting frequency on social media: a guide to managing clients in 2026
- Which Instagram behaviour signals are worth acting on
- How to plan a food photography session
- Turning company values into real decision criteria
- Seven Instagram Story formats that work
- Brand mini-documentary: when to use it in your content strategy
- Choose the newsletter type before you write anything
- What really changes with a professional Instagram account
- Reading Instagram insights and deciding what to produce
- How to shoot better with the gear you already have
- How to test YouTube thumbnails without guessing
- Audiovisual narrative: from concept to final edit
- Communication as a service: what you deliver
- Designing newsletter blocks you actually reuse
- KOL (Key Opinion Leader): how to bring them into client influence campaigns
- Free alternatives to Adobe: what each one actually covers
- What a content manager actually does all day
- How to sustain a brand YouTube channel: content operations
- Commercial planning for agencies: land the client's strategy in a plan
- Advertising campaign: from Volkswagen's Think Small (1959) to the integrated digital era of 2026, the real phases, and why most campaigns fail at the brief
- Motion graphics for marketing: when to use them in your clients' video production
- Is advertising on YouTube worth it for your case?
- Lower thirds: how to build a title system for branded video
- Animation for marketing video: types and when to use it in client projects