Hubspot to Excel - Incompatible Fields ?
Katie Murray
when trying to create a query using contacts data from Hubspot I get the following error
"Incompatible fields: date, contact_owner_id, contact_owner_first_name, contact_owner_last_name, contact_lead_count IllegalDimensionMetricCombinationException"
I understand this combination of selected split by fields and metrics don't work, but how can I learn what are 'appropriate' combinations to use. Is there any documentation on this for the Hubspot to Excel API??
I have a lot of new queries to write and need to get a better idea or overview of the 'schema' of Hubspot as seen by Supermetrics in excel, and what can or cannot by queried.
Any help really appreciated!
Thanks for asking Katie.
With some data sources you can find this kind of compatibility information from their own documentations. These are HubSpots own resources on their own API's:
Analytics API V2:
https://developers.hubspot.com/docs/methods/analytics/analytics-overview
CMS Blogs API V2:
https://developers.hubspot.com/docs/methods/blogv2/get_blogs
CMS Blog Authors API V3:
https://developers.hubspot.com/docs/methods/blog/v3/list-blog-authors
CMS Blog Posts API V2:
https://developers.hubspot.com/docs/methods/blogv2/get_blog_posts
CMS Page Publishing API V2:
https://developers.hubspot.com/docs/methods/pages/get_pages
Companies API V2:
https://developers.hubspot.com/docs/methods/companies/companies-overview
Company Properties API V1:
https://developers.hubspot.com/docs/methods/companies/get_company_properties
Contacts API V1:
https://developers.hubspot.com/docs/methods/contacts/contacts-overview
Contact Lists API V1:
https://developers.hubspot.com/docs/methods/lists/contact-lists-overview
Contact Properties API V1:
https://developers.hubspot.com/docs/methods/contacts/contact-properties-overview
CRM Pipelines API V1:
https://developers.hubspot.com/docs/methods/pipelines/get_pipelines_for_object_type
Deals API V1:
https://developers.hubspot.com/docs/methods/deals/deals_overview
Email Events API V1:
https://developers.hubspot.com/docs/methods/email/email_events_overview
Engagements API V1:
https://developers.hubspot.com/docs/methods/engagements/engagements-overview
Forms API V2:
https://developers.hubspot.com/docs/methods/forms/forms_overview
Marketing Emails API V1:
https://developers.hubspot.com/docs/methods/lists/marketing-email-overview
Owners API V2:
https://developers.hubspot.com/docs/methods/owners/owners_overview
Social Media API V1:
https://developers.hubspot.com/docs/methods/social_media/get_channels
Which fields are compatible and which are not is up to the data source itself and Supermetrics doesn't unfortunately have any control over this.
In your case, most likely the field "contact_lead_count" is not compatible with "contact_owner_xxx" fields. Try making separate queries with just the contact owner details and one with the contact lead count.
Best regards,
-Supermetrics Team