Data Packs

Summarising the information you need

It’s all about the specifics.

Spectrum Analysis Data Pack Services

For local area marketing, franchise area sales, business and marketing demographics, clubs, member associations, population forecasting.

Local Area Data Pack

Are you responsible for providing demographic information for a specific area anywhere across Australia? 

We can compile a Local Area Data Pack in PDF format that includes a combination of demographic mapping information that has been summarised for an area, site or territory that matches your interests and requirements.

These Local Area Data Packs can be used to help you with questions about:

  • what kinds of potential customers live in the area
  • what kinds of businesses are based in the area and what do their employees do
  • how people are likely to move around within, through, into and out of the area
  • where to open a new store or site
  • where to place fixed advertising
  • what is the socio-economic level of the area
  • which age groups are more prevalent
  • how many people rent and how often do they change address
  • developing a business development prospecting list, establishing referral or alliance relationships or sending invitations for a grand opening or special offer
  • preparing reports for either the sale or transfer of an existing site or store

Our Local Area Data Packs are suitable for both B2B and B2C enterprises as many workers will visit B2C locations at lunchtime or after work. They can also be prepared with enterprise branding information.

We can use our six step data analysis process to include in the Local Area Data Pack:

  • *Residential Demographic Map – sourced from Australian Bureau of Statistics (ABS) data, a one page summary looking at the major demographic and socio-economic segments (age, income, marital status, transport to work, profession or occupation, family type, birth country, language spoken at home, type of home occupancy and structure of the dwelling) within the specific local area with state or national averages to highlight differences, strengths, below average items and groups of opportunity
  • *Business and Employment Map – sourced from Australian Bureau of Statistics (ABS) Counts of Australian Businesses data showcasing people who work in the local area, and the size (number of employees) and category (industry) of individual businesses to compare with the state or national averages of employees, white or blue collar, employees in certain fields, industries or more big or small business to calculate lunchtime or after work trade, business to business (B2B) marketing and local area marketing opportunities. The raw data includes Business Registrations as well as activity measured by Goods and Services Tax (GST) submissions to the Australian Taxation Office (ATO)
  • Local Area Fact Sheet – a snapshot of the local area highlighting key features relevant to your enterprise with population counts and growth estimates, demographic indicators, addresses of competitors and business generators using the local area, site or territory you nominate (determined by a defined territory, marketing area, council area, suburb/s, postcode/s or radius)
  • Locator Map – shows the location of your enterprise, franchise or trade boundary, residential population density, location of local businesses and community groups and retail hubs. You can also add on an overlay of competitor locations
  • *Local Area Map – only geographic features including major and minor roads, road names, postcode and/or suburb boundaries and labels, train lines, rivers and other features you nominate and can include the boundaries of marketing or territory areas of existing franchise sites or corporate or retail network sites
  • Land Use and Zoning Map – this map defines the area by the smallest geographic unit used by the ABS, Mesh Blocks which is encoded with the land use or zoning within its boundary so you can visually identify the industrial and commercial precincts as well as schools, hospitals, parks and residential areas, shopping centres and strips, homemaker centres and strips with a key to their size
  • Population and Household Density Map – presents the geographic features of the local area over the top of a graphic indicator of household density. The number of households per square kilometre has been calculated for each Census Collection District (CCD) in Australia with the highest household density area in red, second highest in orange then yellow, then green
  • Customer Heat Map – presents the addresses of the customers in your database and displays them in graduating colours from blue (no customers), to green (medium concentration of customers) to red (high concentration). If combined with the Target Market Index Map (TMI), it can map out Local Area Marketing locations where you will attract more sales. The heat map process may change the projection of the map slightly
  • Target Market Index Map – presents the geographic features of the area with demographic variables that are related to the success of your enterprise to produce a single indicator of relative market potential by CCD to identify Target Market Index (TMI) hotspots
  • Business Distribution and Development Map – with access to a private database of around 700,000 businesses in Australia (the Spectrum Analysis Business Hit List), we have geocoded the entire list so that every business can be seen on a map by any size area with the company name, address, phone number, Australian and New Zealand Standard Industrial Classification (ANZSIC), title and business type all available. The geocoded business records can be represented on a Business Distribution Map with colour codes dependent on their ANZSIC Division Title. It provides concentrations of potential customers, suppliers, competitors or generators and can list contact points into which to market your business, by business category and includes company name, address, phone and business classification
  • *Business Hit List – using the information from the above data analysis, mapping and modelling, we can generate a Business Hit List that can be provided in Excel or CSV format with up to 1,500 records. This information can be used for more accurate site selection, market segmentation, product distribution, supply chain management and targeted marketing activities

