Google Analytics Reports

Google Analytics

Get Started. It's Free
or sign up with your email address
Google Analytics Reports by Mind Map: Google Analytics Reports

1. GA Reporting Menu

1.1. top level

1.1.1. audience active users 30 User 14 user explorer clientId or userId ga:clientId lifetime value and cohort analysis 21 Lifetime Value and Cohorts 25 demographics and interests (Google Proprietary) 5 Audience 6 geo 18 Geo Network 18 behaviour new vs returning Frequency and Recency Engagement session quality conversion probability technology and mobile / cross device 23 Platform or Device 13 27 System 8 custom 9 Custom Variables or Columns 5 benchmarking users flow 22 Page Tracking 22

1.1.2. acquisition traffic channels treemps source/medium and referrals google ads and campaigns Advertising Google Ad search console social 26 Social Interactions 8

1.1.3. behaviour behaviour flow and site content 22 Page Tracking 22 8 Content Grouping 4 site speed 25 Site Speed 20 site search 20 Internal Search 23 events 16 Event Tracking 9 publisher experiments 7 Content Experiments 3

1.1.4. conversion goals 19 Goal Conversions 17 ecommerce 15 Ecommerce 64 multi-channel funnels

1.1.5. date and time 28 Time 22 Date ga:date Year ga:year Year Period Month Week Day Time ISO

1.1.6. others mobile app 4 App Tracking 13 17 Exceptions 5 dimension metric 31 User Timings 6 dimension metric

1.1.7. cannot combine clientId demographics interest cohort interest only one interest category is allowed no gender or age segment row cannot contain less than 10 users ga:interestAffinityCategory, ga:hostname, ga:pagePath, ga:userGender, ga:mobileDeviceBranding, ga:mobileDeviceModel ga:interestAffinityCategory, ga:hostname, ga:pagePath, ga:mobileDeviceBranding, ga:mobileDeviceModel

2. Extracting GA Reports

2.1. Google analytics Documentation

2.1.1. google analytics query explorer Query Explorer — Google Analytics Demos & Tools Core Reporting API - Reference Guide  |  Analytics Core Reporting API

2.1.2. Dimensions and metrics Dimensions & Metrics Explorer — Google Analytics Demos & Tools What Is The Metadata API - Overview  |  Analytics Metadata API

2.1.3. GA Constraints allowed in segments Limits on daily requests Sampling If less than 10 users in a segment, the rows are censored faq

2.2. Pentaho

2.2.1. google analytics input step

2.2.2. Documentation Old documentation with Simple API Key

2.2.3. steps setup GA connection setting setup query definitions click Get fields Edit the output columns

2.2.4. Google analytics connection settings Application name Enter an application name such as "PDI" or leave the default. Email and Password Your Google Developer Service Account's Email Address (e.g. "<random [email protected]>"). Simple API Key See the prerequisites section above to acquire the API key Specifiy tableId Directly Check this option, if you want to specify the tableId directly without getting the tableId from the profile Get tableId from profile Get profiles

2.2.5. Query definition Start date Specifies the start date associated with the query. The date must be entered in the following format: YYYY-MM-DD. End date Specifies the end date associated with the query. The date must be entered in the following format: YYYY-MM-DD. Dimensions Specifies the dimension fields for which you want to query. The Google Analytics API documentation provides you with a list of valid inputs and metrics that can be combined. Metrics Specifies the metrics fields you want returned. At least one metric must be provided. Filters Specifies the filter (described in the Google Analytics API documentation). Here is an example: 'ga:country==Algeria'. Sort Specifies a field on which to sort. Here is an example: 'ga:city'. Specifiy a segment Allows you to specify a segment for the query. A segment is analogous to a database "view." Use custom segment Use predefined segment Check this option, when you want to specify a custom segment. A segment is analogous to a database "view."

2.2.6. Get Fields get the fields from GA based on the Query definitions

2.2.7. Output fields Feed field type from GA Feed field from GA Output field define the new column name Output type define the data type Input format define the formatting

2.3. R

2.3.1. Google Analytics API into R

2.4. Python

2.4.1. Hello Analytics Reporting API v4; Python quickstart for service accounts

2.4.2. googleanalytics

2.4.3. Google Analytics Reporting API v4 using Python [2020 update] - JC Chouinard

2.5. Google Sheets

2.5.1. Chrome extension to import into Google sheets

2.5.2. Google sheets add on

2.6. Granularity

2.6.1. clientId + sessionCount Available in In User explorer only

3. Framework

