Location Data Knowledge Base

Data methodologies, and Release schedules.
We are trying to understand the difference between employees and daytime population.   It looks like some of the population may be double counted.  Can you explain what rows are used for the 2014 Total Daytime population #.      Methodologies are different for Employees and Daytime Population.   Employees & Establishments in Business Summary are sourced from the D&B Business list and summarized to a geographic level although delivered in the Experian CAPE release.  The employee counts are as accurate as the D&B employee value but are also subject to block centroid allocation used for population. Employment fields from the Occupation & Employment folder are based upon the American Community Survey, modeled to a current year value and are part of CAPE. Daytime Population is sourced from Experian and are compiled values using several CAPE fields.  The excerpt below is pulled from the Tech Overview delivered to clients.      Daytime PopulationDaytime Population – Current Year Estimates (CYE) The Daytime Population database is created using a variety of methodologies applicable for different subsets of the Total Daytime Population. These subsets are then added together to create the Total Daytime Population. The process starts by identifying key subsets of the residential population that are assumed to stay in or close to their home location during the day. In particular, the following subsets of population are assumed to remain in the same Block Group during the day as the Block Group in which they live (or reside): Residential Population : Children aged less than or equal to 2 Residential Population : Civilian aged 16+ population that are unemployed Residential Population : Civilian aged 16+ population that work at home Residential Population : Population aged 65+ who are retired Residential Population : Population aged 16+ who are homemakers Residential Population : Population aged 16+ who are in the Armed Forces All of the above variables can be directly obtained from previously calculated CAPE – Demographics – Current Year Estimate (CYE) residentially-based variables, except for the ‘Residential Population : Population aged 16+ who are homemakers’. This variable is calculated by applying suitable localized proportions to the existing ‘larger population’ variable of the ‘Civilian aged 16+ population who are ‘Not in Labor Force’. Applying these proportions determines the subset of this ‘larger population’ that are estimated to be homemakers. Once these initial subsets of Daytime Population who are assumed to stay in their residential Block Group during the daytime are defined and accounted for, then the daytime location of other population types are modelled. It is assumed that these remaining population types are much more likely to travel out of their residential Block Group to reach their typical daytime location than is the case for the population groups previously accounted for. However, flows from home address to daytime address that occur completely within the same Block Group are also possible for these types. First, the estimate of daytime population at place of work that has already been modelled for the Mosaic Workplace database is accounted for. This variable is: Daytime Population, Civilian 16+, at WorkplaceAfter the above, the main population groups left to be modelled are: Within the work to create Mosaic Workplace, this variable is estimated using Census Tract-to-Tract flows of workers from residence to workplace, and National Business Database data to update these flows and allocate them from Tract level to Block Group level. Daytime Population, Students : Prekindergarten to 8th grade Daytime Population, Students : 9th grade to 12th grade Daytime Population, Students : Post-secondary students Daytime Population: Any remaining Civilian aged 16+ population that are ‘Not in Labor Force’ and have not yet been accounted for. All of the three student populations are modelled using a variety of data from the National Center for Education Statistics (NCES) and also information from key institutions (i.e. universities/colleges) themselves. After making allowance for students registered at an institution but very unlikely to travel to that institution on a typical day (for example, students undertaking online courses), this information is compiled and modelled to create an initial estimate of the typical number of students that spend the day at the location (or campus) of each institution. These figures are then calibrated so that the initial estimates of students who spend a typical day at the location of each institution, and those who stay within their residential Block Group during a typical day, are balanced to equal the national number of students within each category (i.e. Prekindergarten to 8th grade, 9th grade to 12th grade, Post-secondary students). Once all students have been accounted for, current estimates of each relevant daytime population sub-group are tallied and compared to the national estimate of ‘Residential Population: Civilian aged 16+ population that are Not in Labor Force’. The above work does not yet account for a proportion of this population group. The, as yet unaccounted for, proportion of this group is therefore calculated and assumed to spend a typical day within the Block Group in which they live. Having allocated all of the relevant subsets of residential population to either the Block Group in which they reside, or to another Block Group which they are estimated to travel to in order to spend a typical day, then the two final variables in the database are calculated: Daytime Population Aged 16+ Total Daytime Population (i.e. all ages)
View full article
  Households or individuals may be excluded from the ConsumerView file for multiple reasons.  If an example list of names is provided to data_products@alteryx.com, they can be validated with Experian.  Otherwise, here are examples of exclusions: Households at addresses may be renters with no deed information available Household only has cell phones and is not in the phone book white pages Privacy - many people see to it their name is never on any kind of mailing list when doing business with companies Below is an excerpt on Experian's privacy & Compliance: Experian Marketing Services’ Approach to Privacy EMS is a steward of the information it collects, maintains, utilizes and shares.  Our stewardship is anchored in a values-based approach to privacy.  Our information values focus squarely upon the protection of information in our care and the safeguarding of consumer privacy through appropriate and responsible use.  For more information regarding our approach to privacy, please visit our web site at http://www.experian.com/privacy/index.html . Direct Marketing Association As a member and Board of Directors participant of the Direct Marketing Association (DMA), EMS drives the adoption of, and subsequently abides by, and encourages its clients to adhere to, the DMA’s Privacy Promise and Guidelines for Ethical Business Practices.  The Privacy Promise is a public assurance to American consumers that DMA members follow specific practices to protect consumer privacy.  Specifically, the Privacy Promise requires member companies to:   Provide notice of consumers’ ability to opt-out Honor consumer opt-out requests Maintain an in-house opt-out suppression file Use the DMA Preference Service suppression files (e.g., MPS, TPS, e-MPS) Promote industry-wide compliance with DMA self-regulatory guidelines  Why are some people not contained in the Experian ... For additional information, contact data_products@alteryx.com
