Custom tables
- Last Updated: July 2, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
The driver provides thirteen custom tables, as described in the table below. Each table contains compatible Google Analytics metrics and dimensions. Custom tables allow you to simplify and write more effective queries against Google Analytics. Custom tables can be added to your Google Analytics relational schema, and further customized, using the Configuration Manager.
| Table | Dimensions Available | Metrics |
|---|---|---|
| Adsense | _campaign _date _day _dayOfWeek _dayOfWeekName _hour _month _week _year _yearMonth |
adsenseAdsClicks adsensePageImpressions adsenseRevenue goalValueAll organicSearches sessions transactionRevenue users |
| Adwords | _campaign _date _day _dayOfWeek _dayOfWeekName _hour _month _week _year _yearMonth |
adClicks adCost goalValueAll impressions organicSearches sessions transactionRevenue |
| Campaign | _date _day _dayOfWeek _dayOfWeekName _hour _month _week _year _yearMonth _dcmLastEventAd _dcmLastEventAdType _dcmLastEventAdvertiser _dcmLastEventCampaign _dcmLastEventCreative _dcmLastEventCreativeType _dcmLastEventCreativeVersion _dcmLastEventSite _dcmLastEventSitePlacement _dcmLastEventSpotId |
dcmCPC dcmCTR dcmClicks dcmCost dcmImpressions dcmMargin dcmROI dcmRPC |
| Commerce | _affiliation _campaign _city _continent _country _date _day _dayOfWeek _dayOfWeekName _daysSinceLastSession _daysToTransaction _hostname _hour _keyword _language _metro _month _networkDomain _networkLocation _region _source _userGender _userType _week _year _yearMonth |
itemQuantity sessions transactionRevenue transactionShipping transactionTax transactions uniquePurchases users |
| Entrance | _browser _city _continent _country _date _day _dayOfWeek _dayOfWeekName _hour _metro _month _networkDomain _networkLocation _region _week _year _yearMonth |
bounces entranceRate entrances pageviews sessions users |
| Event | _city _continent _country _date _day _dayOfWeek _dayOfWeekName _eventAction _eventCategory _eventLabel _hour _language _metro _month _networkDomain _networkLocation _region _week _year |
eventValue totalEvents uniqueEvents |
| Exit | _browser _city _continent _country _date _day _dayOfWeek _dayOfWeekName _hour _metro _month _networkDomain _networkLocation _region _week _year _yearMonth |
bounces exitRate exits pageviews sessions users |
| Floodlight | _date _year _month _week _day _hour _dayOfWeek _dayOfWeekName _yearMonth _dcmClickAd _dcmClickAdvertiser _dcmClickCampaign _dcmClickCreative _dcmClickCreativeType _dcmClickCreativeVersion _dcmClickSite _dcmClickSitePlacement _dcmClickSpotId _dcmFloodlightActivity _dcmFloodlightActivityGroup |
dcmFloodlightQuantity dcmFloodlightRevenue |
| Overview | _browser _city _country _date _language _networkLocation _operatingSystem _screenResolution |
avgSessionDuration bounceRate pageviews pageviewsPerSession percentNewSessions sessions users |
| PageSpeed | _date _day _dayOfWeek _dayOfWeekName _hour _month _week _year _yearMonth |
domainLookupTime pageDownloadTime pageLoadSample pageLoadTime pageviews redirectionTime serverConnectionTime serverResponseTime speedMetricsSample |
| PageUsage | _browser _campaign _city _continent _country _date _day _dayOfWeek _dayOfWeekName _hour _metro _month _networkDomain _networkLocation _operatingSystem _region _source _week _year _yearMonth |
bounces goalCompletionsAll newUsers pageviews sessionDuration sessions transactionRevenue users |
| Search | _browser _city _continent _country _date _dayOfWeek _dayOfWeekName _language _metro _networkDomain _networkLocation _operatingSystem _region _searchCategory _searchDestinationPage _searchKeyword _searchStartPage _searchUsed |
organicSearches searchDepth searchDuration searchExits searchUniques |
| Usage | _city _continent _country _date _day _dayOfWeek _dayOfWeekName _hostname _hour _language _metro _month _networkDomain _networkLocation _region _userType _week _year _yearMonth |
bounces entrances exits pageLoadSample pageLoadTime pageviews sessionDuration sessions timeOnPage uniquePageviews |