Jepto

Help Center

Close
Frequently Asked Questions

Frequently Asked Questions

Clients

Clients

Users

Users

Insights

Insights

Automation Jobs

Automation Jobs

Insights

Automation | Google Search Console

Google Search Console

Automation | Google Business Profile

Google Business Profile

Automation | Google Ads

Google Ads

Automation | Google Analytics

Google Analytics

Automation | Website

Website

Automation | Facebook Ads

Facebook Ads

Automation | Microsoft Ads

Microsoft Ads
KPI Management

KPI Management

KPI Management | Google Analytics

Google Analytics

KPI Management | Google Ads

Google Ads

KPI Management | Google Business Profile

Google Business Profile

KPI Management | Facebook Ads

Facebook Ads

KPI Management | Microsoft Ads

Microsoft Ads

KPI Management | Google Sheets

Google Sheets
Budget Tracking

Budget Tracking

Budget Tracking | Google Sheets

Google Sheets
Anomaly Detection

Anomaly Detection

Data Warehouse

Data Warehouse

Data Warehouse | Google Data Studio

Google Data Studio

Data Warehouse | BigQuery

Google BigQuery

Data Warehouse | Google Business Profile

Google Business Profile (Formerly Google My Business)

Data Warehouse | Google Search Console

Google Search Console

Data Warehouse | Facebook Ads

Facebook Ads
Settings

Settings

Integrations

Integrations

Integrations | Google Data Studio

Google Data Studio

Integrations | Slack

Slack

Integrations | Zapier

Zapier

Integrations | Make

Make
Comments

Comments

Comments | Slack

Slack
Extensions

Extension

Extension | Explorer

Branch Explorer
Add comment from Slack

Comments | Slack

Anomaly Algorithm

Anomaly Detection

Authentication

Integrations | Make

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget history

Budget Tracking

Connecting Zapier

Integrations | Zapier

Connecting to Slack

Integrations | Slack

Creating a Data Studio Report

Data Warehouse | Google Data Studio

Creating a Pipeline

Data Warehouse

Data Source Metrics

KPI Management | Google Ads

Data Source Metrics

KPI Management | Google Analytics

Data Source Metrics

KPI Management | Facebook Ads

Data Source Metrics

KPI Management | Microsoft Ads

Data Source Metrics

KPI Management | Google Business Profile

Data Studio Connector Fields

Integrations | Google Data Studio

Data Studio Parameters

Integrations | Google Data Studio

Editing a Pipeline

Data Warehouse

Facebook Ads Fields

Data Warehouse | Facebook Ads

Facebook Ads KPI

KPI Management | Facebook Ads

Facebook Ads destination URL checker

Automation | Facebook Ads

Free Connector to Data Warehouse field comparison

Data Warehouse | Google Business Profile

Getting Started

Frequently Asked Questions

Google Ads change history

Automation | Google Ads

Google Ads destination URL checker

Automation | Google Ads

Google Analytics change history

Automation | Google Analytics

Google BigQuery Permissions

Data Warehouse | BigQuery

Google Business Profile Fields

Data Warehouse | Google Business Profile

Google Business Profile Listing Answers

Automation | Google Business Profile

Google Business Profile Listing Questions

Automation | Google Business Profile

Google Business Profile Location Updates

Automation | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | Google Business Profile

Google Reviews

Automation | Google Business Profile

Google Search Console Fields

Data Warehouse | Google Search Console

Google Sheets for Budgets

Budget Tracking | Google Sheets

Google Sheets format

KPI Management | Google Sheets

Grant access to BigQuery data

Data Warehouse | Google Data Studio

How to create a Data Studio Report for Facebook

Data Warehouse | Google Data Studio

How to use Regex and Examples

Frequently Asked Questions

KPI Insight

Insights

KPI Seasonal Trends

KPI Management

KPI Status

KPI Management

KPI Target Settings

KPI Management

KPI history

KPI Management

Managed BigQuery

Data Warehouse | BigQuery

Microsoft Ads destination URL checker

Automation | Microsoft Ads

Page status checker

Automation | Website

Pipeline Extensions

Data Warehouse

Portfolio

Clients

Robots.txt change detection

Automation | Website

Rolling Average

KPI Management

Search Console Activity

Automation | Google Search Console

Add comment from Slack

Comments | Slack

Anomaly Algorithm

Anomaly Detection

Authentication

Integrations | Make

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget history

Budget Tracking

Connecting Zapier

Integrations | Zapier

Connecting to Slack

Integrations | Slack

Creating a Data Studio Report

Data Warehouse | Google Data Studio

Creating a Pipeline

Data Warehouse

Data Source Metrics

KPI Management | Google Ads

Data Source Metrics

KPI Management | Google Analytics

Data Source Metrics

KPI Management | Facebook Ads

Data Source Metrics

KPI Management | Microsoft Ads

Data Source Metrics

KPI Management | Google Business Profile

Data Studio Connector Fields

Integrations | Google Data Studio

Data Studio Parameters

Integrations | Google Data Studio

Editing a Pipeline

Data Warehouse

Facebook Ads Fields

Data Warehouse | Facebook Ads

Facebook Ads KPI

KPI Management | Facebook Ads

Facebook Ads destination URL checker

Automation | Facebook Ads

Free Connector to Data Warehouse field comparison

Data Warehouse | Google Business Profile

Getting Started

Frequently Asked Questions

Google Ads change history

Automation | Google Ads

Google Ads destination URL checker

