Ruben LozanoFractional Marketer
    ES
    Accenture Interactive logo

    Digital Marketing Analyst at Accenture Interactive

    In-client working to create KPI reports and dashboards for marketing and business teams at one of the world's leading consulting firms.

    Feb 2019 – Aug 2019
    Full-time
    On-site · Barcelona, Spain

    The Company

    What is Accenture Interactive?

    Accenture Interactive (now Accenture Song) is the world's largest digital agency and part of Accenture. It helps brands transform their customer experiences through strategy, technology, and creative services.

    Visit Accenture Interactive

    North Star Metric (NSM)

    My Objective

    Working embedded within a client's marketing team, the objective was to build comprehensive analytics dashboards and KPI reports that enabled data-driven decision making. This involved collecting data from multiple sources, building automated reports, and training teams on how to interpret and act on the data.

    NSM: Dashboard Adoption & Data Accuracy

    Optimised Metrics

    Results

    12
    Reports Automated
    8
    Data Sources Integrated
    60%
    Reporting Time Saved
    25+
    Dashboard Users
    40+
    KPIs Tracked

    Execution

    Tasks & Responsibilities

    Tasks

    1. 1Build and maintain marketing performance dashboards using Google Data Studio and Power BI.
    2. 2Integrate data from multiple marketing platforms into unified reporting views.
    3. 3Create automated weekly and monthly KPI reports for marketing and business stakeholders.
    4. 4Train client teams on dashboard usage and data interpretation.

    Responsibilities

    1. 1Responsible for the design and delivery of marketing analytics dashboards.
    2. 2Responsible for data accuracy and reporting consistency across all platforms.
    3. 3Responsible for stakeholder communication and report presentation.

    Transparency

    Successes & Failures

    Successes

    • Automated 12 recurring reports, saving 60% of manual reporting time.
    • Integrated 8 different data sources into unified dashboards.
    • Trained 25+ team members on data-driven marketing decision making.

    Failures

    • Some data integration challenges due to legacy systems and inconsistent naming conventions.

    Marketing Areas

    Areas at Accenture Interactive

    Analytics & Reporting

    Building dashboards and automated reports from multiple marketing data sources.

    Data Integration

    Connecting platforms like Google Ads, Facebook, CRM, and web analytics into unified views.

    Stakeholder Management

    Presenting insights to marketing and business teams, training on dashboard usage.

    Marketing Technology Stack

    Tools at Accenture Interactive

    Google Data Studio
    Power BI
    Google Analytics
    Google Ads
    Facebook Ads
    Excel
    SQL
    Salesforce

    Testimonial

    Feedback from Accenture Interactive

    "Ruben brought clarity to our marketing data. His dashboards became the single source of truth for our team's performance discussions."
    Client Engagement Lead
    Accenture Interactive

    Time Commitment

    Time at Accenture Interactive

    Full-time on-site role embedded within a client's marketing team at their offices in Barcelona. Daily standups and weekly reporting cadence.

    5
    Hours worked
    4
    Meetings
    3
    Areas applied

    Need help with your Startup's performance?

    Let's schedule a time to talk about your project. Tell me about your goals and I'll share what I've done at previous startups.

    Let's Connect
    Back to Work Experience

    Stay in the loop

    Get growth marketing insights, new articles, and resources delivered to your inbox. No spam, unsubscribe anytime.