Consulting in the area of reporting for X-Sell, Development & Retention

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.

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