a. Plan, launch, and optimize Meta Ads campaigns across multiple objectives (brand awareness, lead generation, and conversions).
b. Monitor performance metrics like CTR, CPC, CPM, ROAS, and engagement rates and ensure continuous improvements.
c. Optimize bids, budgets, and ad creatives to ensure campaigns meet KPIs.
2. Excel based data analysis & reporting:
a. Analyse large datasets from multiple ad platforms (Meta Ads, Google Ads, etc.) using advanced Excel functions.
b. Create and maintain Pivot Tables, dashboards, and dynamic reports to monitor key campaign metrics.
c. Apply Power Query for data cleaning and transformation. Use IF, VLOOKUP, INDEXMATCH,SUMIFS, COUNTIFS for deep analysis of campaign performance.
3. Budget tracking & reconciliation:
a. Manage daily, weekly, and monthly budget tracking to ensure alignment with targets.
b. Identify discrepancies across platforms and reconcile budgets using Excel tools like SUMIFS and conditional formatting.
4. Data driven decision making & forecasting:
a. Use What if Analysis, Goal Seek, and FORECAST functions to predict campaign performance and align strategies with business goals.
b. Provide insights on the effectiveness of campaigns, recommend adjustments, and forecast future outcomes based on historical data trends. Ad
5. Platform insights and strategy:
a. Stay updated with the latest Meta Ads features, policies, and trends to leverage new opportunities.
b. Develop and execute A/B tests to identify high performing creatives and strategies.
6. Collaboration and stakeholder communication:
a. Work closely with cross functional teams to ensure consistent messaging and alignment with business objectives.
b. Provide detailed reports and insights to stakeholders, explaining performance trends, optimizations, and ROI.