Additional customised components can be included on any of these maps or lists.

The most popular Standard Data Packs for any areas, site or territory include:

  1. *Residential Demographic Map
  2. *Business and Employment Map
  3. *Local Area Map
  4. *Business Hit List

Any other combination is also available.

Disclaimer – Whilst we do our best to source the most current Business List information from reliable sources, the nature of business is such that the information may change or that the geocoding process may not align perfectly with a precise street address. However, we will always do our best to work with the most recent and reliable data available.

Postcode Data Pack

Are you responsible for finding demographic information for a specific postcode anywhere across Australia? 

We can compile a Postcode Data Pack in PDF format that includes a combination of demographic mapping information that has been summarised for an individual postcode that matches your interests and requirements.

We can use our six step data analysis process to include in the Postcode Data Pack any of the options from the Local Area Data Pack (above) with two slight variations:

  • the maps use the postcode boundary for the area size
  • the Business Hit List is provided in Excel or CSV format with up to 500 records

Interactive Store Data Packs

Have you been asked to provide specific store information through a point and click mapping interface in HTML for use on a website or to be seen online at any time?

The click component could include:

  • store fact sheet
  • location map
  • area demographic summary
  • area business and employment summary
  • business hit list
  • store photographs
  • interactive store map

This information can be helpful at either a full network level or an individual store level.

We can use our six step data analysis process to:

  • provide access to large amounts of information in a user friendly format, just like browsing a website, at individual store level
  • provide national, state and international maps to see the associated documentation, data and maps
  • develop a master login for the head office with all network information and different user logins for specific store information (for either existing or prospective franchisees)
  • provide user manuals, documentation, data sheets or maps in various formats including Store Data Packs
  • provide a simplified version for your enterprise website
All of this information can be used to create Store Data Packs that typically include:
 
  • store summary sheet with quick reference facts like store sales figures, sales ranking, property details (for example lease expiry and rent), store characteristics (for example trading hours, number of counters, signage and floorspace), market characteristics (for example population density and relevant businesses in the area), generator information (for example shopping centres in the area) and competitor information
  • demographic summary of the area around the store (say 3kms) comparing some essential demographics of the area to a city, state or national average
  • business demographic summary of the area around the store showing number of people who work in the area, the size of individual businesses and the industry group the local businesses belong to
  • business hit list that gives you the contact points in which to market your business, broken down by business category and lists the company name, address, suburb, state, phone and type of business it is classified as
  • store location map showing the residential density of the population, the location of local businesses and community groups as well as the location of retail hubs and shopping centres
  • photographs of the store capturing some key criterias that are considered relevant to sales, and may include signage visibility, onsite parking, reception area and general presentation of the store
  • competitor location can also be included

Once the Store Data Packs for the entire network are compiled, it can be linked to the respective stores on the map and the user can access this information just by pointing and clicking on any store on the network overview map.

Interactive Territory Data Packs

Have you been asked to provide specific territory information through a point and click mapping interface in HTML for use on a website or to be seen online at any time?

Just like our Interactive Store Data Packs listed above, we can provide a similar service for enterprises at the territory level.

Interactive Territory Data Packs typically include:

  • comprehensive strategic information one or more territories
  • demographic summary of the territory comparing some essential demographics of the area to a city, state or a national average
  • usiness demographic summary of the area showing the number of people who work in the area, the size of individual businesses and the industry group local businesses belong to
  • business hit list which gives you the contact points into which market your business, broken down by business category and lists the company name, address, suburb, state, phone, and type of business it is classified as
  • territory locator map showing the location of your store/s or trade boundary, the residential density of population, the location of local businesses and community groups as well as the location of retail hubs and shopping centres.
  • competitor location can also be included 

Once the Territory Data Packs for the entire network are compiled, it can be linked to the respective territories on the map and the user can access this information just by pointing and clicking on any territory on the territory overview map.

Clubs and Member Based Associations Data Packs

Do need to know where your members come from?

All of the Local Area Data Packs listed above are available for Clubs and Member Based Associations.