View full article
The Q3 2018 US Spatial package includes analytics-ready data from TomTom and the US Census as well as data-specific analysis tools to get the most from the spatial data. The documentation package attached includes –   Release notes, variable list and change log Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?   Sample workflows included with the data installs are now grouped within a top-level "Data Install Samples" category Annual updates for Places, Other Name Places, CBSAs, and CCDs/MCDs   Please download and extract the attached 'Q32018_US_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 Canada Data package includes analytics-ready data from TomTom, Dun & Bradstreet and Statistics Canada as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes, variable list and change log D&B Analytical file - data description, SIC lookup code, penetration report Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?     1600+ Language Characteristics variables from the Statistics Canada 2016 Census regarding “mother tongue” and “language spoken at home” Business Summary built for Statistics Canada 2016 Dissemination Area inventory Sample workflows included with the data installs are now grouped within a top-level “Data Install Samples” category   Please download and extract the attached 'Q32018_CA_Data.zip' for the complete documentation.
View full article
The Q3 2018 Australia & New Zealand Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_AUNZ_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 Brazil Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_BR_Spatial.zip' for the complete documentation.
View full article
The Q3 2018 Europe (EU) Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_EU_Spatial.zip' for the complete documentation.   Countries included in this install are:   Andorra Austria Belgium Croatia Czech Republic Denmark Finland France Germany Gibraltar (British Overseas Territories) Hungary Italy (including Vatican City) Liechtenstein Luxembourg Monaco Netherlands Norway Poland Portugal San Marino Slovakia Slovenia Spain Sweden Switzerland
View full article
The Q3 2018 UK and Republic of Ireland (ROI) Spatial package includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes Spatial products include documentation on drive time methodology and Alteryx map layers   Please download and extract the attached 'Q32018_UKROI_Spatial.zip' for the complete documentation.  
View full article
The Q3 2018 Canada Spatial Data includes analytics-ready data from TomTom as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –   Release notes, variable list and change log Spatial products include documentation on drive time methodology and Alteryx map layers   What's new in this release?     Sample workflows included with the data installs are now grouped within a top-level “Data Install Samples” category   Please download and extract the attached 'Q32018_CA_Spatial.zip' for the complete documentation.
View full article
Data package documentation for the Q4 2017 data releases may be downloaded from the links below...   US Data: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_US_Data.zip CA Data: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_CA_Data.zip US Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_US_Spatial.zip CA Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_CA_Spatial.zip UK & ROI Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_UKROI_Spatial.zip EU Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_EU_Spatial.zip AU & NZ Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_AUNZ_Spatial.zip BR Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q42017_BR_Spatial.zip   Please note that documentation packages are also included with the download from licenses.alteryx.com and the external hard drive (US Data or Canada Data)
View full article
 Data package documentation for the Q1 2018 data releases may be downloaded from the links below...   US Data: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_US_Data.zip CA Data: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_CA_Data.zip US Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_US_Spatial.zip CA Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_CA_Spatial.zip UK & ROI Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_UKROI_Spatial.zip EU Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_EU_Spatial.zip AU & NZ Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_AUNZ_Spatial.zip BR Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q12018_BR_Spatial.zip   Please note that documentation packages are also included with the download from licenses.alteryx.com and the external hard drive (US Data or Canada Data)
