Logo

How can we help?

Intelligent Data Warehouse (IDW) FAQ:

1) When will today's data from the various data sources be available for reporting?

When we cache data for the sources on the dashboard, we pull the data at the beginning of the day for up to yesterday's data.  Depending on the provider and their requirements they happen at different times of the day.  Refer to the table below for detailed information on when this data is collected and stored.


2) When connecting to a Google Sheet or a new data source, when will see data in our dashboards or reports? 

Google Sheets data should be available immediately after connecting the data source / template and account settings (if required).  This is also true for all providers.  If we don't have the data already in the data warehouse when a request is made to our servers, then we will go in real time to the API and get the data immediately.

3) What data gets stored in the IDW?

When a client V2 dashboard is set up, we will grab all of the standard date ranges (yesterday, last 7 days, last week, last month, etc.) and store that data within the IDW for fast dashboard load times. If an account does not have any V2 dashboards enabled, then no data for that account will be stored in the IDW.

4) Network-specific behaviour for IDW:

Days of History: Refers to the number of days that is refreshed at the time that the data is updated in the data warehouse.

Maximum days: Refers to the total number of days available to be collected from the API from the date the data source was first added to the account.

Time of Refresh: Refers to the time of day (in the timezone of the account)* that we request the refreshed data from the data provider.  *Where the timezone is noted in the table below, the timezone of the account is ignored and the mentioned timezone is used instead.

Template Editor: Source of the data preview when using the NinjaCat Template Builder.

Reports: Source of the data in the final report after it was run under the Reports submenu.

  Days of History Maximum Days Time of Refresh Template Editor Reports
Adobe Analytics 35 730 Midnight Live if no dashboard Live if no dashboard
Adobe TubeMogul 35 730 Midnight Always data warehouse Always data warehouse
AdRoll 35 730 Midnight Always live Always live
Advice Local 35 730 Midnight Always data warehouse Always data warehouse
Amazon Ads 35 730 Midnight Live if no dashboard Live if no dashboard
ApexChat 35 730 Midnight Live if no dashboard Live if no dashboard
Apple Search Ads 35 730 Midnight Live if no dashboard Live if no dashboard
AppNexus 35 730 Midnight Always data warehouse Always data warehouse
Big Query 35 730 Midnight Always live Always live
Bing Ads 90 730 3 Always live Always live
BirdEye 35 730 Midnight Live if no dashboard Live if no dashboard
Brightroll 35 730 Midnight Live if no dashboard Live if no dashboard
Callcap 35 730 Midnight Always live Always live
CallRail 35 730 Midnight Always live Always live
CallSource 35 730 Midnight Always live Always live
CallTrackingMetrics 35 730 Midnight Always live Always live
Centro 35 400 Midnight Always data warehouse Always data warehouse
Century Interactive 35 730 Midnight Always live Always live
Change History 2 730 Midnight Always data warehouse Always data warehouse
Choozle 35 730 Midnight Live if no dashboard Live if no dashboard
Constant Contact 35 730 Midnight Live if no dashboard Live if no dashboard
Double Click For Publishers 35 730 Midnight Live if no dashboard Live if no dashboard
DoubleClick 35 730 2 Live if no dashboard Live if no dashboard
DoubleClick Bid Manager 35 730 2 Live if no dashboard Live if no dashboard
DoubleClick Search 35 730 4 Live if no dashboard Live if no dashboard
Email 2 730 Midnight Always data warehouse Always data warehouse
Facebook 60 730 Midnight PST Always live Always live
Facebook Insights 28 730 8 Always live Always live
FTP 35 730 Midnight Always live Always live
Google AdWords 90 730 3 Always live Always live
Google Analytics 35 730 3 Always live Always live
Google My Business 60 547 3 Always live Always live
Google Sheets 2 730 3 Always live Always live
Grade Us 35 730 Midnight Live if no dashboard Live if no dashboard
HubSpot 35 730 Midnight Live if no dashboard Live if no dashboard
ifbyphone 35 730 Midnight Always live Always live
Infinity 35 730 Midnight Always live Always live
Instagram 730 730 Midnight Live if no dashboard Live if no dashboard
Invoca 35 730 Midnight Always live Always live
LinkedIn 35 730 Midnight Always data warehouse Always data warehouse
LinkedIn Organizations 35 730 Midnight Always data warehouse Always data warehouse
Listrak 35 730 Midnight Always data warehouse Always data warehouse
LogMyCalls 35 730 Midnight Always live Always live
MailChimp 730 730 Midnight Live if no dashboard Live if no dashboard
Marchex 35 730 Midnight Always live Always live
Media Math 35 730 Midnight Always data warehouse Always data warehouse
Monday 35 730 Midnight Live if no dashboard Live if no dashboard
Mongoose 35 730 Midnight Always live Always live
Navis 35 730 Midnight Always live Always live
NinjaTrack 65 730 3 Live if no dashboard Live if no dashboard
Perfect Audience 35 730 Midnight Live if no dashboard Live if no dashboard
Reach Local 200 730 Midnight Always live Always live
ResponseTap 35 730 Midnight Always live Always live
ReviewPush 35 730 Midnight Live if no dashboard Live if no dashboard
Salesforce 35 730 Midnight Always data warehouse Always data warehouse
SearchConsole 35 485 3 Always live Always live
Simpli.fi 35 730 Midnight Always data warehouse Always data warehouse
Sizmek 35 730 Midnight Live if no dashboard Live if no dashboard
SQL 35 730 Midnight Always live Always live
SteelHouse 35 730 Midnight Live if no dashboard Live if no dashboard
Talroo 35 730 Midnight Live if no dashboard Live if no dashboard
The Trade Desk MyReports 35 730 Midnight Always data warehouse Always data warehouse
The TradeDesk 5 730 6 Always data warehouse Always data warehouse
Thinknear 35 730 Midnight Live if no dashboard Live if no dashboard
TruMeasure 35 730 Midnight Always live Always live
Twitter 35 730 1 Always data warehouse Always data warehouse
Twitter Organic 730 730 1 Always data warehouse Always data warehouse
Url 35 730 Midnight Live if no dashboard Live if no dashboard
Vendasta Reputation 35 730 Midnight Always data warehouse Always data warehouse
Waze 35 730 Midnight Live if no dashboard Live if no dashboard
What Converts 35 730 Midnight Always live Always live
WorthAuto 35 730 Midnight Live if no dashboard Live if no dashboard
Yahoo 35 730 3 Always live Always live
Yext 35 730 Midnight Always data warehouse Always data warehouse
Zapier 2 Realtime updates Midnight Always data warehouse Always data warehouse

Still have questions and don't see the answers you seek?  Please email support@ninjacat.io and we will be happy to assist you further!

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.