ApartmentIQ: Getting Started With Direct Data Delivery

Connecting ApartmentIQ to External Data Solutions

Written By Jaime Dorn (Super Administrator)

Updated at November 13th, 2025

Welcome to our Direct Data Delivery documentation! Our platform offers a daily direct data feed of unit level data and a range of integration types tailored to suit your technology needs and technical skill levels. We offer a Data Sync data feed with a no-code integration option and a data lake integration option. We also provide direct access to our APIs. 

Data Sync - (No-code) BI Delivery Overview

You can effortlessly connect and analyze your data without the need for advanced technical skills. Our Data Sync option offers the following data that you can easily connect to and use in your analytics platform/tool:

  • Choose between 4 levels of data granularity:

    • MSA
       
    • Property
       
    • Floor Plan
       
    • Unit
       
  • All unit-level rents for your owned properties and their comparable properties in ApartmentIQ
     
  • Receive 30 days of leased unit-level rent and effective rent for units currently advertised in your Market Surveys
     
  • Opt-in to direct data feed for research properties and expanded market coverage

*A comprehensive list of the available fields can be found in the final section below for your reference 
 

Below are specific how-to guides for common analytics platforms to configure a Data Sync (no-code) data delivery: 


Data Sync - DataLake Overview

Data Sync integrates seamlessly with data lake providers when you need to store and analyze massive volumes of diverse information from multiple sources. This includes but is limited to: 

  • AWS
     
  • Snowflake
     
  • Azure
     
  • GCP

    Contact your Customer Success Manager for more details.
     

Alternative Options

ApartmentIQ offers other options to ensure you are able to get the data you need, in the format you desire. A similar csv API option where you can dynamically apply filters to view properties within MSA boundaries is available. We also offer a JSON API for highly technical teams who require handling implementation on their own. Please contact your Customer Success Manager or our Support Team for more information. Additionally, please reference this link for developer resources.

 

Getting Started 

To get started with any of ApartmentIQ’s Direct Data options, please contact our support team (support@apartmentiq.io) for your Data Sync or API key access. 

The files update every morning and are ready with the current day's data by 11 AM CST. If you access the file before the update is complete, it will still contain data from the previous day. This process ensures there is no downtime for any of our Direct Data options, allowing you to always access the most up-to-date information available.

When an application user adds or removes comps to a Market/Research Survey in Apartment IQ, for Standard and DataLake integrations the new changes will be reflected in your data feed the next day, API data will be available in real time. 

The APIs allow you to search for additional properties via geocode and does not require a property to be part of a Market or Research survey. 

 

Comprehensive list of our available fields 

A full detailed list of the fields available via our Standard and DataLake integrations: 
 

Unit Level File

Field Name

Definition

Report Generation Date

Date this data was pulled from ApartmentIQ

Market Name

Name of the Market or Research Report

Market ID

ID of the Market or Research Report in Apartment IQ

Property

Name of the property

Property ID

ID of the Property in Apartment IQ

Property URL

Website URL for the property

Address

Street Address for the property

City

City of the Property

State

State of the Property

Zip

Zip of the Property

Latitude

Latitude of the Property

Longitude

Longitude of the Property

Date Tracking Started

Date of when we first started tracking the Property

Unit Count

Number of total units in the Property

Year Built

Year the property was built 

Unit

The specific Unit # in a property

Days On Market

The number of days the unit was advertised online

Date Available

Date the advertised unit is available

Beds

Number of bedrooms in the unit

Baths

Number of baths in the unit

Rent

Advertised Rent price of the unit

Sq Ft

Square footage of the unit

Rent / Sq Ft

Average rent per square foot of the unit

Last Change Date

Date of the last rent change

Last Change

Amount of the last rent change

Total Change

Total rent change

Rent Changes

Number of rent changes

Trucomp

Whether the unit is a truComp of the subject units in the comp set.

Date Leased

Date the unit was leased.

Trucomp Rent Differential

Percent differential of the units rent compared to the truComp average rent.

Trucomp Sq Ft Differential

Percent differential of the units square footage compared to the truComp average square footage.

Trucomp Rent / Sq Ft Differential

Percent differential of the units rent per square foot compared to the truComp average rent per square foot.

Concessions

Value of the rent concession.

NER

Net effective rent of the unit

Concession Details

Raw details of the rent concession.

NER / Sq Ft

Net effective rent per square foot of the unit

Unit Status

Applied, Leased, or Available

Year Renovated

Year the property was renovated

Floorplan Name

Name of the unit’s floorplan

Unit specific amenities

Amenities for this unit that only apply to specific units in the building

Management Company

The name of the company who manages the property

 
Floor Plan File

Field Name

Definition

Report Generation Date

Date this data was pulled from ApartmentIQ

Market Name

Name of the Market or Research Report

Market ID

ID of the Market or Research Report in Apartment IQ

Property

Name of the property

Property ID

ID of the Property in Apartment IQ

Property URL

Website URL for the property

Data Tracking Started

Date of when we first started tracking the Property

Address

Street Address for the property

City

City of the Property

State

State of the Property

Zip

Zip of the Property

