Many of us can recall a time in high school when we were sitting in math class and thinking, 'When am I ever going to use this stuff in the real world?'
And then we suddenly find ourselves in the real world, only to realize that numbers actually do play a pivotal role in what we do -- especially in digital marketing.
Free Template School Holidays 2019 Calendar UK, USA, QLD, NZ Blank School Holidays 2019 Calendar UK, USA, QLD, NZ, England, NSW Get School Holidays 2019 Calendar UK, USA, QLD, NZ, England, NSW. School budgets are immensely important to track where the funds are being invested and for what they are being used. School budget templates further help to tabulate this data, making it easier for the school administration staff to formulate the budget better.
The trouble is, many marketers are right-brained, meaning Excel spreadsheets riddled with numbers and formulas aren't all that inviting. Making them from scratch can be especially intimidating.
While we won't argue with that, we will say that the advantages of leveraging Excel's functionality to organize information and streamline tasks are unparalleled. To help those of you looking for a way to sharpen your skills, we've put together a detailed list of ways you can start using Excel to simplify your marketing tasks. Complete with templates, these suggestions will have you making strides in no time. Know what's even better? You can download this full collection of Excel templates in one fell swoop.
9 Excel Marketing Templates
Tell us a little about yourself below to gain access today:
Free Excel Spreadsheet Templates That Make Marketing Easier
1. A Marketing Budget Template
While marketing budgets vary from business to business, the need for structure and a clear sense of alignment between your goals and your spending is critical across the board. To ensure you're always prepared for unanticipated costs, it's important that you're not only allocating your budget thoughtfully and properly, but that you're also keeping tabs on how closely you're sticking to your projected expenses.
If you want to avoid a mess at the end of the month or quarter, take a look at this collection of 8 marketing budget templates, designed to help you organize your marketing spend better. From product marketing, to website redesign, to content marketing, to events, these templates serve as a guide for marketers to visualize and track their expenses to avoid overspending.
The collection also contains a master marketing budget template that'll help you generate a high-level visualization of your marketing budget on both a month-by-month and quarterly basis.
Download the marketing budget templates here.
2. Social Media Posting Schedule
You might already use a social media scheduler to manage and publish your posts every week, but you still need a place to draft your social copy and decide which posts will go to which social networks.
And because most social media schedulers allow you to upload social post copy in bulk, from a spreadsheet, it behooves you to have an Excel template designed for this purpose. With that in mind, we created the Excel template shown above.
This social media posting schedule allows you to draft each social post, the date/time it is to be posted, the message you want to publish, and any link you want to accompany your message (that link could be a blog post, registration page, an ebook landing page, you name it).
Once you've drafted all of your social posts for the week, month, or quarter, you can sort them by social network and upload your Excel file into your social media platform of choice.
Download the social media posting schedule here.
3. A Blog Editorial Calendar
Blogging plays a significant role in your ability to attract visitors and leads to your website. But managing a blog is one of those responsibilities that's easier said than done.
Whether you're struggling with ideation, consistency, or simply just lacking organization, an editorial calendar can often serve as the solution you need to refocus your blogging efforts and generate even more traffic and leads from your content. Visualize the blog posts you plan to publish in a given week or month makes it easier to define overarching themes, keep track of ideas, manage contributions, and prioritize strategic distribution.
Use this editorial calendar template as the starting point for keeping track of all of your business' content. It'll help you be more mindful of topic selection, buyer personas, keyword inclusions, and CTA alignment.
Download the blogging editorial calendar template here.
4. A SMART Goal Matrix
Whether you're planning for a new year, quarter, or month, defining a clear set of goals is critical for driving the direction of your marketing efforts and priorities.
Do you need help not only setting marketing objectives, but actually achieving them? Start with these SMART goal planning templates. Rooted in specificity, measurability, attainability, relevancy, and timeliness, these templates will help you set your team up for success while providing you with a tool for identifying your greatest marketing needs.
Download the SMART goal planning templates here.
5. An On-Page SEO Template
When it comes to SEO, there's a lot for marketers to remember in order to see results. (Put another way, there's a lot for marketers to forget.) With search engines evolving and algorithm changes turning your existing strategy on its head from time to time, it can be easy to feel overwhelmed and push off revamping your SEO strategy. However, SEO should never be treated like an afterthought.
If you're looking for the light at the end of the tunnel, pull up this handy SEO template created in Excel. Designed to make the process of managing your SEO efforts a whole lot easier, marketers can use this template to guide their strategy step-by-step or pass it off to their webmaster to serve as a helpful guide. It focuses on not keywords and SEO best practices while providing tips and tricks to identify nuances and increase productivity.
Download the on-page SEO template here.
6. A Google Ads Campaign Tracker
If you’re doing your Google Ads campaigns right, they probably aren't exactly walks in the park. That's because to get the most bang for your buck, you've set up multiple campaigns with multiple ad groups and have variations of your campaigns -- all with different content. Not only that, you're (hopefully) also keeping track of those campaigns to determine which ones to shut off, add more money to, or tweak.
Sounds like a lot to keep track of, right? But take a deep breath. This Google Ads tracking template can keep you on top of your Google Ads game. It'll help you catch mistakes and implement best practices across all the different campaigns and ad groups you're running -- for the top, middle, and bottom of the funnel. Not to mention, it's a perfect complement to that SEO template you've started using.
Download the Google Ads tracking template here.
7. A Social Media Content Calendar
Since you’re probably generating tons of clicks from your Google Ads campaigns and writing awesome content thanks to your blogging editorial calendar, you're going to need some help figuring out how to spread the love on social. We've got just the thing.
The social media calendar template is the perfect resource for helping you scale and streamline your social media marketing. When you use Excel to break out separate worksheets for each social network you're using, you'll be able to keep a repository of content ideas so you're never struck by writer's block, and always have something to post.
It's also worth mentioning that Excel really comes in handy when it comes to Twitter, as it has the ability to count your characters to help you write tweets that stay within the 140 character limit.
Download the social media content calendar template here.
8. A Service-Level Agreement (SLA) Template
It's no secret that sales and marketing are known to have a pretty rocky relationship history. Sales might think marketing isn't generating enough leads, while marketing might think their sales reps aren't capitalizing on the leads they're sending over. When it comes down to it, though, finger-pointing doesn't grow a business.
In an effort to better align your sales and marketing teams, turn to this template for creating a service-level agreement (SLA). Generally speaking, an SLA is a contract that defines the expectations sales has for marketing leads (both quantity and quality), as well as the expectations that marketing has for how sales will act on qualified leads.
With this customizable SLA template in your toolbox, you'll have the information you need to reduce tension, define a concrete monthly lead generation goal, track and measure the success of specific lead generation channels, and keep close tabs on your current sales close rates.
Download the service-level agreement (SLA) template here.
9. A Leads and Traffic Goal Calculator
You have to set a leads goal, but you don't know where to start. Then, once you finally figure that out, you have to determine how much traffic you need to hit that goal .. but you're not sure what approach to take there, either.
Sounds like you could use hand calculating your leads and traffic goals. Luckily, there's an Excel template for that. Rather than try to sort of these numbers on your own, this template is designed to take care of the math and leave you with a clear picture of what you need to accomplish in order to achieve your traffic and leads goals and ensure the health of your inbound marketing strategy.
Download the leads and traffic goal calculator here.
10. Your Monthly Marketing Metrics
Is there a feeling sweeter than hitting all of your goals for the month? How about communicating your success to your boss? Excel spreadsheets can be used to prepare comprehensive reports of your marketing metrics to send off to your boss -- and there's no need to work from scratch. (After all, you've already so worked hard this month.)
To simplify your reporting, check out these monthly marketing metrics templates (and the corresponding PowerPoint template). Each, month, you can update them quickly and easily to reflect your monthly visits, leads, customers, and conversion rates. From there, you'll have everything you need to accurately track and report on which channels are performing best. Every boss loves to see ROI, so you can't go wrong with these templates.
Download the monthly marketing metrics templates here.
How do you use Excel to streamline your marketing? Share your favorite techniques, tips, and templates in the comment section below.
11. Essential KPI Tracker
If you're a fan of the monthly metrics template -- item #10 on this list -- you might want to grab a copy of this template as well. The essential KPI tracker, shown above, takes the metrics your marketing team has agreed to track and describes them in more detail.
KPI stands for 'key performance indicator' -- they're basically your most important metrics, each with a unique purpose and place in your marketing strategy. Using this template, you can assign specific employees to each KPI, define the frequency at which you'll monitor each KPI's performance, and assign each KPI a color that reflects the quality of that KPI's performance.
If one of your KPIs is organic traffic, for example, you can set up your template such that 100 page views per month is red (poor performance), 500 page views/month is yellow (stable performance), and 1000 page views/month is green (great performance).
Download the essential KPI tracker here.
Want more Excel tips? Check out these Excel formulas, keyboard shortcuts, and tips.
A good shot list maximizes shooting time and limits downtime across all departments. In this post, we lay out the essentials of a shot list with pro-tips on best practices.
We’re also going to walk you through StudioBinder’s shot list module so you can maximize your productivity. In the end, we’ve provided a shot list template pdf that you can use outside of StudioBinder.
Alright, time to start shot listing!
Shot List Definition
What is a shot list?
A shot list is all the shots you want to get on a shoot day. Your shot list includes key details, such as shot size, type, camera movement, lens and gear requirements, and more. Think of it as a shopping list to make sure you get every shot you need to tell the story.
Creative shots aside, it’s easy to forget that a shot list is a strategic document. It’s a way for you to clearly communicate your vision with a DP and 1st AD, and plan out the shooting game plan for the day.
Shot lists are not exclusive to filmmaking. You can build a camera shot list for a photography shoot, and, if you have multiple cameras, you can use a shot list to specify which shots will be created with each camera.
What is a shot list?
The anatomy of a shot list
A shot list can be as simple or detailed as you want. It is a roadmap that will get you to a finished project but there is a lot of flexibility and personalization you can bring to the process.
As detailed as shot lists can be, there are some core elements that every list should have:
- Scene Number
- Shot Number
- Shot Description
- Camera Movement
- Shot Size and Type
If you're still asking yourself 'What is a shot list?' check out the video below where we explain the shot list anatomy and show you how to build one.
Related Posts
The Anatomy of a Shot List
Film Shot List Template
Basic shot list elements
Now that we've gone off the basic requirements of a shot list, let's go through StudioBinder's online shot list. Each element is designed to communicate vital information to your crew. When used to its full potential, a shot list will guide you through a smooth and productive shoot.
First, we're going to highlight some of the core elements that each shot list should have. In the following section, we'll get into just how detailed and specific you can make a shot list.
1. SCENE NUMBER
Scene numbers are extremely important in your StudioBinder project. They sync between your script, shot list and schedule. You can also use color labels to identify different scenes or types of shots.
2. SHOT NUMBER
This is a reference number for the shot / row. Simply list out your shots starting at 1. Reset the shot number back to 1 for every new setup.
3. DESCRIPTION
Provide as much detail as you’d like for each shot. It could be anything from an insert description, an action in the scene, or a line of dialogue.
4. SHOT SIZE
Shot size defines the size of the subject in the frame (e.g., close-up, medium shot, etc).
5. SHOT TYPE (CAMERA ANGLE)
The shot type references the position of the camera in relation to the subject (e.g., eye-level, high angle, low angle, etc.).
A change in camera angle calls for a new setup in your camera shot list. If the camera angle changes during the take, phrase it as something like a low-med-high, which means the shot starts low, moves to a medium, and ends on a high angle. This can be added in the Description.
Here’s a comprehensive list of 50+ camera shots and angles commonly used in shot lists.
6. CAMERA MOVEMENT
Camera movement identifies any movements of the camera during the shot. Remember, complex camera movements are time-consuming to setup so use them sparingly. https://aptyellow496.weebly.com/blog/frank-turner-tape-deck-heart-album-download.
How to Make a Shot List
Film Shot List Template
Advanced shot list options
Beyond the basic shot list elements, there are a number of details you can add. In StudioBinder, you can customize your shot list with many additional columns to get as specific and detailed as you want.
In this section, we'll highlight these advanced features so you can see just how useful and detailed a comprehensive shot list can be.
7. STATUS (THE SHOT LOG)
Once the shot is complete, mark the row with the ✓ to track your progress.
Pro Tip: Marking shots as Nice-to-Have in advance helps everyone better prioritize the essentials on set—which is helpful if you start falling behind schedule.
8. SUBJECT
The subject is the focus of the shot. It can be a character, group of characters, a prop, establishing shot, etc. The subject helps your team plan when actors should report to set or when a prop or location needs to be prepped.
Pro Tip: Remember that insert shots are often the easiest to shoot, requiring minimal talent, crew and gear. Factor them strategically into your camera shot list while other shots are being prepped. It’s also a good idea to keep a list of insert shots on standby for shooting during downtime.
9. VFX
Here you can make a note of any VFX (visual effects) this particular shot might need. Make sure you VFX Supervisor is included when creating a shot list so they can advise on any special considerations needed while filming.
10. CAMERA
Designate which type of camera you're going to use and make sure to confer with your camera department so they are prepared. If you're on a multi-camera shoot, identify individual cameras or specialty cameras (e.g., drone, GoPro, security camera, webcam, etc.).
11. EQUIPMENT
Identify the camera equipment that will be supporting the camera (e.g., tripod, crane, dolly, etc.). This helps you anticipate the set up time for equipment changes.
12. CAMERA LENS
The Lens column helps your DP and assistant camera team (ACs) prep for upcoming shots. Changing the lens constitutes a new setup, and takes time to accomplish. Minimize setup time by grouping your shot list by lens setups.
13. FRAME RATE
The frame rate indicates if this shot will be normal speed, slow motion, or fast motion.
14. SPECIAL EQUIPMENT
If there are any specific pieces of equipment needed for a shot (e.g., a drone, an underwater housing, etc.) you can include that information here.
15. SOUND
Is a shot covered with a boom mic or a lav mic? Both? Is the shot MOS (without sound)? If you have a complex sound setup, add it to the Notes column.
16. LIGHTING
This is where you can make any specific notes about the lighting of this particular shot.
17. LOCATION
Where you shoot each shot is very important to scheduling and organizing your shoot. Moving your entire crew from one location to another is extremely time consuming so grouping shots by location is essential.
18. PREP TIME
Setting up for each shot take time and calculating that time accurately will make your shoot as efficient as possible. Meet with your department heads (e.g., Camera, Grip/Electric, ADs, etc.) so that these times are accurate and agreed upon.
19. SHOOT TIME
Based on the script time, setup time and estimated number of takes, the shot list template will automatically generate an estimated shoot time for every shot.
We also add an additional five minutes of padding to every estimate just to play it safe.
20. TOTAL ESTIMATED TIME
The Total Est. Time column will allow you to add the prep and shoot time. This lets the entire crew know when they should be finished with a particular shot and move onto the next one.
21. START TIME
This gives the crew a general idea of how the day is scheduled. Scary movie 1 in hindi mp4 free download. When you calculate your set-up and shoot times for each shot, the start time can be estimated.
22. CAMERA SETUP
You can mark the end of each setup so the crew knows exactly when and where each change will take place. If you've included prep and shoot times, the setup line will automatically calculate time for the entire setup.
Pro Tip: Setups can eat up a lot of time over the course of a day. Once the camera is set with specific equipment (or lens), shoot as many setups with that gear before switching.
23. CUSTOM NOTES
Our film shot list template has two notes sections: notes for specific shots and notes for the whole scene. These could be used in a variety of ways, including for setups, meal breaks, etc.
24. COLOR CODING
To add an additional layer of customization, you can also color code your shots. This way, you can group them by setup, location, actor, etc.
25. PRINT VIEW
If you would like to print out your shot list, the print view will include the reference image along with all the shot specs.
Shot List camera movement types
Camera movements in a shot list
Our shot list template includes the following camera movement terms as drop-downs so that you can build the most detailed camera shot list.
Camera Move | Description |
---|---|
When the shot is locked off, the camera doesn’t pan, tilt, zoom or change in any way. | |
Pan | When you rotate the camera horizontally from a fixed location. |
When you rotate the camera vertically from a fixed location. | |
Pedestal | When the camera is moved vertically up or down (without tilting). |
When you move the entire camera forwards and backwards along a track. | |
Truck | The same as dollying, only you are moving the entire camera from left to right instead of forward and backward. |
Used in combo with dolly or truck to show a curve in the dolly track. | |
Steadicam | When the camera is stabilized using a special rig onto the body of a specialized operator. |
The camera is held by the operator without a stabilizer. | |
Crane or Boom | When you have a shot that starts extremely high and moves to a lower position or vice versa. Often used for overhead and establishing shots. |
When you zoom in or out of a subject. | |
Rack Focus | This is more a technique than a move. Rack focus is when the focus changes quickly from one subject to another in the same shot. |
A technique where the camera moves closer or further from the subject while simultaneously adjusting the zoom angle to keep the subject the same size in the frame. |
Related Posts
Mastering the Shot List: P.T. Anderson
Create a shot list
How to make a shot list strategically
Generating a shot list can be a fun and creative process but choosing your shots is just the first step. For the shot list to be fully functional, it also needs to be strategic so that your shoot runs as smoothly and efficiently as possible.
Create a shot list in three steps:
- Write out your list of camera shots.
- Group the camera shots by setups.
- Reorder the setups into the most efficient order of shooting.
That’s the gist of it. But like most things, the devil’s in the details. Writing out a shot is easy, conceptualizing is hard.
Shot List Collaboration
Shot lists are joint efforts
Just like filmmaking itself, a shot list should always be a collaboration. After you've generated a list of which shots you want, the actual shooting scheduling can be generated. Pokemon mystery dungeon explorers of darkness free romantic poems.
This is where each department should be brought into the discussion. For example, if a shot needs special equipment like a process trailer, your camera department might say that this will require 3 hours to set up. When you realize that you can shoot 4 additional shots if you skip the process trailer, it becomes a question of priorities.
Shot lists can and should be a living document during the pre-production process. Once you've gathered input from your collaborators, you can make the most productive and efficient schedule.
Variables come into play with any production and the goal is to eliminate as many of them ahead of time. This begins with a solid shot list.
Shot List Collaboration
Communicating in StudioBinder
In the past, you would have to send your finalized shot list to your UPM, upload a PDF to an online file sharing site like Dropbox, and hold a meeting to determine how the schedule will shift and what shots are feasible.
Now, with StudioBinder, you can eliminate this process entirely. Since your shot lists are saved under your scene strips, your shooting schedule and call sheets automatically adjust.
Not to mention, your department heads can view, edit, and comment directly on the shot list.
Sales Kpi Excel Template
There are times when all you need is a basic, quick shot list (i.e., a photography shot list template, etc.) and other times when you need something more robust.
So we’ve created both!
Up Next
Create a shot list with StudioBinder
Now that you're an expert on what a shot list looks like and how it works, it's time to make your own! With StudioBinder's software, you can create a professional and functional shot list for your next project. We'll take you through the process, step-by-step, so you can get to work.
Up Next: Create a Shot List in StudioBinder →
Showcase your vision with elegant shot lists and storyboards.
Excel Templates For Kpis International School Thailand
Create robust and customizable shot lists. Upload images to make storyboards and slideshows.