The role of an Ad Campaign Reporting Assistant at Magic
About the Client
A digital media and marketing agency that connects brands to Christian audiences through advertising, content partnerships, event engagement, and social/digital marketing. They run ad placements, curate content and grow audiences across faith-based sites and channels. The agency supports advertisers and partners seeking to engage consumers and leaders in the faith-based market.
Why does this role exist?
We’re hiring a detail-oriented reporting specialist to turn campaign performance data into clear, client-ready reports and recommendations. The role exists to ensure every campaign has accurate, well-organized data, insightful interpretation, and a polished deliverable that guides the client’s next steps. This position supports timely delivery of campaign insights so clients can understand results and confidently book follow-up campaigns.
The Impact you’ll make
Campaign Data Collection & Verification
- Contact media outlets and partners to request campaign performance reports and confirm all required data is received.
- Track and follow up on missing or late reports; communicate issues promptly to the internal team.
Data Management & Excel Reporting
- Enter performance data into the provided Excel template accurately and consistently.
- Clean, organize, and format raw data to prepare it for analysis and reporting.
- Ensure final Excel files are complete, consistently labeled, and stored in organized folders.
Analysis & Client‑Facing Insights
- Create AI-assisted campaign analyses that translate ad data into clear, client‑friendly insights and recommendations.
- Summarize how well the campaign performed with an overall positive tone while gently noting any underperforming elements.
- Provide practical suggestions to improve future campaigns and end each report with a call to action to book the next campaign.
Report Design & Delivery
- Build simple, visually clear campaign reports using provided templates in Canva, PowerPoint, or Word.
- Export final reports to PDF and ensure both the PDF report and the accompanying Excel file are complete, properly labeled, and delivered to the client.
Administration & Tracking
- Maintain organized folders and tracking documents so campaign reports are easy to locate and reference.
- Communicate any missing data, delays, or issues promptly to the customer success and delivery teams.
Skills, Knowledge and Expertise
Required:
- Demonstrable experience producing ad campaign reports and client-facing campaign summaries.
- Strong written communication skills with proven ability to turn data into clear recommendations.
- Advanced Excel proficiency (templates, data cleaning, consistent formatting).
- Familiarity with Canva, PowerPoint, or Word for report design and PDF export.
- Availability to work 40 hours/week, PST hours with morning PST availability for training and an ASAP start
- WFH Set-Up:
- Computer with at least 8GB RAM, an Intel i5 core processor/AMD Ryzen 5 Processor and up.
- Internet speed of at least 40MBPS
- Headset with an extended mic that has noise cancellation and a webcam
- Back-up computer and internet connection
- Quiet, dedicated workspace at home
Your Superpowers:
- Advanced Excel (data entry, cleaning, formatting).
- Comfortable using Canva/PowerPoint/Word and exporting polished PDFs.
- Experience with basic analytics concepts and translating metrics to insights.
- Familiarity with AI tools for drafting analyses and summaries (prompting best practices). Soft skills / traits
- Exceptional written communication and client-facing tone.
- Strong attention to detail and data accuracy.
- Proactive follow-up and good stakeholder communication.
- Positive, solutions-focused mindset and ability to gently surface issues.
You should apply if…
- You enjoy turning messy campaign data into polished, actionable client deliverables.
- You’re client-first, responsive, and comfortable communicating delays or missing data clearly.
- You can work independently, manage 40 hours/week, and thrive in a fast turnaround environment.
- You’re respectful and aligned with working on faith‑based marketing campaigns.
What to expect…
Work Setup:
- Remote position
- Must have a reliable internet connection and a quiet workspace
- Required to provide own computer with Intel Core i5 or something similar or higher operating system
Working Hours:
- 40 hours per week
- Flexible, 8hrs/day, Pacific Time hours. Training will be morning Pacific Time hours
Compensation:
- $7 per hour
- No benefits package included
To learn more about Magic visit their website
Please let Magic know you found this job position on Remote Career Africa as a way to support us to continue providing you with quality remote jobs
Always read and understand the full job requirements before you apply
