Power BI + Google Analytics = Power Analytics

Google Analytics is one of the most popular website performance tracking tools that companies use to measure progress toward online marketing goals. It enables digital marketing teams to gain insights into their audience’s navigation behavior and preferred ways of interacting with content. Businesses can also discover which search terms led visitors to their site, which pages and content attracted the most viewers, and what percentage responded to a call-to-action.
Most organizations use Google Analytics to establish whether they’re meeting their marketing objectives, and obtain insights into what changes could be made to improve website performance. But with Google Analytics data in Power BI, it’s possible to uncover hidden relationships or patterns that point to completely new opportunities or suggest innovative marketing ideas and ways to attract new customers.
Google Analytics does a great job of tracking website visitor behavior, such as the number of unique page visits, time spent browsing a site, and geographic location of customers. But Google Analytics doesn’t offer a lot of analytic tools for connecting marketing data to data from other parts of the company, or to external data trends that are influencing the marketplace.
That’s the value added by Power BI. With Power BI you can compare web performance data in Google Analytics to data brought in from other sources, internal and external. Import data from HDInsight, Azure Marketplace, Exchange—or even Facebook, Wikipedia, and Data.gov. Evaluate web performance data against data you import from Salesforce, Marketo, or other sources. Enable colleagues to achieve a more holistic view of your organization’s performance.
For many users, what’s really exciting about Power BI is its dynamic visualization tools. Sure it’s great to measure how your website performs over time, but there’s a pretty big wow factor in watching data come alive in real time, uncovering multiple trends and relationships.
Consider Power BI map visualizations. They enable you to track where visitors to your site arrive from various locations worldwide over time. If a location catches your eye, you can drill down for more detail. See a spike in website traffic at a certain place and time? Zoom in and pinpoint the location. Cross check the time and place against contemporaneous events. Did the jump in traffic coincide with a local conference or sales announcement? Armed with this insight, you can better anticipate when people will visit your site, enabling you to add relevant and timely information to generate interest in your products or services.
0116.Map visualization Power BI + Google Analytics = Power Analytics
In Power BI, it’s straightforward to connect to the Google Analytics content pack.
  1. In the left navigation pane, click Get Data.

    6758.Left Nav 5F00 Get Data Power BI + Google Analytics = Power Analytics

  2. In the Services box, click Get.

    0624.Services  2D00  Get Power BI + Google Analytics = Power Analytics

  3. From the menu of online services, select Google Analytics, and then click Connect.

    8156.Google Analytics  2D00  Connect Power BI + Google Analytics = Power Analytics

  4. Enter the Google Analytics account, property, and view that you want to connect to. Then sign in with your Google Analytics credentials.

    6253.Connect to Google Analytics Power BI + Google Analytics = Power Analytics

  5. To permit Power BI to connect to Google Analytics, click Accept.

     Power BI + Google Analytics = Power Analytics

  6. When the import process completes, you will see a new dashboard, report, and model in the Navigation Pane. Select the dashboard to view your imported data.

    2630.GA Dashboard Post 2D00 Import View Power BI + Google Analytics = Power Analytics

You can also import Google Analytics data directly into Power BI Desktop (formerly Power BI Designer).
  1. Launch Power BI Desktop. On the ribbon, in the External Data group, click Get Data.

     Power BI + Google Analytics = Power Analytics

  2. From the drop-down menu, click More…

     Power BI + Google Analytics = Power Analytics

  3. In the Get Data window, click Other. From the list of other data sources, click Google Analytics, and then click Connect.

     Power BI + Google Analytics = Power Analytics

  4. Read the information about connecting to a third-party service, and then click Continue.

     Power BI + Google Analytics = Power Analytics

  5. Google Analytics asks Power BI Desktop for permission to connect to your data. Click Accept.

     Power BI + Google Analytics = Power Analytics

  6. Power BI Desktop shows that you’re signed in to Google Analytics. To load your Google Analytics data, click Connect.

    4606.GA Sign in Power BI + Google Analytics = Power Analytics

  7. Power BI Desktop loads the Google Analytics data. Now you can start creating your amazing dynamic reports.

    0601.GA Dashboard Design Preview Power BI + Google Analytics = Power Analytics

Power BI makes it possible for anyone to connect to huge amounts of structured and unstructured data from multiple sources. By importing data from Google Analytics into the mix, organizations can view their website’s performance in the context of many other variables.
Power BI has the tools for manipulating this data, representing it visually, and sharing it easily with your colleagues. The more sources of data you have, with the right tools to analyze and visualize them, the more likely that important insights will emerge.

I tried this last week and got an error when the data tried to refresh/import.

Hi Eric,

The best way to solve for this is to go to our community (community.powerbi.com) and search for any people having the same issue and potential solutions. If you can include more info on the type of error, the community might be able to help.

This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.