View full article
 Data package documentation for the Q2 2018 data releases may be downloaded from the links below...   US Data: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_US_Data.zip CA Data: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_CA_Data.zip US Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_US_Spatial.zip CA Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_CA_Spatial.zip UK & ROI Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_UKROI_Spatial.zip EU Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_EU_Spatial.zip AU & NZ Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_AUNZ_Spatial.zip BR Spatial: http://downloads.alteryx.com/ReleaseDocumentation/Q22018_BR_Spatial.zip   Please note that documentation packages are also included with the download from licenses.alteryx.com and the external hard drive (US Data or Canada Data)
View full article
Hi all,   Effective with the Q4 2018 data releases, the base URL referenced in the .map files that render DigitalGlobe Satellite imagery is changing from dgmaps.alteryx.com to whitelist.alteryx.com/v1/dgmaps/v1. This change was made to align with our System Requirements. As we already recommend that customers have whitelist.alteryx.com listed as a safe site, we don't expect this to impact our customers.   Customers can still use the Q3 2018 DigitalGlobe data if they run into network issues. Any network-related issues should ultimately be resolved by whitelisting whitelist.alteryx.com.   Regards,   Jerad Rades Team Lead, Data Products
View full article
Mosaic BG Dominant and Mosaic BG Household Distribution counts are balanced to Experian’s census estimates.  ConsumerView is a marketing file and therefore doesn’t need to be balanced to the census estimates.
View full article
Greetings Alteryxians!   The Q1 2019 Business and Location Insights data packages were released today. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools to get the most from the packaged data. All data packages are available via the Downloads & Licenses portal; US & Canada Business Insights customers should receive their hard drives later this week, but you are also welcome to download the data from the portal.   Here are a couple important notes specific to this release. Please see the product specific documentation for more details. US & Canada: Install now only includes country specific CASS dataset (i.e., US Business Insights will only install US CASS by default) Canada: Forward Sortation Area data was not updated due to vendor source issue. The vendor confirmed there was no change from Q4 to Q1.   All documentation packages are included in the attached .7z archive. As a side note, our team is working on content to help customers get started with their Insights packages. If you haven't already, be sure to take a look at some of the recent articles in the Location Data Knowledge Base regarding things like installation, mapping, and many more to come! Shout out to @TravisR for his work!   Feel free to add any questions in the comments below.   Jerad Rades Team Lead, Data Products
View full article
Hi everyone!   The Q4 2018 Business and Location Insights data packages includes analytics-ready data from a variety of vendors as well as data-specific analysis tools to get the most from the packaged data. All data packages will be available via the Downloads & Licenses portal later today. US & Canada Business Insights customers should receive their hard drives later this week, but you are also welcome to download the data from the portal.   Here are a couple important notes for this release. Please see the product specific release notes for more information. Product name change (does not affect product contents): US and Canada "Data", which includes demographics, business lists, etc., are now called "Business Insights" All "Spatial" packages are now called "Location Insights" DigitalGlobe Satellite Maps base URL changed to whitelist.alteryx.com/v1/dgmaps/v1. See this post for more details.   All documentation packages included in the attached .zip file. Please let us know if you have any questions or concerns.   Happy Alteryxing!   Jerad Rades Team Lead, Data Products   Note that this post includes a corrected version of the US Data Variable List that was not included on the hard drive or via the Downloads & Licenses portal. The correction corresponds to TrueTouch variables within the ConsumerView dataset - there were no new variables with the Q4 2018 release. 
View full article