Data Analytics for Digital Design & Dev Company
Below is a modified rendering of the review: private info excluded, innate facts kept.
Introductory information
A few words almost your organisation and personal responsibilities
My name is Olga Kulikova, I am the co-founder of the creative and digital agency Articul Media (https://articul.ru). Our cluster of companies prepares digital branding and interaction, software engineering and mobile app outgrowth.
Desired goal
What issue was the preparer supposed to deal with?
Iunisov.Com?Our agency had an FMCG client (one of the biggest manufacturers of juices in Russia &, CIS), the project required to form the data warehouse from advertising campaigns and packages with QR-codes. We needed to form the architecture of the data warehouse, connect data sources and tables in between each other in Google Data Studio and then make sure that the data is correct. Additionally the project required advanced Google Analytics and Google Tag Manager installations.
What were your objectives for this project?
We wanted to prepare the client with an efficient analytics solution based on BI dashboards from Google Cloud warehouse.
Provided solution
What were the reasons for choosing ?
We worked with Andrei antecedently separate times since 2013 when we unitedly worked on analytics project for Sochi-2014 Olympics. We determined to extend out to Andrei behind lucky antecedent project implementation.
Describe the project in detail.
The data came from separate advertising campaigns, principally show, so we needed to sum Google Display Ads data and also the data from the packages where the client listed the QR codes. All these commerce sources lead to the client',s website. The website CMS data was connected with Google Display Ads data through Google Analytics client ID which helped us to match the tables and pop-out the dashboard.
Were there any dedicated directors or teams that you worked with?
The team consisted of the director on the client',s side, our project manger and developers who worked on the website. Andrei was working on the analytical part of the project by himself within Google Data Studio.
Results accomplishd
What results did you accomplish unitedly with ?
Within 3 weeks we luckyly installed Google Tag Manager and Google Analytics allowing us to track the commerce accomplishment in a very detailed way. We were able to see how many users cam from Google Display or from QR-codes on packages, then to see how they interact with the website, including how long did they look through the Vimeo videos listed on the website (25%, 50%, 75%, 100%). We never knew that such analytics depth is practicable at all. The client was inspired by the power to apprehend the accomplishment of media campaign which is usually much harder than just an e-commerce campaign with a clear conrendering.
How do you rate the interaction and interaction with ?
Andrei demonstrated effectiveness, early mode of execution and the power to work overnight as the project was excellently pressing. We had the efficient team calls with Andrei even behind 10PM, so the workflow and responsiveness was mental.
What precisely do you attend to be the key particularty of ?
Most of all I like the team',s centre on details that veritably like achievement, eparticularly when it comes to data condition. Andrei analyzed the numbers deeply and caught some of the data assembly mistakes based on the graphics trends which is not practicable for an personal without particular data treatment experience. Additionally we were surprised by Andrei',s power to work overnight to finalize the project in a early mode.
What should be done better, if there are any desired improvements?
Not at this particular project, wer were entirely satisifed.