Extracting HubSpot Data with Skyvia

Functionality Overview

Skyvia's Export tool along with the HubSpot connector allows you to extract CRM data, activity history, and record relationships from HubSpot into structured files on a scheduled basis for reporting, analytics, backups, or integration with other systems. Extracts can be set up to include all records, associations, etc. in the portal, or they can be filtered with specific criteria to narrow down the results.

Exported files can either be made available for manual download from Skyvia or placed on a storage service like an SFTP or any of the various connections available with Skyvia.

Impact on Skyvia Subscription

An important consideration is that exports from HubSpot with Skyvia’s Export tool will impact your subscription level in Skyvia. Each row in any reports you export from HubSpot will count as a processed “record”, counting against your total limit in your subscription.

🔗 Understanding Records in Skyvia

Tables Available for Export

HubSpot’s entire schema is accessible through the Skyvia Export tool, which means it’s important to define exactly what data you want to pull out of HubSpot.

In general, the schema/tables available for export can be grouped into the following categories:

HubSpot objects
Association tables
Property metadata tables
History/audit tables
Engagement/activity tables

Here’s an additional categorization to help illustrate the available data points:

Category	Example in Skyvia	What it represents
Core objects	Contacts, Companies, Deals, Tickets	The actual CRM records
Engagements	CompanyEngagements, ContactEngagements	Emails, calls, tasks, meetings linked to records
Associations	ContactDeals, CompanyContacts, DealTickets	Join tables showing relationships between objects
Properties	ContactProperties, CompanyProperties	Metadata describing fields on the object
History	ContactsHistory, DealsHistory	Property change history for records
Supporting objects	Lists, Users, etc.	Misc HubSpot platform data
Analytics	AnalyticsBreakdownbySessionReport, AnalyticsFormsReport, AnalyticsPagesReport	HubSpot’s internal reporting datasets (custom reports not available)

Overview of Available Tables

Please Note: These tables are not an exhaustive list of available data tables. See next section for the full list of 147 available tables.

Standard CRM Objects

These are the primary records in HubSpot and the most commonly exported objects. If your portal has a custom object in place, those records can be exported just like a standard object.

Object	Definition
Contacts	Individual people in the CRM
Companies	Organizations or businesses
Deals	Sales opportunities or financial relationships
Tickets	Service or support requests
LineItems	Products/services attached to deals
Products	Catalog of sellable items
Owners	HubSpot users assigned to records
Pipelines	Sales/service pipelines
PipelineStages	Stages within pipelines

Engagement / Activity Objects

These represent interactions with records and connect to CRM objects via associations.

Object	Definition
Engagements	Generic engagement container
Calls	Logged phone calls
Emails	Logged email communications
Meetings	Scheduled meetings
Notes	Notes attached to records
Tasks	To-do items

Association Tables

These are HubSpot relationships represented as relational joins. If you have a custom object in place, association objects will be available for any established object associations.

Object	Definition
ContactCompanies	Links contacts to companies
ContactDeals	Links contacts to deals
ContactTickets	Links contacts to tickets
CompanyDeals	Links companies to deals
CompanyTickets	Links companies to tickets
DealTickets	Links deals to tickets
DealLineItems	Links deals to line items
DealContacts	Links deals to contacts
EngagementContacts	Engagement linked to contacts
EngagementDeals	Engagement linked to deals
EngagementCompanies	Engagement linked to companies
EngagementTickets	Engagement linked to tickets

Property Metadata Objects

These describe the schema of HubSpot objects and are helpful for generating data dictionaries and auditing HubSpot’s schema.

Object	Definition
ContactProperties	All contact fields
CompanyProperties	All company fields
DealProperties	All deal fields
TicketProperties	All ticket fields
LineItemProperties	All line item fields

Property History Objects

These store field change history. Reports will include columns like Record ID, Property Name, Old Value, New Value, and Timestamp.

Object	Definition
ContactsHistory	History of contact property changes
CompaniesHistory	History of company property changes
DealsHistory	History of deal property changes
TicketsHistory	History of ticket property changes

Marketing / CRM Supporting Objects

These represent supporting segmentations, form interactions, and background data in the portal.

Object	Definition
Lists	HubSpot static or active lists
ListMemberships	Contact membership in lists
Forms	HubSpot forms
FormSubmissions	Data submitted through forms
Campaigns	Marketing campaigns
Owners	CRM users

Email Marketing Objects

These represent marketing email data points, engagements, and interactions.

Object	Definition
MarketingEmail	Individual Marketing Emails
EmailCampaigns	Marketing email campaigns
EmailEvents	Opens, clicks, bounces
EmailSubscriptions	Contact subscription status
SubscriptionTypes	Types of email subscriptions

All Available Tables - 147

Actors	CompanyBasedListMemberships	MarketingEmails
AnalyticsBreakdownByAllReport	CompanyContacts	MeetingProperties
AnalyticsBreakdownByAllTotalReport	CompanyDeals	Meetings
AnalyticsBreakdownByGeolocationReport	CompanyEngagements	Messages
AnalyticsBreakdownByGeolocationTotalReport	CompanyProperties	NoteProperties
AnalyticsBreakdownBySessionsReport	CompanyTickets	Notes
AnalyticsBreakdownBySessionsTotalReport	ContactBasedListMemberships	Orders
AnalyticsBreakdownBySourcesReport	ContactCompanies	Owners
AnalyticsBreakdownBySourcesTotalReport	ContactDeals	Pages
AnalyticsBreakdownByUtmCampaignsReport	ContactEngagements	PostalMail
AnalyticsBreakdownByUtmCampaignsTotalReport	ContactListContacts	PostalMailProperties
AnalyticsBreakdownByUtmContentsReport	ContactLists	Products
AnalyticsBreakdownByUtmContentsTotalReport	ContactProperties	PublishingChannels
AnalyticsBreakdownByUtmMediumsReport	Contacts	Quotes
AnalyticsBreakdownByUtmMediumsTotalReport	ContactsHistory	QuotesProperties
AnalyticsBreakdownByUtmSourcesReport	ContactTickets	Services
AnalyticsBreakdownByUtmSourcesTotalReport	Courses	Subscriptions
AnalyticsBreakdownByUtmTermsReport	DealBasedListMemberships	TaskProperties
AnalyticsBreakdownByUtmTermsTotalReport	DealCompanies	Tasks
AnalyticsContentBlogPostsReport	DealContacts	Teams
AnalyticsContentBlogPostsTotalReport	DealEngagements	Templates
AnalyticsContentKnowledgeArticlesReport	DealLineItems	Threads
AnalyticsContentKnowledgeArticlesTotalReport	DealPipelines	TicketBasedListMemberships
AnalyticsContentLandingPagesReport	DealPipelineStages	TicketCompanies
AnalyticsContentLandingPagesTotalReport	DealProperties	TicketContacts
AnalyticsContentListingPagesReport	Deals	TicketDeals
AnalyticsContentListingPagesTotalReport	DealsHistory	TicketEngagements
AnalyticsContentStandardPagesReport	DealTickets	TicketPipelines
AnalyticsContentStandardPagesTotalReport	Domains	TicketPipelineStages
AnalyticsEventCompletionsReport	EmailEvents	TicketProperties
AnalyticsEventCompletionsTotalReport	EmailProperties	Tickets
AnalyticsFormsReport	Emails	TicketsHistory
AnalyticsFormsTotalReport	EngagementCompanies	UrlMappings
AnalyticsPagesReport	EngagementContacts	UserDetails
AnalyticsPagesTotalReport	EngagementDeals	Users
AnalyticsSocialAssistsReport	Engagements	Workflows
AnalyticsSocialAssistsTotalReport	EngagementTickets
AnalyticsViews	EventsReport
Appointments	FeedbackSubmissions
BlogAuthors	Files
BlogPosts	Folders
Blogs	Forms
BlogTopics	FormSubmissions
BroadcastMessages	Inboxes
CallDispositions	InvoiceLineItems
CallProperties	Invoices
Calls	Layouts
Campaigns	Leads
ChannelAccounts	LineItemDeals
Channels	LineItemInvoices