Aggregation of Data Sources in Adloop
What’s the point of Aggregating Data Sources?
You know if you’ve ever tried to manage marketing campaigns on different platforms: it can be tedious to gather all the data from sources such as Google Analytics, Facebook Ads and others, the performance marketing agencies are looking for is hard to reach.
This step is extremely time-consuming when done manually, and you could do without it and focus on data analysis instead. Clutch shows in a study conducted in 2016 that companies rely on multi-channel campaigns, with an average of 8 marketing channels.
Data aggregation is the basis without which the analytical process could not take place. It must be done, and done well. Fortunately, there are now solutions like Adloop that allow you to automate data unification across multiple marketing channels in a few clicks, saving hours of precious time.
What is Data Sources Aggregation?
Data aggregation is the process of connecting all marketing data in a central repository, where the information retrieved can be efficiently processed, analyzed, and compared.
Aggregated marketing data is usually classified into 3 categories:
- Advertising Platforms that provide data that is generally called Ad-Centric: impressions, clicks, delivery costs, ad names, and campaign types.
- Analytics tools that feed the platform with user behavior data on your sites and apps (Site-Centric data): page views, add to cart, account creation, purchase, the origin of visits etc.
- CRM or transactional applications, are used to identify customers or prospects, communicate with them, find out what they have bought, etc. This is User-Centric data.
Centralizing the data of a campaign with various sources serves to develop the ability to analyze how the product offer is received across different channels and intended targets over time.
This unification is a pillar of marketing analytics, as mentioned in the introduction, but when done manually, it can quickly become difficult due to the amount of information to manage & process.
Benefits of Data aggregation
Automated data aggregation is very advantageous and the total cost of ownership of data aggregation services has dramatically reduced because of platforms like Adloop.
First, data aggregation saves time, by connecting to one centralized place instead of connecting to N number of different platforms separately.
All your data in one place makes it easier to analyze the data and improves the quality of your reporting in a very short time period.
Once unified, the data can be exported directly, whether to Excel, dataviz or datamarts for example.
Finally, the aggregation of data offers gains in efficiency and productivity, as it allows us to see things that could not be observed in an advertising platform like Youtube Ads for instance. Marketers have invested too much energy in unifying all their data in one place manually, with the added risk of error. That time is over! Finally, a platform like Adloop makes it possible in a few clicks to collect data from different sources thanks to the many data connectors it has.
How to gather your data in Adloop?
Everything is managed in a Data Sources section.
It is very easy to add a data source in Adloop, just click on the “add” button, and within a few clicks you’ve added your first data source. These data connectors are divided into categories but it is also possible to search for them by name. If you cannot find one you’re looking for let us know.
Each data source uses a specific connection mode among 3 main modes:
- Oauth: connection delegation system. Adloop inherits read permission on data from an account you have rights on.
- API: you will be asked to enter an API key that you will have retrieved from the ad platform itself or from your account manager.
- Login/Password: Simply the login and password of an Adloop user that you have created in the ad platform.
Choice of dimensions and metrics
Once the connection is established, you must choose the dimensions and metrics to be retrieved from the data source. The default dimensions or metrics will be imported no matter what because they are the main elements, it is not possible to delete them.
The other dimensions and metrics are selectable if you need them.
Imported period or import frequency
Adloop imports 1 year of data when a data source is added.
Once added, the data is refreshed every 3 hours, or 8 times a day.
Security and Privacy
Adloop respects the General Data Protection Regulation (GDPR), more information here.