Typically, what you would do if you’re going to send out YouTube posts to Facebook. You’re gonna do that to Twitter or any other social media platform.
It takes a lot of emphasis on time.
When you film your video, you create it, you upload it to YouTube then you schedule it in your calendar.
Then the next thing you would do is upload it to your WordPress site. After that, you would post to social media. You go to Facebook and Twitter, maybe use a program like Buffer or any other social media platform.
But it takes time to go ahead and do all these things.
What we’ve done is we’ve randomized these things.
I want to show you some of these postings that I have here scheduled out so you could see this whole list of postings.
This is our data store.
We’ve got some postings here that basically go into this.
We have our title or written text, our photo, link and when it was created.
you can see there’s a ton of postings and these com are going out throughout the next year and two.
Basically we’re trying to recycle and reuse some of the old video content that we have.
One of the ways that we do this is kind of through the power of Airtable and Integromat.
We used to use Zapier in the past but Zapier just doesn’t have that that power and oomph.
When we’re looking at Integromat, we start out with a basic item here for our blog content.
We use Airtable for just about everything because it’s database structure. There’s people use Asana Trello but the thing is, with those platforms they don’t have a database structure, which you can’t add in extra fields.
Blog Content BSI
Let’s go ahead and take a look at this table and what that really looks like so I’m going to show you here.
If we go to the blog content backstage income
So anytime there’s a new post in here in our blog content area, it starts looking for the need to schedule a social media post.
So right here as you look through these most recent ones. Here’s all our fields: the title, date, schedule, your YouTube URL, website URL and video thumbnail, Pinterest thumbnails, WordPress. It’s just like an excel sheet for the website. So it’s all in here, everything is lined up there.
So once it goes in here here’s here’s what happens. We go into this system right here.
In this system, what’s happening is that basically Airtable takes this system and it goes in and it looks to see
if there any fields with the website URL, date schedule, title and video thumbnail.
If there are and they all exist with those records, meaning we’re just checking for it.
Let’s go ahead and grab something from the google sheets.
What I’m doing here from the google sheets is actually i’m getting a few random values which i’ve created in this google file and
This google file what it does is we’re getting some pretext and post tech.
If you want to take a look at what that looks like it basically looks like this.
So I’ve got the row number, I’ve got the pretext uh one pretext two pretext three pretext four and all that is is just put something at the beginning of the of the item.
When we do this it’s extrapolating this data to go ahead and add it in a little bit later.
Then we also have post text, which is like an icon and an arrow and an arrow force.
So you’ll see what I mean here in just a second. So what it does is when we start this process, this automation thing, which allows us to go on routes.
Unlike Zapier, which is much more visual, what we do is we go through air table. we go in and put some routers here in between just to split up some data in the future in case.
We need to ever split things up without reworking too many things.
Then we go extract a random google sheet from those records.
So we pick a random item or value from this whole list and there’s a bunch of records in here.
So it’s just, hey awesome did you see it awesome with a different icon so it’s about 185 different fields.
Here it is, we basically extract it right here.
- Custom range A to Z
- Count random between 1 and 184 (so that’s our code there)
So once it picks that as long as the date is in the future where this blog is scheduled for.
well then, what we do is we input this record into our data store.
The reason we do this in a data store is because Buffer or other social media platforms only lets you schedule maybe 100 posts it might be 50 posts in advance.
We’re looking to store maybe a thousand to 2000 posts and here’s what it does: it basically adds this into our data store
where this is the social media table.
This is where it’s going, we’re going to data store number two website. We add time, we add the date scheduled, we add a few days, a random amount of days between 190 and 390 days and between 5 minutes and negative 990 minutes.
So it puts kind of a random value.
Then the written text that we have is those random items. So it’s like pretext from c, we have the title, we have the post text, we have the arrow then we also have the link.
That’s how it works.
We have another record over here.
So we have it at different points where in the air table system that we just add a few minutes. Others of them we go ahead and do it longer duration.
So every single one’s a little bit different and then it goes into this data store right here
Then what we do is, periodically as we look, we go into our dashboard here on Integromat.
In this dashboard, what happens is we go in from the field and it checks hey from this data store we’re going to go and look in the store and we find okay days out as long as the days out in this data store.
Which tells you right here how many days out until it has to be posted, which gets updated automatically because it’s a formula 8 days, 8 days and 8 days. So you’ll see that every 8 days it checks kind of as long as it’s less than 14.
If there’s posts there go ahead and push them into the website
So here it would go backstage income it would go to buffer and then it would delete that record from there.
So that’s the way that it works is that it goes in and then checks this periodically and you can set the sequence up to look and that’s how we go ahead and really integrate it.
That’s how you keep your buffer schedule full
That’s the way we do it because that way, we automatically take our posts and we randomly generate it from our content table.
Then we randomly assign some dates to it and then we pool it at certain times as long as the dates coming up into buffer.
If you need to resort some of these posts you could go into the calendar and you could move some and and rearrange some as needed.
We’re always just trying to be a little ahead because sometimes the automations may have a little problem here or there.
But other than that, that’s the way that the smarter approach to doing it.
But as you look through this calendar, you can see there’s a ton of postings here that we have every single kind of day.
The calendar is full.
It’s there and we can go ahead and keep adding more in and you can see we have up to march 2021 already which is about a year forward.
We already have some postings and those will continue to increase as we move forward with time. So we’re just always looking to fill it up more and more.
We’re doing basically three to four postings as we get three to four postings per year of recycled content.
So as we go even further ahead we will just, let’s say one or two years later, we’ll go back to the original post and just recycle them one more time.
That’s the smarter approach that we like to take for social media postings.
Just go ahead to reuse our content when it comes to our YouTube videos so that way they’re getting out to Facebook, Twitter and so on.