Using Looker BI with Power My Analytics

Using Looker BI with Power My Analytics

Info
Looker BI (Beta) is a premium add-on that turns your warehoused marketing data into interactive dashboards and automated alerts, powered by Google's Looker. Because each workspace is configured and managed by our team, onboarding is hands-on and starts with a quick conversation with us.

Why Use Looker BI?

With Looker BI connected to your Power My Analytics data, you can:
  • Build interactive dashboards on top of your marketing data, with drill-downs and custom explores.
  • Set alerts that notify you automatically when metrics cross the thresholds you care about.
  • Explore and visualize data from across your connectors in one place.
  • Add your own views, explores, and measures as your reporting needs grow.

Who Can Use Looker BI?

Looker BI is a premium, white-glove service available to customers on a Custom plan (formerly Enterprise) with BigQuery exports enabled. Your marketing data is exported from the Hub into your own BigQuery dataset (using Data Builder exports), which Looker then connects to.
Alert
Because Looker BI includes hands-on onboarding and ongoing support from our team, it carries premium pricing. Please contact our sales team to discuss pricing and confirm it's the right fit for your needs before getting started.

How Onboarding Works

Looker BI onboarding is currently a guided, manual process handled by our team. To get started, contact our sales team at sales@powermyanalytics.com. We'll walk you through connecting your BigQuery data and setting up your Looker workspace.

Before you reach out, prepare the items below so we can configure your connection quickly.

Before You Begin: Create a Service Account

Looker connects to your BigQuery dataset using a dedicated Google Cloud service account that you create and control. Creating your own service account keeps your data fully isolated from other organizations: you decide exactly which dataset Looker can read.

  1. Create a service account. Go to IAM & Admin > Service Accounts > Create service account. You can name it "looker". When prompted to grant access, assign the role BigQuery Job User.
  2. Create a key. Open the service account, go to Keys > Add key > Create new key, choose JSON, then download and save the file somewhere secure.
  3. Share your dataset with the service account. In BigQuery, click the three dots on the dataset you want to use, then choose Share > Manage permissions > Add principal. Paste the service account email (the client_email value from the JSON file), assign the role BigQuery Data Viewer, and click Save.
Notes
Your JSON key file is a credential that grants access to your data. Store it securely and share it with us only through a secure channel.

What to Send Us

When you contact us, please have the following ready:
  1. Your GCP project ID.
  2. Your service account JSON key file.
  3. The BigQuery dataset name you granted the service account access to.
  4. (Optional) A Git repository URL, if you'd like to own your LookML code. If you don't provide one, we'll set this up for you.
  5. The list of email addresses you'd like us to invite to your Looker workspace.

What You'll Get

Once onboarding is complete, you'll have:
  1. Invitations to your Looker workspace for each email you provided.
  2. A project with a working connection to your BigQuery dataset.
  3. The ability to edit views, add explores, and build your own dashboards.

Logging In

After we've set up your workspace, you can sign in to Looker at powermyanalyticsbi.cloud.looker.com/login.

Questions?

To get started or ask about pricing, contact our sales team at sales@powermyanalytics.com. For general questions, you can also submit a ticket.

    • Related Articles

    • Power My Analytics' Sovereign SQL Warehouse Solution

      Power My Analytics offers a Sovereign SQL Warehouse solution with the Custom plan. This article will help you learn about its uses and how to get started. The Sovereign SQL Warehouse gives you complete ownership of your data by storing it in your own ...

    • Report Data in Power BI

      Power My Analytics offers a native Power BI connector that allows you to load your Data Builder datasets directly into Power BI Desktop for custom reports and dashboards. This guide walks you through connecting your PMA hub to Power BI, installing ...

    • Power My Analytics Data Connector User Guide

      The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Looker Studio or Sheets or export to destinations like BigQuery and ...

    • Create Looker Studio Reports with Power My Analytics

      Looker Studio is one of the most popular destinations for visualizing your Power My Analytics data. This guide brings together everything you need to get started with Looker Studio, build effective reports using PMA connectors, and troubleshoot ...

    • YouTube Analytics Error: Connected Account Does Not Appear as an Option in Looker Studio or Data Builder

      When creating reports in Looker Studio or Data Builder, you may encounter an issue where your connected YouTube channel account doesn't appear as an option. This guide will help you understand the problem and provide a straightforward solution to get ...