How can we help?

New post
0

Email Performance through Hubspot

Avatar
Mark Loggins
None
Follow

My employer would like me to integrate data from several places into Klipfolio. One of these places is Hubspot. We run Email campaigns out of that service. I am very new to API. but by scouring through the API docs, I was able to pull over info. BUT, every time a new email campaign starts (sometimes weekly), I would have to create a new query for that campaign. 

 

Klipfolio has pre-built Klips for Hubspots Blog Subscriptions, but why no Email performance? It is nearly impossible to keep the present klip updated efficiently, Any suggestions or ideas?

Date Votes

5 comments

  • 0
    Avatar
    Janice Janczyn

    Hi Mark,

    Which HubSpot endpoint are you using? For example, https://api.hubapi.com/email/public/v1/campaigns/<campaign_id> ? It may be possible to create a dynamic datasource version of your email performance datasource, if you are able to track you campaign IDs in a separate datasource (simple spreadsheet).

    Thank you,
                 Janice

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Mark,

    Thanks for posting in our community!

    What you can do to simplify your task is first create a datasource which is just a list of all recently updated campaigns.
    Then, if you want to get data across all of them, you can use the MAPFLAT function to iterate through these campaign ID's, by creating a dynamic datasource, where the variable is the campaign ID.

    So for example, you use the first method to create a datasource with all recently updated campaigns.
    Then, you create another datasource, which uses this endpoint here to get specific information about a campaign, and make the campaign ID dynamic.
    When you are getting the information from these campaigns, you can do something like this inside of the Editor, for example grabbing the sum of all delivered emails for these campaigns.
    SUM(
           MAPFLAT(
                <IDs from first datasource>,
                 "idVariable",
                 <counters/delivered from dynamic DS>
          )
    )

    Hope this helps!

    Warm regards,
    Joshua
    ______________
    Joshua Cohen-Collier
    Technical Support Specialist, Klipfolio

  • 1
    Avatar
    Mark Loggins

    Thanks Joshua, I will give it a shot.

     

    I could export all that campaign data to CSV and put it on Google Drive. But how would I keep it live? Wouldn't that just be a snapshot?

     

  • 0
    Avatar
    Mark Loggins

    Do I need to create a new datasource for each email campaign? We probably create at least a new campaign per week, meaning I'd have to manually create a new data source every week. Does this sound correct?

  • 0
    Avatar
    Awais Munir

    We have been struggling with Hubspot API for some time. We got everything we wanted through the APIs using MAP and MAPFLAT. But the issue is that it makes the dashboard extremely slow. What I would recommend you is to send the data from Hubspot to another service like for example: Blendo.co which will send it to your database and from there you can get it into Klipfolio. This makes the dashboard load much quicker and everything is smooth.

Please sign in to leave a comment.