More specifically, we can:

  • geocode each member and map your existing membership distribution
  • analyse your levels of membership ‘penetration’ and spend by area and age brackets
  • identify areas of over or under representation and potential expansion
  • identify ways to market specifically to under-represented areas and select primary and secondary marketing areas
  • identify potential alliances, sponsors and collaborations
  • define ‘preferred marketing areas’ for your membership base
  • align your goals with your sponsors’ goals

We can use our six step data analysis process to:

  • show you where your potential members are
  • where to market for new members
  • identify primary and secondary catchment areas
  • discover the services your members would like

Household Expenditure Data Packs

Are you responsible for finding out if there is a broad measure of demand for consumer goods or services (in current dollar terms) for a specific area anywhere in Australia?

We have created a database that uses Australian Bureau of Statistics (ABS) Household Expenditure Survey (HES) data (collected every five years), adjusted the amounts to current values and we produce reports showing household expenditure in two formats:

  • a range of commodities for a single area, site or territory
  • a range of areas, such as all Sydney postcodes, for a single commodity or group of commodities

The HES collects information on the expenditure, income, net worth and other characteristics of household residents in private dwellings throughout Australia.

The ABS provides this information on their website at capital city level but not for smaller areas, sites or territories. The Survey of Income and Housing (SIH) information has to be estimated for smaller geographies and requires access to Confidential Unit Record Files (CURF’s). 

These Household Expenditure Data Packs can be used to help you with questions about:

  • how to develop a strategic network plan
  • comparing different areas based on their average household spend on goods and services of interest to you
  • calculating the market potential for specific goods or services
  • determining your market share

We can use our six step data analysis process to help you:

  • see results for any broad area of interest to a very micro level like Census Collection Districts (CCD) of approximately 200-300 households via our advanced statistical techniques
  • create household expenditure estimates for approximately 600 HES items including current housing costs, domestic fuel and power, food and non-alcoholic beverages, alcoholic beverages, tobacco products, clothing and footwear, household furnishing and equipment, household operations and services, medical care and health expenses, transport, recreation and personal care
  • see the findings from our micro-simulation modelling technique, benchmarking and adjustments based on the Australian National Accounts Australian Consumer Price Index (CPI) to estimate household expenditure on goods and services. Micro-simulation involves linking the HES CURFs to the ABS Census Data using a set of linkage variables which are present in both data sets. All households from a set of the surveyed households are given a weighting for every area request. These weights are then applied to the spend by each household on pre-determined goods and services to obtain a household expenditure for every area request. The estimates are benchmarked against the available ABS household expenditure estimates and other data sources on a case to case baiss and the final estimates are adjusted using the latest Australian National Accounts CPI to make them up-to-date

Disclaimer – Whilst we receive the information from the Australian Bureau of Statistics (ABS), the ABS is not involved in the process of producing household expenditure estimates and will not be responsible for any inaccuracies or events resulting from inaccuracies and Spectrum Analysis cannot warrant the use of these estimates for any specific purpose. 

The terms of licensing household expenditure estimates include:

  • permission to use the estimates for internal use only
  • prohibition to re-sell household expenditure estimates to a third party without permission from Spectrum Analysis
  • attribute the source of household expenditure estimates in any external publication to Spectrum Analysis Australia Pty Ltd

Time Series Sales Forecasting

 

Are you responsible for creating sales forecasts for the future?

A time series is a sequence of observations taken over a period of time, for example, daily, weekly and monthly sales figures or daily maximum temperatures.

A time series analysis can be used to:

  • forecast the future values of a series
  • assess cash flows
  • forecast sales and prepare financial plans
  • assess the performance of a franchise, corporate or retail network (either individually or collectively)
  • plot sales data against time to reveal trends, seasonality, remove the trend or seasonal component
  • identify overall trends, high and low periods and complex facts and then investigate any areas of concern
  • use the sales data to model weekly and monthly forecasts instead of relying on yearly results
  • design efficient stock ordering practices, develop financial plans and optimise staffing and resources

We can use our six step data analysis process, once we understand your enterprise, your products and services, the current and target customer base and the existing buying patterns to:

  • complete a data review for your overall sales and any inconsistencies
  • review for trends, seasonality and complete an outlier analysis
  • develop a forecast model using appropriate statistical techniques like smoothing, logarithmic transformation and appropriate time series models
  • conceal the last few known values of sales and tune the model until it predicts these values as accurately as possible
  • create the model, test to satisfaction and then forecast future sales