{% docs FANS_BY_ARTIST_ACCOUNT_ALL_HEAVY_ROTATIONS_DBT %}

This table contains all distinct heavy rotations per fan, COUNTRY_ISO2, account, vendor, artist and date.
{% enddocs %}

{% docs ARTIST_ACCOUNT_UNIQUE_HEAVY_ROTATION_DATES_DBT %}

This table contains all date and account, vendor, artist combinations when heavy rotations took place.
{% enddocs %}

{% docs FANS_BY_ARTIST_ACCOUNT_AE_EVENTS_DAILY_DBT %}

This table contains cumulative new fans per account, vendor, artist based only on AE data.
{% enddocs %}

{% docs FANS_BY_ARTIST_ACCOUNT_COUNTRY_AE_EVENTS_DAILY_DBT %}

This table contains cumulative new fans per account, vendor, artist and country based only on AE data.
{% enddocs %}


{% docs FANS_BY_ARTIST_ACCOUNT_HEAVY_ROTATION_DAILY_WIDE_DBT%}

This table contains heavy rotation, AE and overall fans count per account, vendor, artist and report date in 
a wide format: each aggregation in a separate column.
{% enddocs %}

{% docs FANS_BY_ARTIST_ACCOUNT_HEAVY_ROTATION_DAILY_COUNTRY_WIDE_DBT%}

This table contains heavy rotation, AE and overall fans count per account, vendor, artist, country and report date in 
a wide format: each aggregation in a separate column.
{% enddocs %}

{% docs FANS_BY_ARTIST_ACCOUNT_AE_EVENTS_DBT%}

This table contains fan's first heavy rotation and related country per artist and account.
{% enddocs %}

{% docs GLOBAL_FANS_BY_ARTIST_AE_EVENTS_DAILY_DBT %}

This table contains cumulative new fans per artist based only on AE data.
{% enddocs %}

{% docs GLOBAL_FANS_BY_ARTIST_COUNTRY_AE_EVENTS_DAILY_DBT%}

This table contains daily running data for artist.
{% enddocs %}

{% docs GLOBAL_FANS_BY_ARTIST_HEAVY_ROTATION_DAILY_COUNTRY_WIDE_DBT%}

This table contains heavy rotation, AE and overall fans count per artist, country and report date in 
a wide format: each aggregation in a separate column.
{% enddocs %}

{% docs GLOBAL_FANS_BY_ARTIST_HEAVY_ROTATION_DAILY_WIDE_DBT%}

This table contains heavy rotation, AE and overall fans count per account, vendor, artist and report date in 
a wide format: each aggregation in a separate column.
{% enddocs %}


{% docs INT_AE_EVENTS_KEY_SPLIT_DBT.sql%}

This table contains string processing steps to avoid complex queries in the downstream.
{% enddocs %}