# Звіти | статистика

## Загальна інформація

Статистика переглядаємо в дашборді snowflake [https://fb69655.snowflakecomputing.com/console](https://fb69655.snowflakecomputing.com/console)  
База [PROVIDER\_DATA](https://app.snowflake.com/oua72789/fb69655/#/data/databases/PROVIDER_DATA) та група таблиць **[BI](https://app.snowflake.com/oua72789/fb69655/#/data/databases/PROVIDER_DATA/schemas/BI)**

Уточнення від сапорту по таблицям:  
`V_RSOC_PARTNER_CLICKFARE_REPORT_IM` -  
it's what we are sending to clickflare, The data is on click level, its good for double checking CF.

`PROVIDER_DATA/BI/V_RSOC_HOURLY_IM` is a view based on `RSOC_HOURLY_VERSION_IM`, the same data, it have max(`PIPED_AT`) and it extracts `CAMPAIGN_ID` from campain or adset  
`PIPED_AT` is time when record was processed, I think conversion is `PST_TIMESTAMP` but need to recheck.  
  
`CAMPAIGN_ID` - це ідентифікатор кампанії джерела трафіку.

## Дашборди зі статистикою

[https://app.snowflake.com/oua72789/fb69655/#/helgateam-v\_rsoc\_hourly\_im-dIdeAaBmv](https://app.snowflake.com/oua72789/fb69655/#/helgateam-v_rsoc_hourly_im-dIdeAaBmv) [https://app.snowflake.com/oua72789/fb69655/#/helgateam-rsoc\_hourly\_version\_im-d22Dh4gEB](https://app.snowflake.com/oua72789/fb69655/#/helgateam-rsoc_hourly_version_im-d22Dh4gEB) [https://app.snowflake.com/oua72789/fb69655/#/helgateam-v\_rsoc\_partner\_clickfare\_report\_im-daH9KHphd](https://app.snowflake.com/oua72789/fb69655/#/helgateam-v_rsoc_partner_clickfare_report_im-daH9KHphd) звірятися з трекером