Learn business growth with Google Analytics 4 Forums Google Analytics 4 Generation of daily events_intraday_ tables but no creation of corresponding events_ tables in BigQuery

  • Generation of daily events_intraday_ tables but no creation of corresponding events_ tables in BigQuery

    Posted by Aiden on 25 August 2022 at 11:59 pm

    I’ve been using GA4 to BigQuery Streaming export for about a month because my daily events have exceeded the export limit (2.7 million events vs 1 million events).

    In Google’s documents (https://support.google.com/firebase/answer/7029846?hl=en), it says:
    If the Streaming export option is enabled, a table called events_intraday_YYYYMMDD is created. This table is continually filled with data throughout the day and is supposed to be deleted at the end of each day once the events_YYYYMMDD is complete.

    So, according to this, I thought I’d have events_YYYYMMDD tables for each day in the past and a events_intraday_YYYYMMDD table for the current day. But that’s not what’s happening – I only have events_intraday_YYYYMMDD tables for past days.

    Am I misunderstanding the docs here? Should I be expecting the events_YYYYMMDD tables to be automatically made and filled in?

    If it’s on me to make sure this happens, then do I need to start manually backing this up?

    Bailey replied 10 months, 3 weeks ago 3 Members · 2 Replies
  • 2 Replies
  • Arjun

    Member
    30 November 2022 at 6:35 am

    According to the documentation you’ve mentioned, an events_YYYYMMDD table should be created and filled in for each day, and an events_intraday_YYYYMMDD table for the current day should exists. The events_intraday_YYYYMMDD table is filled continuously throughout the day and should be deleted when its corresponding events_YYYYMMDD table is complete. However, if you only see events_intraday_YYYYMMDD tables for past days, it seems like the process is not functioning as stated in the documentation. You might want to reach out to Google support for further assistance on this issue. You should not have to manually back this up according to the provided documentation.

  • Bailey

    Member
    4 July 2023 at 6:49 am

    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.

Log in to reply.