Setting Up Other Data Sources
      Back to home
      1. Wicked Help Center
      2. 1. SETUP
      3. Setting Up Other Data Sources

      How do I create "Marketing Costs" with HTTP Post

      Intro to Marketing Costs via HTTP POST

      When you want to add other Marketing Costs for a Wicked Reports account, there are a few possibilities to accomplish this: CSV, HTTP Post, Zapier, or API. This article focuses on uploading Marketing Costs via HTTP Post.

      The primary scenario for uploading other Marketing Costs is  when you are marketing on an channel for which Wicked does not have Native Integration.

      • Scenario #1 - Driving traffic via Amazon, Twitter (X) or other Non-Native Platforms
        Case: You are paying for ads on a platform that Wicked Reports does not integrate with, however you'd like to make sure those costs are accounted for and contribute to overall marketing costs to keep your MER accurate.  In this case, by adding Marketing Costs, you can ensure the correct costs are attributed to the proper channel. 
      • Scenario #2 - Paid Email blasts
        Case        : You collaborate with a company that conducts paid email blasts on your behalf. Assuming that tracking is correctly configured for these email blasts, adding Marketing Costs allows you to assess whether the costs incurred for the email blasts are generating the desired value.
        There are of course other scenarios for which you may want to include additional marketing costs.

         

        How to Format Marketing Costs for HTTP Post

        When preparing your Marketing Costs for HTTP Post, you'll want to make sure you've added all the required fields and formatted them correctly. If you have not prepared your HTTP Post properly, you will, most often, receive an error message and you'll need to correct the error before the HTTP Post can pass through. In this section, we'll cover:

         

        The URL Endpoint

        To send Custom Clicks to Wicked, use the URL:

        https://api.wickedreports.com/marketing/<WickedClientName>

        You will need to replace <WickedClientName> with your client name in your account. See this help doc to find your client name.

         

        The Required Headers

        The only required header is Content-Type. It should be as follows:

        • Content-Type: application/x-www-form-urlencoded

         

        The Body's Required Key-Value Pairs:

        • Date_Time: This is a Date/Time setting for the Marketing Costs to be applied. You can use “NOW” for the current date/time or any date/time using this format: mm/dd/yyyy hh:mm am/pm
        • Source: The utm_source value that will be applied to the Marketing Costs.
        • Clicks: The number of clicks to be recorded with the Marketing Costs.  If you don't know the exact amount of clicks, add your best estimate
        • Costs: This decimal value is the costs spent on the Marketing
        • AdId: This is the string value AdID associated with the Marketing.  If you don't have an AdId, you a unique string for each HTTP post of marketing costs
        • AccountId: This is the string value AccountID associated with the Marketing Costs (Amazon Ads AccountID, Twitters accountID, etc).  If you don't have an AccountID, pick any string for each HTTP post for this Account's costs

           

          The Body's Optional Key-Value Pairs:

          • Medium: The utm_medium value that will be applied to the Marketing Costs.
            Recommended, if available.
          • Campaign: The utm_campaign value that will be applied to the Marketing Costs
            Not required, but highly recommended.
          • Term: The utm_term value that will be applied to the Marketing Costs.
            Recommended, if available.
          • Content: The utm_content value that will be applied to the Marketing Costs.
            Recommended, if available
          • SourceSystem:  This is a string value that represents which system (platform) these Marketing Costs are from
          • ConversionCount: This integer value is the count of sales that came from the Marketing Costs, to be reported within Wicked Reports
          • ConversionValue: This integer is the value of conversions from the Marketing Costs, to be reported within Wicked Reports
          • AdStatus: This string is the status of the Ad from the Marketing Costs (i.e. Active/Paused/etc.)
          • CampaignStatus: This string is the status of the Campaign from the Marketing Costs (i.e. Active/Paused/etc.)
          • AdGroupStatus: This string is the status of the Ad Group from the Marketing Costs (i.e. Active/Paused/etc.)
          • AdSetStatus: This string is the status of the Ad Set from the Marketing Costs (i.e. Active/Paused/etc.)
          • AdType: This string is the type of Ad used in the marketing (i.e. Video, Image, Email, etc.)
          • CampaignID: This string is the ID of the Campaign in the marketing
          • AdGroupID: This string is the ID of the AdGroup in the marketing

          Now that you've added all the required fields and formatted them correctly, you can go ahead and send your custom click to Wicked!

           

          An Alternative Method:

          In addition, in case your CRM doesn't provide an easy way to send your data to Wicked, you can now send the Marketing Costs data as part of the URL query string. 

          Here's an example URL showing how to send your data using the query string:

          https://api.wickedreports.com/clicks/client?Source=Amazon&Clicks=1000&Costs=2000&AdId=1000&AccountID=amz123&Date_Time=NOW

           

          How to Review Marketing Costs in Wicked

          To ensure your custom clicks have passed into Wicked properly, you'll want to check out the API Verification Page.

          The API Verification Page will allow you to see all the Marketing Costs that have passed into your Wicked Reports account. It pulls in fresh data every 30 minutes. So, you can send your Marketing Costs through, then come to this page to verify it's been received.

          Simply change your filters, and look for your Marketing.

          • If you see the Marketing Costs on your API verification page, then we've received it.
          • If you do not see your Marketing Costs on the API verification page, that means an error has occurred and we have not received it. Please update the error before re-submitting.

          That's it! You've now completed your Marketing Cost upload. Once your data has processed, you should be able to see the costs in your reports.

          If you have any questions regarding Marketing Costs, then please review the FAQs below. If you find you still have questions after reading the FAQs, then reach out to the Wicked Reports support team via live chat, or by sending an email directly to support@wickedreports.com. We're always happy to help!

           

          FAQs:

          1. I'm getting a "Content-Type" error. What should by Content Type be?
            Content-Type should be “application/x-www-form-urlencoded”.