2023-12-28 PAC: Internal analytics

Getting reviews for all customers / consistency with Data Lake

1. Import successful?

2. PlaceID fetching?

3. Review retrieval (Google)?

Action: Upload file was shared in chat. PAC to check whether upload was successful and processing is taking place appropriately.

Story: Ensure that all sites are reliably retrieving new reviews on the correct cadence

Flag accuracy per product tier: Entitled, Installed, Working

• SKUs

  • Doug to map SKU sets to product tiers

• Product tiers

  • Review tool

    • Story: Review site fetched date?

  • Review requests sent

    • Count of review requests sent increased (already available)

  • DMS integration working?

    • Send last DMS customer data to Lake

      • Story: Date on which integration last ran

      • Story: Date on which we last received a non-empty file

• What’s the right granularity?

  • By “product tier”

  • Story:

    • Ensure flags are set appropriately (historical data)

    • Set flags properly on an ongoing basis for all records

      • SFDC integration?

Deleted records and the Data Lake

• Review deleted

• Request deleted

Story: These flags are in our records today but not being sent to the Lake.