Monthly influencer ROI report from Later, emailed and archived

On the first of each month at 7am, generate our monthly influencer program report from Later, email it to our marketing leadership list, and archive it in Notion so we have a running history. Use a cron trigger.

Scope every Later call to the previous calendar month. Work out the first and last day of that month at run time and pass them as startDate and endDate in YYYY-MM-DD format in UTC. If the workflow runs on 1 March, the reporting window is 1 February to 28 February.

Pull three things from Later. Use Get Platform Return On Investment for estimated media value and return on investment broken down by content type. Use Get Platform Performance for the engagement and reach split across Instagram, TikTok and the rest. Use Get Instance Performance for program wide totals.

Later treats platform and contentType as mutually exclusive filters and returns a 400 with type ANL_00400 if both are sent in one request, so ask for those breakdowns in separate calls: one pass for the content type breakdown with no platform filter, and one call per platform family for the channel split. platform selects a whole family, so instagram covers instagram_post, instagram_reel and instagram_story. Leave instanceIds unset so the report covers every instance bound to our credentials, unless we name specific ones.

A few more Later details to handle. Every performance route requires an explicit metrics parameter and returns only the metric names requested, and the supported values differ per endpoint, so use each operation's own list rather than assuming a shared set. Get Instance Performance returns a single aggregate object with metrics under data.metrics rather than an array. Aggregate routes, including instance performance and platform return on investment, always return nextCursor as null, so do not try to paginate them. Paid media metrics are prefixed paid, such as paidImpressions, and link metrics are prefixed trackingLinks or affiliateLinks. Dates are UTC.

To report month over month direction, repeat the program wide and return on investment pulls for the month before the reporting month and compare the two. Treat that earlier month as context only. The report is about the month just closed.

Write a short narrative report, not a table dump. Open with the headline return on investment number for the month. Explain which content types earned their spend and which did not, using estimated media value against spend as the basis for that judgement, and name them specifically. Call out the month over month direction and whether the program is improving or slipping. Close with two or three concrete recommendations for next month's content mix, each tied to something in the data rather than generic advice. Aim for something a busy executive reads in two minutes.

Send the finished write up with Gmail Send a Message to our marketing leadership list. Use a subject line that names the month, for example "Influencer program report: February 2026", and put the narrative in the body.

Then archive the same write up as a Notion page using Create a Page in our Marketing Reports database. Title it with the month so the database reads as a chronological history, and keep the body identical to what was emailed. Make the recipient list and the target Notion database easy to change without editing the rest of the logic.

If Later reports no activity for the month, still send a short note saying there was nothing to report and skip the recommendations rather than inventing them. If a Later call fails, retry once before giving up, and never send a report that quietly drops one of the three data pulls without saying so.