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 Looker Studio
Data Warehouse | BigQuery
Data Warehouse | Google Business Profile
Data Warehouse | Google Search Console
Data Warehouse | Facebook Ads
Social Posts
Local Listings
Reviews
Settings
Integrations
Integrations | Google Looker Studio
Integrations | Slack
Integrations | Zapier
Integrations | Make
Integrations | Webhook
Comments
Comments | Slack
Extension
Extension | Explorer
Settings
Comments | Slack
Users
Local Listings
Reviews
Analysis
Anomaly Detection
Anomaly Detection
Integrations | Webhook
Insights
Anomaly Detection
Anomaly Detection
Local Listings
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
Local Listings
Local Listings | Media
Social Posts
Settings
Local Listings | Categories & Services
Local Listings | Categories & Services
Local Listings | Categories & Services
Users
Clients
Clients
Comments
Settings
Settings
Integrations | Zapier
Settings
Settings
Settings
Settings
Integrations | Slack
Settings
Local Listings | Media
KPI Management
Data Warehouse | Google Looker Studio
Data Warehouse | Google Looker Studio
Data Warehouse | Google Looker Studio
Automation Jobs
Social Posts
Clients
Data Warehouse | Google Looker Studio
Data Warehouse
Social Posts
Data Warehouse | BigQuery
KPI Management
KPI Management | Microsoft Ads
KPI Management | Google Business Profile
KPI Management | Google Analytics
KPI Management | Facebook Ads
KPI Management | Google Ads
Data Warehouse
Data Warehouse
Data Warehouse
Clients
Users
Settings
Social Posts
Data Warehouse | Google Looker Studio
Data Warehouse
Comments
Settings
Settings
Social Posts
Data Warehouse | Facebook Ads
KPI Management | Facebook Ads
Automation | Facebook Ads
Insight | Facebook Ads
Reviews
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 Looker Studio
Comments
Local Listings
Frequently Asked Questions
Local Listings | Media
Insights
KPI Management
KPI Management
KPI Management
Insights
Integrations | Webhook
KPI Management
KPI Management
KPI Management
KPI Management
KPI Management
Local Listings
Local Listings
Local Listings | Media
Integrations | Google Looker Studio
Data Warehouse | BigQuery
Data Warehouse | BigQuery
Integrations | Google Looker Studio
Settings
Local Listings | Media
Local Listings | Media
Local Listings | Media
Local Listings | Media
Social Posts
Local Listings | Media
Automation | Microsoft Ads
Insight | Microsoft Ads
Automation | Website
Insight | Website
Local Listings
Reviews
Data Warehouse
Local Listings | Platforms
Clients
Social Posts | Google Business Profile
Clients
Social Posts
Local Listings
Data Warehouse | Google Looker Studio
Insights
Reviews
Reviews
Reviews
Reviews
Automation | Website
Insight | Website
Automation | Website
KPI Management
Social Posts
Automation | Google Search Console
Insight | Google Search Console
Automation | Google Search Console
Insight | Google Search Console
Local Listings
Clients
Integrations | Slack
Local Listings | Categories & Services
Local Listings | Categories & Services
Social Posts
Frequently Asked Questions
Settings
Extension | Explorer
Settings
Comments | Slack
Users
Local Listings
Reviews
Analysis
Anomaly Detection
Anomaly Detection
Integrations | Webhook
Insights
Anomaly Detection
Anomaly Detection
Local Listings
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
Local Listings
Local Listings | Media
Social Posts
Settings
Local Listings | Categories & Services
Local Listings | Categories & Services
Local Listings | Categories & Services
Users
Clients
Clients
Comments
Settings
Settings
Integrations | Zapier
Settings
Settings
Settings
Settings
Integrations | Slack
Settings
Local Listings | Media
KPI Management
Data Warehouse | Google Looker Studio
Data Warehouse | Google Looker Studio
Data Warehouse | Google Looker Studio
Automation Jobs
Social Posts
Clients
Data Warehouse | Google Looker Studio
Data Warehouse
Social Posts
Data Warehouse | BigQuery
KPI Management
KPI Management | Microsoft Ads
KPI Management | Google Business Profile
KPI Management | Google Analytics
KPI Management | Facebook Ads
KPI Management | Google Ads
Data Warehouse
Data Warehouse
Data Warehouse
Clients
Users
Settings
Social Posts
Data Warehouse | Google Looker Studio
Data Warehouse
Comments
Settings
Settings
Social Posts
Data Warehouse | Facebook Ads
KPI Management | Facebook Ads
Automation | Facebook Ads
Insight | Facebook Ads
Reviews
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 Looker Studio
Comments
Local Listings
Frequently Asked Questions
Local Listings | Media
Insights
KPI Management
KPI Management
KPI Management
Insights
Integrations | Webhook
KPI Management
KPI Management
KPI Management
KPI Management
KPI Management
Local Listings
Local Listings
Local Listings | Media
Integrations | Google Looker Studio
Data Warehouse | BigQuery
Data Warehouse | BigQuery
Integrations | Google Looker Studio
Settings
Local Listings | Media
Local Listings | Media
Local Listings | Media
Local Listings | Media
Social Posts
Local Listings | Media
Automation | Microsoft Ads
Insight | Microsoft Ads
Automation | Website
Insight | Website
Local Listings
Reviews
Data Warehouse
Local Listings | Platforms
Clients
Social Posts | Google Business Profile
Clients
Social Posts
Local Listings
Data Warehouse | Google Looker Studio
Insights
Reviews
Reviews
Reviews
Reviews
Automation | Website
Insight | Website
Automation | Website
KPI Management
Social Posts
Automation | Google Search Console
Insight | Google Search Console
Automation | Google Search Console
Insight | Google Search Console
Local Listings
Clients
Integrations | Slack
Local Listings | Categories & Services
Local Listings | Categories & Services
Social Posts
Frequently Asked Questions
Settings
Extension | Explorer
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.
Selecting a sheet
When selecting the sheet from the dropdown, the 100 most recently modified sheets are shown. So if your sheet is not shown, please make a small edit to that 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.
You can change the missing data values upon creation of the Budget in the Advance Settings. Either choose "Fill with Zero" or "Fill with Previous Value". If Previous Value is selected and it doesn't have data, it will still be filled with zeroes.
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.