Project details
Recommended projects
Adobe Experience Cloud Consultant (m/f/d)
Business Analyst – SAP S/4HANA Output Management (f/m/d)
CRM Manager (m/w/d)
AI Consultants - Data Science (m/w/d)
Data Engineer (m/f/d)
AI Consultant for Vibe Coding (m/w/d)
AI Evaluation Consultant (m/w/d)
Senior Project Manager Customer Interaction
Freelance Statistics Expert with Python Experience (m/f/d)
Fullstack Data Platform Developer & Architect (m/f/d)
ERP-Transformation Manager (m/w/d)
Freelance Editor (m/f/d)
Interim Chief Transformation Officer (m/f/d)
Chemist with Python Experience (m/w/d)
Freelance Biology Expert for AI Model Training (m/f/d)
Freelance Chemistry Expert for AI Model Training (m/f/d)
AI Agent Evaluation Analyst (m/w/d)
Account Manager B2B for a media company (m/f/d)
Physicist with Python Experience (m/w/d)
Freelance Civil Engineer with Python Experience (m/f/d)
AI Consultant - Machine Learning (m/w/d)
MCP & Tools Python Developer (m/w/d)
Evaluation Scenario Writer (m/w/d)
Interim Buyer (m/f/d)
Commissioning & Qualification (C&Q) Engineer (m/f/d)
Quality Compliance Auditor (GCP/GCLP/GVP) (M/W/D)
Senior Regulatory Compliance Expert (FDA Inspection Preparation) (m/f/d)
Senior Factor 10 Developer (IPS / IPM) (m/f/d)
Construction & Contractor Safety Specialist (SiGeKo) (M/f/d)
EHS Specialist – Cell Manufacturing
Frontend developer to HR platform with Angular experience
Time's up! We are no longer accepting applications.
Consulting in the area of reporting for X-Sell, Development & Retention
Project info
- Period01.08.2024 - 31.12.2024
- Capacityfrom 90%
- Daily rate750 - 850€
- LocationKarlsruhe, Germany
- Languages Essential:
- German(Advanced)
Desirable:- English(Advanced)
- German
- Remotefrom 99%
Description
Building daily up-to-date reports to control existing customer marketing (X-Sell, Development & Retention) across online channels (Control-Center App & Web).
When steering sales measures for existing customers in the online channel (Control-Center App & Web), new standard reports are introduced to measure the efficiency and accuracy of existing and new measures promptly and continuously. The sales success of these measures is reflected in all business transactions in the existing customer business (X-Sell, Development & Retention) and all products. Depending on the use case, specialized reports and KPIs must be created.
As part of this assignment, the following reports will be created:
Cross-channel: Daily Active Users in the channel including conversion rate in all business cases Here, the number of active customers who have been targeted for sales outreach is to be measured, as well as their shares in company-relevant segmentations (by product ownership, cancellation status, online activity, customer age). Furthermore, the conversion rate of sales successes is determined per active customer to assess and optimize the effectiveness of the outreach. This report is provided for a weekly steering committee with board participation.
X-Sell: Campaign/offer performance compared to plan, as well as concrete prioritization of offer deployment A standard report should be created for precise control of X-Sell campaigns in all products, starting with Small Screen. As technical input, a quantitative plan number per campaign or deployment will be provided and attributed as precisely as possible to actual orders to accurately control the performance of individual campaigns.
Development & Retention: For these business cases, a standard report should be created that, based on customer page movements in the existing customer shop, makes daily traffic, funnel depth, and final conversion evaluable across products.
How should the service be delivered?
The final reports should be provided in PowerBI on the client's reporting server and designed for regular and interactive use. Content relevant for steering committees should be offered in an easily exportable format in PowerPoint or Excel.
Data supply for the reports should be pulled via SQL queries from the central Data Warehouse (SQL Server). Prototype SQL queries already exist for most requested reports; these must be technically and functionally reviewed and optimized during the project phase in consultation with internal experts, and implemented (including in-code documentation) as regularly maintained queries. Data supply for page movements and funnels (especially in the BK funnel) comes from another, non-compatible data source, Adobe Analytics.
Beyond the above documentation, a documentation should be provided in the team's Confluence area that documents report usage for end users and exposes adjustment options and references to the data used for report maintainers.
Requirements
Where can the service be delivered from: The location can be freely chosen by the external resource; it can be remote or at the project site 76135 Karlsruhe, Hinterm Hauptbahnhof 3. For the first project phase of approx. 3 weeks, presence on site in Karlsruhe (Tuesday–Thursday) is strongly desired.
Required profile:
- Data Analyst or Data Scientist with practical understanding of online marketing and preferably telecom experience
MUST:
- SQL
- PowerBI
- Basic statistical knowledge
- Technical understanding of online platforms and telecommunications topics
Nice to have:
- Adobe Analytics
- Ad server
- Creation of standard online reports for channel control