Adobe Launch Page View Count Condition to Fire Tag

session_page_view_count_adobe_launch_rule_condition

You are given a 3rd party pixel tag from Facebook or Google and asked to fire the tags when the visitor has viewed 3 pages. Or you have an email capture overlay and you don’t want to distract your visitor when they land on your site on the first page view. Adobe Launch has built in functionality to track the session page view count and let’s you fire a tag when the visitor has 3 page views (or how every many page views you want).

Continue Reading

Drift Chat Interaction Google Analytics Tracking Using GTM

This guide shows you how to track Drift chat widget interactions and email captures in Google Analytics using Google Tag Manager (GTM). The tutorial will show you how to capture the following Drift interactions in Google Analytics events:

1) Drift chat widget is opened and closed
2) Drift chat widget sidebar is opened and closed
3) A user’s email address is captured in a conversation in the Drift chat widget
4) A conversation started and a message sent along with the Drift conversation id

After you’ve captured the Drift interactions in GTM you’ll learn how to pass this data to Google Analytics and view the aggregate reports. You’ll then go a step further and analyze an individual user journey in Google Analytics and see the Drift chat interactions in chronological order together with the user’s other site behaviors.

Continue Reading

Pardot iFrame Form Tracking with Google Analytics

pardot_iframe_form_tracking_google_analytics

This guide shows you how to track Pardot form submissions completed in an iFrame in Google Analytics. The method described allows you to properly attribute the acquisition traffic source and medium to the conversion- the Pardot lead form submission in Google Analytics. You can also see what page on your site the Pardot iFrame lead form was submitted on using this tutorial.

Continue Reading

Google Analytics R Tutorial

google_analytics_r_tutorial_et

This is a tutorial on how to use R to directly connect to and extract data from Google Analytics using the Google Analytics Reporting API v4. This is meant to be a simple example and assumes no prior knowledge or experience with R, APIs or programming.

I’ve included a video that walks you through each step of the process. You will be up and running in a few minutes. By the end of this tutorial you will be able to:

•Extract page view data for your top pages from Google Analytics Reporting API to R.
•Create a line graph showing session trended by day using R.

Continue Reading

Digital Analytics Data Quality- Your First Lesson

data-quality-digital-analytics

Make sure you are very confident in the accuracy of your data before you present it to stakeholders.

Eager Young Digital Analyst Meet the Data Quality Mousetrap

Almost 9 years ago when I was first starting out in my career in digital analytics I was tasked with an analysis of an internal search tool. It was one of those sites that had a bunch of filtering options for search. The visitor could select sizes, colors, product categories, and many other product attributes. I dove head first into the web analytics tool and started to explore the data. I quickly found what I thought was a smoking gun. According to the data, the insight I discovered was that the only internal search filtering option that visitors used was the color filter.

I presented two recommendations in my PowerPoint analysis:
1) Simplify the filtering and just keep the color filter
OR
2) Highlight the other filtering options like size, product category etc. to get visitors to use other filters

Read the story of how I found my career as a digital analyst on Craigslist.

Digital Analyst Meet the Debugger

Continue Reading

Google Analytics Cost Data Import from Google Sheets – Automated

This tutorial shows how to import Google Analytics cost data automatically from Google Sheets with the click of a button. Here is the sample sheet. Go to the File – Make a Copy to edit the sheet in your Google Drive.

Continue Reading

Integrate Google Adwords & Google Analytics with Salesforce Guide

salesforce_google_analytics_integration__ga_visitor_id_in_sf_lead_detail

How do you integrate Google Adwords and Salesforce?
How do you integrate Google Analytics and Salesforce?

The simple answer to any data integration question: you need a unique identifier that is shared across both systems. This post will give you detailed step by step instructions on how to set and capture the unique identifier to integrate Salesforce with Google Adwords and Google Analytics.

Continue Reading

Real-Time Reporting Adobe Analytics API Tutorial

adobe_analytics_real-time_dashboard_sample_

Adobe has a nice real-time dashboard built directly into Reports & Analytics (SiteCatalyst). It is easy to configure and get up and running quickly. According to Adobe product manager Ben GainesReal-Time reports in Adobe Analytics has become one of the most popular features in Reports & Analytics.” What you may not know is that real-time data can be accessed via Adobe’s reporting API. Adobe has a great tutorial on how to get started with the Adobe Analytics Real-Time API that you need to check out. The example was used in a lab session at past Adobe Summits and it looks like it was offered again at the 2016 Adobe Summit. If you went to Summit let me know how the session was. I haven’t attended the session before, but I was in search of a real-time API sample for Adobe Analytics and I stumbled upon this gem.

In this post I am going to walk you through Lesson 1 and Lesson 6 from this tutorial. Lesson 1 gives you the basic fundamentals needed to run a Adobe Analytics real-time report. Lesson 6 gives you a working real-time dashboard with snazzy D3.js visualizations that you can load right now in your browser. Hopefully you can use this as the foundation for building some actionable solutions that leverage real-time data at your organization. I look forward to hearing about the real-time dashboard you build or the real-time content and campaign optimization or the real-time site health alert tools. Please share what you create in the comments or @ryanpraski.

Continue Reading

Python Google Analytics API Over 1 mil Rows Unsampled Data + Pull Data From Multiple Profiles

How to pull large data sets with over 1 million rows from Google Analytics and avoid sampling?
How to pull the same data across multiple Google Analytics profiles?

google_analytics_python_api_1_million_rows
This post provides a solution for exporting more than 10,000 rows (the example pulls over 1 millions rows) and a solution for the sampling limitations of Google Analytics. The solution uses the Google Analytics reporting API and Python. It checks for the presence of sampling before running a query and gives you the ability to break your query down into smaller 10,000 row pieces. The pieces are multiple smaller queries with shorter date ranges. All the data from the small queries are stitched together and output into a single CSV file for the full date range. With this solution you can also pull data from multiple profiles using this single Python application. If you work across multiple Google Analytics profiles with high traffic volumes and often run into sampling, then this solution should save you lots of time. If you’d like to see how to use the Google Analytics Sheets Add-on to pull more than 10k rows of data and avoid sampling check out my previous post.

Continue Reading

Pull More than 10k rows Unsampled using Google Analytics Sheets Add-on

How to pull a Google Analytics report with more than 10,000 rows?
How to get around Google Analytics Sampling Limitations?

Sample Google Analytics Sheet used in this tutorial (file make a copy to edit)

google_analytics_google_sheet_add-on

Google Analytics Sheet Add-on 119,421 rows of data

How do you pull a Google Analytics report with more than 10,000 rows? How do you get around Google Analytics Sampling Limitations? These were the most common questions I was asked after my recent Google Analytics reporting API Python tutorial. This new tutorial will show you how to export more than 10,000 rows using the Google Analytics Spreadsheet Add-on and how avoid the sampling limitations of Google Analytics. I also have another post in the works on how to use Python and the Google Analytics API to avoid sampling and pull even more data. Keep an eye out for the new post!

Continue Reading