Latitude

Latitude of the Property

Longitude

Longitude of the Property

Unit Count

Number of total units in the Property

Year Built

Year the property was built 

Year Renovated

Year the property was renovated

Floor Plan Name

Name of the unit’s floorplan

Beds

Number of bedrooms in the unit

Baths

Number of baths in the unit

Avg Sq Ft

Average square footage of all units within the floorplan

Unit Mix: Total Units

Projected count of total units by bed type

Unit Mix

Percentage of units of a given bed type relative to the entire property

Available Units

Count of currently available units within a floorplan 

Days on Market

Average days on market for available units

Avg Rent

Average rent of the units

Avg Rent/Sq Ft

Average rent per square foot of the units

Average NER

Average net effective rent of the units

Avg NER/Sq Ft

Average net effective rent per square foot of the units

Rent Trends

Difference in rent values between the start and end of the configured time frame

Management Company

The name of the company who manages the property

 

Property Level File

Field Name

Definition

Report Generation Date

Date this data was pulled from ApartmentIQ

Market Name

Name of the Market or Research Report

Market ID

ID of the Market or Research Report in ApartmentIQ

Property

Name of the property

Property ID

ID of the Property in ApartmentIQ

Property URL

Website URL for the property

Date Tracking Started

Date of when we first started tracking the Property

Address

Street Address for the property

City

City of the Property

State

State of the Property

Zip

Zip of the Property

Latitude

Latitude of the Property

Longitude

Longitude of the Property

Unit Count

Number of total units in the Property

Year Built

Year the property was built 

Year Renovated

The specific Unit # in a property

Comp Score

Score to determine how similar property is to subject

Google Rating

Average of 0 to 5 ratings

Google Reviews

Number of reviews that were factored into the rating

Advertised Occupancy %

The projected percentage of occupied units, calculated by subtracting vacant units from the total units and dividing the result by the total units.

Leased %

The percentage of all active leases, including upcoming move in dates, relative to the total property count. 

Pre-Leased %

Percentage of active leases, excluding on-notice units, relative to the total property count. 

Exposure %

The percent of a property’s total units that are available for rent. 

Exposure % (Next 30d)

The percent of a property’s total units that are available for rent in the next 30 days. 

Exposure % (Next 60d)

The percent of a property’s total units that are available for rent in the next 60 days. 

Applications (Last 7d)

Units removed from the website in the last 7 days.

Re-listed Units (Last 7d)

Units reposted to the website in the last 7 days. 

Re-listed Units (Last 30d)

Units reposted to the website in the last 30 days. 

Leases (Last 7d)

Units that were delisted for 7 days and are now converted from applications into leases. 

Leases (Last 30d)

Units that were delisted for 30 days and are now converted from applications into leases. 

Vacant Units

Available, Leased, or Applied Units with a date available within the next 10 days. 

Available Units

All advertised units that are available for future or immediate move-in. 

New Available Units (Last 7d)

Advertised units that became available within the last 7 days. 

New Available Units (Last 30d)

Advertised units that became available within the last 30 days. 

New Available Units per Week (Last 4w)

Units that became available within the selected timeframe. 

Avg Rent

Average rent of all available units

Avg Sq Ft

Average square footage of all available units

Avg Rent/Sq Ft

Average rent per square foot of all available units

Avg NER

Average net effective rent for all available units

Avg NER/Sq Ft

Average net effective rent per square foot for all available units

Concessions

Monetary value for concessions offered for available units

Concession Details

Additional details for for concessions offered for available untis

0BR Avg Rent

Average rent of studio units

0BR Concessions

Monetary value for concessions offered on studio units

0BR Concession Details

Additional details for for concessions offered on studio units

0BR Avg NER

Average Net effective rent for studio units

0BR Avg Sq Ft

Average square footage for studio units

0BR Avg Rent/Sq Ft

Average rent per square foot for studio units

0BR Avg NER/Sq Ft

Average Net effective rent per square foot for studio units

0BR Available Units

Number of advertised studio Units

0BR Vacant Units

Number of vacant studio Units

1BR Avg Rent

Average rent of 1 Bedroom units

1BR Concessions

Monetary value for concessions offered on 1 Bedroom units

1BR Concession Details

Additional details for for concessions offered on 1 Bedroom units

1BR Avg NER

Average Net effective rent for 1 bedroom units

1BR Avg Sq Ft

Average square footage for 1 bedroom units

1BR Avg Rent/Sq Ft

Average rent per square foot for 1 Bedroom units

1BR Avg NER/Sq Ft

Average Net effective rent per square foot for 1 bedroom units

1BR Available Units

Number of advertised 1 Bedroom Units

1BR Vacant Units

Number of vacant 1 Bedroom Units

2BR Avg Rent

Average rent of 2 Bedroom units

2BR Concessions

Monetary value for concessions offered on 2 Bedroom units

2BR Concession Details

Additional details for for concessions offered on 2 Bedroom units

2BR Avg NER

Average Net effective rent for 2 bedroom units

2BR Avg Sq Ft

Average square footage for 2 bedroom units

2BR Avg Rent/Sq Ft

