Pazartesi, Kasım 4, 2024

Matomo Google Arşiv SiteID Düzeltme

matomo yüksek çözünürlüklü logo, matomo logosu, matomo nasıl kurulur, matomo hata çözümleri

Google Analytics kullandınız ve gün geldi benim gibi açık kaynaklı ve google’dan daha güzel veri sunan bir araca geçmek istediniz, Matomo bu noktada tam bir kurtarıcı ve oldukça güzel veriler sunuyor, ancak eski verilerinizi aktarma sırasında sitenizi kullanıyorken aktarım yapıyorsanız siteid değişiyor ve eski verileri göremiyorsunuz.

Bu noktada yapılacak çok basit bir şey var, eski verilerin olduğu tablolarda ID değişikliğine gitmek

UPDATE db_archive_blob_2016_01 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_01 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_01 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_02 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_02 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_02 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_03 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_03 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_03 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_04 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_04 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_04 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_05 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_05 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_05 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_06 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_06 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_06 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_07 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_07 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_07 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_08 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_08 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_08 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_09 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_09 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_09 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_10 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_10 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_10 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_11 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_11 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_11 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2016_12 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2016_12 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2016_12 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_01 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_01 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_01 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_02 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_02 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_02 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_03 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_03 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_03 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_04 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_04 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_04 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_05 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_05 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_05 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_06 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_06 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_06 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_07 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_07 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_07 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_08 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_08 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_08 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_09 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_09 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_09 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_10 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_10 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_10 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_11 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_11 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_11 SET idsite = 1 WHERE idsite = 4;

UPDATE db_archive_blob_2017_12 SET idsite = 1 WHERE idsite = 2;
UPDATE db_archive_blob_2017_12 SET idsite = 1 WHERE idsite = 3;
UPDATE db_archive_blob_2017_12 SET idsite = 1 WHERE idsite = 4;

Ardından arşivinizi web sitesi üzerinde görebilirsiniz.