Closed

Build SEM Dashboard using Facebook API, Google adwords API and Google Analytics API

This project is one of a three steps project.

We are a small online advertising agency and we want to build a web SEM dashboard that shows a high level view to all of our Facebook ad accounts and Google adwords accounts.

The SEM dashboard pulls Facebook ad account data, Google AdWords account data and Google Analytics account data using API.

Main dashboard page:

A list of google accounts and Facebook accounts ordered in one table.

15 Columns:

1. platform (Facebook icon / Google icon)

2. account name

3. account monthly budget

4. account spent (by the date range)

5. account expected spent (calculated by a simple formula)

6. account expected spent in percentage

7. account KPI-1 (transactions / leads / app installs/ registrations / etc)

8. account KPI-2 (transactions / leads / app installs/ registrations / etc)

9. account KPI-3 (transactions / leads / app installs/ registrations / etc)

10. cost per KPI -1

11. cost per KPI -2

12. cost per KPI -3

13. Account expected KPI-1 (calculated by a simple formula)

14. Account expected KPI-2 (calculated by a simple formula)

15. Account expected KPI-3 (calculated by a simple formula)

Campaign View:

When you click on one of the accounts in the list (Facebook account or Google account), the next page is all campaigns of a chosen account.

The KPI's are the same as in the main dashboard page

You are able to unmark campaigns if you don’t want to include its data, which also affects the main dashboard view

Technical Requirements:

- We need to be able to choose the accounts we want to show on the main page dashboard (there is a lot of inactive accounts we dont want to include)

- We also need to be able to associate a specific Facebook ad account with a specific google AdWords account and merge them together in the main dashboard view. (most of our clients have both a Facebook ad account and a Google ad account)

- When we merge Facebook account with a Google account, a new row is being added with a summary of the two rows (also in the main dashboard view)

- We need to be able to reorder the accounts on the list. (drag and drop)

- The KPI's columns pulls the data from a specific Facebook ad account goal or from a specific Google AdWrod goal or a specific Google Analytics goal. (when we click on the KPI in a specific account row a drop down menu is open with the 3 options above, then when we choose one of them a list of goals is shown) Each account in each row has its own goals (KPI's), and we need to be able to choose a goal (KPI) from all three platforms to each account in each row.

- The system must be always updated with the most updates data, if a change is being made in a Facebook ad account or in a Google ad account we need to see it in our dashboard.

if you have any question please dont hesitate to ask

Thanks

Skills: Graphic Design, HTML, PHP, Website Design

See more: google analytics track facebook connect users, google analytics twitter facebook, google adwords analytics set, google analytics track facebook connect, sem adwords analytics, google analytics traffic facebook, create dashboard google analytics, google analytics build dashboard, dashboard google analytics, custom dashboard google analytics, kpi dashboard google analytics, excel dashboard google analytics, using animated gif google adwords, drupal easy website build, alibaba website build, vbnet build gps using google maps, handicapping website build service design, joomla commerce website build, full website build, copy exitsing website build site, drag drop website build bracelet, teacher rating website build, bid website build, common questions freelance website build, website build bid

About the Employer:
( 3 reviews ) Tel Aviv, Israel

Project ID: #11798244

15 freelancers are bidding on average $850 for this job

meet2amitvw

Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. You can also c More

$1030 USD in 10 days
(148 Reviews)
9.1
phpdevindia

Hello, We do have the experience of Facebook & Google ads API and thus I am assisting you. The dashboard will basically compile all the analytics data from facebook and Google Ad manager and campaign of your site, B More

$2000 USD in 28 days
(197 Reviews)
7.9
getwebsolutionsl

Hello, We have gone through your requirement and are confident that we can successfully execute the project within the timeline. We are an established Web Design, Web Development & Mobile Apps Development Company ha More

$888 USD in 21 days
(56 Reviews)
7.0
Shopify

************************ CRM/ ERP / DASHBOARDS / HRM ************************************* Hello, Our expertise on developing CRM/ERP/Dashboard/HRM through different Software Platforms like ZOHO , ODOO, VTiger More

$773 USD in 10 days
(16 Reviews)
6.8
SevenStarInfo

Hello, We are happy to discuss our proposal with you. KEY POINTS THAT MAKE US DIFFER FROM OTHERS: ~ We have 5+ years of experiences in Unity 3D, Xcode, CoCoa 2d, Phonegap and major iOS and Android developement. ~ More

$1000 USD in 10 days
(70 Reviews)
7.1
eagleblackdesign

Hello! We are a professional team of php/mysql/js/html developers. We have huge experience in creating apps and scripts from scratch or modifying existing ones. We are available and will be happy to help you with the More

$840 USD in 14 days
(35 Reviews)
6.7
Projectssss

Hi, I'm interested in your project. I have few questions, Can u please Start chat Box Now to discuss Questions ?

$616 USD in 10 days
(39 Reviews)
6.0
luminous15

Hello There I think I can help you out to achieve this task but definitely need more details. It would be really helpful if you could explain details about each column required so that we can check whether the data y More

$1000 USD in 45 days
(45 Reviews)
5.9
RubyOnRail

Hi,I have gone through your project description. I could be confident if we can proceed towards more discussion. I am an individual developer and you will be working directly with me if we proceed work on this project More

$555 USD in 10 days
(5 Reviews)
5.5
xielessupport

I'm David from Xieles Support. I'm have done many server setup which includes web service, mail service, DNS service. I'm an experts in Level-3 Server Administration and Server Security Hardening. Xieles Support has More

$497 USD in 14 days
(19 Reviews)
5.3
akshayKelotra123

Hi I am well versed and having experience of 5+ years as Wordpress developer/designer. I believe that we can make a healthy relationship by working together. I have scored 1st place in WordPress test on Upwork. More

$555 USD in 3 days
(2 Reviews)
3.7
arun01012016

Hello there, I completely fit into the requirements you have framed for the designer. Hence, it would be great if you can open a line of communication so that I can analyze and share some mockup designs which will h More

$555 USD in 10 days
(18 Reviews)
3.7
dilshadbukhari

I have experience in PHP programming and well versed in open-sources / Framework like codenigter, opencart, Wordpress and other Web solutions . My strengths are web development, php, ajax, css, html , Web Service etc More

$250 USD in 10 days
(9 Reviews)
3.3
honghas

Hello, I am Annie I am working for DSP company (which you can go to its website : [url removed, login to view]) I have done a quite similar dashboard and you can see its picture via this link : [url removed, login to view] More

$1500 USD in 10 days
(1 Review)
3.1
AleenaIlyas

Hello I have read what you exactly need. I would like to ask you a few questions. Please feel free to contact me anytime so we can have a detailed discussion and finalize our budget and timeline. I will deliver in best More

$555 USD in 10 days
(2 Reviews)
2.0
globalbwsindia

We are 1000+ employees in our company. So we can do any kind of project based on all languages and all stream. We have 3 years+ experience employees for all stream especially C Programming, C++,C#, , Html,Html5,Wordpr More

$672 USD in 6 days
(2 Reviews)
0.4
viramgama

Hello SIR!! How Are You! I am Excited to share with you the proposal for the build SEM dashboard. I have lot of experience in Joomla, WordPress, PHP, Magento, Javascript,HTML5,bootstrap css. I have lot o More

$250 USD in 30 days
(0 Reviews)
0.0
semsolutionsAB

One of the reputable company of the Skåne region in Sweden SEM solutions AB is here to help you grow. We have gone through the details regarding development online advertising agency website along with the features More

$750 USD in 30 days
(0 Reviews)
0.0