Implementation of Looker Enhancements with Mobile Team

[johnny-jesensky-adhoc]

Description

Following up from our spike ticket, this ticket is to work with the Mobile Team to implement the query, and table changes to their Looker report.

---

Tasks

• [x] Meet with Mobile Team to walk them through the stubbed-out queries that point to Mobile GA4 table. (currently scheduled for Wed, October 2nd)
• [x] Build a new base table for them to query (columns names will be kept the same as what they are using now to make it easier for them to make the transition).
• [x] They will rewrite the queries that power their reports using the new base query.
• [x] Be available for any questions Mobile Team might have around implementing the changes.
• [ ] Possible Task: Once changes implemented, quantify the improvements made to the report, including on costs, bytes processed, etc.

---

Acceptance Criteria

• [x] Mobile Team has everything the need to update their Looker report.

[johnny-jesensky-adhoc]

@dorseypa1 This work will Mobile will continue under the following ticket.

Prep Reporting Table for Mobile Team & Date Suffix Query Changes

One of those tasks will be owned my the Mobile Team, but tracking the work for us to help with implementation, and assistance as needed.

Moving this one to Done.