How to upload revenue via CSV

If you are using a third party or internal tracker that is not integrated via API to our system, you can still upload your data to TheOptimizer via CSV. 

You simply need to go to Manual Stats Update and choose the CSV file to upload. 

💡NOTE: CSV file columns must respect a certain naming format. You can download our CSV template here. Using this CSV format, you will be able to upload data for campaigns, ad sets, and ads, with a single file. 

Here you can find a full list of all the columns with a short description for each of them: 

• Date: the date that is going to be updated in the format yyyy-mm-dd.
• Type: the entity that is being updated, such as campaign, ad set, content (ad), domain.
• TrafficSourceCampaignId: campaign ID as reported on Facebook
• TrafficSourceWidgetId: leave empty.
• TrafficSourceContentId: ID of the content (ad) that is being updated if you selected “content” under Type (otherwise, leave empty).
• TrafficSourceSectionId: leave empty.
• TrafficSourceDomainId: the id of the domain that is being updated if type=domain (otherwise leave empty).
• TrafficSourceSiteId: leave empty.
• TrafficSourceExchangeId: leave empty.
• TrafficSourceAdGroupId: the id of the ad group that is being updated if type=adgroup (otherwise leave empty).
• TrackerCampaignId: the ID of the campaign on your tracking platform. This is only necessary if you are uploading publisher data for systems like (Tonic, Sedo, Domain Active, etc). Leave empty if not used.
• TrackerClicks: clicks as reported in your tracking system. Leave empty if not used.
• TrackerConversions: conversions as reported in your tracking system. Leave empty if not used.
• TrackerRevenue: revenue as reported in your tracking system. leave empty if not used.
• TrafficSourceImpressions: impressions as reported from your traffic source. Leave empty if not used.
• TrafficSourceClicks: clicks as reported from your traffic source. Leave empty if not used.
• TrafficSourceConversions: conversions as reported from your traffic source. Leave empty if not used.
• Cost: the cost (spend) as reported from your traffic source. Leave empty if not used.
• TrafficSourceRevenue: revenue as reported from your traffic source. Leave empty if not used.
• PublisherClicks: clicks as reported by your publisher integration (usually systems similar to Tonic, Sedo, Domain Active). Leave empty if not used.
• PublisherRevenue: revenue as reported by your publisher integration (usually systems similar to Tonic, Sedo, Domain Active). Leave empty if not used.
• PublisherConversions: conversions as reported by your publisher integration (usually systems similar to Tonic, Sedo, Domain Active). Leave empty if not used.

Next step: Facebook metrics explained

Before you start automating, you can check out all the available Facebook metrics explained here.