Data Platform Request Form
Is this a request for a:
- Dataset
- Data Pipeline
- Data Feature
Please provide the description of your request:
If we want the business and data analysts to use the new field referer_data, added as a part of T327074, we Have to add it to pageview_hourly, pageview_actor and pageview_daily tables.
Note: referer_class has been updated with the new type external(media sites). We will need a new column called referer_name which will provide name of the search engine (Google, Bing etc.) and media site (TikiTok, Instagram etc. ) against the external(media sites) and external (search engine) referer classes.
Use Case: (Please explain what this feature will be used for):
Product Analytics doesn't regularly query the webrequest table because it's huge and granular, it has a lot of data. So the team uses a lot of the derived tables or the aggregated tables for analyses. Therefore, we are requesting DE to add a new referer_name column to hourly and daily tables in Hive and Druid for Product Analytics and other stakeholders like Partnerships, Audience Insights etc. to be able to query and chart the data easily in Superset and Turnilo and use it effectively to make informed decisions.
Priority:
High
Ideal Delivery Date: end of Q3
Dataset Checklist
- Provide link to CSV/GSheet example data. Link: ____
- Provide link to the desired Table Schema. Link: ____
- Does this data contain anything that is sensitive, PII or Private?
- Yes
- No
- I don't know
- Who will own the data (Fix issues, update descriptions & metadata etc.)?
Datapipeline Checklist
- Do you have the transformation you like to be applied Link: ____
- Does this data need to be linked to other data in the Data Lake?
- Yes
- No
Data Feature Checklist
Please link to the following if applicable.
Document Type | Required? | Document/Link |
Related PHAB Tickets | Yes | <add link here> |
Product One Pager | Yes | <add link here> |
Product Requirements Document (PRD) | Yes | <add link here> |
Product Roadmap | No | <add link here> |
Product Planning/Business Case | No | <add link here> |
Product Brief | No | <add link here> |
Other Links | No | <add links here> |
For Data Engineering Team to fill out:
Value Calculator | Rank |
---|---|
Will this improve the efficiency of a teams workflow? | 1-3 |
Does this have an effect of our Core Metrics? | 1-3 |
Does this align with our strategic goals? | 1-3 |
Is this a blocker for another team? | 1-3 |