Skip to main content

Config Sheet Registry

This is a spreadsheet that serves as a comprehensive registry of clients and their associated data and workflow configurations. It contains detailed information that could be used for managing client data integrations, tracking data sources, and overseeing business intelligence (BI) workflows.

At a high level it is a registry of all the config sheets. You can learn more about config sheets here. Config Sheets

Fields​

Key fields and their contents include:

  • Client: The name of the client, which can include specific project names or templates (e.g., "Adopt A Pet," "Alo Moves").

  • Config Sheet Link: A direct link to a Google Sheet containing configuration details for the respective client.

  • Snowflake Database: The name of the Snowflake database associated with the client (e.g., "thrive_5ea8a080e7eac").

  • BigQuery Dataset: The name of the BigQuery dataset linked to the client (e.g., "thrivestack.performance").

  • Platforms: A list of data platforms and sources integrated for the client, such as "Facebook Ads," "GA4," "Google Ads," "TikTok Ads," "Bing Ads," "CRM," and "Shopify."

  • Bi Company: The name of the business intelligence company or entity involved with the client's data (e.g., "Kinship," "Alo," "EAB Global").

  • Bi Workflow: A description of the specific BI workflows or projects related to the client (e.g., "Kinship - Adopt A Pet," "Alo - Search," "Autodesk - Programmatic, Autodesk - Social, Autodesk - Search").

  • BigQuery Project: The name of the BigQuery project, if applicable (e.g., "thrive-ga.analytics_258858150").

  • Primary Contact: The main contact person for the client. thrive_funnel updates and thrive_funnel_update_2: These fields indicate whether "thrive_funnel" updates are applicable to the client and may include the name of the individual responsible.

  • GA3/4 Cut Off Date Applies: Indicates if a Google Analytics 3/4 cut-off date applies to the client. ain, Date Check, Check Sums, GA4 Update, and Data Team Comments: These fields likely relate to internal tracking, data quality checks, and operational notes. This spreadsheet would be valuable for: Onboarding and Offboarding Clients: Quickly identifying all data touchpoints and configurations for a new or exiting client.

  • Troubleshooting Data Issues: Pinpointing which platforms and databases are involved for a specific client when investigating data discrepancies.

  • Auditing Data Sources: Gaining an overview of all integrated platforms across different clients.

  • Managing BI Projects: Understanding the various BI companies and workflows in progress.

  • Contact Management: Identifying the primary contact for each client.

  • Internal Data Management: Tracking the status of GA4 updates and other internal data processes.

Accessing the Config Registry​

You can access it by clicking on the button below and it will take you to Google Sheets.

Access Config Registry