version: 2 models: - name: STG_GOOGLE_ADS__CAMPAIGN_HISTORY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: base_campaign_id data_type: number description: "" - name: account_id data_type: number description: "" tests: - not_null - name: name data_type: varchar description: "" tests: - not_null - name: start_at data_type: timestamp_ntz description: "" tests: - not_null - name: end_at data_type: timestamp_ntz description: "" tests: - not_null - name: status data_type: varchar description: "" tests: - not_null - name: payment_mode data_type: varchar description: "" - name: advertising_channel_type data_type: varchar description: "" tests: - not_null - name: updated_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__AD_SET_COUNTRY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: account_id data_type: number description: "" tests: - not_null - name: report_date data_type: date description: "" tests: - not_null - name: video_views data_type: number description: "" - name: clicks data_type: number description: "" - name: conversions data_type: float description: "" - name: country_criterion_id data_type: number description: "" - name: campaign_id data_type: number description: "" tests: - not_null - name: impressions data_type: number description: "" - name: all_conversions data_type: float description: "" - name: cost_micros data_type: number description: "" - name: interaction_event_types data_type: varchar description: "" - name: interactions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__AD_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: account_id data_type: number description: "" tests: - not_null - name: report_date data_type: timestamp_ntz description: "" - name: conversions_value data_type: float description: "" - name: conversions data_type: float description: "" - name: interactions data_type: number description: "" - name: interaction_event_types data_type: varchar description: "" - name: campaign_id data_type: number description: "" tests: - not_null - name: impressions data_type: number description: "" - name: view_through_conversions data_type: number description: "" - name: ad_set_id data_type: number description: "" - name: video_views data_type: number description: "" - name: clicks data_type: number description: "" - name: cost_per_conversion data_type: float description: "" - name: cost_micros data_type: number description: "" - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__AD_HISTORY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: ad_set_id data_type: number description: "" - name: name data_type: varchar description: "" tests: - not_null - name: status data_type: varchar description: "" - name: type data_type: varchar description: "" - name: final_urls data_type: array description: "" - name: updated_at data_type: timestamp_ntz description: "" tests: - not_null - name: _fivetran_synced data_type: timestamp_ntz description: "" - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__AD_SET_HISTORY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: campaign_id data_type: number description: "" tests: - not_null - name: base_ad_set_id data_type: number description: "" - name: name data_type: varchar description: "" tests: - not_null - name: status data_type: varchar description: "" - name: target_restrictions data_type: varchar description: "" - name: updated_at data_type: timestamp_ntz description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__CAMPAIGN_BUDGET_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: campaign_id data_type: number description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: updated_at data_type: timestamp_ntz description: "" tests: - not_null - name: amount_micros data_type: number description: "" - name: period data_type: varchar description: "" - name: total_amount_micros data_type: number description: "" - name: type data_type: varchar description: "" - name: lifetime_budget data_type: number description: "" - name: daily_budget data_type: number description: "" - name: _fivetran_synced data_type: timestamp_ntz description: "" - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__GEO_TARGET_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: country_code data_type: varchar description: "" - name: name data_type: varchar description: "" tests: - not_null - name: _fivetran_synced data_type: timestamp_tz description: "" - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__CAMPAIGN_CRITERION_HISTORY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: campaign_id data_type: number description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: geo_target_constant_id data_type: number description: "" - name: negative data_type: boolean description: "" - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__ACCOUNT_HISTORY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: id data_type: number description: "" tests: - not_null - name: business_account_id data_type: number description: "" - name: name data_type: varchar description: "" tests: - not_null - name: currency data_type: varchar description: "" - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null - name: STG_GOOGLE_ADS__AD_IMAGE_HISTORY_DBT description: "" columns: - name: source_schema data_type: varchar description: "" tests: - not_null - name: ad_set_id data_type: number description: "" tests: - not_null - name: ad_id data_type: number description: "" tests: - not_null - name: updated_at data_type: timestamp_ntz description: "" tests: - not_null - name: image_url data_type: varchar description: "" tests: - not_null - name: mime_type data_type: varchar description: "" tests: - not_null - name: name data_type: varchar description: "" tests: - not_null - name: pixel_height data_type: number description: "" tests: - not_null - name: pixel_width data_type: number description: "" tests: - not_null - name: preview_image_url data_type: varchar description: "" tests: - not_null - name: preview_pixel_height data_type: number description: "" tests: - not_null - name: preview_pixel_width data_type: number description: "" tests: - not_null - name: synced_at data_type: timestamp_ntz description: "" tests: - not_null - name: is_most_recent_record data_type: boolean description: "" tests: - not_null