version: 2 models: - name: GOOGLE_ADS__ACCOUNT_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: varchar description: "" tests: - not_null - name: name data_type: varchar description: "" tests: - not_null - name: currency data_type: varchar description: "" tests: - not_null - name: to_usd_conversion_rate data_type: number description: "" tests: - not_null - name: campaigns_count data_type: number description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: GOOGLE_ADS__CAMPAIGN_DBT description: "" tests: - dbt_utils.expression_is_true: arguments: expression: "id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "account_id not like '%.00000%'" - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - source_schema - id columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: varchar description: "" tests: - not_null - name: name data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: global_participant_id data_type: varchar description: "" - name: account_id data_type: varchar description: "" tests: - not_null - name: account_name data_type: varchar description: "" - name: start_at data_type: timestamp_ntz description: "" - name: end_at data_type: timestamp_ntz description: "" - name: status data_type: varchar description: "" - name: currency data_type: varchar description: "" tests: - not_null - name: clicks data_type: number description: "" - name: impressions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: video_views data_type: number description: "" - name: conversions data_type: float description: "" - name: interactions data_type: number description: "" - name: spend data_type: number description: "" - name: spend_usd data_type: number description: "" - name: reporting_url data_type: varchar description: "" - name: ad_set_daily_budget data_type: varchar description: "" - name: ad_set_lifetime_budget data_type: varchar description: "" - name: daily_budget data_type: number description: "" - name: lifetime_budget data_type: number description: "" - name: ad_set_daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "ad_set_daily_budget is not null" - is_null: arguments: where: "ad_set_daily_budget is null" - name: ad_set_lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "ad_set_lifetime_budget is not null" - is_null: arguments: where: "ad_set_lifetime_budget is null" - name: daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "daily_budget is not null" - is_null: arguments: where: "daily_budget is null" - name: lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "lifetime_budget is not null" - is_null: arguments: where: "lifetime_budget is null" - name: targeting_countries data_type: array description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: min_report_date data_type: date description: "The earliest report date for this entity" tests: - not_null - name: max_report_date data_type: date description: "The latest report date for this entity" tests: - not_null - name: action_type data_type: varchar description: "" tests: - not_null - accepted_values: arguments: values: - VIEWS - CLICKS - name: actions data_type: number description: "" tests: - not_null - name: rate_type data_type: varchar description: "" tests: - not_null - name: rate data_type: number description: "" tests: - not_null - name: CTR description: Click Through Rate - name: cost_per_action data_type: number description: "" tests: - not_null - name: cost_per_action_usd data_type: number description: "" tests: - not_null - name: COST_PER_IMPRESSION description: Cost Per Impression tests: - not_null - name: COST_PER_IMPRESSION_USD description: Cost Per Impression in USD tests: - not_null - name: GOOGLE_ADS__AD_SET_COUNTRY_DBT description: "" tests: - dbt_utils.expression_is_true: arguments: expression: "id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "campaign_id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "account_id not like '%.00000%'" - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - source_schema - id - country_code columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: varchar description: "" tests: - not_null - name: country_code data_type: varchar description: "" - name: name data_type: varchar description: "" tests: - not_null - name: campaign_id data_type: varchar description: "" tests: - not_null - name: campaign_name data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: campaign_objective data_type: varchar description: "" tests: - not_null - name: campaign_global_participant_id data_type: varchar description: "" - name: account_id data_type: varchar description: "" tests: - not_null - name: account_name data_type: varchar description: "" - name: start_at data_type: timestamp_ntz description: "" - name: end_at data_type: timestamp_ntz description: "" - name: status data_type: varchar description: "" - name: currency data_type: varchar description: "" tests: - not_null - name: clicks data_type: number description: "" - name: impressions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: video_views data_type: number description: "" - name: conversions data_type: float description: "" - name: interactions data_type: number description: "" - name: spend data_type: number description: "" - name: spend_usd data_type: number description: "" - name: reporting_url data_type: varchar description: "" - name: daily_budget data_type: varchar description: "" - name: lifetime_budget data_type: varchar description: "" - name: campaign_daily_budget data_type: number description: "" - name: campaign_lifetime_budget data_type: number description: "" - name: daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "daily_budget is not null" - is_null: arguments: where: "daily_budget is null" - name: lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "lifetime_budget is not null" - is_null: arguments: where: "lifetime_budget is null" - name: campaign_daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "campaign_daily_budget is not null" - is_null: arguments: where: "campaign_daily_budget is null" - name: campaign_lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "campaign_lifetime_budget is not null" - is_null: arguments: where: "campaign_lifetime_budget is null" - name: targeting_countries data_type: array description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: min_report_date data_type: date description: "The earliest report date for this entity" tests: - not_null - name: max_report_date data_type: date description: "The latest report date for this entity" tests: - not_null - name: action_type data_type: varchar description: "" tests: - not_null - accepted_values: arguments: values: - VIEWS - CLICKS - name: actions data_type: number description: "" tests: - not_null - name: rate_type data_type: varchar description: "" tests: - not_null - name: rate data_type: number description: "" tests: - not_null - name: CTR description: Click Through Rate - name: cost_per_action data_type: number description: "" tests: - not_null - name: cost_per_action_usd data_type: number description: "" tests: - not_null - name: COST_PER_IMPRESSION description: Cost Per Impression tests: - not_null - name: COST_PER_IMPRESSION_USD description: Cost Per Impression in USD tests: - not_null - name: GOOGLE_ADS__AD_SET_DBT description: "" tests: - dbt_utils.expression_is_true: arguments: expression: "id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "campaign_id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "account_id not like '%.00000%'" - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - source_schema - id columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: varchar description: "" tests: - not_null - name: name data_type: varchar description: "" tests: - not_null - name: campaign_id data_type: varchar description: "" tests: - not_null - name: campaign_name data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: campaign_objective data_type: varchar description: "" tests: - not_null - name: campaign_global_participant_id data_type: varchar description: "" - name: account_id data_type: varchar description: "" tests: - not_null - name: account_name data_type: varchar description: "" - name: start_at data_type: timestamp_ntz description: "" - name: end_at data_type: timestamp_ntz description: "" - name: status data_type: varchar description: "" - name: currency data_type: varchar description: "" tests: - not_null - name: clicks data_type: number description: "" - name: impressions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: video_views data_type: number description: "" - name: conversions data_type: float description: "" - name: interactions data_type: number description: "" - name: spend data_type: number description: "" - name: spend_usd data_type: number description: "" - name: reporting_url data_type: varchar description: "" - name: daily_budget data_type: varchar description: "" - name: lifetime_budget data_type: varchar description: "" - name: campaign_daily_budget data_type: number description: "" - name: campaign_lifetime_budget data_type: number description: "" - name: daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "daily_budget is not null" - is_null: arguments: where: "daily_budget is null" - name: lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "lifetime_budget is not null" - is_null: arguments: where: "lifetime_budget is null" - name: campaign_daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "campaign_daily_budget is not null" - is_null: arguments: where: "campaign_daily_budget is null" - name: campaign_lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "campaign_lifetime_budget is not null" - is_null: arguments: where: "campaign_lifetime_budget is null" - name: targeting_countries data_type: array description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: min_report_date data_type: date description: "The earliest report date for this entity" tests: - not_null - name: max_report_date data_type: date description: "The latest report date for this entity" tests: - not_null - name: action_type data_type: varchar description: "" tests: - not_null - accepted_values: arguments: values: - VIEWS - CLICKS - name: actions data_type: number description: "" tests: - not_null - name: rate_type data_type: varchar description: "" tests: - not_null - name: rate data_type: number description: "" tests: - not_null - name: CTR description: Click Through Rate - name: cost_per_action data_type: number description: "" tests: - not_null - name: cost_per_action_usd data_type: number description: "" tests: - not_null - name: COST_PER_IMPRESSION description: Cost Per Impression tests: - not_null - name: COST_PER_IMPRESSION_USD description: Cost Per Impression in USD tests: - not_null - name: GOOGLE_ADS__AD_DBT description: "" tests: - dbt_utils.expression_is_true: arguments: expression: "id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "campaign_id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "account_id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "ad_set_id not like '%.00000%'" - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - source_schema - id - creative_id columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: varchar description: "" tests: - not_null - name: name data_type: varchar description: "" tests: - not_null - name: status data_type: varchar description: "" - name: account_id data_type: varchar description: "" tests: - not_null - name: campaign_id data_type: varchar description: "" tests: - not_null - name: campaign_name data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: campaign_objective data_type: varchar description: "" tests: - not_null - name: campaign_global_participant_id data_type: varchar description: "" - name: ad_set_id data_type: varchar description: "" tests: - not_null - name: ad_set_name data_type: varchar description: "" tests: - not_null - name: ad_set_start_at data_type: timestamp_ntz description: "" tests: - not_null - name: ad_set_end_at data_type: timestamp_ntz description: "" tests: - not_null - name: creative_id data_type: varchar description: "" tests: - not_null - name: creative_image_url data_type: varchar description: "" - name: creative_video_url data_type: varchar description: "" - name: image_url data_type: variant description: "" - name: currency data_type: varchar description: "" tests: - not_null - name: clicks data_type: number description: "" - name: impressions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: video_views data_type: number description: "" - name: conversions data_type: float description: "" - name: interactions data_type: number description: "" - name: spend data_type: number description: "" - name: spend_usd data_type: number description: "" - name: reporting_url data_type: varchar description: "" - name: ad_set_daily_budget data_type: varchar description: "" - name: ad_set_lifetime_budget data_type: varchar description: "" - name: campaign_daily_budget data_type: number description: "" - name: campaign_lifetime_budget data_type: number description: "" - name: ad_set_daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "ad_set_daily_budget is not null" - is_null: arguments: where: "ad_set_daily_budget is null" - name: ad_set_lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "ad_set_lifetime_budget is not null" - is_null: arguments: where: "ad_set_lifetime_budget is null" - name: campaign_daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "campaign_daily_budget is not null" - is_null: arguments: where: "campaign_daily_budget is null" - name: campaign_lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "campaign_lifetime_budget is not null" - is_null: arguments: where: "campaign_lifetime_budget is null" - name: targeting_countries data_type: array description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: min_report_date data_type: date description: "The earliest report date for this entity" tests: - not_null - name: max_report_date data_type: date description: "The latest report date for this entity" tests: - not_null - name: action_type data_type: varchar description: "" tests: - not_null - accepted_values: arguments: values: - VIEWS - CLICKS - name: actions data_type: number description: "" tests: - not_null - name: rate_type data_type: varchar description: "" tests: - not_null - name: rate data_type: number description: "" tests: - not_null - name: CTR description: Click Through Rate - name: cost_per_action data_type: number description: "" tests: - not_null - name: cost_per_action_usd data_type: number description: "" tests: - not_null - name: COST_PER_IMPRESSION description: Cost Per Impression tests: - not_null - name: COST_PER_IMPRESSION_USD description: Cost Per Impression in USD tests: - not_null - name: GOOGLE_ADS__CAMPAIGN_COUNTRY_DBT description: "" tests: - dbt_utils.expression_is_true: arguments: expression: "id not like '%.00000%'" - dbt_utils.expression_is_true: arguments: expression: "account_id not like '%.00000%'" - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - source_schema - id - country_code columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: varchar description: "" tests: - not_null - name: country_code data_type: varchar description: "" - name: name data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: global_participant_id data_type: varchar description: "" - name: account_id data_type: varchar description: "" tests: - not_null - name: account_name data_type: varchar description: "" - name: start_at data_type: timestamp_ntz description: "" - name: end_at data_type: timestamp_ntz description: "" - name: status data_type: varchar description: "" - name: currency data_type: varchar description: "" tests: - not_null - name: clicks data_type: number description: "" - name: impressions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: video_views data_type: number description: "" - name: conversions data_type: float description: "" - name: interactions data_type: number description: "" - name: spend data_type: number description: "" - name: spend_usd data_type: number description: "" - name: reporting_url data_type: varchar description: "" - name: ad_set_daily_budget data_type: varchar description: "" - name: ad_set_lifetime_budget data_type: varchar description: "" - name: daily_budget data_type: number description: "" - name: lifetime_budget data_type: number description: "" - name: ad_set_daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "ad_set_daily_budget is not null" - is_null: arguments: where: "ad_set_daily_budget is null" - name: ad_set_lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "ad_set_lifetime_budget is not null" - is_null: arguments: where: "ad_set_lifetime_budget is null" - name: daily_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "daily_budget is not null" - is_null: arguments: where: "daily_budget is null" - name: lifetime_budget_usd data_type: number description: "" tests: - not_null: arguments: where: "lifetime_budget is not null" - is_null: arguments: where: "lifetime_budget is null" - name: targeting_countries data_type: array description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: min_report_date data_type: date description: "The earliest report date for this entity" tests: - not_null - name: max_report_date data_type: date description: "The latest report date for this entity" tests: - not_null - name: action_type data_type: varchar description: "" tests: - not_null - accepted_values: arguments: values: - VIEWS - CLICKS - name: actions data_type: number description: "" tests: - not_null - name: rate_type data_type: varchar description: "" tests: - not_null - name: rate data_type: number description: "" tests: - not_null - name: CTR description: Click Through Rate - name: cost_per_action data_type: number description: "" tests: - not_null - name: cost_per_action_usd data_type: number description: "" tests: - not_null - name: COST_PER_IMPRESSION description: Cost Per Impression tests: - not_null - name: COST_PER_IMPRESSION_USD description: Cost Per Impression in USD tests: - not_null - name: GOOGLE_ADS__CAMPAIGN_BENCHMARK_BY_ACCOUNT_DBT description: "" tests: - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - vendor_id - subaccount_id - platform - objective columns: - name: vendor_id data_type: number description: "" tests: - not_null - name: subaccount_id data_type: number description: "" tests: - not_null - name: platform data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: avg_rate data_type: number description: "" tests: - not_null - name: GOOGLE_ADS__CAMPAIGN_BENCHMARK_BY_ACCOUNT_ARTIST_DBT description: "" tests: - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - vendor_id - subaccount_id - global_participant_id - platform - objective columns: - name: vendor_id data_type: number description: "" tests: - not_null - name: subaccount_id data_type: number description: "" tests: - not_null - name: global_participant_id data_type: varchar description: "" tests: - not_null - name: platform data_type: varchar description: "" - name: objective data_type: varchar description: "" tests: - not_null - name: avg_rate data_type: number description: "" tests: - not_null - name: GOOGLE_ADS__CAMPAIGN_BENCHMARK_BY_ACCOUNT_ARTIST_COUNTRY_DBT description: "" tests: - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - vendor_id - subaccount_id - global_participant_id - country_code - platform - objective columns: - name: vendor_id data_type: number description: "" tests: - not_null - name: subaccount_id data_type: number description: "" tests: - not_null - name: global_participant_id data_type: varchar description: "" tests: - not_null - name: country_code data_type: varchar description: "" tests: - not_null - name: platform data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: avg_rate data_type: number description: "" - name: GOOGLE_ADS__CAMPAIGN_BENCHMARK_BY_ACCOUNT_COUNTRY_DBT description: "" tests: - dbt_utils.unique_combination_of_columns: arguments: combination_of_columns: - vendor_id - subaccount_id - country_code - platform - objective columns: - name: vendor_id data_type: number description: "" tests: - not_null - name: subaccount_id data_type: number description: "" tests: - not_null - name: platform data_type: varchar description: "" tests: - not_null - name: country_code data_type: varchar description: "" tests: - not_null - name: objective data_type: varchar description: "" tests: - not_null - name: avg_rate data_type: number description: "" tests: - not_null