NoimosAI

BigQuery Integration

Analyze BigQuery sales and usage data in NoimosAI to understand differences across products and channels. Import customer information into CRM and use your findings for customer follow-up and your next marketing initiatives.

View All Integrations

What you can do with this integration

Analyze business data to inform improvements

Check relevant tables and fields to analyze sales and usage trends and differences across products and channels. Review individual records, missing data, and duplicates to identify caveats when interpreting results and ideas for improvement.

Import customer and behavioral data into CRM

Map fields to import customer lists and purchase and usage history from the connected source into NoimosAI CRM. Set up one-time or recurring imports to build a foundation for tailored customer initiatives.

Follow up with customers based on usage

Use imported purchase and usage history to plan re-engagement for inactive customers and post-onboarding follow-up. Check recipients, messages, and timing to inform customer engagement initiatives.

Use customer lists for outreach

Select people suited to your current goal from imported customer information and prepare personalized messages or proposals. Review the recipient list and content before proceeding with outreach.

Write campaign measurement results back to the database

Save campaign metrics, effectiveness assessments, and measured improvements in supported databases where write-back is enabled. Use results measured in NoimosAI from a dedicated table for internal analysis and reports.

How to use it

Prepare a service account JSON key. BigQuery Data Viewer permission is required for the target data, and BigQuery Job User permission for the project billed for queries.

  1. 1.Select BigQuery

    Add a BigQuery connection in NoimosAI and enter a connection name.

  2. 2.Set the JSON key and connection target

    Enter the service account JSON key. Specify the data project, billing project, and location as needed, then connect. BigQuery Data Viewer permission is required for the target data, and BigQuery Job User permission for the project billed for queries.

  3. Break down last month’s sales by channel.
    NoimosAI
    I’m checking the relevant tables and fields and preparing a query to summarize last month’s sales by channel.
    Thinking…

    3.Check tables and analyze

    Check the target datasets and tables, then retrieve and analyze the required data using SQL.

NoimosAI

Go further with the tools you use every day.

Connect with NoimosAI to move from research to execution in one workspace.