If you run a PPC agency, there is often a need for agency-level analyzing. If you are looking for a custom solution to this problem, this marketing agency dashboard service is for you. This solution is suitable to both ecommerce and lead generation agencies.
1. The system extracts and combines data from all data sources and accounts.
2. The fully automated data refresh enables real-time analysis and saves time.
3. You can see the data for all clients together or filter to a specific client. This helps the marketing team quickly identify clients that need attention and current agency issues.
4. Visualize all the data to make it easy to see the patterns and trends.
5. Users can use the dashboards to share updates with clients.
CONTACT US TO GET THIS SOLUTION
Here is Kris Sugatan, the CEO of the PPC agency Sugatan.io talking about how dashboards by Vidi helped her marketing agency to become data-driven:
We have experience working with top marketing agencies such as Neil Patel’s NP Digital and TubeScience. As a result, we frequently advise our clients on which types of analysis are most valuable in the industry.
The process for creating the dashboards is the following:
1. Extract data automatically from all the accounts and all the marketing sources. At Vidi we usually do this by using our own code which is the most cost-effective way for our clients long-term. Alternatively, we can help you select a third-party software to extract all the data automatically.
2. Combine the data together in a single dataset. Sometimes it is appropriate to do this in a database. Other times we extract data straight to Power BI/Looker Studio/Tableau.
3. Visualise this data in a dashboard. We will create a custom analysis for your marketing agency and present it in a user-friendly format.
4. Create a client filter for you so that you can view data by client or for the whole agency.
5. Optionally we would enable external sharing so that every client can see the data only for themselves.
CONTACT US TO GET THIS SOLUTION
At the end of our project you will get:
1. Automated data extraction flow from all the data sources and accounts
2. A visually-appealing dashboard in Looker Studio/Power BI/Tableau
3. Maintenance support from Vidi Corp
The best thing is, you will own all the technology at the end which gives you competitive advantage and keeps you flexible.
The client is a lead generation agency that runs PPC ads on Facebook and Google. They manage 10+ Google ads accounts and 5 Facebook accounts. All their lead data is gathered in a separate database. They wanted to automate their current reporting and replicate the same look and feel that they had.
Vidi Corp used Windsor.ai to extract data from Facebook and Google Ads together. After connecting these data sources to Windsor, the software generated a link that could be used for data extraction. The link detailed the needed account IDs and also all the columns which we needed for analysis.
The same process was followed for Facebook Ads
Finally, the lead data was extracted from a MySQL database
After extracting the data, we created a data model blending the data from all the data sources inside Power BI.
Finally, we visualised the data in Power BI. We utilised conditional formatting to demonstrate the days when the agency hit their marketing target and when the target was met.
This marketing agency runs one campaign per customer, so we used a campaign filter to filter data by client.
This case study is described in detail here
We used our own scripts to extract data from Facebook and Google Ads for our clients. Before we started working together they were spending $700 per month on Supermetrics to extract the data. We replaced Supermetrics using our own code which saved them many thousands of dollars over multiple years.
Our own code aggregated the data for 30+ Facebook Accounts into a single Big Query database.
We then visualised the data in a dashboard and created a client filter, enabling us to view data for individual clients.