3.1. GA Performance Metrics

3.1.1. GA Performance Metrics

3.1.2. Acquisition Users New Users Sessions How did the user land in your website?

3.1.3. Behaviour Pages per session Bounce rate Average session duration What do they do in your website?

3.1.4. Conversion goals ecomm events transactions revenue ecomm conversion rate Did they convert to your objective?

3.2. channel grouping

3.2.1. responsibility accounting Assign customer traffic to organisation

3.2.2. Source and Media Source Who/What initiated the traffic Media How did the user get here What action did the person take to get here examples salesforce - email newsletter - email

3.3. channel strategy

3.3.1. Top of funnel Paid Placement of ads Earned Word of Mouth

3.3.2. Consideration Marketplaces

3.3.3. Bottom of funnel Owned Existing customers Marketplace

4. UTM Tagging

4.1. examples

4.1.1. ex 1: campaign tagging 20200102_01sale_email_window_p 200102_01_01sale_email_window_ 20200102_01sale_email_window_p 200102_02_01sale_email_window_ 20200102_01sale_email_window_p 200102_03_01sale_email_window_ 20200102_01sale_email_window_p 200102_04_01sale_email_window_ 20200102_01sale_email_window_p 200102_05_01sale_email_window_ utm_source: salesforce utm_medium: segment utm_campaign: teatree_2020 utm_content: 20200102_01sale_email_window_p url:

4.1.2. ex 2: referral What Is Referral Traffic in Google Analytics? Does not work!

4.2. How is Traffic sources captured?

4.2.1. UTM Parameters utm_source: Identify the advertiser, site, publication, etc. that is sending traffic to your property, for example: google, newsletter4, billboard. utm_campaign: The individual campaign name, slogan, promo code, etc. for a product. utm_medium: The advertising or marketing medium, for example: cpc, banner, email newsletter. advertising utm_content: Used to differentiate similar content, or links within the same ad. For example, if you have two call-to-action links within the same email message, you can use utm_content and set different values for each so you can tell which version is more effective. utm_term: Identify paid search keywords. If you're manually tagging paid keyword campaigns, you should also use utm_term to specify the keyword.

4.3. managing UTM parameters

4.3.1. UTM Parameters: Demystify Your Marketing In Minutes

4.3.2. google sheet UTM Generator

4.3.3. ga dev Campaign URL Builder — Google Analytics Demos & Tools

4.4. filter and transform source medium

4.4.1. Facebook Referrals in Google Analytics – Loves Data

4.5. ga:campaignCode utm_id: Campaign id or granular tag

4.5.1. how to use Take UTM Parameters to the next Level with “utm_id”

4.6. channel grouping

4.6.1. Automatic assignment of channel grouping by GA based on defined rules

4.6.2. default channel grouping rules Direct Source exactly matches direct AND Medium exactly matches (not set) OR Medium exactly matches (none) Organic Search Medium exactly matches organic Social Social Source Referral exactly matches Yes OR Medium matches regex ^(social|social-network|social-media|sm|social network|social media)$ Email Medium exactly matches email Affiliates Medium exactly matches affiliate Referral Medium exactly matches referral Paid Search Medium matches regex ^(cpc|ppc|paidsearch)$ AND Ad Distribution Network does not exactly match Content Other Advertising Medium matches regex ^(cpv|cpa|cpp|content-text)$ Display Medium matches regex ^(display|cpm|banner)$ OR Ad Distribution Network exactly matches Content (unavailable) or (other) Sessions don't match any channel description.

4.6.3. customizing

4.7. Auto-tagging for Google Ads

4.7.1. DEFAULT setting id OFF

4.7.2. Auto-tagging: Definition - Google Ads Help

5. Customer Tracking using GA

5.1. setting USERID in GTM

5.1.1. example admin set preprty userid tracking

5.1.2. youtube

5.1.3. google youtube

5.1.4. youtube

5.1.5. weltpixel youtube

5.2. Using Salesforce for tracking Website

5.2.1. web analytics connector

5.2.2. sfmc collect code?

5.3. Web log

5.3.1. Matching with Web Log more rows in weblog There are more rows in weblog vs GA decode user agent UA string Detect Apple iPhone Model Numbers and User-Agents List of User Agent strings Tutorial about Detecting User Agent Types and Client Device Capabilities WURFL - Mobile Device Database by ScientiaMobile

5.4. Physical Traffic in Brick Mortar

5.4.1. Check-in capture QR Code Bluetooth Beacon Wifi captive portal