Automation | Google Ads

Google Analytics change history

Automation | Google Analytics

Google BigQuery Permissions

Data Warehouse | BigQuery

Google Business Profile Fields

Data Warehouse | Google Business Profile

Google Business Profile Listing Answers

Automation | Google Business Profile

Google Business Profile Listing Questions

Automation | Google Business Profile

Google Business Profile Location Updates

Automation | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | Google Business Profile

Google Reviews

Automation | Google Business Profile

Google Search Console Fields

Data Warehouse | Google Search Console

Google Sheets for Budgets

Budget Tracking | Google Sheets

Google Sheets format

KPI Management | Google Sheets

Grant access to BigQuery data

Data Warehouse | Google Data Studio

How to create a Data Studio Report for Facebook

Data Warehouse | Google Data Studio

How to use Regex and Examples

Frequently Asked Questions

KPI Insight

Insights

KPI Seasonal Trends

KPI Management

KPI Status

KPI Management

KPI Target Settings

KPI Management

KPI history

KPI Management

Managed BigQuery

Data Warehouse | BigQuery

Microsoft Ads destination URL checker

Automation | Microsoft Ads

Page status checker

Automation | Website

Pipeline Extensions

Data Warehouse

Portfolio

Clients

Robots.txt change detection

Automation | Website

Rolling Average

KPI Management

Search Console Activity

Automation | Google Search Console

Choose article...
Data Warehouse | Google Search Console

Google Search Console Fields

Transferring your Search Console data into Google Big Query is quick and easy. To make analyzing easy in Google Data Studio the data is broken down into entities, within a single table. Each entity represents a type of data.

The process of moving your data into Big Query begins by fetching your historic data, with the timeframes of each entity shown below. After this a daily update is performed, some entities have a delay to when new data is available and is also shown in the table below.

Data Studio Report Template — Copy this report to hit the ground running and start your data analysis https://datastudio.google.com/reporting/2b7c6276-e627-4940-a2d7-8430958bdcbb

Entity date ranges for syncing

Entity Historic Data Period Daily Update Schedule

Basic

From 16 months ago up to 3 days ago 3 days ago

Page

From 16 months ago up to 3 days ago 3 days ago

Query

From 16 months ago up to 3 days ago 3 days ago

Sitemap

Current day Current day

All Entities

Field Type Description

entityType

TextString Grouping of the data (Basic, Query, Page, Sitemap)

date

CalendarDate Date of the search in Pacific Time Zone (PT)

searchType

TextString Which search tab contained the link seen by the user

device

TextString The type of device on which the user is searching

country

TextString The country where the search came from

searchAppearance

TextString The specific search result type or feature

insertId

TextString Composite key of the data

Basic

Field Type Description

query

TextString Search string that users searched for on Google

page

TextString The final URL linked by a Search result after any skip redirects

clicks

NumericInteger Count of clicks from a Google search result that landed the user on your property

impressions

NumericInteger 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

NumericFloat Click-through rate: The click count divided by the impression count

position

NumericFloat The position of the topmost link to your property in search results, averaged across all queries in which your property appeared


Query

Field Type Description

queryClicks

NumericInteger Count of clicks from a Google search result that landed the user on your property, aggregated by query.

queryImpressions

NumericInteger 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. Its value is aggregated by query.

queryCTR

NumericFloat Click-through rate: The click count divided by the impression count. Its value is aggregated by query.

queryPosition

NumericFloat The position of the topmost link to your page in search results, averaged across all queries in which your property appeared. Its value is aggregated by query.

Page

Field Type Description

pageClicks

NumericInteger Count of clicks from a Google search result that landed the user on your page

pageImpressions

NumericInteger 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

NumericFloat Click-through rate: The click count divided by the impression count

property

TextString Website URL

pagePosition

NumericFloat The position of the topmost link to your page in search results, averaged across all queries in which your property appeared

wordsInQuery

NumericInteger Number of words in the query

protocol

TextString Transfer protocol of the page (http or https)

hostName

TextString Hostname of the page

pagePath1

TextString First level directory of the page

pagePath2

TextString Second level directory of the page

pagePath3

TextString Third level directory of the page

pagePath4

TextString Fourth level directory of the page

queryParameter

TextString Query parameters of the page

anchorTag

TextString Anchor tag of the page

Sitemap

Field Type Description

sitemapPath

TextString The URL where the sitemap is posted, relative to the property root.

sitemapLastSubmitted

TextString The date when the sitemap was last submitted to Google using this report

sitemapPending

BooleanBoolean If true, the sitemap has not been processed.

sitemapList

BooleanBoolean If true, the sitemap is a collection of sitemaps.

sitemapType

TextString 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

TextString Date & time in which this sitemap was last downloaded. Date format is in RFC 3339 format (yyyy-mm-dd).

sitemapWarnings

NumericInteger The number of warnings in the sitemap.

sitemapErrors

NumericInteger 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

TextString The specific type of content in this sitemap (androidApp, image, iosApp, mobile, news, pattern, video, web)

sitemapContentSubmitted

NumericInteger Date & time in which this sitemap was submitted. Date format is in RFC 3339 format (yyyy-mm-dd).

sitemapContentIndexed

NumericInteger The number of URLs from the sitemap that were indexed (of the content type)

Was this article helpful?
Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here

Please try again

Oops! Something went wrong while submitting the form.

Sorry about that. What did you find most unhelpful?
Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here

Please try again

Oops! Something went wrong while submitting the form.