Frequently Asked Questions
Clients
Users
Insights
Insight | Google Search Console
Insight | Google Business Profile
Insight | Google Ads
Insight | Google Analytics
Insight | Website
Insight | Facebook Ads
Insight | Microsoft Ads
Automation Jobs
Automation | Google Search Console
Automation | Google Business Profile
Automation | Google Ads
Automation | Google Analytics
Automation | Website
Automation | Facebook Ads
Automation | Microsoft Ads
KPI Management
KPI Management | Google Analytics
KPI Management | Google Ads
KPI Management | Google Business Profile
KPI Management | Facebook Ads
KPI Management | Microsoft Ads
KPI Management | Google Sheets
Budget Tracking
Budget Tracking | Google Sheets
Anomaly Detection
Data Warehouse
Data Warehouse | Google Data Studio
Data Warehouse | BigQuery
Data Warehouse | Google Business Profile
Data Warehouse | Google Search Console
Data Warehouse | Facebook Ads
Local Listings
Reviews
Settings
Integrations
Integrations | Google Data Studio
Integrations | Slack
Integrations | Zapier
Integrations | Make
Integrations | Webhook
Comments
Comments | Slack
Extension
Extension | Explorer
Settings
Comments | Slack
Users
Anomaly Detection
Anomaly Detection
Integrations | Webhook
Insights
Anomaly Detection
Anomaly Detection
Integrations | Make
Insights
Data Warehouse
Automation Jobs
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Automation Jobs
Budget Tracking
Budget Tracking
Budget Tracking
Budget Tracking
Integrations | Webhook
Budget Tracking
Budget Tracking
Settings
Local Listings
Users
Clients
Clients
Comments
Settings
Settings
Integrations | Zapier
Settings
Settings
Settings
Settings
Integrations | Slack
Settings
Automation Jobs
Clients
Data Warehouse | Google Data Studio
Data Warehouse
Data Warehouse | BigQuery
KPI Management | Microsoft Ads
KPI Management | Google Business Profile
KPI Management | Google Analytics
KPI Management | Facebook Ads
KPI Management | Google Ads
Integrations | Google Data Studio
Data Warehouse
Data Warehouse
Data Warehouse
Clients
Users
Settings
Data Warehouse | Google Data Studio
Data Warehouse
Comments
Settings
Settings
Data Warehouse | Facebook Ads
KPI Management | Facebook Ads
Automation | Facebook Ads
Insight | Facebook Ads
Settings
Data Warehouse | Google Business Profile
Frequently Asked Questions
Settings
Automation | Google Ads
Insight | Google Ads
Automation | Google Ads
Insight | Google Ads
Automation | Google Analytics
Insight | Google Analytics
Data Warehouse | BigQuery
Automation | Google Business Profile
Insight | Google Business Profile
Data Warehouse | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Data Warehouse | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Data Warehouse
Data Warehouse | Google Search Console
Budget Tracking | Google Sheets
KPI Management | Google Sheets
Data Warehouse | Google Data Studio
Comments
Local Listings
Data Warehouse | Google Data Studio
Data Warehouse | Google Data Studio
Data Warehouse | Google Data Studio
Frequently Asked Questions
Insights
KPI Management
KPI Management
Insights
Integrations | Webhook
KPI Management
KPI Management
KPI Management
KPI Management
KPI Management
KPI Management
Local Listings
Local Listings
Data Warehouse | BigQuery
Data Warehouse | BigQuery
Integrations | Google Data Studio
Settings
Automation | Microsoft Ads
Insight | Microsoft Ads
Automation | Website
Insight | Website
Local Listings
Reviews
Data Warehouse
Clients
Clients
Data Warehouse | Google Data Studio
Insights
Reviews
Reviews
Reviews
Automation | Website
Insight | Website
Automation | Website
KPI Management
Automation | Google Search Console
Insight | Google Search Console
Automation | Google Search Console
Insight | Google Search Console
Clients
Integrations | Slack
Local Listings
Frequently Asked Questions
Settings
Extension | Explorer
Users
Reviews
Settings
Clients
Integrations | Google Data Studio
Users
Settings
Comments
Frequently Asked Questions
Settings
Comments | Slack
Users
Anomaly Detection
Anomaly Detection
Integrations | Webhook
Insights
Anomaly Detection
Anomaly Detection
Integrations | Make
Insights
Data Warehouse
Automation Jobs
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Integrations | Webhook
Automation Jobs
Budget Tracking
Budget Tracking
Budget Tracking
Budget Tracking
Integrations | Webhook
Budget Tracking
Budget Tracking
Settings
Local Listings
Users
Clients
Clients
Comments
Settings
Settings
Integrations | Zapier
Settings
Settings
Settings
Settings
Integrations | Slack
Settings
Automation Jobs
Clients
Data Warehouse | Google Data Studio
Data Warehouse
Data Warehouse | BigQuery
KPI Management | Microsoft Ads
KPI Management | Google Business Profile
KPI Management | Google Analytics
KPI Management | Facebook Ads
KPI Management | Google Ads
Integrations | Google Data Studio
Data Warehouse
Data Warehouse
Data Warehouse
Clients
Users
Settings
Data Warehouse | Google Data Studio
Data Warehouse
Comments
Settings
Settings
Data Warehouse | Facebook Ads
KPI Management | Facebook Ads
Automation | Facebook Ads
Insight | Facebook Ads
Settings
Data Warehouse | Google Business Profile
Frequently Asked Questions
Settings
Automation | Google Ads
Insight | Google Ads
Automation | Google Ads
Insight | Google Ads
Automation | Google Analytics
Insight | Google Analytics
Data Warehouse | BigQuery
Automation | Google Business Profile
Insight | Google Business Profile
Data Warehouse | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Data Warehouse | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Automation | Google Business Profile
Insight | Google Business Profile
Data Warehouse
Data Warehouse | Google Search Console
Budget Tracking | Google Sheets
KPI Management | Google Sheets
Data Warehouse | Google Data Studio
Comments
Local Listings
Data Warehouse | Google Data Studio
Data Warehouse | Google Data Studio
Data Warehouse | Google Data Studio
Frequently Asked Questions
Insights
KPI Management
KPI Management
Insights
Integrations | Webhook
KPI Management
KPI Management
KPI Management
KPI Management
KPI Management
KPI Management
Local Listings
Local Listings
Data Warehouse | BigQuery
Data Warehouse | BigQuery
Integrations | Google Data Studio
Settings
Automation | Microsoft Ads
Insight | Microsoft Ads
Automation | Website
Insight | Website
Local Listings
Reviews
Data Warehouse
Clients
Clients
Data Warehouse | Google Data Studio
Insights
Reviews
Reviews
Reviews
Automation | Website
Insight | Website
Automation | Website
KPI Management
Automation | Google Search Console
Insight | Google Search Console
Automation | Google Search Console
Insight | Google Search Console
Clients
Integrations | Slack
Local Listings
Frequently Asked Questions
Settings
Extension | Explorer
Users
Reviews
Settings
Clients
Integrations | Google Data Studio
Users
Settings
Comments
Frequently Asked Questions
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.
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.
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.
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.
Intra day data is currently not factored into the prediction process, so where possible please aggregate values to a single day value.
The first occurrence will be honoured and succeeding duplicate values will be ignored.
Some systems utilize a dash to represent missing or no value, avoid this as we only accept numeric, currency and negative values.
Avoid using different currencies on a single row.
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
Oops! Something went wrong while submitting the form.
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
Oops! Something went wrong while submitting the form.