{"id":1219,"date":"2023-11-14T16:34:15","date_gmt":"2023-11-14T16:34:15","guid":{"rendered":"https:\/\/theoptimizer.io\/help\/?post_type=ht_kb&#038;p=1219"},"modified":"2023-11-20T19:31:09","modified_gmt":"2023-11-20T19:31:09","slug":"how-to-upload-revenue-via-csv","status":"publish","type":"ht_kb","link":"https:\/\/theoptimizer.io\/help\/knowledge-base\/how-to-upload-revenue-via-csv\/","title":{"rendered":"How to upload revenue via CSV"},"content":{"rendered":"\n<p>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.&nbsp;<\/p>\n\n\n\n<p>You simply need to go to <strong>Manual Stats Update<\/strong> and choose the CSV file to upload.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"280\" src=\"https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-1024x280.png\" alt=\"How to upload data manually via CSV on TheOptimizer\" class=\"wp-image-1220\" srcset=\"https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-1024x280.png 1024w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-300x82.png 300w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-768x210.png 768w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-50x14.png 50w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-1536x421.png 1536w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-2048x561.png 2048w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-60x16.png 60w, https:\/\/theoptimizer.io\/help\/wp-content\/uploads\/2023\/11\/How-to-upload-revenue-data-manually-with-CSV-The-Optimizer-x-Facebook-100x27.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>\ud83d\udca1<strong>NOTE:<\/strong> CSV file columns must respect a certain naming format. You can download our CSV template <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1DGpytxaY-dJEW0G6OvNhcSew12H6BmNv3Wspt_r8u2E\/edit#gid=0\"><strong>here<\/strong><\/a>.&nbsp;Using this CSV format, you will be able to upload data for campaigns, ad sets, and ads, with a single file.&nbsp;<\/p>\n\n\n\n<p>Here you can find a full list of all the columns with a short description for each of them:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Date:<\/strong> the date that is going to be updated in the format yyyy-mm-dd.<\/li>\n\n\n\n<li><strong>Type<\/strong>: the entity that is being updated, such as campaign, ad set, content (ad), domain.<\/li>\n\n\n\n<li><strong>TrafficSourceCampaignId<\/strong>: campaign ID as reported on Facebook<\/li>\n\n\n\n<li><strong>TrafficSourceWidgetId<\/strong>: leave empty.<\/li>\n\n\n\n<li><strong>TrafficSourceContentId<\/strong>: ID of the content (ad) that is being updated if you selected \u201ccontent\u201d under Type (otherwise, leave empty).<\/li>\n\n\n\n<li><strong>TrafficSourceSectionId<\/strong>: leave empty.<\/li>\n\n\n\n<li><strong>TrafficSourceDomainId<\/strong>: the id of the domain that is being updated if type=domain (otherwise leave empty).<\/li>\n\n\n\n<li><strong>TrafficSourceSiteId<\/strong>: leave empty.<\/li>\n\n\n\n<li><strong>TrafficSourceExchangeId<\/strong>: leave empty.<\/li>\n\n\n\n<li><strong>TrafficSourceAdGroupId<\/strong>: the id of the ad group that is being updated if type=adgroup (otherwise leave empty).<\/li>\n\n\n\n<li><strong>TrackerCampaignId<\/strong>: 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.<\/li>\n\n\n\n<li><strong>TrackerClicks<\/strong>: clicks as reported in your tracking system. Leave empty if not used.<\/li>\n\n\n\n<li><strong>TrackerConversions<\/strong>: conversions as reported in your tracking system. Leave empty if not used.<\/li>\n\n\n\n<li><strong>TrackerRevenue<\/strong>: revenue as reported in your tracking system. leave empty if not used.<\/li>\n\n\n\n<li><strong>TrafficSourceImpressions<\/strong>: impressions as reported from your traffic source. Leave empty if not used.<\/li>\n\n\n\n<li><strong>TrafficSourceClicks<\/strong>: clicks as reported from your traffic source. Leave empty if not used.<\/li>\n\n\n\n<li><strong>TrafficSourceConversions<\/strong>: conversions as reported from your traffic source. Leave empty if not used.<\/li>\n\n\n\n<li><strong>Cost<\/strong>: the cost (spend) as reported from your traffic source. Leave empty if not used.<\/li>\n\n\n\n<li><strong>TrafficSourceRevenue<\/strong>: revenue as reported from your traffic source. Leave empty if not used.<\/li>\n\n\n\n<li><strong>PublisherClicks<\/strong>: clicks as reported by your publisher integration (usually systems similar to Tonic, Sedo, Domain Active). Leave empty if not used.<\/li>\n\n\n\n<li><strong>PublisherRevenue<\/strong>: revenue as reported by your publisher integration (usually systems similar to Tonic, Sedo, Domain Active). Leave empty if not used.<\/li>\n\n\n\n<li><strong>PublisherConversions<\/strong>: conversions as reported by your publisher integration (usually systems similar to Tonic, Sedo, Domain Active). Leave empty if not used.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Next step: Facebook metrics explained <\/h2>\n\n\n\n<p>Before you start automating, you can check out all the available Facebook metrics explained <a href=\"https:\/\/theoptimizer.io\/help\/article-categories\/4-available-facebook-metrics-explained\/\"><span style=\"text-decoration: underline;\">here<\/span><\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the template you need to use if you are uploading revenue data via CSV. <\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[],"class_list":["post-1219","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-3-how-to-connect-facebook-to-an-external-revenue-stream"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/comments?post=1219"}],"version-history":[{"count":6,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb\/1219\/revisions"}],"predecessor-version":[{"id":1399,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb\/1219\/revisions\/1399"}],"wp:attachment":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb-category?post=1219"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb-tag?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}