Make.com + Zapier Automation Expert (Meta Ads Insights, WhatsApp/Call Tracking, Daily Email Report) - Contract to Hire
Description
We run video ads for Dush (construction chemicals). We need a specialist to build, harden, and document a Make.com automation that pulls Meta (Facebook/Instagram) Ads insights daily, computes messaging-CTA clicks / conversations started and Call button clicks, adds platform / age–gender / device breakdowns, and emails a clean KPI report. Must be robust—no API/breakdown errors.
All communication, access sharing, files, and payments will remain on Upwork. Access to our ad account will be granted after hire.
Scope & Deliverables
Make.com scenario (single flow):
Insights (Ad Set, last 1 day): spend, reach, impressions, frequency, inline_link_clicks, unique_inline_link_clicks, ctr, cpc, thruplays (or video_thruplay_watched_actions), video_p25/p50/p75/p95/p100, video_avg_time_watched_actions, actions, cost_per_action_type.
Set Variables (3x) from actions[]:
– Messaging-CTA clicks (e.g., “Send Message”)
– Conversations started (on-ad messaging)
– Call button clicks
Use safe mappers (coalesce / select / map / sum) so empty arrays never break.
Breakdown calls (exclude actions and all video_*):
– Publisher Platform (FB vs IG)
– Age + Gender
– Impression Device (Placement if available)
Email → HTML report with totals + snapshots, scheduled 08:00 IST daily.
Error handling: fallback “No delivery yesterday” email; avoid invalid breakdown combinations; handle 0-bundle days.
(Optional) Logging: Append daily metrics to a Google Sheet and provide a simple Looker Studio view.
Documentation & Handover: 1-page config (IDs, fields, formulas, limits), scenario export, and a short screen recording uploaded to the Upwork workspace.
Support: 7 days bug-fix after go-live.
Acceptance Criteria (binary)
Email contains: Spend, Reach, Impr, Freq, CTR, CPC, ThruPlays, P50/P75/P95/P100, Avg Watch (s), Messaging-CTA Clicks, Conversations Started, Call Clicks (per ad set or campaign total—agree upfront).
Publisher Platform section shows Clicks/CTR/Reach for FB & IG.
Age/Gender and Device sections list top rows with values.
Scenario does not fail due to breakdown/empty-array issues.
Works whether Meta returns thruplays or video_thruplay_watched_actions.
Must-Have Skills
Make.com (mappers, aggregators, error routes, scheduling).
Meta Ads Insights API (field vs breakdown compatibility, actions array).
Zapier basics (future extensions).
Clean HTML email templating; concise documentation.
Nice to Have
Experience with messaging-CTA tracking, UTMs, call-tracking numbers.
Looker Studio / Sheets automation.
Access (after hire)
Business Manager read-insights permissions, relevant Campaign/Ad Set IDs, report recipient email, and a Sheet (if logging).
Timeline & Budget
Build + test: 2 days.
Fixed price—submit your bid
Apply Now
Apply Now
We run video ads for Dush (construction chemicals). We need a specialist to build, harden, and document a Make.com automation that pulls Meta (Facebook/Instagram) Ads insights daily, computes messaging-CTA clicks / conversations started and Call button clicks, adds platform / age–gender / device breakdowns, and emails a clean KPI report. Must be robust—no API/breakdown errors.
All communication, access sharing, files, and payments will remain on Upwork. Access to our ad account will be granted after hire.
Scope & Deliverables
Make.com scenario (single flow):
Insights (Ad Set, last 1 day): spend, reach, impressions, frequency, inline_link_clicks, unique_inline_link_clicks, ctr, cpc, thruplays (or video_thruplay_watched_actions), video_p25/p50/p75/p95/p100, video_avg_time_watched_actions, actions, cost_per_action_type.
Set Variables (3x) from actions[]:
– Messaging-CTA clicks (e.g., “Send Message”)
– Conversations started (on-ad messaging)
– Call button clicks
Use safe mappers (coalesce / select / map / sum) so empty arrays never break.
Breakdown calls (exclude actions and all video_*):
– Publisher Platform (FB vs IG)
– Age + Gender
– Impression Device (Placement if available)
Email → HTML report with totals + snapshots, scheduled 08:00 IST daily.
Error handling: fallback “No delivery yesterday” email; avoid invalid breakdown combinations; handle 0-bundle days.
(Optional) Logging: Append daily metrics to a Google Sheet and provide a simple Looker Studio view.
Documentation & Handover: 1-page config (IDs, fields, formulas, limits), scenario export, and a short screen recording uploaded to the Upwork workspace.
Support: 7 days bug-fix after go-live.
Acceptance Criteria (binary)
Email contains: Spend, Reach, Impr, Freq, CTR, CPC, ThruPlays, P50/P75/P95/P100, Avg Watch (s), Messaging-CTA Clicks, Conversations Started, Call Clicks (per ad set or campaign total—agree upfront).
Publisher Platform section shows Clicks/CTR/Reach for FB & IG.
Age/Gender and Device sections list top rows with values.
Scenario does not fail due to breakdown/empty-array issues.
Works whether Meta returns thruplays or video_thruplay_watched_actions.
Must-Have Skills
Make.com (mappers, aggregators, error routes, scheduling).
Meta Ads Insights API (field vs breakdown compatibility, actions array).
Zapier basics (future extensions).
Clean HTML email templating; concise documentation.
Nice to Have
Experience with messaging-CTA tracking, UTMs, call-tracking numbers.
Looker Studio / Sheets automation.
Access (after hire)
Business Manager read-insights permissions, relevant Campaign/Ad Set IDs, report recipient email, and a Sheet (if logging).
Timeline & Budget
Build + test: 2 days.
Fixed price—submit your bid
Apply Now
Apply Now