{% docs STG_SME_EMAIL_CLICK_EVENT_DBT %}
Staging table holding references to SME email click events.
{% enddocs %}

{% docs STG_SME_EMAIL_OPEN_EVENT_DBT %}
Staging table holding references to SME email open events.
{% enddocs %}

{% docs STG_SENDGRID_EMAIL_CLICK_EVENT_DBT %}
Staging table holding references to Sendgrid email click events from artists.
{% enddocs %}

{% docs STG_SENDGRID_EMAIL_OPEN_EVENT_DBT %}
Staging table holding references to Sendgrid email open events from artists.
{% enddocs %}

{% docs STG_SENDGRID_CUSTOM_LIST_EMAIL_CLICK_EVENT_DBT %}
Staging table holding references to Sendgrid email click events from custom lists.
{% enddocs %}

{% docs STG_SENDGRID_CUSTOM_LIST_EMAIL_OPEN_EVENT_DBT %}
Staging table holding references to Sendgrid email open events from custom lists.
{% enddocs %}

{% docs STG_SME_SHOPIFY_ORDER_EVENT_DBT %}
Staging table holding references to SME Shopify orders.
{% enddocs %}

{% docs STG_SHOPIFY_ORDER_LINE_EVENT_DBT %}
Staging table holding references to Shopify Order Lines.
{% enddocs %}

{% docs STG_SME_CRM_TICKET_EVENT_DBT %}
Staging table holding references to SME ticket events.
{% enddocs %}

{% docs STG_SME_CRM_NEWSLETTER_EVENT_DBT %}
Staging table holding references to SME newsletter subscriptions.
{% enddocs %}

{% docs STG_SME_AE_ACTIVITY_EVENT_DBT %}
Staging table holding references to aggregated AE events by artist and fan.
{% enddocs %}

{% docs STG_SME_AE_ACTIVITY_FEED_DBT %}
Staging table holding references to AE events collected by SME main processes.
{% enddocs %}

{% docs INT_STG_AE_MEMBERS_DBT %}
Staging table holding AE related fan personal data.
{% enddocs %}

{% docs STG_SONGWHIP_AE_ACTIVITY_EVENT_DBT %}
Staging table holding references to AE events collected by Songwhip.
{% enddocs %}

{% docs STG_SME_CRM_CAMPAIGN_EVENT_DBT %}
Staging table holding references to SME campaigns.
{% enddocs %}

{% docs INT_CRM_FAN_DBT %}

This view is made to hold fan related data extracted from CRM that can be easily
referenced in downstream models. By having big  SQL query in a separate model, then it
will make it easier to build and understand downstream models.

{% enddocs %}

{% docs INT_EVENT_COLLECTION_JOIN %}

This view is made to hold relationships between events and collections. 
By having big  SQL query in a separate model, then it will make it easier to 
build and understand downstream models.
{% enddocs %}

{% docs STG_HEAVY_ROTATION_DBT %}

This table contains heavy rotation related events collected from Appreciation Engine.

This table is filled with incremental strategy based on the LOAD_TIMESTAMP column. 
That is why first load takes longer time but next incremental loads are faster.

{% enddocs %}


{% docs GLOBAL_PARTICIPANT_CRM_ARTIST_DBT %}

This table contains a mapping between Global Participant ID and CRM Artist ID of the Artists that are currently ingested into Fansifter.

{% enddocs %}

{% docs SME_ACCOUNT_DBT %}

This table contains a mapping between Accounts and SME CRM Labels, AE Business Units and Salesforce Marketing Cloud Business units.
{% enddocs %}

{% docs GLOBAL_PARTICIPANT_ACCOUNT_DBT %}

This table contains a list of Global Participants along with Accounts that we ingest their data for. This can be treated as a temporary label roster before an official one is implemented.
{% enddocs %}

{% docs INT_PRIMARY_FANS_DBT %}

This table has list of fans and artist combinations for only those fans who have other data features beside AE.
{% enddocs %}

{% docs STG_EXTERNAL_EVENT_DBT %}

Table holding all the events from different sources.
{% enddocs %}

{% docs INT_EXTERNAL_EVENT_DBT %}

