Home > Tracking Campaigns > Other Systems (CPVLab, iMobiTrax, P202, Track Revenue, Click, Google Analytics, etc.)

How to Use Google Analytics API (7)

06-06-2017 04:21 PM #1 poker007 (Member)
How to Use Google Analytics API

I'm a GA noobie and wondering if anybody could please tell me how do you use the google api to pull data from the Model Comparison Tool? E.g., would like to automate attribution reporting for various channels such as the conversion metrics?

Thanks

07-26-2017 08:18 PM #2 rolandb ()

I've actually just been trying to figure this out myself recently. A simple-ish solution that doesn't require coding involves using Google Sheets.

  1. In Google Sheets, get the GA Add-on by going to (in the menu) Add-ons > Get Add-ons.
  2. Find Google Analytics and install the add-on.
  3. In the menu, under Add-ons, you'll see Google Analytics. Select Create New Report.
  4. Type in a Name, Select your Account Information, and choose your Metrics / Dimensions. The Metrics and Dimensions autofill as you type (also found here), but don't have the metrics from the Model Comparison Tool, so if you want to use that, just click Create Report to create a dummy report and in the next steps, I'll explain how to access data from the Multi-Channel Funnels.
  5. A new tab called Report Configuration will be created. Change Type to mcf.
  6. Change Metrics and Dimensions using those from this link in the format of mcf:<metric/dim>
  7. Go back to Add-ons and under Google Analytics, click Run Report.


You can generate multiple reports at the same time or have multiple metrics/dimensions. Once you've figured out what data you need, you can schedule reports to run automatically under Add-ons > Google Analytics > Schedule reports.

It's just data that is fetched, so you can also generate your own charts.

Hope that's clear!

07-27-2017 11:01 AM #3 danielt (Member)

Go try the Google Data Studio https://www.google.com/analytics/data-studio/

You can hook up G Analytics into that and have fun with your data without a single line of code + good looking stats and graphs ( love graphs )

07-27-2017 07:25 PM #4 rolandb ()

Google Data Studio is amazing. Doesn't connect to the Multi-Channel Funnels Reporting API though, but that can be worked around by connecting Data Studio to either Sheets or BigQuery.

07-27-2017 07:59 PM #5 cmdeal (Veteran Member)

Quote Originally Posted by rolandb View Post
Google Data Studio is amazing. Doesn't connect to the Multi-Channel Funnels Reporting API though, but that can be worked around by connecting Data Studio to either Sheets or BigQuery.
Can you or danielt post a guide of how to best do this?

07-27-2017 08:54 PM #6 rolandb ()

Quote Originally Posted by cmdeal View Post
Can you or danielt post a guide of how to best do this?
Sure. Data Studio down right now for maintenance, but will post a guide going once it's back up.

07-28-2017 08:09 AM #7 danielt (Member)

Quote Originally Posted by cmdeal View Post
Can you or danielt post a guide of how to best do this?
Cool. Let me go over it and I will get back

Home > Tracking Campaigns > Other Systems (CPVLab, iMobiTrax, P202, Track Revenue, Click, Google Analytics, etc.)