Facebook ads, google adwords and Google Analytics integration
I am working on a project for a digital ad agency. Am developping tool is a web platform that aims to monitor the marketing campaigns of an agency and its clients on facebook and adwords. I pull data from facebook ad profile API and Adwords API using cron jobs, structure it, and save it for analysis and visualization in an interactive dashboard. I will also integrate Google Analytics data to understand how advertising costs affect customer interactions on the website. I wonder if I need a data store in my case, or is a relationship database sufficient?
source to share
Can't say anything to the AdWords API. But for Facebook Ads Insights. In fact, a relational database like mysql is used quite often. But I have no information about your usage pattern. I suggest you take a look at your access pattern and QPS to reverse performance and scale to design for the infrastructure you need.
source to share