How to test missing data from imported data of Google Analytics?

[webysther]

Hi, after migration in manual mode I got plausible working, what I did:

1. Manual backup postgres/clickhouse
2. Restore backup clickhouse (in my case only postgres has problem)
3. Running clean postgres with plausible
4. Backup new postgres to get schema
5. Stop Plausible/postgres
6. Get only data and apply the data from new schema for what is required NOT NULL
7. Start postgres
8. Ingestion of only the new data (the FK is turned off and on)
9. Start again plausible

Everything is working but only a site with old google analytics don't show, I checked on clickhouse for the imported_* table and get the data. I want to know how tables I need to check for the site_id or the SQL used in the filter for "All time" to run local to check what table is missing the connection to start working again:

site_id for this one is 11:

clickhouse-client

USE plausible_events_db;

select count(*) from imported_* where site_id = 11; # have data
select count(*) from imported_custom_events where site_id = 11 # none
select count(*) from ingest_counters where site_id = 11 # none
select count(*) from sessions_v2 where site_id = 11 # none
select count(*) from sessions_v2_backup where site_id = 11 # none

\c plausible_db

plausible_db=# select imported_data from public.sites where id = 11;
                                                                   imported_data                                                                    
----------------------------------------------------------------------------------------------------------------------------------------------------
 {"id": "d562e386-5fe1-4edb-a983-19e6e8ee68ea", "source": "Google Analytics", "status": "ok", "end_date": "2023-06-18", "start_date": "2019-11-08"}
(1 row)

The list of tables I have manually imported for postgres:

COPY public.users
COPY public.sites
COPY public.site_memberships
COPY public.api_keys
COPY public.goals
COPY public.google_auth
COPY public.salts
COPY public.setup_help_emails
COPY public.setup_success_emails

Any direction where I need to check or the SQL to run to check why the historical don't show?