* DENG-4201 remove blogs_goals_v1 since now in shared prod
* DENG-4201 remove blogs_sessions_v1 from mktg prod since now in shared prod
* DENG-4201 remove www_site_hits_v1 from mktg prod since now in shared prod
* DENG-4201 remove firefox_whatsnew_summary_v1 from mktg prod since now in shared prod
* DENG-4201 remove www_site_downloads_v1 from mktg prod since now in shared prod
* DENG-4201 remove www_site_events_metrics_v1 from mktg prod since now moved to shared prod
* DENG-4201 remove www_site_landing_page_metrics_v1 from mktg prod since now moved to shared prod
* DENG-4201 remove www_site_page_metrics_v1 from mktg prod since now moved to shared prod
* DENG-4201 remove blogs_daily_summary_v1 from mktg prod since now moved to shared prod
* DENG-4201 remove blogs_landing_page_summary_v1 from mktg prod since now moved to shared prod
* DENG-4201 remove blogs_empty_check_v1
* DENG-4201 remove www_site_empty_check_v1
* DENG-4201 remove www_site_metrics_summary_v1 from mktg prod since now moved to shared prod
* DENG-4201 remove dl with attr v1 and v2 from mktg prod since now in shared prod instead
* DENG-4201 remove tests from mktg prod since tables no longer live in mktg prod
* Add new columns to www_site_hits_v2
* Add new cols to www_site_downloads_v2
* Remove comments
* Update column descriptions to clarify which are CTS vs TS
* Move Google Search Console ETLs & views to `moz-fx-data-shared-prod`.
* Temporarily add back Google Search Console views in `moz-fx-data-marketing-prod` to avoid breaking existing reporting.
* Update Google Search Console ETL entries in dry-run skip config.
* Temporarily add pass-through views in `moz-fx-data-marketing-prod` in place of Google Search Console ETL tables to avoid breaking existing reporting.
* Remove `localized_site_country_code` and `localized_site_country` columns from `search_impressions_by_page` view.
Because they're so sparsely populated that it can be misleading.
* Add `user_region` and `user_subregion` columns to Google Search Console views.
* Change `classify_site_query` UDF to differentiate Firefox, Pocket, and Mozilla brand keywords.
* Use new brand keyword regular expressions from Adria Kyne in `classify_site_query` UDF.
* Classify queries in Google Search Console data.
* Refactor repeated Google Search Console logic into UDFs.
* Replace `page_path_segment_1` field with `localized_site_code` field, and add related derived fields.
* Rename `country_code` field `user_country_code`.
* Add `user_country` field.
* Include Google Search Console data for MDN.
* DENG-3355 add funnel_derived_clients UDF to clients_first_seen_28_days_later view
* DENG-3355 add distribution model to clients first seen 28 days later
* DENG-3355 add partner org to clients first seen 28 days later
* DENG-3355 add the UDFs to clients_first_seen
* DENG-3355 remove fully qualified project name from the UDFs
* DENG-3355 add fully qualified project name to UDFs
* DENG-3355 add partnership logic to GA4 site metrics summary
* DENG-3355 add stub implementation of funnel_derived_ga_metrics UDF
* DENG-3355 add stub implementation test for distribution_model_ga_metrics
* DENG-3355 add stub tests for partner_org_ga_metrics UDF
* DENG-3355 add stub test for funnel_derived_clients UDF
* DENG-3355 add stub implementation test for distribution_model_clients
* DENG-3355 add stub implementation test for partner_org_clients
* DENG-3355 fix formatting of stub funnel_derived_ga_metrics
* DENG-3355 fix formatting of metadata yaml files to include newlines
* DENG-3355 fix format of partner org clients metadata.yaml
* DENG-3355 add comment to partner org clients udf.sql
* Update sql/moz-fx-data-shared-prod/udf/distribution_model_ga_metrics/udf.sql
Co-authored-by: Ben Wu <12437227+BenWu@users.noreply.github.com>
* DENG-3367 remove unnecessary alias in www_site_metrics_summary view
---------
Co-authored-by: Ben Wu <12437227+BenWu@users.noreply.github.com>
* Acoustic configuration updated, init.sql files removed and user facing views defined
* added missing dataset_metadata for acoustic
* change access group to new braze wg
* fix workgroup
---------
Co-authored-by: Leli Schiestl <lschiestl@mozilla.com>
* DENG-2938 - update schema column descriptions for product download columns
* DENG-2938 - update product download logic to be firefox desktop only
* DENG-2938 add backticks around date
* DENG-2919 - update www_site_metrics_summary_v2 logic to count only Desktop Firefox downloads towards downloads
* DENG-2919 wrap reserved col names with backticks
* DENG-2837 Add 2 new QA checks
* DENG-2837 add spaces to end of checks
* DENG-2837 add where clause to blogs_goals_v2 check
* DENG-2837 - add QA check for www_site_hits_v2
* DENG-2837 adding more checks and adding extra empty line
* DENG-2837 add not null check to ga_sessions_v2
* DENG-2837 add pattern check for visit identifier on blogs_goals_v2
* DENG-2784 - add wait task for blogs partitions to 4 blogs tables
* DENG-2784 - add sensors for events table for production property
* DENG-2784 - add sensor for production property for the 3 tables in mozilla org derived
* DENG-2784 fix backticks
* DENG-2784 - add spaces to jinja, also update gclid conv to ga4 dag
* DENG-2784 - leave Marlene's DAG where it is
* DENG-2784 - switch to depends_on
* DENG-2784 add dag names to depends_on
* DENG-2784 - remove some of the unneeded dependencies and change name from partition to table
* DENG-2784 switch from prod to wmo to be more clear
* DENG-2784 switch from prod to wmo to be more clear
* DENG-2492 Initial commit for new table blogs_landing_page_summary_v2
* DENG-2492 add cleaned landing page logic
* DENG-2492 fix typo in query
* DENG-2492 add more explicit table references and rename stage table
* DENG-2492 include table aliases in group by
* DENG-2492 update the schema column descriptions
* DENG-2492 wrap date with backticks
* DENG-2492 initial commit, work in progress
* DENG-2492 work in progress
* DENG-2492 work in progress
* DENG-2492 initial commit
* DENG-2492 update query
* DENG-2492 remove trailing space from metadata.yaml
* DENG-2492 add column descriptions to schema.yaml
* Add ETLs for historical Google Search Console data synced by Fivetran.
* Fix formatting of `CASE` subclauses like `WHEN` inside Jinja blocks.
* Add ETLs for current Google Search Console data exported directly to BigQuery.
* Add views for Google Search Console data.
* DENG-2492 - add new column engagement time and update hit time column definition
* DENG-2492 - fix formatting for updated SQL
* DENG-2492 update hit_time calculation
Katie Windau
Sean Rose
Marlene Hirose
Leli
Anna Scholtz
kik-kik
Winnie Chan