4/11/2024 0 Comments Airtable zapier social media post![]() There's a number of views you'll also need to set up in the social media schedule tab, discussed below. Team Database: This database stores information so your social team knows who to contact about an event. Two fields each for each network you will tag them on. Tag Database: This lists all of the organizations or other social accounts you tag in your posts. Status select field with options such as draft, ready for review, edits needed, send to scheduling, day-of reminder, manual schedule, etc. Lookup field for the tags from the tag database. Lookup field for the team lead name and phone number from the team database. ![]() Select field for network of post, with separate listings for Instagram, Instagram stories, "dark" posts, etc.ĭate and time for a reminder, if the post requires photography or content from an in-the-field team member. Media, for the photo, video, or image to be included in the post. Social Schedule: This is where your individual social media posts will live. Link to the tag database, for any organization we should tag in the post Link to the team database, for event lead Start and end dates of the event - date fields Messaging category (we use this to report out for each category) - select field We use it to list all of the events, campaigns, and messaging that we'll be pushing out via social media. To follow this recipe, you will need to be somewhat familiar with the basic functioning of Airtable.Ĭontent: This is the home of your editorial calendar. I built the system on Airtable's Pro plan ($20 per user per month), but it may well be possible to do this without the pro plan, depending on how complex you'd like the system to be. You can also add on some kind of social media scheduling tool - we use Buffer - as a double check system. Zapier, to automagically send things where they need to go. There's two tools you will need to make this basic setup work: Use Zapier to send posts you're done writing to where they need to go. Set up an Airtable base that has separate, interconnected tables for your editorial calendar, social media schedule, and tag database. Have a form to allow any one of our 600+ employees to suggest something that they think we should post. Making our social media plans public enough that our Compliance department could review them, while still keeping thing comparatively locked down. Sending reminders to team members who are out in the field, asking them to send content to the social media crew. Researching what Instagram, Twitter, Facebook, LinkedIn, etc user accounts for every one of these networks was taking a LOT of time. We have over 1,000 other organizations that we tag in our posts in just one year. Social media should be just that - social. Or if you're someone who enjoys martech and DIY-ing and are willing to tinker.ĭespite searching, there were a few things I considered requirements that no other system made easily manageable. ![]() Seriously, home-built systems require consistent management and tweaking, and the time investment is real. Have researched commercial options that are professionally supported and decided they're not for you. Know what kind of reporting out you need from the system. What do you want the system to do? What do you NEED it to do? Have a solid understanding of your system requirements. You should never use a home-built program like this unless you: Here's a version of that spreadsheet for you to start with. For well over 2 years, I ran a very successful multi-platform social media program using a spreadsheet and very inexpensive subscription to a social media scheduling system. I will caveat this: if you are just starting out with your social media program, or you're just managing 2 or 3 social networks, it is VERY likely that implementing this system is going to be overkill. In the time since, I've also taken this DIY mentality to our social media scheduling and planning system. That system has proven quite effective even as we've re-considered commercial options. ![]() In 2017, I built a social media monitoring system utilizing Slack, which I documented and posted about two years ago. YMMV, but I’m leaving the post up as inspiration for anyone who wants to give it a go. The details of many of these things have changed - AirTable offers native integrations for some things, Zapier has gotten much more powerful, and Facebook Pages has gotten more locked down. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |