Google Analytics Multi-Channel Funnel Reporting API

Resources

Data Source Type: Web Accessible Resource
Authentication: OAuthToken Authentication
Sample query:

To get the source, medium and date for visits and conversions

https://www.googleapis.com/analytics/v3/data/mcf?ids=ga%3A{profileID}&start-date=30daysAgo&end-date=today&metrics=mcf%3AtotalConversions&dimensions=mcf%3AsourceMediumPath%2Cmcf%3AconversionDate    

Google Analytics Multi-Channel Funnel Reporting API : Multi-Channel Funnel Reporting API
Google Analytics Multi-Channel Funnel API Explorer : Multi-Channel Funnel API Explorer
Dimensions and Metrics Guide: Dimensions and Metrics Reference Guide
Klipfolio Blog Using the Multi-Channel Funnel Reporting API to retrieve data for your dashboard
Google Docs Date Ranges: Google Docs Date Ranges

Step-by-Step

You can retrieve Multi-Channel Funnel data from Google Analytics. This is a cross-section of data that allows you to examine conversion paths from your website. For example, you can view the percentage of conversions that visit your site through a combination of referral, search, and direct channels.

Before you begin, you should be familiar with the Multi-Channel Funnel Reporting API tool.

Create a Multi-Channel Funnel (MCF) API data source using Google Analytics

To create a MCF API data source using Google Analytics, you need to accomplish the following tasks:

  • Craft a query using the Google Analytics API Explorer
  • Begin the data source creation process
  • Authenticate with Google

Step 1: Craft a query using the Google Analytics API Explorer

Use Google Analytics Multi-Channel API Explorer to craft a query for use in Klipfolio.

    1. Log in to Google Analytics Multi-Channel API Explorer.
    2. Click the Off button located at the upper right to authorize requests using OAuth 2.0.
    3. Enter your Google Analytics profile ID in the table id field beginning with ga:.
    4. Enter a valid "start-date" and "end-date" using the following format YYYY-MM-DD. You can also use 30 days ago or today.
    5. In the metrics field, enter a valid Multi-Channel Funnel metric. If you are unsure of what to enter, see the Dimensions and Metrics Reference Guide. For example, mcf:totalConversions.
    6. Optional: In the dimensions field, enter a valid Multi-Channel Funnel dimension. To see a list of Dimensions and Metrics, refer to the Dimensions and Metrics Reference Guide.
    7. Click the Execute button to submit your query.

When the request executes, a GET request is displayed, providing a URL endpoint that you can use as a query in Klipfolio.

Step 2: Begin the data source creation process

To create a MCF API data source using Google Analytics, go to the New Data Source page in Klipfolio and select the REST/URL option.

Authenticate with Google

  1. Click on Authentication, and at Type, select OAuth Credentials from the drop-down menu.
  2. Click the Create button.
  3. Select Google from the list of OAuth providers.
  4. Accept valid credentials for your Google Analytics account. You will be returned to the Web Accessible Resource connector window.
  5. In the URL field, paste in the query you created in Step 1. Exclude the suffix &key={YOUR_API_KEY} parameter.
  6. From the Data Format menu, select a JSON file type.
  7. Click the Get Resource button.

Build your Klips with the generated JSON file!

Related links