Filter
User User( id="ddeabe91476a490297a3fd512c03f5f9", external_auth_id="auth0|6267e12253b86800682af6cc", name="Asif Azam", email="aa@zamazplc.com", onboarded="True", amazon_users=.... )
Created At 2022-05-13 10:36:15.582176
Params {"merchant_name": "Saffron Royal", "date_to": "2022-05-12", "date_from": "2022-03-14", "country_code": "UK", "profile_ids": "1659175697539187", "report_name": "Activ8 2022", "merchant_type": "seller"}
Result
{
  "ad_groups": {
    "average_per_campaign": 40.0
  },
  "ad_spend": {
    "total": 15966.49,
    "wasted": 1718.37
  },
  "asins": {
    "converting": {
      "total": 133
    },
    "unique": {
      "total": 55
    }
  },
  "branded": {
    "False": {
      "ad_spend": {
        "total": 0,
        "wasted": 0
      },
      "clicks": {
        "click_through_rate": 0,
        "cpc": 0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0,
        "total": 0
      },
      "sales": {
        "summary": {
          "acos": 0,
          "roas": 0,
          "total": 0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "total": 0
        }
      }
    },
    "True": {
      "ad_spend": {
        "total": 0,
        "wasted": 0
      },
      "clicks": {
        "click_through_rate": 0,
        "cpc": 0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0,
        "total": 0
      },
      "sales": {
        "summary": {
          "acos": 0,
          "roas": 0,
          "total": 0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "total": 0
        }
      }
    }
  },
  "budget": {
    "daily_efficiency": {
      "full_spend": 32,
      "high_spend": 8,
      "low_spend": 20,
      "percent_full_spend": 0.5333,
      "percent_high_spend": 0.1333,
      "percent_low_spend": 0.3333,
      "percent_zero_spend": 0.0,
      "total_days": 60,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.9789,
      "percent_underspend": 0.0211,
      "total": 16310.0,
      "total_underspend": 343.51
    },
    "top_daily_underspend": [
      {
        "date": "2022-03-16",
        "percent_spend": 0.35644897959183675,
        "total": 245.0,
        "total_ad_spend": 87.33,
        "total_underspend": 157.67
      },
      {
        "date": "2022-05-03",
        "percent_spend": 0.6350133333333333,
        "total": 375.0,
        "total_ad_spend": 238.13,
        "total_underspend": 136.87
      },
      {
        "date": "2022-03-20",
        "percent_spend": 0.48551020408163265,
        "total": 245.0,
        "total_ad_spend": 118.95,
        "total_underspend": 126.05
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 9
    }
  },
  "clicks": {
    "click_through_rate": 0.0142,
    "cpc": 0.71,
    "total": 22339
  },
  "conversions": {
    "conversion_rate": 0.3374,
    "total": 7538
  },
  "impressions": {
    "total": 7081504
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 101.3,
      "total": 485
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0,
        "cpc": 0.0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0.0,
        "total": 0
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        },
        "summary": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "top_non_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "percent_converting": 0.0,
          "total": 0
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 2145.22
        },
        "summary": {
          "percentage_of_total": 0.1975,
          "total": 3153.85,
          "wasted": 1008.63
        }
      },
      "campaigns": {
        "total_budget": 3630.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0163,
        "cpc": 0.56,
        "total": 5647
      },
      "conversions": {
        "conversion_rate": 0.2467,
        "total": 1393
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2098,
          "roas": 4.7668,
          "total": 10225.93,
          "total_orders": 1393.0
        },
        "summary": {
          "acos": 0.3084,
          "roas": 3.2424,
          "total": 10225.93,
          "total_orders": 1393
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.265,
            "ad_spend": 139.15,
            "clicks": 261,
            "cpc": 0.53,
            "query": "tv wipes",
            "sales": 525.1
          },
          {
            "acos": 0.2003,
            "ad_spend": 61.68,
            "clicks": 94,
            "cpc": 0.66,
            "query": "screen wipes",
            "sales": 307.95
          },
          {
            "acos": 0.2203,
            "ad_spend": 56.73,
            "clicks": 86,
            "cpc": 0.66,
            "query": "glasses cleaner spray",
            "sales": 257.54
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 13.49,
            "clicks": 22,
            "cpc": 0.61,
            "query": "car gadgets",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.31,
            "clicks": 14,
            "cpc": 0.59,
            "query": "anti fog spray for glasses",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 6.62,
            "clicks": 12,
            "cpc": 0.55,
            "query": "b004raxvrs",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 546,
          "non_converting": 1291,
          "percent_converting": 0.2972,
          "total": 1837
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 146.85
        },
        "summary": {
          "percentage_of_total": 0.0135,
          "total": 215.83,
          "wasted": 68.98
        }
      },
      "campaigns": {
        "total_budget": 1220.0,
        "unique": 2
      },
      "clicks": {
        "click_through_rate": 0.0087,
        "cpc": 0.75,
        "total": 287
      },
      "conversions": {
        "conversion_rate": 0.2718,
        "total": 78
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2052,
          "roas": 4.8731,
          "total": 715.61,
          "total_orders": 78.0
        },
        "summary": {
          "acos": 0.3016,
          "roas": 3.3156,
          "total": 715.61,
          "total_orders": 78
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.261,
            "ad_spend": 32.81,
            "clicks": 43,
            "cpc": 0.76,
            "query": "compressed air cleaner for pc",
            "sales": 125.72
          },
          {
            "acos": 0.4268,
            "ad_spend": 41.93,
            "clicks": 54,
            "cpc": 0.78,
            "query": "air duster compressed air",
            "sales": 98.24
          },
          {
            "acos": 0.1435,
            "ad_spend": 7.17,
            "clicks": 8,
            "cpc": 0.9,
            "query": "air duster compressed air for pc",
            "sales": 49.95
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 4.49,
            "clicks": 5,
            "cpc": 0.9,
            "query": "air duster can",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 3.2,
            "clicks": 4,
            "cpc": 0.8,
            "query": "compressed air",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 3.14,
            "clicks": 5,
            "cpc": 0.63,
            "query": "keyboard cleaner air spray",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 36,
          "non_converting": 71,
          "percent_converting": 0.3364,
          "total": 107
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 8129.34
        },
        "summary": {
          "percentage_of_total": 0.5133,
          "total": 8195.09,
          "wasted": 65.75
        }
      },
      "campaigns": {
        "total_budget": 12680.0,
        "unique": 6
      },
      "clicks": {
        "click_through_rate": 0.0114,
        "cpc": 0.78,
        "total": 10515
      },
      "conversions": {
        "conversion_rate": 0.384,
        "total": 4038
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.2933,
          "roas": 3.4092,
          "total": 27714.79,
          "total_orders": 4038.0
        },
        "summary": {
          "acos": 0.2957,
          "roas": 3.3819,
          "total": 27714.79,
          "total_orders": 4038
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3847,
            "ad_spend": 2974.96,
            "clicks": 2881,
            "cpc": 1.03,
            "query": "glasses cleaner",
            "sales": 7732.9
          },
          {
            "acos": 0.2717,
            "ad_spend": 1143.93,
            "clicks": 1678,
            "cpc": 0.68,
            "query": "screen cleaner",
            "sales": 4209.75
          },
          {
            "acos": 0.2442,
            "ad_spend": 872.68,
            "clicks": 949,
            "cpc": 0.92,
            "query": "screen cleaner spray and cloth",
            "sales": 3572.9
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 4.83,
            "clicks": 7,
            "cpc": 0.69,
            "query": "spectacles cleaner",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 4.02,
            "clicks": 9,
            "cpc": 0.45,
            "query": "led tv cleaner",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 3.5,
            "clicks": 4,
            "cpc": 0.88,
            "query": "laptop screen wipe",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 135,
          "non_converting": 61,
          "percent_converting": 0.6888,
          "total": 196
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 3683.45
        },
        "summary": {
          "percentage_of_total": 0.2757,
          "total": 4401.72,
          "wasted": 718.27
        }
      },
      "campaigns": {
        "total_budget": 12280.0,
        "unique": 5
      },
      "clicks": {
        "click_through_rate": 0.0215,
        "cpc": 0.75,
        "total": 5890
      },
      "conversions": {
        "conversion_rate": 0.3445,
        "total": 2029
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2568,
          "roas": 3.8941,
          "total": 14343.82,
          "total_orders": 2029.0
        },
        "summary": {
          "acos": 0.3069,
          "roas": 3.2587,
          "total": 14343.82,
          "total_orders": 2029
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3634,
            "ad_spend": 260.33,
            "clicks": 319,
            "cpc": 0.82,
            "query": "macbook screen cleaner",
            "sales": 716.3
          },
          {
            "acos": 0.2325,
            "ad_spend": 130.23,
            "clicks": 184,
            "cpc": 0.71,
            "query": "laptop screen cleaner",
            "sales": 560.22
          },
          {
            "acos": 0.1761,
            "ad_spend": 96.95,
            "clicks": 185,
            "cpc": 0.52,
            "query": "mac screen cleaner",
            "sales": 550.48
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 8.06,
            "clicks": 13,
            "cpc": 0.62,
            "query": "screen wipes tv",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.59,
            "clicks": 8,
            "cpc": 0.95,
            "query": "tv lcd screen cleaner",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 5.48,
            "clicks": 8,
            "cpc": 0.69,
            "query": "phone wipes antibacterial",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 578,
          "non_converting": 765,
          "percent_converting": 0.4304,
          "total": 1343
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-03-14",
    "date_to": "2022-05-12",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-13T10:36:21.111596+00:00",
    "market": "UK",
    "profile_ids": [
      1659175697539187
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 5703.18619316296
  },
  "research_types": {
    "ad_spend": 7771.4,
    "percentage_of_total": 0.4867
  },
  "sales": {
    "acos": 0.3013,
    "roas": 3.3195,
    "total": 53000.15,
    "total_orders": 7538
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.2894,
        "ad_spend": 12167.86,
        "sales": 42039.99
      },
      "top_duplicate": [
        {
          "acos": 0.3849,
          "ad_groups": [
            "AUTO - SLOW SELLING PRODUCTS",
            "EXACT - GENERIC - LENS CLEANER",
            "EXACT - GENERIC -  TOP 5 SELLING PRODUCTS",
            "Lens Cleaner"
          ],
          "ad_spend": 3016.68,
          "campaigns": [
            70522453683832,
            75581110289807,
            227225966555741,
            254270697504492
          ],
          "match_types": [
            "AUTO",
            "EXACT"
          ],
          "query": "glasses cleaner",
          "sales": 7836.67
        },
        {
          "acos": 0.2729,
          "ad_groups": [
            "AUTO - SLOW SELLING PRODUCTS",
            "AUTO - VINYL",
            "Ecofam",
            "EXACT - GENERIC - SCREEN CLEANER",
            "EXACT - GENERIC -  TOP 5 SELLING PRODUCTS"
          ],
          "ad_spend": 1153.04,
          "campaigns": [
            49164602274256,
            52307081038787,
            70522453683832,
            150045356729551,
            227225966555741
          ],
          "match_types": [
            "AUTO",
            "EXACT"
          ],
          "query": "screen cleaner",
          "sales": 4224.5
        },
        {
          "acos": 0.2415,
          "ad_groups": [
            "Ecofam",
            "EXACT - GENERIC - SCREEN CLEANER",
            "PHRASE - GENERIC - TOP 5 SELLING PRODUCTS"
          ],
          "ad_spend": 912.99,
          "campaigns": [
            49164602274256,
            70522453683832,
            150045356729551
          ],
          "match_types": [
            "BROAD",
            "EXACT",
            "PHRASE"
          ],
          "query": "screen cleaner spray and cloth",
          "sales": 3780.38
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 1132,
      "non_converting": 2031,
      "total": 3163
    }
  }
}