Email event API: appName = Workflow or AbBatch don't have time dimension

[#1]

Not all emails metrics pulled by below URL have the dates when the emails sent out:

https://api.hubapi.com/email/public/v1/campaigns/13054799?appId=20185&hapikey=demo

Based on my finding, looks like only the emails with appName equal to 'workflow' and 'ABbatch' don't have time dimension.

On the contrary, The other 2 types of appName('batch' and 'localtimebatch') have time dimenision, which is called "lastProcessingFinishedAt".

So my question is how can i get all the dates for all emails.

--- one more questions
For the dashboard created by hubspot Web UI, in the email performance dashboard(the template one), does it capture all the emails sent with all the app type(workflow, batch, localtimebatch and abbatch)?

thank you!!!

[ryker]

How is it possible that AB emails don't have a time dimension? 

I'm trying to create department specific reporting on newsletters, and they've just decided to start AB testing a few things. But without the time data, I can't report on trends from past emails and the newer AB test emails. At least not through the API, and without needing to manually code the send date or fake a lastProcessingFinishedAt date. 

[#3]

Thanks! It will be great if this improvement can be done in the nearest future.

[cbarley]

Hi @kai_wei_tivity, you can match them with the IDs returned back here: https://developers.hubspot.com/docs/methods/email/get_campaigns_by_id, but you wouldn't be able to match via timestamp. Currently, the data returned from that endpoint can't be compared over a specific time period. There's definitely improvements to be made with that endpoint, so if you're inclined, I'd post your idea in our ideas forum/

[#5]

Hi Connor,

Thanks for your information.

Based on your information, since AB emails and workflow emails won't return a time stamp by API call, How can I match my data pull from API call with the performance report on the monthly level?

For example, I want to see the number of email sent within Sep-2018, so I pull out this information API for all emails types, but since AB emails do not have time stamps returned by API, this data is not gonna match with the email performance report. Is there a way to solve this issues?

Thanks again

[cbarley]

Hey @kai_wei_tivity, thanks for posting - happy to help out here. Batch emails are the only emails that will return a timestamp, whereas AB emails and workflow (automated) emails are sent more than once, and do not return a timestamp. Do you have a specific use-case for the timestamp field? Happy to pass along internally.

The email performance report should include all email types.