API Queries - Report Status

mode=report_status - Fetch a report where a report id was returned.


Additional Parameters

  • report_id - Id of report to fetch.
  • limit - default is 100, maximum allowed is 1000.
  • offset - offset for result.
  • type - Specifies the format of the API response. Set to "json" for a JSON response; otherwise, the response will be in XML. (Optional)

Example queries and responses:

  • In this example, we will show the result of "day_keyword".

    Example query:



    https://www.trillion.com/api.html?username=user&apikey=key&mode=report_status&report_id=6333

    Response (XML):



    When report is generating.

    <results>
    <result Report_id="6333" Status="Processing"/>
    </results>
    

    Response (JSON):



                                {
                                "results": [ 
                                {
                                "Report_id": "6333",
                                "Status": "Processing"
                                }
                                ]
                                }
                            

    When report is generated.

    <results>
    <result AD_Type=" " Average_Bid="" Avg_CPV="" Bid_Rate="" Campaign="booking" Channel="Trillion Suggest" Cost="" Daily_Limit="" Date="" Folder="canonicalize" Geo_Target="DE" Highest_Bid="" My_Bid="0.000" Pricing="CPC" Remaining_Daily_Budget="" Traffic="" Traffic_Type="all" Unbilled="" Win_Rate=""/>
    <result AD_Type=" " Average_Bid="" Avg_CPV="" Bid_Rate="" Campaign="booking" Channel="Trillion Suggest" Cost="" Daily_Limit="90.00" Date="" Folder="canonicalize" Geo_Target="KZ" Highest_Bid="" My_Bid="0.100" Pricing="CPC" Remaining_Daily_Budget="90.00" Traffic="" Traffic_Type="all" Unbilled="" Win_Rate=""/>
    <result AD_Type=" " Average_Bid="" Avg_CPV="" Bid_Rate="" Campaign="booking" Channel="Trillion Suggest" Cost="" Daily_Limit="" Date="" Folder="canonicalize" Geo_Target="NZ" Highest_Bid="" My_Bid="0.050" Pricing="CPC" Remaining_Daily_Budget="" Traffic="" Traffic_Type="all" Unbilled="" Win_Rate=""/>
    <result AD_Type=" " Average_Bid="" Avg_CPV="" Bid_Rate="" Campaign="bookingcarsu" Channel="Trillion Suggest" Cost="" Daily_Limit="" Date="" Folder="canonicalize" Geo_Target="US" Highest_Bid="" My_Bid="0.050" Pricing="CPC" Remaining_Daily_Budget="" Traffic="" Traffic_Type="all" Unbilled="" Win_Rate=""/>
    </results>
    


  •                     {
                        "results": [ 
                        {
                        "AD_Type": "",
                        "Average_Bid": "",
                        "Avg_CPV": "",
                        "Bid_Rate": "",
                        "Campaign": "booking",
                        "Channel": "Trillion Suggest",
                        "Cost": "",
                        "Daily_Limit": "",
                        "Date": "",
                        "Folder": "canonicalize",
                        "Geo_Target": "DE",
                        "Highest_Bid": "",
                        "My_Bid": "0.000",
                        "Pricing": "CPC",
                        "Remaining_Daily_Budget": "",
                        "Traffic": "",
                        "Traffic_Type": "all",
                        "Unbilled": "",
                        "Win_Rate": ""
                        }
                        {
                        "AD_Type": "",
                        "Average_Bid": "",
                        "Avg_CPV": "",
                        "Bid_Rate": "",
                        "Campaign": "booking",
                        "Channel": "Trillion Suggest",
                        "Cost": "",
                        "Daily_Limit": "90.00",
                        "Date": "",
                        "Folder": "canonicalize",
                        "Geo_Target": "KZ",
                        "Highest_Bid": "",
                        "My_Bid": "0.100",
                        "Pricing": "CPC",
                        "Remaining_Daily_Budget": "90.00",
                        "Traffic": "",
                        "Traffic_Type": "all",
                        "Unbilled": "",
                        "Win_Rate": ""
                        }
                        {
                        "AD_Type": "",
                        "Average_Bid": "",
                        "Avg_CPV": "",
                        "Bid_Rate": "",
                        "Campaign": "booking",
                        "Channel": "Trillion Suggest",
                        "Cost": "",
                        "Daily_Limit": "",
                        "Date": "",
                        "Folder": "canonicalize",
                        "Geo_Target": "NZ",
                        "Highest_Bid": "",
                        "My_Bid": "0.050",
                        "Pricing": "CPC",
                        "Remaining_Daily_Budget": "",
                        "Traffic": "",
                        "Traffic_Type": "all",
                        "Unbilled": "",
                        "Win_Rate": ""
                        }
                        {
                        "AD_Type": "",
                        "Average_Bid": "",
                        "Avg_CPV": "",
                        "Bid_Rate": "",
                        "Campaign": "bookingcarsu",
                        "Channel": "Trillion Suggest",
                        "Cost": "",
                        "Daily_Limit": "90.00",
                        "Date": "",
                        "Folder": "canonicalize",
                        "Geo_Target": "US",
                        "Highest_Bid": "",
                        "My_Bid": "0.050",
                        "Pricing": "CPC",
                        "Remaining_Daily_Budget": "",
                        "Traffic": "",
                        "Traffic_Type": "all",
                        "Unbilled": "",
                        "Win_Rate": ""
                        }
                        ]
                        }
                    



  • In this example, we will show the result of "subId".

    Example query:



    https://www.trillion.com/api.html?username=user&apikey=key&mode=report_status&report_id=6334

    Response (XML):



    When report is generating.

    <results>
    <result Report_id="6334" Status="Processing"/>
    </results>
    

    Response (JSON):



                                {
                                "results": [ 
                                {
                                "Report_id": "6334",
                                "Status": "Processing"
                                }
                                ]
                                }
                            

    When report is generated.

    <results>
        <result CPV="$0.05" Click="4" Cost="$0.200" Date="2023-05-02 - 2024-01-01" Folder="EPCVIP" Geo_Target="US" Keyword="direct" SubID="730183522" Traffic_Type="all" Won=""/>
        <result CPV="$0.03" Click="10" Cost="$0.300" Date="2023-05-02 - 2024-01-01" Folder="Sports" Geo_Target="US" Keyword="direct" SubID="741486477" Traffic_Type="all" Won=""/>
        <result CPV="$0.17" Click="5" Cost="$0.860" Date="2023-05-02 - 2024-01-01" Folder="Sports" Geo_Target="US" Keyword="direct" SubID="764445999" Traffic_Type="all" Won=""/>
        <result CPV="$0.17" Click="4" Cost="$0.670" Date="2023-05-02 - 2024-01-01" Folder="Sports" Geo_Target="US" Keyword="direct" SubID="764471257" Traffic_Type="all" Won=""/>
        <result CPV="$0.02" Click="24" Cost="$0.480" Date="2023-05-02 - 2024-01-01" Folder="News" Geo_Target="US" Keyword="direct" SubID="849148702" Traffic_Type="all" Won=""/>
    </results>
    

                        {
                        "results": [ 
                        {
                        "CPV": "$0.05",
                        "Click": "4",
                        "Cost": "$0.200",
                        "Date": "2023-05-02 - 2024-01-01",
                        "Folder": "EPCVIP",
                        "Geo_Target": "US",
                        "Keyword": "direct",
                        "SubID": "730183522",
                        "Traffic_Type": "all",
                        "Won": ""
                        }
                        {
                        "CPV": "$0.03",
                        "Click": "10",
                        "Cost": "$0.300",
                        "Date": "2023-05-02 - 2024-01-01",
                        "Folder": "Sports",
                        "Geo_Target": "US",
                        "Keyword": "direct",
                        "SubID": "741486477",
                        "Traffic_Type": "all",
                        "Won": ""
                        }
                        {
                        "CPV": "$0.17",
                        "Click": "5",
                        "Cost": "$0.860",
                        "Date": "2023-05-02 - 2024-01-01",
                        "Folder": "Sports",
                        "Geo_Target": "US",
                        "Keyword": "direct",
                        "SubID": "764445999",
                        "Traffic_Type": "all",
                        "Won": ""
                        }
                        {
                        "CPV": "$0.17",
                        "Click": "4",
                        "Cost": "$0.670",
                        "Date": "2023-05-02 - 2024-01-01",
                        "Folder": "Sports",
                        "Geo_Target": "US",
                        "Keyword": "direct",
                        "SubID": "764471257",
                        "Traffic_Type": "all",
                        "Won": ""
                        }
                        {
                        "CPV": "$0.02",
                        "Click": "24",
                        "Cost": "$0.480",
                        "Date": "2023-05-02 - 2024-01-01",
                        "Folder": "News",
                        "Geo_Target": "US",
                        "Keyword": "direct",
                        "SubID": "849148702",
                        "Traffic_Type": "all",
                        "Won": ""
                        }
                        ]
                        }
                    

Error Responses:

Possible error responses for this function are:

For a complete list of error responses, see the Error Codes manual page.