Close



Frequently Asked Questions



Frequently Asked Questions

Clients



Clients

Users



Users

Insights



Insights

Insight | Google Search Console

Google Search Console

Insight | Google Business Profile

Google Business Profile

Insight | Google Ads

Google Ads

Insight | Google Analytics

Google Analytics

Insight | Website

Website

Insight | Facebook Ads

Facebook Ads

Insight | Microsoft Ads

Microsoft Ads

Automation Jobs



Automation Jobs

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 Looker Studio

Google Looker 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

Local Listings



Local Listings

Reviews



Reviews

Settings



Settings

Integrations



Integrations

Integrations | Google Looker Studio

Google Looker Studio

Integrations | Slack

Slack

Integrations | Zapier

Zapier

Integrations | Make

Make

Integrations | Webhook

Webhook

Comments



Comments

Comments | Slack

Slack

Extensions



Extension

Extension | Explorer

Branch Explorer

Recent Updates



Account Settings

Settings

Acknowledging and Resolving Insights

Insights

Add comment from Slack

Comments | Slack

Adding a User

Users

An overview of Local Listings

Local Listings

An overview of Reviews

Reviews

Analysis

Anomalies Bulk Action

Anomaly Detection

Anomaly Algorithm

Anomaly Detection

Integrations | Webhook

Anomaly Detection Insight

Insights

Anomaly Detection Settings

Anomaly Detection

Anomaly Job Common Errors

Anomaly Detection

Attributes

Local Listings

Authentication

Integrations | Make

Auto Resolving

Insights

Automatic Schema Updates

Data Warehouse

Automation Job Common Errors

Automation Jobs

Automation: Facebook Ads Destination URL Checker

Integrations | Webhook

Automation: Google Ads Change History

Integrations | Webhook

Automation: Google Ads Destination URL Checker

Integrations | Webhook

Automation: Google Analytics Change History

Integrations | Webhook

Automation: Google Business Profile Answer

Integrations | Webhook

Automation: Google Business Profile Change History

Integrations | Webhook

Automation: Google Business Profile Pending Updates

Integrations | Webhook

Automation: Google Business Profile Question

Integrations | Webhook

Automation: Google Review

Integrations | Webhook

Automation: Google Review Change History

Integrations | Webhook

Automation: Microsoft Ads Destination URL Checker

Integrations | Webhook

Automation: Page Status Checker

Integrations | Webhook

Automation: Robots.txt Change Detection

Integrations | Webhook

Automation: Search Console Activity

Integrations | Webhook

Automation: Search Console Keyword Movement

Integrations | Webhook

Automations Bulk Action

Automation Jobs

Budget Campaign Dynamic Filter

Budget Tracking

Budget Tracking

Budget Tracking

Budget Tracking

Integrations | Webhook

Budget Tracking

Budget Tracking

Local Listings

Local Listings | Media

Calendar

Social Posts

Cancel Subscription

Settings

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.



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.

Help Center

Google Sheets format

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

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

3. Don’t delete rows

4. Avoid time on Date Column

5. Avoid Duplicating dates

6. Don't include dashes within the Metric Column

7. Avoid different currencies within the same column

8. Current time will be based on your spreadsheet timezone

9. Rows that has a future dates will be ignored