Tables v1

Tables v1

API Table of Contents

Table ID	Dimension for query	Metrics for query	Description
1	utm_source, utm_medium, utm_campaign, utm_term, request_stem	pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4	Marketing Campaign results
2	utm_source, utm_medium, utm_term, utm_content	pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4	Marketing Keyword Conversion and Ad Version information
3	geo_country, geo_region, geo_city, geo_latitude, geo_longitude	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	Visitor Geo Location information such as Country, Region, City, Latitude and Longitude
4	geo_organization	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	Visitor Organization information.
5	domain_complete, domain_primary	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	metrics by ISP domain determined by user IP address
6	utm_language	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	metrics by browser language code setting.
7	browser_base, browser_version, platform_base, platform_version, geo_connection_speed	visits	Browser, Platform and Visitor Connection Speed information.
8	utm_screen_resolution, utm_screen_colors, utm_java_enabled, utm_js_version, utm_flash_version	visits	Screen resolution and color depth, Javascript and Flash version for visitor.
9	username	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	metrics by username (if any)
10	user_defined_variable	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	metrics by arbitrary segment variable value
11	visitor_type	pages, visits, transactions, revenue, goals1, goals2, goals3, goals4	New and Returning visitors.
12	request_stem, utm_page_title	pages, entrancepages, exitpages, bouncepages, pagetime, visits, score	Pages & Files
13	request_stem, request_query	pages	Pages & Files
14	clickthru_page_from, clickthru_page_to	pages, transactions, revenue, goals1, goals2, goals3, goals4	Goals & Funnel Process information
15	initial_path_page1, initial_path_page2, initial_path_page3	visits, transactions, revenue, goals1, goals2, goals3, goals4	Goals & Funnel Process information
16	goal_clickthru_entrance_page, goal_clickthru_exit_page	visits	Defined Funnel Navigation information
17	rev_goal_path, rev_goal_path_page1, rev_goal_path_page2, rev_goal_path_page3	goals1, goals2, goals3, goals4	Reverse Goal Path information
18	utm_campaign_goal	goals1, goals2, goals3, goals4	Goal Tracking information
19	utm_term, utm_campaign_hour	transactions, revenue, responses, goals1, goals2, goals3, goals4	Goal Conversion information
20	ecommerce_bill_country, ecommerce_bill_region, ecommerce_bill_city	transactions, revenue	Billing information for e-commerce transactions
21	ecommerce_affiliation	transactions, revenue	affiliate marketing information for e-commerce transactions
22	ecommerce_product_name, ecommerce_product_code, ecommerce_variation	transactions, items, itemrevenue	Product information for e-commerce transactions
23	ecommerce_product_name, ecommerce_bill_country, ecommerce_bill_region, ecommerce_bill_city	transactions, items, itemrevenue	Product City,Region,Country Correlation information for e-commerce transactions
24	ecommerce_product_name, utm_source, utm_medium, utm_term	transactions, items, itemrevenue	Product Keyword, Source, Medium Correlation and Referring Sources informations for e-commerce transactions.
25	utm_request_hostname	pages	Host names of the compaign hit.
26	domain_complete, domain_primary, client_ipaddress	hits, bytes	ISP domain information determined by user IP address; number of hits and bytes transferred.
27	browser_base, browser_version, platform_base, platform_version, geo_connection_speed	hits, bytes	Browser, Platform, Visitor Connection Speed, hits and bytes transferred.
28	username	validhits, bytes	visitors by username (if any), number of successful hits and bytes transferred.
29	request_origfilepath, request_origmime	validhits, bytes	Pages & Files; number of successful hits, and number of bytes transferred.
30	request_download	validhits, bytes	list of download requests
31	request_form	validhits	list of requested "posted form".
32	sc_status	hits	return status codes from server
33	sc_status, request_origfilepath, referral_host, referral_stem, username	errorhits	Referral Errors information.
34	robot_agent, cs_useragent	validhits, errorhits, bytes	robot information.
35	robot_agent, cs_useragent, request_origfilepath	hits	robot Content information
36	log_source_name	hits, bytes	list of log source assigned to profile and their information
37	utm_campaign, cpc_account, cpc_campaign, cpc_adgroup, cpc_keyword	pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4	Advertiser information for UTM campaign
38	utm_term, cpc_account, cpc_campaign, cpc_adgroup, cpc_keyword	pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4	Advertiser information for UTM term (keyword)
39	utm_source, utm_medium, utm_campaign, utm_term,utm_content	pages, visits, transactions, revenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4	ROI reports information
256	visitor_id	pages, visits, visitors, transactions, revenue, goals1, goals2, goals3, goals4	metrics by visitor id
257	transaction_id	transactions, revenue, tax, shipping, items	metrics by transaction id
258	totals, month, day, hour	hits, validhits, errorhits, bytes, pages, nonpages, entrancepages, exitpages, bouncepages, pagetime, visits, visitors, newvisitors, priorvisitors, transactions, customers, newcustomers, priorcustomers, revenue, tax, shipping, items, itemrevenue, responses, impressions, clicks, cost, goals1, goals2, goals3, goals4, goalstarts1, goalstarts2, goalstarts3, avgsessiontime	aggregates by period (for example monthly, daily, hourly totals).