Average rent per square foot for 2 Bedroom units

2BR Avg NER/Sq Ft

Average Net effective rent per square foot for 2 bedroom units

2BR Available Units

Number of advertised 2 Bedroom Units

2BR Vacant Units

Number of vacant 2 Bedroom Units

3BR Avg Rent

Average rent of 3 Bedroom units

3BR Concessions

Monetary value for concessions offered on 3 Bedroom units

3BR Concession Details

Additional details for for concessions offered on 3 Bedroom units

3BR Avg NER

Average Net effective rent for 3 bedroom units

3BR Avg Sq Ft

Average square footage for 3 bedroom units

3BR Avg Rent/Sq Ft

Average rent per square foot for 3 Bedroom units

3BR Avg NER/Sq Ft

Average Net effective rent per square foot for 3 bedroom units

3BR Available Units

Number of advertised 3 Bedroom Units

3BR Vacant Units

Number of vacant 3 Bedroom Units

SS Appliances

“TRUE” If property has this amenity

Dishwasher

“TRUE” If property has this amenity

Garbage Disposal

“TRUE” If property has this amenity

Kitchen Island

“TRUE” If property has this amenity

Washer/Dryer

“TRUE” If property has this amenity

Washer/Dryer Hookup

“TRUE” If property has this amenity

Air Conditioning

“TRUE” If property has this amenity

Ceiling Fans

“TRUE” If property has this amenity

Stone Countertops

“TRUE” If property has this amenity

Tile

“TRUE” If property has this amenity

Vinyl Flooring

“TRUE” If property has this amenity

Carpet

“TRUE” If property has this amenity

Hardwood Floors

“TRUE” If property has this amenity

Views

“TRUE” If property has this amenity

Fireplace

“TRUE” If property has this amenity

Smart Technology

“TRUE” If property has this amenity

High Ceilings

“TRUE” If property has this amenity

Balcony/Patio

“TRUE” If property has this amenity

Walk-In Closets

“TRUE” If property has this amenity

Linen Closet

“TRUE” If property has this amenity

Pantry

“TRUE” If property has this amenity

Fitness Center

“TRUE” If property has this amenity

Pool

“TRUE” If property has this amenity

24 Hour Maintenance

“TRUE” If property has this amenity

Clubhouse/Lounge

“TRUE” If property has this amenity

BBQ/Grill Area

“TRUE” If property has this amenity

Business Center

“TRUE” If property has this amenity

Storage Space

“TRUE” If property has this amenity

Package Service

“TRUE” If property has this amenity

Controlled Access

“TRUE” If property has this amenity

Laundry Facilities

“TRUE” If property has this amenity

Elevator

“TRUE” If property has this amenity

Rooftop Space

“TRUE” If property has this amenity

Online Payments

“TRUE” If property has this amenity

Playground

“TRUE” If property has this amenity

Pet Park

“TRUE” If property has this amenity

Bicycle Storage

“TRUE” If property has this amenity

Gameroom

“TRUE” If property has this amenity

EV Charging

“TRUE” If property has this amenity

Security Deposit

“TRUE” If property has this amenity

Application Fee

“TRUE” If property has this amenity

Admin Fee

“TRUE” If property has this amenity

Parking Fee

“TRUE” If property has this amenity

Parking Garage

“TRUE” If property has this amenity

Carport

“TRUE” If property has this amenity

Surface Lot Reserved

“TRUE” If property has this amenity

Surface Lot

“TRUE” If property has this amenity

Pets Allowed

“TRUE” If property has this amenity

Pet Fee

“TRUE” If property has this amenity

Pet Rent

“TRUE” If property has this amenity

Pet Deposit

“TRUE” If property has this amenity

Pet Limits

“TRUE” If property has this amenity

Pet Restrictions

“TRUE” If property has this amenity

Utility Fees

“TRUE” If property has this amenity

Storage Fee

“TRUE” If property has this amenity

Management Company

The name of the company who manages the property

 

MSA File

Field Name

Definition

Report Generation Date Date this data was pulled from ApartmentIQ
Market Name Name of the Market or Submarket
Property Name of the property
PropertyID ID of the property in ApartmentIQ
Property URL Website URL for the property
Address Street Address for the property
City City of the property
State State of the property
Zip Zip of the property
Latitude Latitude of the property
Longitude Longitude of the property
Unit Count Number of total units in the property
Year Built Year the property was built
Unit Unit name
Days on Market The number of days the unit was advertised online
Date Available Date the advertised unit is available
Beds Number of bedrooms in the unit
Baths Number of baths in the unit
Rent Advertised rent price of the unit
Sq Ft Square footage of the unit
Rent / Sq Ft Average rent per square foot of the unit
Last Change Date Date of the last rent change
Last Change Amount of the last rent change
Total Change Total rent change
Rent Changes Number of rent changes
Date Leased Date the unit was leased
Unit Status Date the unit was leased
Year Renovated Year the property was renovated
Floor plan Name Name of the units floor plan
Unit Specific Amenities Amenities for this unit that only apply to specific units in the building

 

For information regarding common ApartmentIQ terminology, please see our Glossary.