Collect, organize, maintain, and analyze data related to advertising campaigns, clients, projects, and internal operations.
Prepare daily, weekly, and monthly MIS reports, dashboards, and performance summaries for management and clients.
Track campaign performance, including budgets, deliverables, timelines, reach, engagement, leads, and other relevant KPIs.
Consolidate data from different sources and ensure accuracy, consistency, and timely reporting.
Monitor project and campaign progress and highlight delays, discrepancies, or performance gaps to the concerned team.
Coordinate with Creative, Digital Marketing, Media, Accounts, and Client Servicing teams to collect required information.
Maintain databases of clients, campaigns, vendors, media activities, and project-related information.
Prepare client-wise and campaign-wise reports based on management requirements.
Assist management in identifying trends, performance insights, and areas for improvement through data analysis.
Develop and maintain Excel/Google Sheets dashboards, trackers, and reporting templates.
Ensure proper documentation and organized record-keeping of MIS-related information.
Support the team with ad-hoc data analysis and reports whenever required.
Maintain confidentiality and integrity of business and client data.
Specification:
Bachelor’s degree in Business Administration, Management, Information Management, Statistics, Computer Applications, or a related field.
1–2 years of experience in MIS, reporting, data management, business operations, or a similar role; experience in an advertising/digital marketing agency is an advantage.
Strong proficiency in MS Excel/Google Sheets, including formulas, Pivot Tables, VLOOKUP/XLOOKUP, charts, and data cleaning.
Knowledge of Power BI or other data visualization/reporting tools is an advantage.
Basic understanding of digital marketing and advertising metrics such as impressions, reach, engagement, CTR, leads, conversions, and campaign budgets.
Strong analytical and problem-solving skills.
Excellent attention to detail and data accuracy.
Good communication and coordination skills.
Ability to manage multiple reports and deadlines in a fast-paced agency environment.
Proactive, organized, and capable of working independently. Preferred SkilExperience working with Meta Ads, Google Ads, social media analytics, or digital campaign reporting.
Knowledge of dashboards and data visualization.
Ability to present complex data in a simple and understandable format.
Good understanding of advertising agency workflows and campaign management.