Google Data Studio Dashboard Developer

We run a small marketing agency that specializes in the home service industry. We are looking for someone with past experience and the ability to create/organize a dashboard that uses APIs to pull live data from sources like facebook ads (primarily), google ads (secondary), google analytics, CRMs, and other web apps- to be used for analytics and reporting to clients . The immediate need is to be able visual trends in our facebook ad campaigns, for instance to compare one time period to another (week over week, month over month, etc) compare separate campaigns to each other. We'd also like to generate key performance indicators calculated using a combination of data from the advertising platform and CRM. Together this information will be used to monitor the performance of advertising campaigns, run A/B tests, identify issues, and quickly make informed decisions on ad spend.

The dashboard will need to be setup for a number of clients (with unique data sources), and we'd like to expand it beyond just facebook ads. It needs to perform a similar function for other ad platforms (google, homeadvisor, linkedin), and other processes like SEO/organic traffic, in person sales and calls (data tracked through CRM),. We'd like to have a clean interface where conditions can easily be applied to filter the data, or select multiples data sets to compare, ideally in one screen. Once this is complete, the dashboard should be setup so we can quickly add basic formulas to calculate and output KPIs using calculate , both in a graph (over time) or a table to compare- many of these are very simple to calculate, but we want to be able to apply filters to quickly generate them without having to go find the data. A simple example would be specifying a start and end date, and specific ad campaign, then outputting a table with the weekly appointment booking rates across said time period.

Another key feature of the dashboard will be the ability to add new data sources. We regularly get new clients, and add or remove ad platforms, start new campaigns, etc- the dashboard must be easy to expand for new inputs. Its crucial that we can share the visuals as well with our clients, so we'll need the ability to restrict access to certain data sources using login info, or several duplicates of the dashboard that only have specific portions of the data. The latter may be ideal so we can brand the interface for a given client. That being said a master version with all clients and data sources is a must.

Sometimes we will need to share the data with people who will not have regular access, and would like the ability to quickly output filtered graphs/tables/KPIs by email or download. Ideally even a place to enter contact info (email) and automatically send out specific reports once its been previewed within the dashboard.

Below is a list of the features mentioned above that we would ultimately like to have:

-Plug in data from a variety of sources into organized sheets/tab to continually collect raw data

-Data will include things like: conversions, clicks, source, spend, revenue, time, etc.

-Graph and analyze different ad campaign (or traffic, calls, sales, etc.) performance over time

-VIsually compare multiple campaigns, or results, within one platform, or one platform to another in, one data type to another

-Program an interface to filter data for certain conditions to identify trends, success/failure rate, issues etc

-Calculate KPI's using relationships between the incoming data given selected inputs (data source, time period, specific KPI desired)- simple examples would be: appointment booking rates, cost per sale, average time from lead to sale, net return on ad spend, etc.

- Set up the system in a way where new data sources (new clients, new platform or result to track for existing clients) can easily be added into the database/dashboard

- Automate reports (graphs, tables) using the data to send out by email, and interface to manually send out the same ( possibly a form where you can type email addresses and select desired reports then click "generate")

- Assign permissions / restrict access to selected data sources, or created duplicate dashboards with segments of the data, so one clients could look at their data and not others


This is obviously an ongoing project and we'd focus on the key features first, then add on more as they are available. We will likely find new applications and features, and want to continually improve the design, as we use the dashboard more and more, so the work goes beyond the initial setup. We understand this is a tall list of features and we will need some help planning out the functionality, so good communication is a MUST. If you are interested, please provide a resume or list of experience relevant to the dashboard creation above, and links or screenshots of example if possible.

We are open to both full and part time applicants. There is plenty of other administrative tasks we are hiring for too, especially in google workspace and basic accounting- if you would like to work with us full time please provide any other relevant experience you have or tasks you are skilled at. There is a list of proficiencies that are required as well below, though these should be pretty standard for anyone experienced in building dashboards and working remote. Interviews will be conducted via zoom this week.

All applicants should be proficient in:
-Project Management Tools (Trello)
-Organization & Communication (Email, Slack, Google Drive)
-Google workspace (sheets, docs, drawings)
-basic understanding of digital marketing practices (social media, ads, SEO, etc)
-Internet research (google/youtube)
-Ability to honestly track time, and speak up when there is issues

Thanks for applying,

Conner
Bulletproof FX