Jelikož pohybuji delší dobu v analytice, tak v rámci vánoc uvolním pár skriptů atd.
První dárek je tabulka se všemi dimenzemi a metrikami Google Analytics.
Slouží k průzkumu a rychlému přehledu, co která proměnná znamená jaká další jsou ve stejné skupině, či z čeho se daná metrika počítá.Aneb není nad to to mít na jednom místě. Používám ji většinou při návrhu reportů na míru a aplikací.
Odkazy na stáhnutí tabulky
Tabulka v Google Spreadsheets
Export do TSV (oddělovač je tabulátor > doporučuji).
Export do CSV (oddělovač je čárla > nedoporučuji).
Export do XLSX
Export do TSV (oddělovač je tabulátor > doporučuji).
Export do CSV (oddělovač je čárla > nedoporučuji).
Export do XLSX
Google Spreadsheets verze – náhled
Verze na rychlé nakouknutí s vyhledáváním bez sloupce description
id | type | dataType | group | uiName | allowedInSegments | _blockspring_type | calculation |
id | type | dataType | group | uiName | allowedInSegments | _blockspring_type | calculation |
ga:userType | DIMENSION | STRING | User | User Type | TRUE | text | |
ga:sessionCount | DIMENSION | STRING | User | Count of Sessions | TRUE | text | |
ga:daysSinceLastSession | DIMENSION | STRING | User | Days Since Last Session | TRUE | text | |
ga:userDefinedValue | DIMENSION | STRING | User | User Defined Value | TRUE | text | |
ga:users | METRIC | INTEGER | User | Users | number | ||
ga:newUsers | METRIC | INTEGER | User | New Users | TRUE | number | |
ga:percentNewSessions | METRIC | PERCENT | User | % New Sessions | number | ga:newUsers / ga:sessions | |
ga:1dayUsers | METRIC | INTEGER | User | 1 Day Active Users | number | ||
ga:7dayUsers | METRIC | INTEGER | User | 7 Day Active Users | number | ||
ga:14dayUsers | METRIC | INTEGER | User | 14 Day Active Users | number | ||
ga:30dayUsers | METRIC | INTEGER | User | 30 Day Active Users | number | ||
ga:sessionDurationBucket | DIMENSION | STRING | Session | Session Duration | TRUE | text | |
ga:sessions | METRIC | INTEGER | Session | Sessions | TRUE | number | |
ga:bounces | METRIC | INTEGER | Session | Bounces | TRUE | number | |
ga:bounceRate | METRIC | PERCENT | Session | Bounce Rate | number | ga:bounces / ga:sessions | |
ga:sessionDuration | METRIC | TIME | Session | Session Duration | TRUE | number | |
ga:avgSessionDuration | METRIC | TIME | Session | Avg. Session Duration | number | ga:sessionDuration / ga:sessions | |
ga:referralPath | DIMENSION | STRING | Traffic Sources | Referral Path | TRUE | text | |
ga:fullReferrer | DIMENSION | STRING | Traffic Sources | Full Referrer | text | ||
ga:campaign | DIMENSION | STRING | Traffic Sources | Campaign | TRUE | text | |
ga:source | DIMENSION | STRING | Traffic Sources | Source | TRUE | text | |
ga:medium | DIMENSION | STRING | Traffic Sources | Medium | TRUE | text | |
ga:sourceMedium | DIMENSION | STRING | Traffic Sources | Source / Medium | TRUE | text | |
ga:keyword | DIMENSION | STRING | Traffic Sources | Keyword | TRUE | text | |
ga:adContent | DIMENSION | STRING | Traffic Sources | Ad Content | TRUE | text | |
ga:socialNetwork | DIMENSION | STRING | Traffic Sources | Social Network | text | ||
ga:hasSocialSourceReferral | DIMENSION | STRING | Traffic Sources | Social Source Referral | text | ||
ga:organicSearches | METRIC | INTEGER | Traffic Sources | Organic Searches | number | ||
ga:adGroup | DIMENSION | STRING | Adwords | Ad Group | TRUE | text | |
ga:adSlot | DIMENSION | STRING | Adwords | Ad Slot | TRUE | text | |
ga:adDistributionNetwork | DIMENSION | STRING | Adwords | Ad Distribution Network | text | ||
ga:adMatchType | DIMENSION | STRING | Adwords | Query Match Type | text | ||
ga:adKeywordMatchType | DIMENSION | STRING | Adwords | Keyword Match Type | text | ||
ga:adMatchedQuery | DIMENSION | STRING | Adwords | Matched Search Query | text | ||
ga:adPlacementDomain | DIMENSION | STRING | Adwords | Placement Domain | text | ||
ga:adPlacementUrl | DIMENSION | STRING | Adwords | Placement URL | text | ||
ga:adFormat | DIMENSION | STRING | Adwords | Ad Format | text | ||
ga:adTargetingType | DIMENSION | STRING | Adwords | Targeting Type | TRUE | text | |
ga:adTargetingOption | DIMENSION | STRING | Adwords | Placement Type | text | ||
ga:adDisplayUrl | DIMENSION | STRING | Adwords | Display URL | text | ||
ga:adDestinationUrl | DIMENSION | STRING | Adwords | Destination URL | text | ||
ga:adwordsCustomerID | DIMENSION | STRING | Adwords | AdWords Customer ID | text | ||
ga:adwordsCampaignID | DIMENSION | STRING | Adwords | AdWords Campaign ID | text | ||
ga:adwordsAdGroupID | DIMENSION | STRING | Adwords | AdWords Ad Group ID | text | ||
ga:adwordsCreativeID | DIMENSION | STRING | Adwords | AdWords Creative ID | text | ||
ga:adwordsCriteriaID | DIMENSION | STRING | Adwords | AdWords Criteria ID | text | ||
ga:impressions | METRIC | INTEGER | Adwords | Impressions | number | ||
ga:adClicks | METRIC | INTEGER | Adwords | Clicks | number | ||
ga:adCost | METRIC | CURRENCY | Adwords | Cost | number | ||
ga:CPM | METRIC | CURRENCY | Adwords | CPM | number | ga:adCost / (ga:impressions / 1000) | |
ga:CPC | METRIC | CURRENCY | Adwords | CPC | number | ga:adCost / ga:adClicks | |
ga:CTR | METRIC | PERCENT | Adwords | CTR | number | ga:adClicks / ga:impressions | |
ga:costPerTransaction | METRIC | CURRENCY | Adwords | Cost per Transaction | number | (ga:adCost) / (ga:transactions) | |
ga:costPerGoalConversion | METRIC | CURRENCY | Adwords | Cost per Goal Conversion | number | (ga:adCost) / (ga:goalCompletionsAll) | |
ga:costPerConversion | METRIC | CURRENCY | Adwords | Cost per Conversion | number | (ga:adCost) / (ga:transactions + ga:goalCompletionsAll) | |
ga:RPC | METRIC | CURRENCY | Adwords | RPC | number | (ga:transactionRevenue + ga:goalValueAll) / ga:adClicks | |
ga:ROAS | METRIC | PERCENT | Adwords | ROAS | number | (ga:transactionRevenue + ga:goalValueAll) / ga:adCost | |
ga:adQueryWordCount | DIMENSION | STRING | Adwords | Query Word Count | text | ||
ga:goalCompletionLocation | DIMENSION | STRING | Goal Conversions | Goal Completion Location | text | ||
ga:goalPreviousStep1 | DIMENSION | STRING | Goal Conversions | Goal Previous Step – 1 | text | ||
ga:goalPreviousStep2 | DIMENSION | STRING | Goal Conversions | Goal Previous Step – 2 | text | ||
ga:goalPreviousStep3 | DIMENSION | STRING | Goal Conversions | Goal Previous Step – 3 | text | ||
ga:goalXXStarts | METRIC | INTEGER | Goal Conversions | Goal XX Starts | TRUE | number | |
ga:goalStartsAll | METRIC | INTEGER | Goal Conversions | Goal Starts | TRUE | number | |
ga:goalXXCompletions | METRIC | INTEGER | Goal Conversions | Goal XX Completions | TRUE | number | |
ga:goalCompletionsAll | METRIC | INTEGER | Goal Conversions | Goal Completions | TRUE | number | |
ga:goalXXValue | METRIC | CURRENCY | Goal Conversions | Goal XX Value | TRUE | number | |
ga:goalValueAll | METRIC | CURRENCY | Goal Conversions | Goal Value | TRUE | number | |
ga:goalValuePerSession | METRIC | CURRENCY | Goal Conversions | Per Session Goal Value | number | ga:goalValueAll / ga:sessions | |
ga:goalXXConversionRate | METRIC | PERCENT | Goal Conversions | Goal XX Conversion Rate | number | ga:goalXXCompletions / ga:sessions | |
ga:goalConversionRateAll | METRIC | PERCENT | Goal Conversions | Goal Conversion Rate | number | ga:goalCompletionsAll / ga:sessions | |
ga:goalXXAbandons | METRIC | INTEGER | Goal Conversions | Goal XX Abandoned Funnels | number | (ga:goalXXStarts – ga:goalXXCompletions) | |
ga:goalAbandonsAll | METRIC | INTEGER | Goal Conversions | Abandoned Funnels | number | (ga:goalStartsAll – ga:goalCompletionsAll) | |
ga:goalXXAbandonRate | METRIC | PERCENT | Goal Conversions | Goal XX Abandonment Rate | number | ((ga:goalXXStarts – ga:goalXXCompletions)) / (ga:goalXXStarts) | |
ga:goalAbandonRateAll | METRIC | PERCENT | Goal Conversions | Total Abandonment Rate | number | ((ga:goalStartsAll – ga:goalCompletionsAll)) / (ga:goalStartsAll) | |
ga:browser | DIMENSION | STRING | Platform or Device | Browser | TRUE | text | |
ga:browserVersion | DIMENSION | STRING | Platform or Device | Browser Version | TRUE | text | |
ga:operatingSystem | DIMENSION | STRING | Platform or Device | Operating System | TRUE | text | |
ga:operatingSystemVersion | DIMENSION | STRING | Platform or Device | Operating System Version | TRUE | text | |
ga:mobileDeviceBranding | DIMENSION | STRING | Platform or Device | Mobile Device Branding | TRUE | text | |
ga:mobileDeviceModel | DIMENSION | STRING | Platform or Device | Mobile Device Model | TRUE | text | |
ga:mobileInputSelector | DIMENSION | STRING | Platform or Device | Mobile Input Selector | TRUE | text | |
ga:mobileDeviceInfo | DIMENSION | STRING | Platform or Device | Mobile Device Info | TRUE | text | |
ga:mobileDeviceMarketingName | DIMENSION | STRING | Platform or Device | Mobile Device Marketing Name | TRUE | text | |
ga:deviceCategory | DIMENSION | STRING | Platform or Device | Device Category | TRUE | text | |
ga:continent | DIMENSION | STRING | Geo Network | Continent | TRUE | text | |
ga:subContinent | DIMENSION | STRING | Geo Network | Sub Continent | TRUE | text | |
ga:country | DIMENSION | STRING | Geo Network | Country | TRUE | text | |
ga:region | DIMENSION | STRING | Geo Network | Region | TRUE | text | |
ga:metro | DIMENSION | STRING | Geo Network | Metro | TRUE | text | |
ga:city | DIMENSION | STRING | Geo Network | City | TRUE | text | |
ga:latitude | DIMENSION | STRING | Geo Network | Latitude | text | ||
ga:longitude | DIMENSION | STRING | Geo Network | Longitude | text | ||
ga:networkDomain | DIMENSION | STRING | Geo Network | Network Domain | TRUE | text | |
ga:networkLocation | DIMENSION | STRING | Geo Network | Service Provider | TRUE | text | |
ga:flashVersion | DIMENSION | STRING | System | Flash Version | TRUE | text | |
ga:javaEnabled | DIMENSION | STRING | System | Java Support | TRUE | text | |
ga:language | DIMENSION | STRING | System | Language | TRUE | text | |
ga:screenColors | DIMENSION | STRING | System | Screen Colors | TRUE | text | |
ga:sourcePropertyDisplayName | DIMENSION | STRING | System | Source Property Display Name | TRUE | text | |
ga:sourcePropertyTrackingId | DIMENSION | STRING | System | Source Property Tracking ID | TRUE | text | |
ga:screenResolution | DIMENSION | STRING | System | Screen Resolution | TRUE | text | |
ga:socialActivityEndorsingUrl | DIMENSION | STRING | Social Activities | Endorsing URL | text | ||
ga:socialActivityDisplayName | DIMENSION | STRING | Social Activities | Display Name | text | ||
ga:socialActivityPost | DIMENSION | STRING | Social Activities | Social Activity Post | text | ||
ga:socialActivityTimestamp | DIMENSION | STRING | Social Activities | Social Activity Timestamp | text | ||
ga:socialActivityUserHandle | DIMENSION | STRING | Social Activities | Social User Handle | text | ||
ga:socialActivityUserPhotoUrl | DIMENSION | STRING | Social Activities | User Photo URL | text | ||
ga:socialActivityUserProfileUrl | DIMENSION | STRING | Social Activities | User Profile URL | text | ||
ga:socialActivityContentUrl | DIMENSION | STRING | Social Activities | Shared URL | text | ||
ga:socialActivityTagsSummary | DIMENSION | STRING | Social Activities | Social Tags Summary | text | ||
ga:socialActivityAction | DIMENSION | STRING | Social Activities | Originating Social Action | text | ||
ga:socialActivityNetworkAction | DIMENSION | STRING | Social Activities | Social Network and Action | text | ||
ga:socialActivities | METRIC | INTEGER | Social Activities | Data Hub Activities | number | ||
ga:hostname | DIMENSION | STRING | Page Tracking | Hostname | TRUE | text | |
ga:pagePath | DIMENSION | STRING | Page Tracking | Page | TRUE | text | |
ga:pagePathLevel1 | DIMENSION | STRING | Page Tracking | Page path level 1 | text | ||
ga:pagePathLevel2 | DIMENSION | STRING | Page Tracking | Page path level 2 | text | ||
ga:pagePathLevel3 | DIMENSION | STRING | Page Tracking | Page path level 3 | text | ||
ga:pagePathLevel4 | DIMENSION | STRING | Page Tracking | Page path level 4 | text | ||
ga:pageTitle | DIMENSION | STRING | Page Tracking | Page Title | TRUE | text | |
ga:landingPagePath | DIMENSION | STRING | Page Tracking | Landing Page | TRUE | text | |
ga:secondPagePath | DIMENSION | STRING | Page Tracking | Second Page | text | ||
ga:exitPagePath | DIMENSION | STRING | Page Tracking | Exit Page | TRUE | text | |
ga:previousPagePath | DIMENSION | STRING | Page Tracking | Previous Page Path | text | ||
ga:pageDepth | DIMENSION | STRING | Page Tracking | Page Depth | TRUE | text | |
ga:pageValue | METRIC | CURRENCY | Page Tracking | Page Value | number | ||
ga:entrances | METRIC | INTEGER | Page Tracking | Entrances | TRUE | number | |
ga:entranceRate | METRIC | PERCENT | Page Tracking | Entrances / Pageviews | number | ga:entrances / ga:pageviews | |
ga:pageviews | METRIC | INTEGER | Page Tracking | Pageviews | TRUE | number | |
ga:pageviewsPerSession | METRIC | FLOAT | Page Tracking | Pages / Session | number | ga:pageviews / ga:sessions | |
ga:contentGroupUniqueViewsXX | METRIC | INTEGER | Content Grouping | Unique Views XX | number | ||
ga:uniquePageviews | METRIC | INTEGER | Page Tracking | Unique Pageviews | TRUE | number | |
ga:timeOnPage | METRIC | TIME | Page Tracking | Time on Page | TRUE | number | |
ga:avgTimeOnPage | METRIC | TIME | Page Tracking | Avg. Time on Page | number | ga:timeOnPage / (ga:pageviews – ga:exits) | |
ga:exits | METRIC | INTEGER | Page Tracking | Exits | TRUE | number | |
ga:exitRate | METRIC | PERCENT | Page Tracking | % Exit | number | ga:exits / (ga:pageviews + ga:screenviews) | |
ga:searchUsed | DIMENSION | STRING | Internal Search | Site Search Status | TRUE | text | |
ga:searchKeyword | DIMENSION | STRING | Internal Search | Search Term | TRUE | text | |
ga:searchKeywordRefinement | DIMENSION | STRING | Internal Search | Refined Keyword | TRUE | text | |
ga:searchCategory | DIMENSION | STRING | Internal Search | Site Search Category | TRUE | text | |
ga:searchStartPage | DIMENSION | STRING | Internal Search | Start Page | text | ||
ga:searchDestinationPage | DIMENSION | STRING | Internal Search | Destination Page | text | ||
ga:searchAfterDestinationPage | DIMENSION | STRING | Internal Search | Search Destination Page | TRUE | text | |
ga:searchResultViews | METRIC | INTEGER | Internal Search | Results Pageviews | number | ||
ga:searchUniques | METRIC | INTEGER | Internal Search | Total Unique Searches | TRUE | number | |
ga:avgSearchResultViews | METRIC | FLOAT | Internal Search | Results Pageviews / Search | number | ga:searchResultViews / ga:searchUniques | |
ga:searchSessions | METRIC | INTEGER | Internal Search | Sessions with Search | TRUE | number | |
ga:percentSessionsWithSearch | METRIC | PERCENT | Internal Search | % Sessions with Search | number | ga:searchSessions / ga:sessions | |
ga:searchDepth | METRIC | INTEGER | Internal Search | Search Depth | TRUE | number | |
ga:avgSearchDepth | METRIC | FLOAT | Internal Search | Average Search Depth | number | ga:searchDepth / ga:searchUniques | |
ga:searchRefinements | METRIC | INTEGER | Internal Search | Search Refinements | TRUE | number | |
ga:percentSearchRefinements | METRIC | PERCENT | Internal Search | % Search Refinements | number | ga:searchRefinements / ga:searchResultViews | |
ga:searchDuration | METRIC | TIME | Internal Search | Time after Search | TRUE | number | |
ga:avgSearchDuration | METRIC | TIME | Internal Search | Time after Search | number | ga:searchDuration / ga:searchUniques | |
ga:searchExits | METRIC | INTEGER | Internal Search | Search Exits | TRUE | number | |
ga:searchExitRate | METRIC | PERCENT | Internal Search | % Search Exits | number | ga:searchExits / ga:searchUniques | |
ga:searchGoalXXConversionRate | METRIC | PERCENT | Internal Search | Site Search Goal XX Conversion Rate | number | ga:goalXXCompletions / ga:searchUniques | |
ga:searchGoalConversionRateAll | METRIC | PERCENT | Internal Search | Site Search Goal Conversion Rate | number | ga:goalCompletionsAll / ga:searchUniques | |
ga:goalValueAllPerSearch | METRIC | CURRENCY | Internal Search | Per Search Goal Value | number | ga:goalValueAll / ga:searchUniques | |
ga:pageLoadTime | METRIC | INTEGER | Site Speed | Page Load Time (ms) | number | ||
ga:pageLoadSample | METRIC | INTEGER | Site Speed | Page Load Sample | number | ||
ga:avgPageLoadTime | METRIC | FLOAT | Site Speed | Avg. Page Load Time (sec) | number | (ga:pageLoadTime / ga:pageLoadSample / 1000) | |
ga:domainLookupTime | METRIC | INTEGER | Site Speed | Domain Lookup Time (ms) | number | ||
ga:avgDomainLookupTime | METRIC | FLOAT | Site Speed | Avg. Domain Lookup Time (sec) | number | (ga:domainLookupTime / ga:speedMetricsSample / 1000) | |
ga:pageDownloadTime | METRIC | INTEGER | Site Speed | Page Download Time (ms) | number | ||
ga:avgPageDownloadTime | METRIC | FLOAT | Site Speed | Avg. Page Download Time (sec) | number | (ga:pageDownloadTime / ga:speedMetricsSample / 1000) | |
ga:redirectionTime | METRIC | INTEGER | Site Speed | Redirection Time (ms) | number | ||
ga:avgRedirectionTime | METRIC | FLOAT | Site Speed | Avg. Redirection Time (sec) | number | (ga:redirectionTime / ga:speedMetricsSample / 1000) | |
ga:serverConnectionTime | METRIC | INTEGER | Site Speed | Server Connection Time (ms) | number | ||
ga:avgServerConnectionTime | METRIC | FLOAT | Site Speed | Avg. Server Connection Time (sec) | number | (ga:serverConnectionTime / ga:speedMetricsSample / 1000) | |
ga:serverResponseTime | METRIC | INTEGER | Site Speed | Server Response Time (ms) | number | ||
ga:avgServerResponseTime | METRIC | FLOAT | Site Speed | Avg. Server Response Time (sec) | number | (ga:serverResponseTime / ga:speedMetricsSample / 1000) | |
ga:speedMetricsSample | METRIC | INTEGER | Site Speed | Speed Metrics Sample | number | ||
ga:domInteractiveTime | METRIC | INTEGER | Site Speed | Document Interactive Time (ms) | number | ||
ga:avgDomInteractiveTime | METRIC | FLOAT | Site Speed | Avg. Document Interactive Time (sec) | number | (ga:domInteractiveTime / ga:domLatencyMetricsSample / 1000) | |
ga:domContentLoadedTime | METRIC | INTEGER | Site Speed | Document Content Loaded Time (ms) | number | ||
ga:avgDomContentLoadedTime | METRIC | FLOAT | Site Speed | Avg. Document Content Loaded Time (sec) | number | (ga:domContentLoadedTime / ga:domLatencyMetricsSample / 1000) | |
ga:domLatencyMetricsSample | METRIC | INTEGER | Site Speed | DOM Latency Metrics Sample | number | ||
ga:appInstallerId | DIMENSION | STRING | App Tracking | App Installer ID | TRUE | text | |
ga:appVersion | DIMENSION | STRING | App Tracking | App Version | TRUE | text | |
ga:appName | DIMENSION | STRING | App Tracking | App Name | TRUE | text | |
ga:appId | DIMENSION | STRING | App Tracking | App ID | TRUE | text | |
ga:screenName | DIMENSION | STRING | App Tracking | Screen Name | TRUE | text | |
ga:screenDepth | DIMENSION | STRING | App Tracking | Screen Depth | TRUE | text | |
ga:landingScreenName | DIMENSION | STRING | App Tracking | Landing Screen | TRUE | text | |
ga:exitScreenName | DIMENSION | STRING | App Tracking | Exit Screen | TRUE | text | |
ga:screenviews | METRIC | INTEGER | App Tracking | Screen Views | TRUE | number | |
ga:uniqueScreenviews | METRIC | INTEGER | App Tracking | Unique Screen Views | TRUE | number | |
ga:screenviewsPerSession | METRIC | FLOAT | App Tracking | Screens / Session | number | ga:screenviews / ga:sessions | |
ga:timeOnScreen | METRIC | TIME | App Tracking | Time on Screen | TRUE | number | |
ga:avgScreenviewDuration | METRIC | TIME | App Tracking | Avg. Time on Screen | number | ||
ga:eventCategory | DIMENSION | STRING | Event Tracking | Event Category | TRUE | text | |
ga:eventAction | DIMENSION | STRING | Event Tracking | Event Action | TRUE | text | |
ga:eventLabel | DIMENSION | STRING | Event Tracking | Event Label | TRUE | text | |
ga:totalEvents | METRIC | INTEGER | Event Tracking | Total Events | TRUE | number | |
ga:uniqueEvents | METRIC | INTEGER | Event Tracking | Unique Events | number | ||
ga:eventValue | METRIC | INTEGER | Event Tracking | Event Value | TRUE | number | |
ga:avgEventValue | METRIC | FLOAT | Event Tracking | Avg. Value | number | ga:eventValue / ga:totalEvents | |
ga:sessionsWithEvent | METRIC | INTEGER | Event Tracking | Sessions with Event | TRUE | number | |
ga:eventsPerSessionWithEvent | METRIC | FLOAT | Event Tracking | Events / Session with Event | number | ga:totalEvents / ga:sessionsWithEvent | |
ga:transactionId | DIMENSION | STRING | Ecommerce | Transaction ID | TRUE | text | |
ga:affiliation | DIMENSION | STRING | Ecommerce | Affiliation | TRUE | text | |
ga:sessionsToTransaction | DIMENSION | STRING | Ecommerce | Sessions to Transaction | TRUE | text | |
ga:daysToTransaction | DIMENSION | STRING | Ecommerce | Days to Transaction | TRUE | text | |
ga:productSku | DIMENSION | STRING | Ecommerce | Product SKU | TRUE | text | |
ga:productName | DIMENSION | STRING | Ecommerce | Product | TRUE | text | |
ga:productCategory | DIMENSION | STRING | Ecommerce | Product Category | TRUE | text | |
ga:currencyCode | DIMENSION | STRING | Ecommerce | Currency Code | text | ||
ga:transactions | METRIC | INTEGER | Ecommerce | Transactions | TRUE | number | |
ga:transactionsPerSession | METRIC | PERCENT | Ecommerce | Ecommerce Conversion Rate | number | ga:transactions / ga:sessions | |
ga:transactionRevenue | METRIC | CURRENCY | Ecommerce | Revenue | TRUE | number | |
ga:revenuePerTransaction | METRIC | CURRENCY | Ecommerce | Average Order Value | number | ga:transactionRevenue / ga:transactions | |
ga:transactionRevenuePerSession | METRIC | CURRENCY | Ecommerce | Per Session Value | number | ga:transactionRevenue / ga:sessions | |
ga:transactionShipping | METRIC | CURRENCY | Ecommerce | Shipping | TRUE | number | |
ga:transactionTax | METRIC | CURRENCY | Ecommerce | Tax | TRUE | number | |
ga:totalValue | METRIC | CURRENCY | Ecommerce | Total Value | number | (ga:transactionRevenue + ga:goalValueAll) | |
ga:itemQuantity | METRIC | INTEGER | Ecommerce | Quantity | TRUE | number | |
ga:uniquePurchases | METRIC | INTEGER | Ecommerce | Unique Purchases | TRUE | number | |
ga:revenuePerItem | METRIC | CURRENCY | Ecommerce | Average Price | number | ga:itemRevenue / ga:itemQuantity | |
ga:itemRevenue | METRIC | CURRENCY | Ecommerce | Product Revenue | TRUE | number | |
ga:itemsPerPurchase | METRIC | FLOAT | Ecommerce | Average QTY | number | ga:itemQuantity / ga:uniquePurchases | |
ga:localTransactionRevenue | METRIC | CURRENCY | Ecommerce | Local Revenue | number | ||
ga:localTransactionShipping | METRIC | CURRENCY | Ecommerce | Local Shipping | number | ||
ga:localTransactionTax | METRIC | CURRENCY | Ecommerce | Local Tax | number | ||
ga:localItemRevenue | METRIC | CURRENCY | Ecommerce | Local Product Revenue | TRUE | number | |
ga:socialInteractionNetwork | DIMENSION | STRING | Social Interactions | Social Source | text | ||
ga:socialInteractionAction | DIMENSION | STRING | Social Interactions | Social Action | text | ||
ga:socialInteractionNetworkAction | DIMENSION | STRING | Social Interactions | Social Source and Action | text | ||
ga:socialInteractionTarget | DIMENSION | STRING | Social Interactions | Social Entity | text | ||
ga:socialEngagementType | DIMENSION | STRING | Social Interactions | Social Type | text | ||
ga:socialInteractions | METRIC | INTEGER | Social Interactions | Social Actions | number | ||
ga:uniqueSocialInteractions | METRIC | INTEGER | Social Interactions | Unique Social Actions | number | ||
ga:socialInteractionsPerSession | METRIC | FLOAT | Social Interactions | Actions Per Social Session | number | ga:socialInteractions / ga:uniqueSocialInteractions | |
ga:userTimingCategory | DIMENSION | STRING | User Timings | Timing Category | TRUE | text | |
ga:userTimingLabel | DIMENSION | STRING | User Timings | Timing Label | TRUE | text | |
ga:userTimingVariable | DIMENSION | STRING | User Timings | Timing Variable | TRUE | text | |
ga:userTimingValue | METRIC | INTEGER | User Timings | User Timing (ms) | number | ||
ga:userTimingSample | METRIC | INTEGER | User Timings | User Timing Sample | number | ||
ga:avgUserTimingValue | METRIC | FLOAT | User Timings | Avg. User Timing (sec) | number | (ga:userTimingValue / ga:userTimingSample / 1000) | |
ga:exceptionDescription | DIMENSION | STRING | Exceptions | Exception Description | TRUE | text | |
ga:exceptions | METRIC | INTEGER | Exceptions | Exceptions | TRUE | number | |
ga:exceptionsPerScreenview | METRIC | PERCENT | Exceptions | Exceptions / Screen | number | ga:exceptions / ga:screenviews | |
ga:fatalExceptions | METRIC | INTEGER | Exceptions | Crashes | TRUE | number | |
ga:fatalExceptionsPerScreenview | METRIC | PERCENT | Exceptions | Crashes / Screen | number | ga:fatalExceptions / ga:screenviews | |
ga:experimentId | DIMENSION | STRING | Content Experiments | Experiment ID | TRUE | text | |
ga:experimentVariant | DIMENSION | STRING | Content Experiments | Variation | TRUE | text | |
ga:dimensionXX | DIMENSION | STRING | Custom Variables or Columns | Custom Dimension XX | TRUE | text | |
ga:customVarNameXX | DIMENSION | STRING | Custom Variables or Columns | Custom Variable (Key XX) | TRUE | text | |
ga:metricXX | METRIC | INTEGER | Custom Variables or Columns | Custom Metric XX Value | TRUE | number | |
ga:customVarValueXX | DIMENSION | STRING | Custom Variables or Columns | Custom Variable (Value XX) | TRUE | text | |
ga:date | DIMENSION | STRING | Time | Date | text | ||
ga:year | DIMENSION | STRING | Time | Year | text | ||
ga:month | DIMENSION | STRING | Time | Month of the year | text | ||
ga:week | DIMENSION | STRING | Time | Week of the Year | text | ||
ga:day | DIMENSION | STRING | Time | Day of the month | text | ||
ga:hour | DIMENSION | STRING | Time | Hour | TRUE | text | |
ga:minute | DIMENSION | STRING | Time | Minute | TRUE | text | |
ga:nthMonth | DIMENSION | STRING | Time | Month Index | text | ||
ga:nthWeek | DIMENSION | STRING | Time | Week Index | text | ||
ga:nthDay | DIMENSION | STRING | Time | Day Index | text | ||
ga:nthMinute | DIMENSION | STRING | Time | Minute Index | text | ||
ga:dayOfWeek | DIMENSION | STRING | Time | Day of Week | text | ||
ga:dayOfWeekName | DIMENSION | STRING | Time | Day of Week Name | text | ||
ga:dateHour | DIMENSION | STRING | Time | Hour of Day | text | ||
ga:yearMonth | DIMENSION | STRING | Time | Month of Year | text | ||
ga:yearWeek | DIMENSION | STRING | Time | Week of Year | text | ||
ga:isoWeek | DIMENSION | STRING | Time | ISO Week of the Year | text | ||
ga:isoYear | DIMENSION | STRING | Time | ISO Year | text | ||
ga:isoYearIsoWeek | DIMENSION | STRING | Time | ISO Week of ISO Year | text | ||
ga:dcmClickAd | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad (GA Model) | text | ||
ga:dcmClickAdId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad ID (GA Model) | text | ||
ga:dcmClickAdType | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad Type (GA Model) | text | ||
ga:dcmClickAdTypeId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad Type ID | text | ||
ga:dcmClickAdvertiser | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Advertiser (GA Model) | text | ||
ga:dcmClickAdvertiserId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Advertiser ID (GA Model) | text | ||
ga:dcmClickCampaign | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Campaign (GA Model) | text | ||
ga:dcmClickCampaignId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Campaign ID (GA Model) | text | ||
ga:dcmClickCreativeId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative ID (GA Model) | text | ||
ga:dcmClickCreative | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative (GA Model) | text | ||
ga:dcmClickRenderingId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Rendering ID (GA Model) | text | ||
ga:dcmClickCreativeType | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative Type (GA Model) | text | ||
ga:dcmClickCreativeTypeId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative Type ID (GA Model) | text | ||
ga:dcmClickCreativeVersion | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative Version (GA Model) | text | ||
ga:dcmClickSite | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Site (GA Model) | text | ||
ga:dcmClickSiteId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Site ID (GA Model) | text | ||
ga:dcmClickSitePlacement | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Placement (GA Model) | text | ||
ga:dcmClickSitePlacementId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Placement ID (GA Model) | text | ||
ga:dcmClickSpotId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Floodlight Configuration ID (GA Model) | text | ||
ga:dcmFloodlightActivity | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Activity | text | ||
ga:dcmFloodlightActivityAndGroup | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Activity and Group | text | ||
ga:dcmFloodlightActivityGroup | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Activity Group | text | ||
ga:dcmFloodlightActivityGroupId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Activity Group ID | text | ||
ga:dcmFloodlightActivityId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Activity ID | text | ||
ga:dcmFloodlightAdvertiserId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Advertiser ID | text | ||
ga:dcmFloodlightSpotId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Floodlight Configuration ID | text | ||
ga:dcmLastEventAd | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad | text | ||
ga:dcmLastEventAdId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad ID (DFA Model) | text | ||
ga:dcmLastEventAdType | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad Type (DFA Model) | text | ||
ga:dcmLastEventAdTypeId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Ad Type ID (DFA Model) | text | ||
ga:dcmLastEventAdvertiser | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Advertiser (DFA Model) | text | ||
ga:dcmLastEventAdvertiserId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Advertiser ID (DFA Model) | text | ||
ga:dcmLastEventAttributionType | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Attribution Type (DFA Model) | text | ||
ga:dcmLastEventCampaign | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Campaign (DFA Model) | text | ||
ga:dcmLastEventCampaignId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Campaign ID (DFA Model) | text | ||
ga:dcmLastEventCreativeId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative ID (DFA Model) | text | ||
ga:dcmLastEventCreative | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative (DFA Model) | text | ||
ga:dcmLastEventRenderingId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Rendering ID (DFA Model) | text | ||
ga:dcmLastEventCreativeType | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative Type (DFA Model) | text | ||
ga:dcmLastEventCreativeTypeId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative Type ID (DFA Model) | text | ||
ga:dcmLastEventCreativeVersion | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Creative Version (DFA Model) | text | ||
ga:dcmLastEventSite | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Site (DFA Model) | text | ||
ga:dcmLastEventSiteId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Site ID (DFA Model) | text | ||
ga:dcmLastEventSitePlacement | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Placement (DFA Model) | text | ||
ga:dcmLastEventSitePlacementId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Placement ID (DFA Model) | text | ||
ga:dcmLastEventSpotId | DIMENSION | STRING | DoubleClick Campaign Manager | DFA Floodlight Configuration ID (DFA Model) | text | ||
ga:dcmFloodlightQuantity | METRIC | INTEGER | DoubleClick Campaign Manager | DFA Conversions | number | ||
ga:dcmFloodlightRevenue | METRIC | CURRENCY | DoubleClick Campaign Manager | DFA Revenue | number | ||
ga:landingContentGroupXX | DIMENSION | STRING | Content Grouping | Landing Page Group XX | TRUE | text | |
ga:previousContentGroupXX | DIMENSION | STRING | Content Grouping | Previous Page Group XX | TRUE | text | |
ga:contentGroupXX | DIMENSION | STRING | Content Grouping | Page Group XX | TRUE | text | |
ga:userAgeBracket | DIMENSION | STRING | Audience | Age | text | ||
ga:userGender | DIMENSION | STRING | Audience | Gender | text | ||
ga:interestOtherCategory | DIMENSION | STRING | Audience | Other Category | text | ||
ga:interestAffinityCategory | DIMENSION | STRING | Audience | Affinity Category (reach) | text | ||
ga:interestInMarketCategory | DIMENSION | STRING | Audience | In-Market Segment | text | ||
ga:adsenseRevenue | METRIC | CURRENCY | Adsense | AdSense Revenue | TRUE | number | |
ga:adsenseAdUnitsViewed | METRIC | INTEGER | Adsense | AdSense Ad Units Viewed | TRUE | number | |
ga:adsenseAdsViewed | METRIC | INTEGER | Adsense | AdSense Impressions | TRUE | number | |
ga:adsenseAdsClicks | METRIC | INTEGER | Adsense | AdSense Ads Clicked | TRUE | number | |
ga:adsensePageImpressions | METRIC | INTEGER | Adsense | AdSense Page Impressions | TRUE | number | |
ga:adsenseCTR | METRIC | PERCENT | Adsense | AdSense CTR | number | ga:adsenseAdsClicks/ga:adsensePageImpressions | |
ga:adsenseECPM | METRIC | CURRENCY | Adsense | AdSense eCPM | number | ga:adsenseRevenue/(ga:adsensePageImpressions/1000) | |
ga:adsenseExits | METRIC | INTEGER | Adsense | AdSense Exits | TRUE | number | |
ga:adsenseViewableImpressionPercent | METRIC | PERCENT | Adsense | AdSense Viewable Impression % | number | ||
ga:adsenseCoverage | METRIC | PERCENT | Adsense | AdSense Coverage | number | ||
ga:adxImpressions | METRIC | INTEGER | Ad Exchange | AdX Impressions | TRUE | number | |
ga:adxCoverage | METRIC | PERCENT | Ad Exchange | AdX Coverage | number | ||
ga:adxMonetizedPageviews | METRIC | INTEGER | Ad Exchange | AdX Monetized Pageviews | TRUE | number | |
ga:adxImpressionsPerSession | METRIC | FLOAT | Ad Exchange | AdX Impressions / Session | number | ||
ga:adxViewableImpressionsPercent | METRIC | PERCENT | Ad Exchange | AdX Viewable Impressions % | number | ||
ga:adxClicks | METRIC | INTEGER | Ad Exchange | AdX Clicks | TRUE | number | |
ga:adxCTR | METRIC | PERCENT | Ad Exchange | AdX CTR | number | ||
ga:adxRevenue | METRIC | CURRENCY | Ad Exchange | AdX Revenue | TRUE | number | |
ga:adxRevenuePer1000Sessions | METRIC | CURRENCY | Ad Exchange | AdX Revenue / 1000 Sessions | number | ||
ga:adxECPM | METRIC | CURRENCY | Ad Exchange | AdX eCPM | number | ||
ga:campaignCode | DIMENSION | STRING | Traffic Sources | Campaign Code | text | ||
ga:channelGrouping | DIMENSION | STRING | Channel Grouping | Default Channel Grouping | TRUE | text | |
ga:checkoutOptions | DIMENSION | STRING | Ecommerce | Checkout Options | TRUE | text | |
ga:cityId | DIMENSION | STRING | Geo Network | City ID | FALSE | text | |
ga:correlationModelId | DIMENSION | STRING | Related Products | Correlation Model ID | text | ||
ga:countryIsoCode | DIMENSION | STRING | Geo Network | Country ISO Code | FALSE | text | |
ga:dataSource | DIMENSION | STRING | Platform or Device | Data Source | TRUE | text | |
ga:internalPromotionCreative | DIMENSION | STRING | Ecommerce | Internal Promotion Creative | TRUE | text | |
ga:internalPromotionId | DIMENSION | STRING | Ecommerce | Internal Promotion ID | TRUE | text | |
ga:internalPromotionName | DIMENSION | STRING | Ecommerce | Internal Promotion Name | TRUE | text | |
ga:internalPromotionPosition | DIMENSION | STRING | Ecommerce | Internal Promotion Position | TRUE | text | |
ga:isTrueViewVideoAd | DIMENSION | STRING | Adwords | TrueView Video Ad | text | ||
ga:nthHour | DIMENSION | STRING | Time | Hour Index | text | ||
ga:orderCouponCode | DIMENSION | STRING | Ecommerce | Order Coupon Code | TRUE | text | |
ga:productBrand | DIMENSION | STRING | Ecommerce | Product Brand | TRUE | text | |
ga:productCategoryHierarchy | DIMENSION | STRING | Ecommerce | Product Category (Enhanced Ecommerce) | TRUE | text | |
ga:productCategoryLevelXX | DIMENSION | STRING | Ecommerce | Product Category Level XX | TRUE | text | |
ga:productCouponCode | DIMENSION | STRING | Ecommerce | Product Coupon Code | TRUE | text | |
ga:productListName | DIMENSION | STRING | Ecommerce | Product List Name | TRUE | text | |
ga:productListPosition | DIMENSION | STRING | Ecommerce | Product List Position | TRUE | text | |
ga:productVariant | DIMENSION | STRING | Ecommerce | Product Variant | TRUE | text | |
ga:queryProductId | DIMENSION | STRING | Related Products | Queried Product ID | text | ||
ga:queryProductName | DIMENSION | STRING | Related Products | Queried Product Name | text | ||
ga:queryProductVariation | DIMENSION | STRING | Related Products | Queried Product Variation | text | ||
ga:regionId | DIMENSION | STRING | Geo Network | Region ID | FALSE | text | |
ga:regionIsoCode | DIMENSION | STRING | Geo Network | Region ISO Code | FALSE | text | |
ga:relatedProductId | DIMENSION | STRING | Related Products | Related Product ID | text | ||
ga:relatedProductName | DIMENSION | STRING | Related Products | Related Product Name | text | ||
ga:relatedProductVariation | DIMENSION | STRING | Related Products | Related Product Variation | text | ||
ga:shoppingStage | DIMENSION | STRING | Ecommerce | Shopping Stage | TRUE | text | |
ga:subContinentCode | DIMENSION | STRING | Geo Network | Sub Continent Code | text | ||
ga:buyToDetailRate | METRIC | PERCENT | Ecommerce | Buy-to-Detail Rate | number | ||
ga:cartToDetailRate | METRIC | PERCENT | Ecommerce | Cart-to-Detail Rate | number | ||
ga:correlationScore | METRIC | CURRENCY | Related Products | Correlation Score | number | ||
ga:dcmCPC | METRIC | CURRENCY | DoubleClick Campaign Manager | DFA CPC | number | ||
ga:dcmCTR | METRIC | PERCENT | DoubleClick Campaign Manager | DFA CTR | number | ||
ga:dcmClicks | METRIC | INTEGER | DoubleClick Campaign Manager | DFA Clicks | number | ||
ga:dcmCost | METRIC | CURRENCY | DoubleClick Campaign Manager | DFA Cost | number | ||
ga:dcmImpressions | METRIC | INTEGER | DoubleClick Campaign Manager | DFA Impressions | number | ||
ga:dcmROAS | METRIC | PERCENT | DoubleClick Campaign Manager | DFA ROAS | number | ||
ga:dcmRPC | METRIC | CURRENCY | DoubleClick Campaign Manager | DFA RPC | number | ||
ga:hits | METRIC | INTEGER | Session | Hits | TRUE | number | |
ga:internalPromotionCTR | METRIC | PERCENT | Ecommerce | Internal Promotion CTR | number | ga:internalPromotionClicks / ga:internalPromotionViews | |
ga:internalPromotionClicks | METRIC | INTEGER | Ecommerce | Internal Promotion Clicks | TRUE | number | |
ga:internalPromotionViews | METRIC | INTEGER | Ecommerce | Internal Promotion Views | TRUE | number | |
ga:localProductRefundAmount | METRIC | CURRENCY | Ecommerce | Local Product Refund Amount | TRUE | number | |
ga:localRefundAmount | METRIC | CURRENCY | Ecommerce | Local Refund Amount | TRUE | number | |
ga:productAddsToCart | METRIC | INTEGER | Ecommerce | Product Adds To Cart | TRUE | number | |
ga:productCheckouts | METRIC | INTEGER | Ecommerce | Product Checkouts | TRUE | number | |
ga:productDetailViews | METRIC | INTEGER | Ecommerce | Product Detail Views | TRUE | number | |
ga:productListCTR | METRIC | PERCENT | Ecommerce | Product List CTR | number | ga:productListClicks / ga:productListViews | |
ga:productListClicks | METRIC | INTEGER | Ecommerce | Product List Clicks | TRUE | number | |
ga:productListViews | METRIC | INTEGER | Ecommerce | Product List Views | TRUE | number | |
ga:productRefundAmount | METRIC | CURRENCY | Ecommerce | Product Refund Amount | TRUE | number | |
ga:productRefunds | METRIC | INTEGER | Ecommerce | Product Refunds | TRUE | number | |
ga:productRemovesFromCart | METRIC | INTEGER | Ecommerce | Product Removes From Cart | TRUE | number | |
ga:productRevenuePerPurchase | METRIC | CURRENCY | Ecommerce | Product Revenue per Purchase | number | ga:itemRevenue / ga:uniquePurchases | |
ga:quantityAddedToCart | METRIC | INTEGER | Ecommerce | Quantity Added To Cart | TRUE | number | |
ga:quantityCheckedOut | METRIC | INTEGER | Ecommerce | Quantity Checked Out | TRUE | number | |
ga:quantityRefunded | METRIC | INTEGER | Ecommerce | Quantity Refunded | TRUE | number | |
ga:quantityRemovedFromCart | METRIC | INTEGER | Ecommerce | Quantity Removed From Cart | TRUE | number | |
ga:queryProductQuantity | METRIC | INTEGER | Related Products | Queried Product Quantity | number | ||
ga:refundAmount | METRIC | CURRENCY | Ecommerce | Refund Amount | TRUE | number | |
ga:relatedProductQuantity | METRIC | INTEGER | Related Products | Related Product Quantity | number | ||
ga:revenuePerUser | METRIC | CURRENCY | Ecommerce | Revenue per User | FALSE | number | |
ga:sessionsPerUser | METRIC | FLOAT | User | Number of Sessions per User | FALSE | number | |
ga:totalRefunds | METRIC | INTEGER | Ecommerce | Refunds | TRUE | number | |
ga:transactionsPerUser | METRIC | FLOAT | Ecommerce | Transactions per User | FALSE | number |
1 komentář u „Google Analytics – Tabulka všech dimenzí a metrik“
Super, prosím ještě tak přidat vazbu na elementy mezi sebou a hlavně kdy spojení atributů přes API způsobí inner join a kdy je zachován left join. Tedy neexistance elementu nezpůsobí odfiltrování řádku.