Journey Further is a performance marketing agency aiming to bring clarity at speed to their customers. As a data-driven business with a strong open ethos, ensuring that their customers are offered an instant, transparent, and accurate view of their activity whenever they want it is a top priority.
As a result of working with Funnel, they’ve been able to streamline their reporting and analysis processes, aggregating the performance of thousands of their campaigns in one simple solution.
With hundreds of thousands of campaigns across a whole range of different advertising and commercial platforms, Journey Further has an incredible amount of data that they need to centralise and categorise so that it’s presentable and can answer key business questions for their clients & analysts.
They were previously using a range of different third-party connectors that transferred the data to Google Sheets where it was joined with lookup after lookup, causing a lot of manual work and headache. The data was messy and it took several lookup functions just to get the basics of cost, clicks, impressions, campaigns and traffic sources.
It was then finally ready to be sent to Google Data Studio.
There was also the issue with the amount of data (millions of lines of data each day). Their solution worked ok until it reached a point where the data volumes were causing some of the exports to fail, and that left the Marketing Analysts on the Journey Further team and their clients with more questions rather than answers.
“With Funnel, I can connect a marketing platform, export and analyze the data, and start creating reports within 30 minutes.”
Check out Harry’s article on how they utilise Funnel
With Funnel, they have been able to create a more scalable and reliable solution that makes it easier for them to onboard new clients, quickly.
They’ve created their own business logic with a number of standard custom dimensions and metrics which allow them to automate the creation of Business-Ready Data for their reporting. Each time a new client is signed, they are able to use these pre-created metrics and dimensions to automatically generate the fields they need.
And with the needed fields already created and the data already mapped, they can quickly send the data into a number of dashboards and reporting templates they have built out in Google Data Studio that help answer key business questions.
Journey Further’s reporting stack's marketing reporting stack
By integrating Funnel, Journey Further is now able to import all of their data sources - including a range of bespoke connectors that Funnel has developed for them - into a single location that can process, and join it all together before it’s exported as a single source to both Google Sheets and Google Data Studio.
They are able to focus more on working with their clients to optimize their marketing performance rather than worrying about how to just get the data in the first place. And as a data-driven agency with transparency and speed as top priorities, this is key to success.
Depending on who they are speaking to within their clients’ organizations, and even internally, different reports are needed for different stakeholders. The Directors and Managers like a bird’s eye view of the data, Channel Managers want to dig a bit deeper and see how their particular area is performing, and Data Analysts want it all so they can create any query of their liking.
Funnel allows the Journey Further team to provide each member of the organization with the report type they need in the format or platform they need.