Urchin WebAnalytics Software is discontinued and is no longer supported. All Urchin documentation applies only to the Urchin product as it was at the time of discontinuation, and does not apply to any Google Analytics products or services.

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).

 
true
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false