Ephemeral table with additional logic applied to raw external events (email validation, joint ventures, etc.)
{% enddocs %}

{% docs STG_FAN_EMAIL_DBT %}

Python model to validate email syntax and exclude block-listed/disposable emails.
{% enddocs %}

{% docs STG_SME_CRM_CUSTOM_LIST_CAMPAIGN_EVENT_DBT %}

Staging table holding references to custom label lists related campaign data from CRM.
{% enddocs %}

{% docs STG_SME_CRM_CUSTOM_LIST_EMAIL_CLICK_EVENT_DBT %}

Staging table holding references to custom label lists related email click events from CRM.
{% enddocs %}

{% docs STG_SME_CRM_CUSTOM_LIST_EMAIL_OPEN_EVENT_DBT %}

Staging table holding references to custom label lists related email open events from CRM.
{% enddocs %}

{% docs STG_SME_CRM_CUSTOM_LIST_NEWSLETTER_EVENT_DBT %}

Staging table holding references to custom label lists related newsletter data from CRM.
{% enddocs %}

{% docs STG_SME_CRM_CUSTOM_LIST_TICKET_EVENT_DBT %}

Staging table holding references to custom label lists related concert ticket events from CRM.
{% enddocs %}

{% docs INT_ARTIST_EVENT_COLLECTION %}

Ephemeral table referencing only artist related events.
{% enddocs %}

{% docs INT_CUSTOM_LIST_EVENT_COLLECTION %}

Ephemeral table referencing only custom list related events.
{% enddocs %}

{% docs STG_SME_FILEUPLOAD_CAMPAIGN_EVENT_DBT %}

Staging table holding references to events collected from manual file upload process.
{% enddocs %}

{% docs STG_CLEAN_FAN_MOBILE_PHONE_DBT %}

Cleaned phone numbers of all fans after initial ingestion.
{% enddocs %}

{% docs STG_DEDUPLICATED_EXTERNAL_EVENTS_BY_FAN_ID_DBT %}

Staging table where phone only fans have been matched to fans having email
based id and phone.
{% enddocs %}

{% docs STG_DEDUPLICATED_EXTERNAL_EVENTS_DBT %}

Staging table where fans who still have phones only have been assigned
similar id based on cleaned phone.
{% enddocs %}

{% docs STG_BIT_ARTIST_OPTIN_EVENT_DBT %}

This data is ingested from Bandsintown source and contains data about fans and their opt in for
different Sony artists.
{% enddocs %}

{% docs STG_BIT_RSVP_EVENT_DBT %}

This data is ingested from Bandsintown source and contains data about fans RSVP events for
different Sony artists.
{% enddocs %}

{% docs STG_BIT_ARTIST_TRACKING_EVENT_DBT %}

This data is ingested from Bandsintown source and contains data about fans following
different Sony artists.
{% enddocs %}

{% docs STG_BIT_TICKET_CLICK_EVENT_DBT %}

This data is ingested from Bandsintown source and contains data about fans expressing
their intent to buy tickets from different Sony artists.
{% enddocs %}

{% docs STG_BIT_USER_PROFILE_DBT %}

Table holding unique Bandsintown user_id values with respective email and mobile values.
Used as a lookup table for BIT ingestion models.
{% enddocs %}


{% docs STG_TWILIO_SUBSCRIPTION_EVENT_DBT %}

Table holding Twilio SMS subscriptions.
{% enddocs %}


{% docs STG_TWILIO_FAN_MESSAGE_EVENT_DBT %}

Table holding Twilio inbound SMS messages from fans excluding setup messages.
{% enddocs %}

{% docs STG_SME_FILEUPLOAD_CUSTOM_LIST_CAMPAIGN_EVENT_DBT %}

Staging table holding custom list related references to events collected from manual file upload process.
{% enddocs %}

{% docs STG_SONGWHIP_CUSTOM_PAGE_EVENT_DBT %}

Staging table holding custom page (access to exclusive content) events collected from Songwhip.
{% enddocs %}

{% docs STG_SONGWHIP_PRESAVE_EVENT_DBT %}

Staging table holding presave events collected from Songwhip.
{% enddocs %}