Showing results for 
Search instead for 
Did you mean: 

Location Data Knowledge Base

Data methodologies, and Release schedules.
Platform Product: Allocate/Behavioral Issues – Working with Alteryx Customer Support Engineers (CSEs)   To EXPEDITE the resolution of your case, please include the below information.   Allocate/Behavioral - Requested Information *** Suggestion: copy/paste the questions below and email the supporting documentation to   1. Detailed Description of the Issue 2. Screenshot of Alteryx Version 3. Screenshot of Error  4. What dataset and vintage are you using? 5. Please send a copy of your workflow (*.yxmd or *.yxzp) 6. Please send your .ini files in the data install folder for the data set. (optional)     Allocate/Behavioral – Requested Information (Detailed Instructions):   1.  Detailed Description of the Issue – What issues are you having?  Has it worked in the past?  When did the issue start?  Are all users affected or just some?  What are the steps to reproduce your issue?  What have you tried to resolve the issue?  Have you searched the Alteryx Community?     2.  Screenshot of Alteryx Version– Our CSEs need to know the precise version of Alteryx so we can replicate any issues.   In Alteryx, click Help > About and provide a screenshot.  The screenshot will include whether it is Server or Designer.  In addition, whether it is “Running Elevated” Admin vs. Non-Admin.       3.  Screenshot of Error or Exact Text of Error- Click CTRL-Print-screen to capture the error and paste into your e-mail.  Also include where was the error encountered – Gallery, Designer, Scheduler?   Note: You may wish to Google the error text research the issue. The Knowledgebase is also a great place to search the error text as well!      4.  What dataset and vintage are you using?  From the Allocate Input tool, click the Drop Down for Choose a Dataset.  What dataset is selected?  If “Most Recent Vintage”, what is the Dataset below?  i.e. Experian US 2018A (Q4 2018).   5.   Please send a copy of your workflow (*.yxmd or *.yxzp) and sample data if possible. Either create a .yxzp and include macros and data by clicking Options>Export Workflow.  Or, include the workflow *.yxmd and sample data if possible.   6.  Please send your .ini files in the data install folder for the data set. (optional) C:\ProgramData\Alteryx\DataProducts\DataProducts.ini   Suggested links:   Renaming Allocate Variables  
View full article
Behavior Analysis users installing Q3 2016 US Experian data should read!
View full article
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
The attached document contains the Mosaic USA Group and Segment Descriptions
View full article
This two-page document provides concise, color-coded groupings and descriptions of the 71 Mosaic USA clusters.
View full article