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...
KPI Management | Google Sheets

Google Sheets format

Utilizing Google Sheets as a data source gives you a lot of flexibility to connect a variety of systems that aren't already covered. For this to work there are a few rules that you need to follow for our system to be able to extract your data correctly. Please follow the guide below or reach out to the support team if you are having difficulty getting your data organised correctly in a Sheet.

1. Make sure the first row is a header row with column names

We recommend all your columns have text in the header row, but you must have text in the first column header, especially if you are using the Create Spreadsheet Row action. Without any text there, the job will send your data to the top of the sheet rather than to the bottom.
Make sure you have a data and it's on a right date format.

2. Don’t include headers for separate sections but do remove blank rows

Your spreadsheet should have no blank rows in between rows with content.

And it should not have any headers for separate sections in the same column.

3. Don’t delete rows

Do not delete rows in your spreadsheet while your sheet is in use, and don't add rows in the middle of data your job has already recognized. This can cause errors with your job. If you need to delete any rows, ensure the job is turned off as you make your amendments. Once you've finished deleting your rows, you can then turn your job back on.

4. Avoid time on Date Column

Intra day data is currently not factored into the prediction process, so where possible please aggregate values to a single day value.

5. Avoid Duplicating dates

The first occurrence will be honoured and succeeding duplicate values will be ignored.

6. Don't include dashes within the Metric Column

Some systems utilize a dash to represent missing or no value, avoid this as we only accept numeric, currency and negative values.

7. Avoid different currencies within the same column

Avoid using different currencies on a single row.

8. Current time will be based on your spreadsheet timezone

9. Rows that has a future dates will be ignored

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.