Google BigQuery is purpose built for analytics data and has in-built acceleration for Looker Studio. Fast loading reports allow for better data exploration.
By routinely pulling data from the Search Console API and warehousing it, your will never lose your data and create richer insights.
Ownership and direct access to your data enables customized reporting and the ability to analyze your data in any way you want.
In App Extension
Branch Explorer is an extension available in Jepto that transforms and enriches your Google Search Console data to illuminate actionable insights.
A Jepto pipeline fetches your data from Google Search Console and pushes it in Google BigQuery.
Branch Explorer enriches that data in Google BigQuery to make it more useful.
The Branch Explorer Dashboard lets you refine and filter your search data in Data Studio.
| Field | Type | Description |
|---|---|---|
|
entityType |
 String
|
Grouping of the data (Query, Page, Sitemap) |
|
date |
 Date
|
Date of the search in Pacific Time Zone (PT) |
|
searchType |
String
|
Which search tab contained the link seen by the user |
|
device |
String
|
The type of device on which the user is searching |
|
country |
String
|
The country where the search came from |
|
searchAppearance |
String
|
The specific search result type or feature |
|
insertId |
String
|
Composite key of the data |
| Field | Type | Description |
|---|---|---|
|
query |
String
|
Search string that users searched for on Google |
|
page |
String
|
The final URL linked by a Search result after any skip redirects |
|
clicks |
 Integer
|
Count of clicks from a Google search result that landed the user on your property |
|
impressions |
Integer
|
How many links to your property a user saw on Google search results. Impressions are counted when the user visits that page of results, even if the result was not scrolled into view. |
|
ctr |
Float
|
Click-through rate: The click count divided by the impression count |
|
position |
Float
|
The position of the topmost link to your property in search results, averaged across all queries in which your property appeared |
| Field | Type | Description |
|---|---|---|
|
pageClicks |
Integer
|
Count of clicks from a Google search result that landed the user on your page |
|
pageImpressions |
Integer
|
How many links to your page a user saw on Google search results. Impressions are counted when the user visits that page of results, even if the result was not scrolled into view. |
|
pageCTR |
Float
|
Click-through rate: The click count divided by the impression count |
|
pagePosition |
Float
|
The position of the topmost link to your page in search results, averaged across all queries in which your property appeared |
|
wordsInQuery |
Integer
|
Number of words in the query |
|
protocol |
String
|
Transfer protocol of the page (http or https) |
|
hostName |
String
|
Hostname of the page |
|
pagePath1 |
String
|
First level directory of the page |
|
pagePath2 |
String
|
Second level directory of the page |
|
pagePath3 |
String
|
Third level directory of the page |
|
pagePath4 |
String
|
Fourth level directory of the page |
|
queryParameter |
String
|
Query parameters of the page |
|
anchorTag |
String
|
Anchor tag of the page |
| Field | Type | Description |
|---|---|---|
|
sitemapPath |
String
|
The URL where the sitemap is posted, relative to the property root. |
|
sitemapLastSubmitted |
String
|
The date when the sitemap was last submitted to Google using this report |
|
sitemapPending |
 Boolean
|
If true, the sitemap has not been processed. |
|
sitemapList |
Boolean
|
If true, the sitemap is a collection of sitemaps. |
|
sitemapType |
String
|
The type of sitemap. (Possible Options: Sitemap: Sitemap in XML or text format, Sitemap index: A sitemap of sitemaps, RSS: Sitemap in RSS feed format, Atom: Sitemap in Atom feed format or Unknown) |
|
sitemapLastDownloaded |
String
|
Date & time in which this sitemap was last downloaded. Date format is in RFC 3339 format (yyyy-mm-dd). |
|
sitemapWarnings |
Integer
|
The number of warnings in the sitemap. |
|
sitemapErrors |
Integer
|
Number of errors in the sitemap. These are issues with the sitemap itself that need to be fixed before it can be processed correctly. |
|
sitemapContentType |
String
|
The specific type of content in this sitemap (androidApp, image, iosApp, mobile, news, pattern, video, web) |
|
sitemapContentSubmitted |
Integer
|
Date & time in which this sitemap was submitted. Date format is in RFC 3339 format (yyyy-mm-dd). |
|
sitemapContentIndexed |
Integer
|
The number of URLs from the sitemap that were indexed (of the content type) |
