Welcome to the auto-generated documentation for your dbt project!
Navigation
You can use the Project and Database navigation tabs on the left side of the window to explore the models
in your project.
Project Tab
The Project tab mirrors the directory structure of your dbt project. In this tab, you can see all of the
models defined in your dbt project, as well as models imported from dbt packages.
Database Tab
The Database tab also exposes your models, but in a format that looks more like a database explorer. This view
shows relations (tables and views) grouped into database schemas. Note that ephemeral models are not shown
in this interface, as they do not exist in the database.
Graph Exploration
You can click the blue icon on the bottom-right corner of the page to view the lineage graph of your models.
On model pages, you'll see the immediate parents and children of the model you're exploring. By clicking the Expand
button at the top-right of this lineage pane, you'll be able to see all of the models that are used to build,
or are built from, the model you're exploring.
Once expanded, you'll be able to use the --select and --exclude model selection syntax to filter the
models in the graph. For more information on model selection, check out the dbt docs.
Note that you can also right-click on models to interactively filter and explore the graph.
Provides a summary of conversion events at the individual ad level, aggregating key metrics by event and day such as view-through and click-through conversions.
columns:source_relation,source_relationcolumns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idShow 7 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }}
with base as (
select *
from {{ ref('stg_reddit_ads__ad_conversions_report_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__ad_conversions_report_tmp')),
staging_columns=get_ad_conversions_report_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='reddit_ads_union_schemas',
union_database_variable='reddit_ads_union_databases')
}}
from base
),
final as (
select
source_relation,
_fivetran_synced,
account_id,
ad_id,
date as date_day,
lower(event_name) as event_name,
coalesce(total_items,0) as total_items,
coalesce(total_value,0) as total_value,
coalesce(click_through_conversion_attribution_window_month,0) as conversions,
coalesce(view_through_conversion_attribution_window_month,0) as view_through_conversions
{{ fivetran_utils.fill_pass_through_columns('reddit_ads__ad_conversions_passthrough_metrics') }}
from fields
)
select *
from final
stg_reddit_ads__ad
model
Each record represents information about each ad.
columns:source_relation,source_relationcolumns:account_id,account_idcolumns:ad_group_id,ad_group_idShow 10 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }}
with base as (
select *
from {{ ref('stg_reddit_ads__ad_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__ad_tmp')),
staging_columns=get_ad_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='reddit_ads_union_schemas',
union_database_variable='reddit_ads_union_databases')
}}
from base
),
final as (
select
source_relation,
account_id,
ad_group_id,
campaign_id,
click_url,
configured_status,
effective_status,
id as ad_id,
is_processing,
name as ad_name,
post_id,
post_url,
rejection_reason
from fields
)
select *
from final
stg_reddit_ads__account_tmp
model
columns:id,idcolumns:_fivetran_synced,_fivetran_syncedcolumns:attribution_type,attribution_typeShow 6 more
Each record represents a summary of events for each given date and account.
columns:source_relation,source_relationcolumns:account_id,account_idcolumns:clicks,clicksShow 4 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }}
with base as (
select *
from {{ ref('stg_reddit_ads__account_report_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__account_report_tmp')),
staging_columns=get_account_report_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='reddit_ads_union_schemas',
union_database_variable='reddit_ads_union_databases')
}}
from base
),
final as (
select
source_relation,
account_id,
coalesce(clicks,0) as clicks,
date as date_day,
coalesce(impressions,0) as impressions,
region,
coalesce((spend/1000000),0) as spend
{{ fivetran_utils.fill_pass_through_columns('reddit_ads__account_passthrough_metrics') }}
from fields
)
select *
from final
stg_reddit_ads__account_conversions_report_tmp
model
columns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idcolumns:avg_value,avg_valueShow 10 more
Provides a summary of conversion events at the account level, aggregating key metrics by event and day such as view-through and click-through conversions.
columns:source_relation,source_relationcolumns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idShow 6 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }}
with base as (
select *
from {{ ref('stg_reddit_ads__account_conversions_report_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__account_conversions_report_tmp')),
staging_columns=get_account_conversions_report_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='reddit_ads_union_schemas',
union_database_variable='reddit_ads_union_databases')
}}
from base
),
final as (
select
source_relation,
_fivetran_synced,
account_id,
date as date_day,
lower(event_name) as event_name,
coalesce(total_items,0) as total_items,
coalesce(total_value,0) as total_value,
coalesce(click_through_conversion_attribution_window_month,0) as conversions,
coalesce(view_through_conversion_attribution_window_month,0) as view_through_conversions
{{ fivetran_utils.fill_pass_through_columns('reddit_ads__account_conversions_passthrough_metrics') }}
from fields
)
select *
from final
stg_reddit_ads__account
model
Each record in this table represents information about an account.
columns:source_relation,source_relationcolumns:attribution_type,attribution_typecolumns:click_attribution_window,click_attribution_windowShow 6 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }}
with base as (
select *
from {{ ref('stg_reddit_ads__account_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__account_tmp')),
staging_columns=get_account_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='reddit_ads_union_schemas',
union_database_variable='reddit_ads_union_databases')
}}
from base
),
final as (
select
source_relation,
attribution_type,
click_attribution_window,
cast(created_at as {{ dbt.type_timestamp() }}) as created_at,
currency,
id as account_id,
status,
time_zone_id,
view_attribution_window
from fields
)
select *
from final
reddit_ads_campaign_report_data
seed
columns:account_id,account_idcolumns:campaign_id,campaign_idcolumns:date,dateShow 48 more
reddit_ads_campaign_data
seed
columns:id,idcolumns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idShow 6 more
reddit_ads_campaign_conversions
seed
columns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idcolumns:avg_value,avg_valueShow 11 more
reddit_ads_ad_report_data
seed
columns:account_id,account_idcolumns:ad_id,ad_idcolumns:date,dateShow 48 more
reddit_ads_ad_group_report_data
seed
columns:account_id,account_idcolumns:ad_group_id,ad_group_idcolumns:date,dateShow 48 more
reddit_ads_ad_group_data
seed
columns:account_id,account_idcolumns:id,idcolumns:_fivetran_synced,_fivetran_syncedShow 13 more
reddit_ads_ad_group_conversions
seed
columns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idcolumns:ad_group_id,ad_group_idShow 11 more
reddit_ads_ad_data
seed
columns:id,idcolumns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idShow 13 more
reddit_ads_ad_conversions
seed
columns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idcolumns:ad_id,ad_idShow 11 more
reddit_ads_account_report_data
seed
columns:account_id,account_idcolumns:date,datecolumns:_fivetran_synced,_fivetran_syncedShow 47 more
reddit_ads_account_data
seed
columns:id,idcolumns:_fivetran_synced,_fivetran_syncedcolumns:attribution_type,attribution_typeShow 6 more
reddit_ads_account_conversions
seed
columns:_fivetran_synced,_fivetran_syncedcolumns:account_id,account_idcolumns:avg_value,avg_valueShow 10 more