Filter
User User( id="d6c3791d223d47a0995a57e4832f239f", external_auth_id="google-oauth2|115143293194689940171", name="Kieran Hardy", email="kieranhardy1997@gmail.com", onboarded="True", amazon_users=.... )
Created At 2022-05-18 14:07:17.779150
Params {"merchant_name": "Vegums", "country_code": "UK", "profile_ids": "1474528378887338", "date_to": "2022-05-17", "date_from": "2022-03-19", "merchant_type": "seller", "report_name": "Campaign Discovery"}
Result
{
  "ad_groups": {
    "average_per_campaign": 27.0
  },
  "ad_spend": {
    "total": 579.53,
    "wasted": 364.5
  },
  "asins": {
    "converting": {
      "total": 5
    },
    "unique": {
      "total": 16
    }
  },
  "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": 0,
      "high_spend": 0,
      "low_spend": 50,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 50,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.1559,
      "percent_underspend": 0.8441,
      "total": 3225.0,
      "total_underspend": 2722.09
    },
    "top_daily_underspend": [
      {
        "date": "2022-03-27",
        "percent_spend": 0.006201550387596899,
        "total": 64.5,
        "total_ad_spend": 0.4,
        "total_underspend": 64.1
      },
      {
        "date": "2022-03-24",
        "percent_spend": 0.009147286821705427,
        "total": 64.5,
        "total_ad_spend": 0.59,
        "total_underspend": 63.91
      },
      {
        "date": "2022-03-30",
        "percent_spend": 0.027906976744186046,
        "total": 64.5,
        "total_ad_spend": 1.8,
        "total_underspend": 62.7
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 9
    }
  },
  "clicks": {
    "click_through_rate": 0.0184,
    "cpc": 1.15,
    "total": 502
  },
  "conversions": {
    "conversion_rate": 0.1434,
    "total": 72
  },
  "impressions": {
    "total": 276722
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 15.3,
      "total": 46
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0265,
          "total": 15.34,
          "wasted": 15.34
        }
      },
      "campaigns": {
        "total_budget": 530.0,
        "unique": 1
      },
      "clicks": {
        "click_through_rate": 0.0049,
        "cpc": 2.56,
        "total": 6
      },
      "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": [
          {
            "acos": null,
            "ad_spend": 14.0,
            "clicks": 5,
            "cpc": 2.8,
            "query": "b08lp116rt",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 1.34,
            "clicks": 1,
            "cpc": 1.34,
            "query": "b07szgf9tg",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 0,
          "non_converting": 2,
          "percent_converting": 0.0,
          "total": 2
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 58.34
        },
        "summary": {
          "percentage_of_total": 0.4778,
          "total": 276.92,
          "wasted": 218.58
        }
      },
      "campaigns": {
        "total_budget": 1298.5,
        "unique": 4
      },
      "clicks": {
        "click_through_rate": 0.0393,
        "cpc": 1.16,
        "total": 238
      },
      "conversions": {
        "conversion_rate": 0.1092,
        "total": 26
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1386,
          "roas": 7.2165,
          "total": 421.01,
          "total_orders": 26.0
        },
        "summary": {
          "acos": 0.6578,
          "roas": 1.5203,
          "total": 421.01,
          "total_orders": 26
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0784,
            "ad_spend": 9.07,
            "clicks": 22,
            "cpc": 0.41,
            "query": "vegums",
            "sales": 115.66
          },
          {
            "acos": 0.0526,
            "ad_spend": 3.72,
            "clicks": 4,
            "cpc": 0.93,
            "query": "b088rm4q9g",
            "sales": 70.71
          },
          {
            "acos": 0.1388,
            "ad_spend": 6.35,
            "clicks": 8,
            "cpc": 0.79,
            "query": "b07g3jb3xt",
            "sales": 45.75
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 10.35,
            "clicks": 7,
            "cpc": 1.48,
            "query": "vegan omega 3",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.5,
            "clicks": 4,
            "cpc": 2.13,
            "query": "food",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 6.48,
            "clicks": 5,
            "cpc": 1.3,
            "query": "vegan multivitamin",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 16,
          "non_converting": 133,
          "percent_converting": 0.1074,
          "total": 149
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 12.17
        },
        "summary": {
          "percentage_of_total": 0.0981,
          "total": 56.85,
          "wasted": 44.68
        }
      },
      "campaigns": {
        "total_budget": 265.0,
        "unique": 1
      },
      "clicks": {
        "click_through_rate": 0.1306,
        "cpc": 0.81,
        "total": 70
      },
      "conversions": {
        "conversion_rate": 0.1857,
        "total": 13
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.058,
          "roas": 17.2531,
          "total": 209.97,
          "total_orders": 13.0
        },
        "summary": {
          "acos": 0.2708,
          "roas": 3.6934,
          "total": 209.97,
          "total_orders": 13
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0519,
            "ad_spend": 8.62,
            "clicks": 30,
            "cpc": 0.29,
            "query": "vegums",
            "sales": 165.94
          },
          {
            "acos": 0.062,
            "ad_spend": 1.29,
            "clicks": 1,
            "cpc": 1.29,
            "query": "vegan gummy multivitamins",
            "sales": 20.79
          },
          {
            "acos": 0.1059,
            "ad_spend": 1.23,
            "clicks": 1,
            "cpc": 1.23,
            "query": "childrens multivitamins vegan gummies",
            "sales": 11.62
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 4.21,
            "clicks": 3,
            "cpc": 1.4,
            "query": "vegums multivitamin gummies",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 3.65,
            "clicks": 3,
            "cpc": 1.22,
            "query": "vegan multivitamin gummies",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 2.2,
            "clicks": 2,
            "cpc": 1.1,
            "query": "vegan gummy multivitamins 120",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 4,
          "non_converting": 31,
          "percent_converting": 0.1143,
          "total": 35
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 96.19
        },
        "summary": {
          "percentage_of_total": 0.2734,
          "total": 158.43,
          "wasted": 62.24
        }
      },
      "campaigns": {
        "total_budget": 1060.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0087,
        "cpc": 1.32,
        "total": 120
      },
      "conversions": {
        "conversion_rate": 0.1667,
        "total": 20
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.2851,
          "roas": 3.5071,
          "total": 337.35,
          "total_orders": 20.0
        },
        "summary": {
          "acos": 0.4696,
          "roas": 2.1293,
          "total": 337.35,
          "total_orders": 20
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0331,
            "ad_spend": 6.57,
            "clicks": 27,
            "cpc": 0.24,
            "query": "vegums",
            "sales": 198.42
          },
          {
            "acos": 0.3149,
            "ad_spend": 16.5,
            "clicks": 13,
            "cpc": 1.27,
            "query": "vegums multivitamin gummies",
            "sales": 52.4
          },
          {
            "acos": 0.0115,
            "ad_spend": 0.48,
            "clicks": 1,
            "cpc": 0.48,
            "query": "vegum",
            "sales": 41.58
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 12.0,
            "clicks": 6,
            "cpc": 2.0,
            "query": "vegan vitamins",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 9.72,
            "clicks": 5,
            "cpc": 1.94,
            "query": "kids vegan multivitamins",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 4.0,
            "clicks": 2,
            "cpc": 2.0,
            "query": "vegan multivitamins",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 6,
          "non_converting": 22,
          "percent_converting": 0.2143,
          "total": 28
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 0.76
        },
        "summary": {
          "percentage_of_total": 0.0466,
          "total": 27.02,
          "wasted": 26.26
        }
      },
      "campaigns": {
        "total_budget": 265.0,
        "unique": 1
      },
      "clicks": {
        "click_through_rate": 0.0494,
        "cpc": 1.04,
        "total": 26
      },
      "conversions": {
        "conversion_rate": 0.0385,
        "total": 1
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.0366,
          "roas": 27.3553,
          "total": 20.79,
          "total_orders": 1.0
        },
        "summary": {
          "acos": 1.2997,
          "roas": 0.7694,
          "total": 20.79,
          "total_orders": 1
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0366,
            "ad_spend": 0.76,
            "clicks": 1,
            "cpc": 0.76,
            "query": "abidec kids multivitamin",
            "sales": 20.79
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 1.92,
            "clicks": 1,
            "cpc": 1.92,
            "query": "multivitamin&minerals gummies vegan women",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 1.92,
            "clicks": 1,
            "cpc": 1.92,
            "query": "kids multivitamins and minerals gummies",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 1.76,
            "clicks": 1,
            "cpc": 1.76,
            "query": "a-z multivitamins and minerals gummies",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 1,
          "non_converting": 25,
          "percent_converting": 0.0385,
          "total": 26
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-03-19",
    "date_to": "2022-05-17",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-18T14:10:51.115617+00:00",
    "market": "UK",
    "profile_ids": [
      1474528378887338
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 724.6520874751491
  },
  "research_types": {
    "ad_spend": 360.79,
    "percentage_of_total": 0.6226
  },
  "sales": {
    "acos": 0.503,
    "roas": 1.988,
    "total": 1152.08,
    "total_orders": 72
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.2945,
        "ad_spend": 235.54,
        "sales": 799.83
      },
      "top_duplicate": [
        {
          "acos": 1.4672,
          "ad_groups": [
            "A-Z Range - Generic",
            "JF_SP_Multivitamin_Auto",
            "Multivitamins",
            null
          ],
          "ad_spend": 47.01,
          "campaigns": [
            193312682701726,
            237499310192254,
            269971907712359
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT",
            null
          ],
          "query": "vegan multivitamin",
          "sales": 32.04
        },
        {
          "acos": 4.2768,
          "ad_groups": [
            "A-Z Range - Auto",
            "A-Z Range - Generic",
            "Multivitamins",
            null
          ],
          "ad_spend": 30.28,
          "campaigns": [
            192236177551369,
            193312682701726,
            237499310192254
          ],
          "match_types": [
            "AUTO",
            "EXACT",
            null
          ],
          "query": "multivitamin gummies",
          "sales": 7.08
        },
        {
          "acos": 0.4678,
          "ad_groups": [
            "A-Z Range - Auto",
            "A-Z Range - Brand",
            "Multivitamins",
            null
          ],
          "ad_spend": 27.24,
          "campaigns": [
            153698522798597,
            192236177551369,
            237499310192254
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT",
            null
          ],
          "query": "vegums multivitamin gummies",
          "sales": 58.23
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 26,
      "non_converting": 204,
      "total": 230
    }
  }
}