CODEWITHSUNDEEP
firebasegoogle-analytics-firebase
Imran Qadir Baksh - Baloch
Imran Qadir Baksh - Baloch

Reputation: 34034

Firebase first_open count becoming less

Yesterday, when I ran the query,

SELECT
  Count(*)
FROM 
  `analytics_xxx.events_*`
 
WHERE 
  event_name = 'first_open'

It return 571 but today when I ran the same query it was 560. How come the count become less in one day. Is Firebase deleting the first_open event from the database?

Upvotes: 1

Views: 333

Answers (1)

Priyashree Bhadra
Priyashree Bhadra

Reputation: 3607

From the SQL query you provided, this would return just the daily export tables ('events_*').Further, you have stated that you set the BQ table to allow appends manually, however in BQ if the default expiration is set, these tables would be removed as per this documentation.

I would ask you to try to query a specific time period that is known not to expire and monitor that. An example for a query like this could be;

SELECT
    Count(*)
FROM 
      `analytics_xxx.events_2021102*`
WHERE 
      event_name = 'first_open'

This should give a consistent number of results as these tables should fall within the default retention period. If you can identify a specific set of tables where there is a reduction in the count of records, even after this, we can look into it. Otherwise, given the broad scope of the selection ('events_*'), it is difficult to provide a definite answer however the table retention is the likely cause.

Have a look at how the exports follow this, in which it is mentioned how the tables are named.

Upvotes: 1

Related Questions