Facebook Ads - Dashboard

Overview: A simple dashboard tool that has to capture data from Facebook ADS showing a GRID and GRAPH (prefer if we use fusioncharts or similar) The tool must capture data 3x a day and store it in my DB, the main funcionalities are: - Facebook Connect to user account to gather data from ads; - Create graph (from fields coming from DB) - Create grid (from fields coming from DB) - Have user permission for admins and clients - Export PDF We will provide the layout, which will be very very simple. The DATABASE STRUCTURE HAS BEEN CREATED, prints in attachment. TECHNICAL DETAILS: 1) Technical Features A. Data capture on Facebook; B. MySQL database structure: - Dados_raw: Facebook data per day, facebook id; - Dados_agencia: id agency, name of agency, vendor, encouragement, bv, forwarding, commission; - Dados_cliente: id_facebook, customer name, segment, id_agencia. C. Robot to capture data three times a day. 2) Navigation - ADMIN A. Summary of Day and / or period with the following information: - Grid with columns: customer name, clicks, fans, cost per fan, conversion rate, revenue (money) , revenue (%) - Totalizers - Conditional formatting%: <= 19 red > = 20 and <= 29 yellow > = 30 and <= 49 Green > = 50 lime green - Chart with 2 axes, cumulative margin + margin% B. Market Analysis: - Average CPC segment - Average CPC General - CPF average segment - CPF overall average 3) Report - Customer A. Selecting Reports by campaign; [login to view URL] - Display a Campaign; - Display of Advertisements; C. Graphics - Graphic by day with two axes - Population Chart 4) Settings Panel - ADMIN A. Registration of the agency; B. Registration of client: - Name of client; - Facebook connect -> id client; - Associated agency. C. Configuration Dolar D. Create Report - Name of the report; - Insert the number of PI; - Month of the PI; - E-mail Client; - Columns to be used; - Chart 2 axes (fields); - Graphic demographic? (Yes or no, for more premium customers); - Field observations by the report; - Issue report.