Database for storage of social media data for analysis. How do I organize this?

I'm trying to automate some basic reporting around social media content performance. This one Python script I'm working on scans either a YouTube channel or YouTube playlist, and returns the channel's name, subscriber count, video titles, and video views.

While I can easily get it to print out the data I need to store it so I can later generate the report, and also perform analysis. I need to know what the subscriber and view counts were at specific dates, so I can't just store those numbers in one column and update them every time the script is run.

Currently I have it setup as below:

Table 1: videoId videoTitle

Table 2: channelID channelTitle

Table 3: weekId week

Table 4: sCheckId weekId(FK Table 3) channelId(FK Table 2) subscriberNumber

Table 5: vCheckID weekID(FK Table 3) channelID(FK Table2) videoId(FK Table1) videoViews

So initially the script runs and checks to see if the channel or videos already exist in table 2 and table 1 respectively. Table 3 generates a new row that contains the week ID which serves as the date reference so for example weekId 1501 is Year 15 week 1. The script pulls the channel's subscriber count and adds it to table 4. Table 4 generates an sCheckId(just a primary key that auto increments) and saves the subscriber count referencing the weekID from table 3, and the channelId from table 2. The script then checks the view counts of all the videos in a similar fashion by generating a vCheckID(another primary key that auto increments), saves the videoViews number, references the weekId for a date, the channelID so we know what YouTube channel the video lives on, and finally references the videoID so we know what video the view count is for.

I'm still trying to get the above to work, but I can't help but feel this is needlessly complicated. Anyone else have suggestion on how to store the data?