Frederic_Pinch1
Level 2
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-01-2020
08:14 PM
|
11
Posts
2
Likes
0
Solutions
07-26-2019
10:48 PM
Hi Jep, Hoping you can shed some light on the Email Programs: can I also navigate the folders as you described to find them?
... View more
05-29-2019
01:14 PM
Jep, Will this logic of using folders also work for Email Programs? Cheers, Frederic
... View more
05-28-2019
10:30 PM
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?
... View more
05-28-2019
12:28 PM
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?
... View more
05-27-2019
10:24 PM
1 Like
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
... View more
Labels:
11-22-2017
01:12 PM
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...
... View more
11-22-2017
12:56 PM
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?
... View more
11-22-2017
12:47 PM
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?
... View more
11-21-2017
01:14 PM
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...
... View more
11-15-2017
09:47 PM
1 Like
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
... View more
Public Statistics
| Date Registered | 11-15-2017 09:08 PM |
| Date Last Visited | 07-01-2020 08:14 PM |
| Total Messages Posted | 11 |
| Likes Received | 2 |
.png)