Rapport d’analyse des segments ciblés

Le rapport Analyse des segments ciblés est un rapport administrateur uniquement conçu pour vous donner des informations sur la façon dont votre ciblage de segment affecte les performances de vos campagnes en cours. Les cas d’usage de ce rapport sont les suivants :

• Comprendre quels segments ciblés (à la fois comportementaux et contextuels) sont à l’origine d’impressions, de clics et de conversions au sein d’une campagne en cours d’exécution.
• Indexation des performances des segments ciblés pendant la campagne pour identifier les segments qui dépassent ou ne sont pas performants.
• Comprendre si les segments achetés auprès de tiers produisent les performances souhaitées.

Période

Les données de ce rapport sont conservées pendant 14 jours et sont disponibles par intervalles d’un jour. Toutes les dates et heures sont indiquées au format UTC.

Le time_intervals champ dans la requête peut être défini sur last_14_days.

Dimensions

Mesures

Exemple

Demander le rapport

$ cat the_request.json
 
{
    "report": {
        "report_type": "targeted_segment_analytics",
        "format": "csv",
        "report_interval": "last_14_days",
        "columns": [
            "day",
            "member_id",
            "campaign",
            "segment",
            "segment_code",
            "media_cost",
            "imps",
            "clicks",
            "revenue_ecpm",
            "ctr",
            "convs_rate"
        ],
        "filters": [
            {
                "campaign_id": "827286"
            }
        ]
    }
}
 
$ curl -bc -cc -X POST -d @the_request.json 'https://api.appnexus.com/report'
 
// Note that the response contains some internal-only debugging info if you request it as an admin user.
 
{
    "response": {
        "status": "OK",
        "report": {
            "name": "",
            "created_on": "2013-11-20 19:29:34",
            "cache_hit": false,
            "fact_cache_hit": false,
            "fact_cache_error": "did not find any cache table for 1,2,30,31,32,34,36,66,6",
            "json_request": "{"report":{"filters":[{"campaign_id":"827286"},{"member_id":"541"},{"campaign_id":"827286"}],"columns":["day","member_id","campaign","segment","segment_code","media_cost","imps","clicks","revenue_ecpm","ctr","convs_rate"],"report_interval":"last_14_days","format":"csv","report_type":"targeted_segment_analytics"}}",
            "header_info": "",
            "row_count": "",
            "report_size": "",
            "internal_info": "{\"report_id\":\"823418c8d5548559948617332a1b5a23\",\"cache_miss\":1,\"cache_host\":\"vertica\",\"query\":\" SELECT to_char(ymd, 'YYYY-MM-DD') AS alias_1,buyer_member_id AS alias_2,CAMPAIGN_ID AS alias_3,segment_id AS alias_4,segment_id AS alias_5,SUM(MEDIA_COST_DOLLARS) AS alias_6,SUM(IMPS) AS alias_7,SUM(CLICKS) AS alias_8,SUM(booked_revenue_dollars) \/ (CASE WHEN SUM(imps) > 0 THEN  SUM(imps) ELSE 1 END) * 1000 AS alias_9,SUM(clicks)::numeric\/(CASE WHEN SUM(imps) > 0 THEN  SUM(imps)::numeric ELSE 1 END) AS alias_10,SUM(post_click_convs + post_view_convs)::numeric\/(CASE WHEN SUM(imps) > 0 THEN SUM(imps) ELSE 1 END) AS alias_11  FROM view_agg_dw_targeted_segments fact  WHERE 1=1  AND ymd >= '2013-11-06 00:00:00' AND ymd  < '2013-11-20 00:00:00' AND CAMPAIGN_ID IN ('827286') AND buyer_member_id IN ('541')  GROUP BY to_char(ymd, 'YYYY-MM-DD'), alias_2, alias_3, alias_4, alias_5 LIMIT 1000000001\n-- [member_id] 0\n-- [report_id] 823418c8d5548559948617332a1b5a23\"}",
            "user_id": "14311",
            "entity_id": "0",
            "started_on": "2013-11-20 19:29:34",
            "finished_on": "1970-01-01 00:00:01",
            "query_time": ""
        },
        "execution_status": "pending",
        "dbg_info": {
            "instance": "29.bm-hbapi.prod.nym1",m
            "s1ave_hit": false,
            "db": "master",
            "awesomesauce_cache_used": false,
            "count_cache_used": false,
            "warnings": [],
            "time": 128.81517410278,
            "start_microtime": 1384975794.8973,
            "version": "1.14.46"
        }
    }
}