Frederic_Pinch1

Frederic_Pinch1 · ‎07-26-2019

Hi Jep, Hoping you can shed some light on the Email Programs: can I also navigate the folders as you described to find them?

Frederic_Pinch1 · ‎05-29-2019

Jep, Will this logic of using folders also work for Email Programs? Cheers, Frederic

Frederic_Pinch1 · ‎05-28-2019

Wow, impressive... Thanks a lot for the guidance, this seems to work, but it's gonna be a real pain to iterate through the folder levels... This begs the question: how do Marketo display seamless email performance reports with all type of email programs: Is it just that they can use internal joints not available through API?

Frederic_Pinch1 · ‎05-28-2019

Your assumption is right, in type 6, I find the Campaign ID, and in the Campaign table I find the Program ID and Program Name, which is what I need to report on performance by Program. Works great for regular emails, but not for Engagement Programs which don't seem to be tied to a Campaign.. Following your logic by Email ID, if I use the /rest/asset/v1/emails.json endpoint, I am getting those fields: How can I find which engagement program the email belongs to? I am quite confused, because the /rest/v1/campaigns.json endpoint, shows me this: and that is great because I have the Program in there, but Engagement Programs are not listed in that table... I find Engagement Programs under the Smart Campaigns endpoint /rest/asset/v1/smartCampaigns.json : But then, no Program available here! And to make it even more confusing, Marketo states not to use /rest/v1/campaigns.json, as it is deprecated: What's the missing link between SmartCampaigns and Programs for Engagement Programs?

Frederic_Pinch1 · ‎05-27-2019

I am trying to build a report outside of Marketo similar to an Email performance report, after extracting to a data warehouse activity types 6,7,8 and more through Bulk API. Everything was going well until I realized that Engagement Programs, if they are found in activity 6 under a Campaign ID, don't seem to be tied to a Program ID, and therefore I can't get an Email Name. Actually, the Campaign ID for those engagement programs is a SmartList, found under the SmartList asset endpoint, without Program attribute, whereas the regular email programs are found as attributes of the Campaign in the Campaign endpoint as any one would expect... How can I find the Program Name associated to a Engagement Program Activity entry? Sanford Whiteman‌ wrote: There's no exposed Activity Type ID for the cast as separate from the send. You would have to triangulate this (roughly) by aggregating their last stream ID change (which is a separate event) with the send. I am not sure if that could be a clue, as I cannot make sense of that explanation: where would I find that Cast transaction entry to match with the send? Cheers, Frederic

Frederic_Pinch1 · ‎11-22-2017

OK thanks for all the explanations Sanford, I am new to that topic. So if I got that right, as a conclusion, requesting to compress the request only results in a faster transfer, no other benefits...

Frederic_Pinch1 · ‎11-22-2017

Oh OK, so that still means that the volume downloaded out of the Marketo instance will be compressed, consuming less of the 500MB a day quota?

Frederic_Pinch1 · ‎11-22-2017

I tried yesterday, and even though the Header Accept-Encoding: gzip gets accepted in the request, it still downloads a regular CSV, not a GZIP file... What am I missing?

Frederic_Pinch1 · ‎11-21-2017

That is not an easy task... We offer it as a consulting engagement, using the Bulk API, which won't hit your API calls limits... Contact me if interested...

Frederic_Pinch1 · ‎11-15-2017

There is a way! It is a bit convoluted, but here it is: Get a list of all tagType using : GET /rest/asset/v1/tagTypes.json 2. Pick one Tag Type in the list which is required and applicable to programs, and get all the Tag Values for that Tag Type using: GET /rest/asset/v1/tagType/byName.json?name=+[Tag Type Name] 3. For each Tag Value of that Tag Type, you can now get all the Tag Values for all Tag Types for all Programs: GET /rest/asset/v1/program/byTag.json?tagType='+[Tag Type Name]+'&tagValue='+[Values]+'&maxReturn=200 And as a bonus, it will include Program costs, costs start date and cost notes! I hope this helps... Frederic

Online Status	Offline
Date Last Visited	‎07-01-2020 08:14 PM

Date Registered	‎11-15-2017 09:08 PM
Date Last Visited	‎07-01-2020 08:14 PM
Total Messages Posted	11
Likes Received	2

Top Badges Earned

Re: API questions: Engagement Programs Activity

Re: API questions: Engagement Programs Activity

Re: API questions: Engagement Programs Activity

Re: API questions: Engagement Programs Activity

API questions: Engagement Programs Activity

Re: Compression on Bulk Export APIs?

Re: Compression on Bulk Export APIs?

Re: Compression on Bulk Export APIs?

Re: Exporting all Email and campaign content

Re: REST API - Retrieve Tag and Cost Info Using Br...