If you get certain advertising data reported by email or have a monthly fee for an advertising software that you want to get into Funnel, you can upload it using an Excel or CSV file that you format and populate with data yourself.
This article will teach you how to format and upload your data to Funnel, as well as how to use it after uploading.
You can use this template for creating your first file for upload to make sure you get the formatting right.
Formatting the file
The following information can be included in the file and is required:
- Campaign name
The following information can be included as well, but is optional:
- Campaign id
Funnel handles data on a daily basis, which means that all information in your custom file needs to be uploaded with a daily resolution. Here are some common solutions for when you don't get a report with a daily breakdown:
- If you get a weekly report: Divide the cost, impressions and clicks by 7 days.
- If you get a monthly report: Divide the cost, impressions and clicks by the number of days in the month.
- If you get a campaign report with a specific time frame: Divide the cost, impressions and clicks by the number of days the campaign was live.
Below is an example of a file for the cost for a SEO campaign from January 1st to January 23, 2016.
Date should be in the format "2015-06-20", "06/20/2015", "06/20/15", "Jun 20, 2015" or "20 Jun, 2015".
Currency should be formated with the three letter ISO 4217 code e.g., USD, EUR, GBP.
You can set the campaign name to what ever you want, but please keep in mind that if you want to match your ad data with the data from Google Analytics on a campaign level the campaign name needs to be the same as the utm_campaign tag.
Campaign id is optional, but we recommend to use it if it's available in the report you get.
It's fine to have commas in your numbers, they will be removed though. Use dots between the integer and decimal numbers of your cost values.
Upload the file to Funnel
When the file is ready it's time to upload it to Funnel. Navigate to Data Sources in the left hand sidebar. Click on + Data Source and scroll down to the bottom and select Upload your own data.
Upload the file and make sure you get the right values for the different columns.
Lastly name the file and click Upload new data.
Recommendations regarding naming the file
The file will show up as a new ad account in the ad account list in Funnel. We recommend that you name the file after the cost source, e.g., SEO, TV, The Economist Display. In this way you can simply add to the ad account with new campaigns or data for more dates instead of creating a new ad account.
Update the uploaded file
If you want to add more campaigns or add data for additional dates, find the ad account in the list under Configuration > Ad accounts in Funnel. If you click on "Upload file" on the right hand side of the list. Use the same file as before with updated data in it, or an entirely new file with the just the new numbers you want to add to the previous upload.
If you upload data for previously used dates and using the same Campaign name or Campaign id as before, you will overwrite the previously uploaded data.
Use your uploaded data
To see what data you have already uploaded to Funnel navigate to Data Explorer and select to view the Connection and Ad campaign name dimensions. This will allow you to see the name of the campaigns uploaded and their value.
This Data explorer view in the screen shot below is filtered to only show data from the connection "New Source - example".
You'll only notice that after having uploaded your first file "Other (File upload)" will pop up as a new connection type in the dimension configuration. You can create dimension rules for this data just like you would for any other data source.