Filter
User User( id="317dda5dbc4f4cd0b0dbc886a89dd158", external_auth_id="auth0|6281013b552181006816fb04", name="Addison best", email="addison@88herbs.com", onboarded="True", amazon_users=.... )
Created At 2022-05-15 17:25:07.495658
Params {"profile_ids": "3116970944339971", "report_name": "test", "merchant_type": "seller", "country_code": "CA", "date_from": "2022-03-16", "merchant_name": "88Herbs | Ingredient Experts", "date_to": "2022-05-14"}
Result
{
  "ad_groups": {
    "average_per_campaign": 36.0
  },
  "ad_spend": {
    "total": 7400.95,
    "wasted": 3146.44
  },
  "asins": {
    "converting": {
      "total": 23
    },
    "unique": {
      "total": 14
    }
  },
  "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": 60,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 60,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.1883,
      "percent_underspend": 0.8117,
      "total": 39300.0,
      "total_underspend": 31899.05
    },
    "top_daily_underspend": [
      {
        "date": "2022-05-14",
        "percent_spend": 0.0786412213740458,
        "total": 655.0,
        "total_ad_spend": 51.51,
        "total_underspend": 603.49
      },
      {
        "date": "2022-05-12",
        "percent_spend": 0.12270229007633587,
        "total": 655.0,
        "total_ad_spend": 80.37,
        "total_underspend": 574.63
      },
      {
        "date": "2022-05-07",
        "percent_spend": 0.1295267175572519,
        "total": 655.0,
        "total_ad_spend": 84.84,
        "total_underspend": 570.16
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 26
    }
  },
  "clicks": {
    "click_through_rate": 0.0317,
    "cpc": 1.33,
    "total": 5547
  },
  "conversions": {
    "conversion_rate": 0.1257,
    "total": 697
  },
  "impressions": {
    "total": 1788202
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 41.4,
      "total": 866
    }
  },
  "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": 334.5
        },
        "summary": {
          "percentage_of_total": 0.2291,
          "total": 1695.77,
          "wasted": 1361.27
        }
      },
      "campaigns": {
        "total_budget": 9060.0,
        "unique": 10
      },
      "clicks": {
        "click_through_rate": 0.1245,
        "cpc": 1.24,
        "total": 1368
      },
      "conversions": {
        "conversion_rate": 0.0811,
        "total": 111
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1107,
          "roas": 9.0371,
          "total": 3022.9,
          "total_orders": 111.0
        },
        "summary": {
          "acos": 0.561,
          "roas": 1.7826,
          "total": 3022.9,
          "total_orders": 111
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1637,
            "ad_spend": 72.09,
            "clicks": 45,
            "cpc": 1.6,
            "query": "rhodiola rosea",
            "sales": 440.3
          },
          {
            "acos": 0.1638,
            "ad_spend": 35.31,
            "clicks": 24,
            "cpc": 1.47,
            "query": "bacillus coagulans probiotic",
            "sales": 215.55
          },
          {
            "acos": 0.0192,
            "ad_spend": 1.92,
            "clicks": 2,
            "cpc": 0.96,
            "query": "b01inkvvro",
            "sales": 99.75
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 84.59,
            "clicks": 49,
            "cpc": 1.73,
            "query": "male enhancing erection pills",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 82.16,
            "clicks": 78,
            "cpc": 1.05,
            "query": "abortion pill",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 51.2,
            "clicks": 33,
            "cpc": 1.55,
            "query": "penisize enlargement pills",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 80,
          "non_converting": 688,
          "percent_converting": 0.1042,
          "total": 768
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 1537.58
        },
        "summary": {
          "percentage_of_total": 0.3664,
          "total": 2712.0,
          "wasted": 1174.42
        }
      },
      "campaigns": {
        "total_budget": 27840.0,
        "unique": 13
      },
      "clicks": {
        "click_through_rate": 0.062,
        "cpc": 1.36,
        "total": 1994
      },
      "conversions": {
        "conversion_rate": 0.1324,
        "total": 264
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2461,
          "roas": 4.0631,
          "total": 6247.35,
          "total_orders": 264.0
        },
        "summary": {
          "acos": 0.4341,
          "roas": 2.3036,
          "total": 6247.35,
          "total_orders": 264
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.2,
            "ad_spend": 124.53,
            "clicks": 91,
            "cpc": 1.37,
            "query": "bacillus coagulans probiotic",
            "sales": 622.7
          },
          {
            "acos": 0.5504,
            "ad_spend": 286.57,
            "clicks": 220,
            "cpc": 1.3,
            "query": "magnesium glycinate",
            "sales": 520.7
          },
          {
            "acos": 0.3652,
            "ad_spend": 160.27,
            "clicks": 101,
            "cpc": 1.59,
            "query": "magnesium glycinate 400mg",
            "sales": 438.9
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 15.61,
            "clicks": 11,
            "cpc": 1.42,
            "query": "bioemblem triple magnesium complex | 300mg of magnesium glycinate, malate,",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 11.91,
            "clicks": 7,
            "cpc": 1.7,
            "query": "5htp",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 11.1,
            "clicks": 7,
            "cpc": 1.59,
            "query": "magnesium glycinate 100mg",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 125,
          "non_converting": 713,
          "percent_converting": 0.1492,
          "total": 838
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 1786.54
        },
        "summary": {
          "percentage_of_total": 0.2597,
          "total": 1921.8,
          "wasted": 135.26
        }
      },
      "campaigns": {
        "total_budget": 19200.0,
        "unique": 8
      },
      "clicks": {
        "click_through_rate": 0.0121,
        "cpc": 1.5,
        "total": 1278
      },
      "conversions": {
        "conversion_rate": 0.1635,
        "total": 209
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.3064,
          "roas": 3.2637,
          "total": 5830.75,
          "total_orders": 209.0
        },
        "summary": {
          "acos": 0.3296,
          "roas": 3.034,
          "total": 5830.75,
          "total_orders": 209
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.2487,
            "ad_spend": 494.96,
            "clicks": 232,
            "cpc": 2.13,
            "query": "rhodiola",
            "sales": 1989.85
          },
          {
            "acos": 0.1939,
            "ad_spend": 171.81,
            "clicks": 144,
            "cpc": 1.19,
            "query": "bacillus coagulans",
            "sales": 886.15
          },
          {
            "acos": 0.1867,
            "ad_spend": 109.24,
            "clicks": 102,
            "cpc": 1.07,
            "query": "rhodiola rosea",
            "sales": 585.05
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 49.89,
            "clicks": 37,
            "cpc": 1.35,
            "query": "ksm 66",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 13.18,
            "clicks": 8,
            "cpc": 1.65,
            "query": "magnesium glycinate 200mg",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.1,
            "clicks": 12,
            "cpc": 0.84,
            "query": "5htp 50mg",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 25,
          "non_converting": 42,
          "percent_converting": 0.3731,
          "total": 67
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 517.34
        },
        "summary": {
          "percentage_of_total": 0.1448,
          "total": 1071.38,
          "wasted": 554.04
        }
      },
      "campaigns": {
        "total_budget": 19200.0,
        "unique": 8
      },
      "clicks": {
        "click_through_rate": 0.0351,
        "cpc": 1.18,
        "total": 907
      },
      "conversions": {
        "conversion_rate": 0.1246,
        "total": 113
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1901,
          "roas": 5.2597,
          "total": 2721.05,
          "total_orders": 113.0
        },
        "summary": {
          "acos": 0.3937,
          "roas": 2.5398,
          "total": 2721.05,
          "total_orders": 113
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.7006,
            "ad_spend": 251.59,
            "clicks": 206,
            "cpc": 1.22,
            "query": "magnesium glycinate",
            "sales": 359.1
          },
          {
            "acos": 0.2295,
            "ad_spend": 65.49,
            "clicks": 37,
            "cpc": 1.77,
            "query": "ashwagandha ksm-66",
            "sales": 285.35
          },
          {
            "acos": 0.023,
            "ad_spend": 2.2,
            "clicks": 2,
            "cpc": 1.1,
            "query": "organic rhodiola rosea",
            "sales": 95.85
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 19.36,
            "clicks": 13,
            "cpc": 1.49,
            "query": "organic ashwagandha",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 12.71,
            "clicks": 10,
            "cpc": 1.27,
            "query": "ksm-66 ashwagandha",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 11.61,
            "clicks": 7,
            "cpc": 1.66,
            "query": "ksm66 ashwagandha",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 74,
          "non_converting": 353,
          "percent_converting": 0.1733,
          "total": 427
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "$",
    "date_from": "2022-03-16",
    "date_to": "2022-05-14",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-15T17:25:12.549510+00:00",
    "market": "CA",
    "profile_ids": [
      3116970944339971
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 7576.306284613533
  },
  "research_types": {
    "ad_spend": 5479.15,
    "percentage_of_total": 0.7403
  },
  "sales": {
    "acos": 0.4153,
    "roas": 2.4081,
    "total": 17822.05,
    "total_orders": 697
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.3835,
        "ad_spend": 2641.19,
        "sales": 6887.2
      },
      "top_duplicate": [
        {
          "acos": 0.6117,
          "ad_groups": [
            "Ad group 1",
            "magnesium"
          ],
          "ad_spend": 538.16,
          "campaigns": [
            147807586079428,
            178960174229811
          ],
          "match_types": [
            "BROAD",
            "PHRASE"
          ],
          "query": "magnesium glycinate",
          "sales": 879.8
        },
        {
          "acos": 0.7301,
          "ad_groups": [
            "Ad group 1",
            "Ad Group 1",
            "magnesium",
            "rhodiola"
          ],
          "ad_spend": 276.75,
          "campaigns": [
            12931143318883,
            139918647172952,
            147807586079428,
            178960174229811
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT"
          ],
          "query": "magnesium bisglycinate",
          "sales": 379.05
        },
        {
          "acos": 0.5299,
          "ad_groups": [
            "Ad group 1",
            "Ad Group 1"
          ],
          "ad_spend": 234.17,
          "campaigns": [
            40033923340404,
            139422568955720
          ],
          "match_types": [
            "BROAD",
            "EXACT"
          ],
          "query": "5htp",
          "sales": 441.9
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 290,
      "non_converting": 1740,
      "total": 2030
    }
  }
}