{% docs INT_FAN_LOCATION_DBT %}

This table contains fan related location data that is not dependant on fans relationship
with different artists. Location can be fetched either from CRM, Appreciation engine,
 Shopify of Songwhip. City and region in this table are not cleaned yet.
Country values are in ISO2 format.

{% enddocs %}

{% docs FAN_GENDER_DBT %}

This table contains fan related gender data that is not dependant on fans relationship
with different artists. Gender can be fetched either from CRM or Appreciation engine.

{% enddocs %}

{% docs FAN_ARTIST_CUSTOM_LIST_FIRST_LAST_EVENT_DBT %}

This table contains first, last date, country per fan, vendor, subaccount and artist.

{% enddocs %}

{% docs FAN_FIRST_LAST_EVENT_DBT %}

This table contains first, last date, country per fan, vendor, subaccount and artist.

{% enddocs %}

{% docs FAN_AGE_DBT %}

This table contains fan's age range. Age range is calculated using date of birth either
from CRM or Appreciation Engine.
{% enddocs %}

{% docs FAN_GENRE_DBT %}

This table contains fan preferred genre values extracted from the CRM PREFERENCE_C table.
Values are split on `;`, uppercased, cleaned to contain only alphanumeric characters and
underscores (e.g. `DANCE / ELECTRONIC` becomes `DANCE_ELECTRONIC`), and aggregated into
an array per fan. Only genres with more than 200 associated fans are included.
{% enddocs %}

{% docs FAN_LANGUAGE_DBT %}

This table contains fan preferred language values extracted from the CRM FAN_C table.
Values are split on `,`, normalized to ISO 639-1 two-character codes using the langcodes
library, and aggregated into an array per fan. The original unsplit string is preserved
in LANGUAGE_ORIGINAL for auditing purposes.
{% enddocs %}

{% docs FAN_DSP_DBT %}

This table contains fan related DSP values like Deezer, Spotify, Apple music, Amazon or 
YouTube. This is extracted from data stored in CRM.
{% enddocs %}

{% docs FAN_ARTIST_ACQUISITION_CHANNEL_DBT %}

When fans engage with artists then this can take place through marketing campaign or
by signing up for newsletter. Each of those are related to a specific channel. This
table contains unique value per fan, vendor, subaccount and artist combination.
{% enddocs %}

{% docs GLOBAL_FAN_ARTIST_ACQUISITION_CHANNEL_DBT %}

When fans engage with artists then this can take place through marketing campaign or
by signing up for newsletter. Each of those are related to a specific channel. This
table contains unique value per fan and  artist combination.
{% enddocs %}

{% docs FAN_CUSTOM_LIST_ACQUISITION_CHANNEL_DBT %}

When fans sign up for custom lsits then this can take place through marketing campaign or
by signing up for newsletter. Each of those are related to a specific channel. This
table contains unique value per fan, vendor, subaccount and custom list combination.
{% enddocs %}

{% docs FAN_HEAVY_ROTATION_DBT %}

This table contains fan's heavy rotations per artist. Each
fan in this table can have heavy rotation activities related to multiple artists.
{% enddocs %}

{% docs FAN_SHOPIFY_SPEND_DBT %}

This table contains fan's total Shopify spendings per vendor, subaccount and artist. Each fan
in this table can have bought merchandize from multiple artists.
{% enddocs %}

{% docs GLOBAL_FAN_SHOPIFY_SPEND_DBT %}

This table contains fan's total Shopify spendings per artist. Each fan
in this table can have bought merchandize from multiple artists.
{% enddocs %}

{% docs ARTIST_MAX_SPEND_DBT %}

This table contains maximum spend per vendor, account and artist.
{% enddocs %}

{% docs FAN_ARTIST_DBT %}

This table contains distinct fan-account-artist combinations.
{% enddocs %}

{% docs FAN_ARTIST_MARKETING_CONSENT_DBT %}

This table contains fan-account-artist level information about available marketing consent.
{% enddocs %}

{% docs FAN_MARKETING_CONSENT_DBT %}

This table contains fan level information about available marketing consent.
{% enddocs %}

{% docs FAN_LOCATION_DBT %}

This table is based on INT_FAN_LOCATION_DBT model but  city and region values 
are either cleaned values or missing values in case cleaning failed.
{% enddocs %}

{% docs FAN_ARTIST_CUSTOM_LIST_LAST_EMAIL_EVENT_DBT %}

This table contains last email activity related date per fan, artist and custom list.

{% enddocs %}


{% docs INT_FAN_SALESCLOUD_RETARGET_CONSENT %}
This table contains Sales Cloud fans obtained via DE, AT, NO forms along with their marketing consent.
{% enddocs %}

{% docs FAN_ARTIST_TEXT_CONSENT_DBT %}
This table contains Text consents. Currently based on Twilio/test source/source type combination.
{% enddocs %}

{% docs FAN_ARTIST_LAST_SMS_EVENT_DBT %}

This table contains last date inbound SMS date for fan/artist combination.

{% enddocs %}