# View: int_prod_social_spike_stats

**View Name:** int_prod_social_spike_stats
**Table Source:** `INTELLIGENCE.DBT_PROD.SOCIAL_SPIKE_STATS`
**File Path:** `int_prod_social_spike_stats.view.lkml`

## Overview

- **File Size:** 1369 bytes
- **Lines of Code:** 76
- **Dimensions:** 7
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- sql_table_name: INTELLIGENCE.DBT_PROD.SOCIAL_SPIKE_STATS ;;
- derived_table:  { sql: SELECT * FROM intelligence.prod.social_spike_stats WHERE social = {% parameter social %};; }
- dimension: social {

## Dimensions

| Name | Type |
|------|------|
| `date` | date |
| `account_id` | string |
| `name` | string |
| `new_followers_today` | number |
| `avg_new_followers` | number |
| `stdev_new_followers` | number |
| `spike_score` | number |

## Measures

| Name | Type |
|------|------|
| `count_spikes` | count_distinct |

## Derived Table

```sql
sql: SELECT * FROM intelligence.prod.social_spike_stats WHERE social = {% parameter social %
```