Project Audio
The Challenge
This project outline was to help the client startup audio advertising platform. They also required help with the setup and analytics of some campaigns.
ADOPSTAR'S RESPONSE
The client wanted to startup a personalised audio advertising platform but none of the solutions fit what they wanted to do so decided to create their own. This is where Adopstar first came in to help.
Adopstar has been in the advertising industry since 2010 and the director had a lot more time under his belt, with all this knowledge we went to the client as a consultant to give our expertise on how an ad server should work. There are lots of ad servers out there and each one has its pros and cons so the idea was to take as many of the pros as we could and not take any of the cons, as well as this we tried to add an element of uniqueness to the platform. Eventually the platform was finished as they were able to start using it to traffic audio campaigns.
Once the platform was working and our client had clients, we were asked if we could help them with campaign management, analytics and to be a first point of call for technical questions before going to the engineering team. At first this was a new challenge as we have not done audio advertising before but with time we learnt how everything worked.
Once we were up to speed with how the platform worked and how audio advertising worked in general we were able to start helping out more, one of the first things we did was build a dashboard in google sheets to keep an eye on the campaigns, for one region this was relatively easy to do as we used Excel formula to pull campaigns from a data dump tab then we could go through all the campaigns, update all the numbers and make sure the campaigns was running smoothly.
For the other region this was not so easy as we were unable to pull the campaigns to be able to do a data dump. To get over this hurdle we asked for access to the platform’s API. With access to the API we were able to write a google app script to pull the campaigns out of the API and put them into a google sheet, the script also did a bit of tidying to make it look a bit neater and once that was done we were able to follow the same process as the first region updating the numbers and make sure everything was good.
the result
After building the campaign management documents we were asked to do more dashboards for other things they were doing, like a dashboard to keep an eye on a specific campaign as we needed to make sure the campaign did not under deliver on specific personalised sections.
We also have access to a SQL Database that has the last 30 days worth of data in it, the main use of this is to take a deep dive into the campaigns if there are any issues before sending it over to the engineering team. For example, we can check to see what data is being passed in the tag this can help when looking into why a specific personalised section of the script has not delivered.
From this work we have learnt a lot about how personalised audio advertising works and have picked up many new skills we can use in the future.
For more information or to find out what we can do for you, email:[email protected]
