According to the documentation from Google, you should get an events_YYYYMMDD table for each past day and a current day’s events_intraday_YYYYMMDD table, which is filled throughout the day and then deleted once the events_YYYYMMDD table for the day is complete. If you’re only seeing events_intraday_YYYYMMDD tables for past days and not the events_YYYYMMDD tables, it seems like there may be an issue with your setup. It is not you who is responsible for creating the events_YYYYMMDD tables; they should be made and populated automatically by Google. It is highly recommended that you get in touch with Google’s support to troubleshoot this problem. As for manual backup, you should not need to do this because the data is meant to be automatically migrated from the events_intraday_YYYYMMDD to the events_YYYYMMDD table by the end of each day.