/
2023-12-28 PAC: Internal analytics

2023-12-28 PAC: Internal analytics

Owned by Doug Chase (Deactivated)
Last updated: Dec 28, 2023
1 min read

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?

  • Story: Evaluate whether we could send the product tier itself rather than the set of flags to make life easier on the Lake/analytics side

 

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.

 

 

Add label