Event Attendance query not pulling any information

  • 29Views
  • Last Post 4 weeks ago
Melissa Wright posted this 4 weeks ago


I'm using the query below to try and pull a raw file of attendees at an event we hosted earlier this month. This same query has worked fine for me in the past, but when I run it, I'm not getting any information (i.e., query finishes running and there is nothing listed in the raw data panel or the CSV file I export). I see the event was indeed logged in HubSpot as happening on 9/18/19. Could someone please review the query and let me know if I'm doing something wrong or if something has changed? Best, Melissa


SELECT c."First Name" as "FirstName", c."Last Name" as "LastName",c."Email" as "email", 

       e."timestamp"  as "Activity Date", e."Metadata_Body" as "Meeting Body"

FROM Contacts AS c, Engagements AS e

     INNER JOIN Engagements ON e.Associations_ContactIds like ('%' || c.Id || '%') 

WHERE  e.timestamp >='09/18/2019 00:00:00'

      AND e.timestamp <='09/18/2019 23:59:59'

      AND e.Type in ('Meeting')

      And e.activityType = 'University-Wide Event (e.g., Symposium)'

GROUP by c."First Name" , c."Last Name",c."Email", e."timestamp", e."Metadata_Body" 

ORDER BY c."First Name" , c."Last Name"

Dmitriy Muzurov posted this 4 weeks ago

Hello Melissa,

Thank you for submitting a ticket with us.

We have tested the query on our side and it is working.

Please make sure the requested data corresponds to all specified conditions in your HubSpot account.

Should you have any questions, do not hesitate to contact us back.