Business Intelligence Freelance Jobs

Hello,

We are a travel meta search website (airbarato.com) and we are looking to create a marketing reports that compares media spend vs revenue that compares multiple data sources to build a few reports views. This can be built in any of the main cheap and automated platforms like Klipfolio, Datahero, DataBox or similar that are $100 or less a month. We do not want this to be a custom build.


Data Sources:
    Media Spend Sources:
        - Google Adwords
        - Facebook Ads

    Revenue Sources:
        - Google Analytics Custom Event * $ per event
        - Google Double Click Ad Exchange Revenue
        - Custom CSV (intentmedia)

We are looking to have the following reports built.

Total By Day (below are the columns):
    - Date
    - Google Adwords Spend
    - Facebook Ad Account Spend
    - Total Media Spend (Sum of the above)
    - Custom Event Revenue (Google Analytics Custom Event * $ per event)
    - Google Double Click Ad Exchange Revenue
    - Intent Media (Custom CSV that can either be manually uploaded daily or even better pulled automatically from a google spreadsheet)
    - Total Revenue (Sum of the above)
    - Total Profit (Total Revenue - Media Spend)
    - Profit Margin (Profit / Total Media Spend - it is the only one that is a %, all the others are $)

Total By Day By Country (below are the columns)
    - Date
    - Country
    - Google Adwords Spend
    - Facebook Ad Account Spend
    - Total Media Spend (Sum of the above)
    - Custom Event Revenue (Google Analytics Custom Event * $ per event)
    - Google Double Click Ad Exchange Revenue
    - Intent Media (Custom CSV that can either be manually uploaded daily or even better pulled automatically from a google spreadsheet)
    - Total Revenue (Sum of the above)
    - Total Profit (Total Revenue - Media Spend)
    - Profit Margin (Profit / Total Media Spend - it is the only one that is a %, all the others are $)

Total By Day By Country By Device (below are the columns)
    - Date
    - Country
    - Device (Desktop or Mobile)
    - Google Adwords Spend
    - Facebook Ad Account Spend
    - Total Media Spend (Sum of the above)
    - Custom Event Revenue (Google Analytics Custom Event * $ per event)
    - Google Double Click Ad Exchange Revenue
    - Intent Media (Custom CSV that can either be manually uploaded daily or even better pulled automatically from a google spreadsheet)
    - Total Revenue (Sum of the above)
    - Total Profit (Total Revenue - Media Spend)
    - Profit Margin (Profit / Total Media Spend - it is the only one that is a %, all the others are $)
    - Daily Sessions (pulled from Google Analytics)
    - Daily RPS (Total Revenue / Daily Sessions)
    - Facebook CPC
    - Adwords CPC
    


Total By Day By Campaign
    - Date
    - Campaign Name
    - Media Spend (as this will be a line item for each specific campaign, it will be only either be Google or Facebook)
    - Custom Event Revenue (Google Analytics Custom Event * $ per event for each specific campaign)
    - Google Double Click Ad Exchange Revenue (As this will not be individually reported, we assume here 30% of the total revenue)
    - Intent Media (Custom CSV that can either be manually uploaded daily or even better pulled automatically from a google spreadsheet -  for each specific campaign)
    - Total Revenue (Sum of the above)
    - Total Profit (Total Revenue - Media Spend)
    - Profit Margin (Profit / Total Media Spend - it is the only one that is a %)    


A bit more details on the sources:
    - Facebook Ads should be able to connect automatically through one of the connectors. Facebook information should be pulled from there and all necessary above fields should be able to be taken from there (please note that in the case of “Campaign” in FB it is actually the Adset name.
    - Google Ads should be able to connect automatically through one of the connectors.
Facebook information should be pulled from there and all necessary above fields should be able to be taken from there.
    - Custom Event Revenue is a Google Analytics unique event  and all necessary above fields should be able to be taken from there including but not limited to the Campaign which is received through a UTM event
    - Intent Media. We receive it daily via email.
We can either upload manually or put it in a google spreadsheet. It contains all the necessary above columns to be able to create all the reports. Attached you can see a sample daily report.

    - Google Double Click Ad Exchange  should be able to connect automatically through one of the connectors. Facebook information should be pulled from there and all necessary above fields should be able to be taken from there (except the Campaign information for the Total By Day By Campaign Report). If not able to connect, we can also have it be uploaded daily to a Google Spreadsheet.



If you prefer to offer to start with one or two of the reports, that would be acceptable as well!

Another important clarification is that we are not looking for a visual dashboard for now, only the data to be shown correct in tables.

Category: Sales & Marketing
Subcategory: Advertising on Google, Facebook
What do you need?: Large campaigns, for many products and markets (high budget)
Is this a project or a position?: Project
Required availability: As needed