Filter
User User( id="ac8cce8079c249b7942ea8be21377e74", external_auth_id="auth0|6284b959e102dc006f80286d", name="michael joines", email="help@zoomavit.com", onboarded="True", amazon_users=.... )
Created At 2022-05-19 08:34:13.316276
Params {"date_to": "2022-05-18", "country_code": "US", "report_name": "Zoomavit", "date_from": "2022-03-20", "merchant_name": "Zoomavit", "merchant_type": "seller", "profile_ids": "2444913975934584"}
Result
{
  "ad_groups": {
    "average_per_campaign": 65.0
  },
  "ad_spend": {
    "total": 5074.0,
    "wasted": 2427.05
  },
  "asins": {
    "converting": {
      "total": 21
    },
    "unique": {
      "total": 6
    }
  },
  "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.2225,
      "percent_underspend": 0.7775,
      "total": 22800.0,
      "total_underspend": 17726.0
    },
    "top_daily_underspend": [
      {
        "date": "2022-03-26",
        "percent_spend": 0.02573684210526316,
        "total": 380.0,
        "total_ad_spend": 9.78,
        "total_underspend": 370.22
      },
      {
        "date": "2022-03-21",
        "percent_spend": 0.02681578947368421,
        "total": 380.0,
        "total_ad_spend": 10.19,
        "total_underspend": 369.81
      },
      {
        "date": "2022-03-24",
        "percent_spend": 0.027526315789473683,
        "total": 380.0,
        "total_ad_spend": 10.46,
        "total_underspend": 369.54
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 13
    }
  },
  "clicks": {
    "click_through_rate": 0.0087,
    "cpc": 1.38,
    "total": 3665
  },
  "conversions": {
    "conversion_rate": 0.1007,
    "total": 369
  },
  "impressions": {
    "total": 1793550
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 123.5,
      "total": 555
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 127.21
        },
        "summary": {
          "percentage_of_total": 0.0601,
          "total": 304.95,
          "wasted": 177.74
        }
      },
      "campaigns": {
        "total_budget": 6000.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.012,
        "cpc": 1.06,
        "total": 289
      },
      "conversions": {
        "conversion_rate": 0.0727,
        "total": 21
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.3183,
          "roas": 3.1417,
          "total": 399.65,
          "total_orders": 21.0
        },
        "summary": {
          "acos": 0.763,
          "roas": 1.3105,
          "total": 399.65,
          "total_orders": 21
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1185,
            "ad_spend": 4.5,
            "clicks": 3,
            "cpc": 1.5,
            "query": "b071dd17q6",
            "sales": 37.98
          },
          {
            "acos": 0.604,
            "ad_spend": 22.94,
            "clicks": 25,
            "cpc": 0.92,
            "query": "b0014d2gek",
            "sales": 37.98
          },
          {
            "acos": 0.0395,
            "ad_spend": 1.5,
            "clicks": 1,
            "cpc": 1.5,
            "query": "b0797hqfgt",
            "sales": 37.98
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 8.46,
            "clicks": 9,
            "cpc": 0.94,
            "query": "b076b24p1w",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.77,
            "clicks": 6,
            "cpc": 1.3,
            "query": "b07255mprn",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.03,
            "clicks": 5,
            "cpc": 1.41,
            "query": "b00mraeniq",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 17,
          "non_converting": 104,
          "percent_converting": 0.1405,
          "total": 121
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 398.7
        },
        "summary": {
          "percentage_of_total": 0.2754,
          "total": 1397.61,
          "wasted": 998.91
        }
      },
      "campaigns": {
        "total_budget": 3900.0,
        "unique": 4
      },
      "clicks": {
        "click_through_rate": 0.0182,
        "cpc": 1.16,
        "total": 1202
      },
      "conversions": {
        "conversion_rate": 0.074,
        "total": 89
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2349,
          "roas": 4.2571,
          "total": 1697.29,
          "total_orders": 89.0
        },
        "summary": {
          "acos": 0.8234,
          "roas": 1.2144,
          "total": 1697.29,
          "total_orders": 89
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.5343,
            "ad_spend": 50.73,
            "clicks": 38,
            "cpc": 1.34,
            "query": "vitamin b complex",
            "sales": 94.95
          },
          {
            "acos": 0.1907,
            "ad_spend": 10.86,
            "clicks": 8,
            "cpc": 1.36,
            "query": "liquid b complex",
            "sales": 56.95
          },
          {
            "acos": 0.7666,
            "ad_spend": 43.64,
            "clicks": 37,
            "cpc": 1.18,
            "query": "organic liquid b12",
            "sales": 56.93
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 19.69,
            "clicks": 15,
            "cpc": 1.31,
            "query": "b complex liquid",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 19.61,
            "clicks": 25,
            "cpc": 0.78,
            "query": "b00mraeniq",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 18.76,
            "clicks": 13,
            "cpc": 1.44,
            "query": "b vitamins complex liquid",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 77,
          "non_converting": 557,
          "percent_converting": 0.1215,
          "total": 634
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 79.48
        },
        "summary": {
          "percentage_of_total": 0.0993,
          "total": 503.81,
          "wasted": 424.33
        }
      },
      "campaigns": {
        "total_budget": 14700.0,
        "unique": 6
      },
      "clicks": {
        "click_through_rate": 0.0742,
        "cpc": 1.24,
        "total": 405
      },
      "conversions": {
        "conversion_rate": 0.084,
        "total": 34
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1088,
          "roas": 9.1881,
          "total": 730.27,
          "total_orders": 34.0
        },
        "summary": {
          "acos": 0.6899,
          "roas": 1.4495,
          "total": 730.27,
          "total_orders": 34
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0597,
            "ad_spend": 12.47,
            "clicks": 11,
            "cpc": 1.13,
            "query": "zoomavit b12",
            "sales": 208.75
          },
          {
            "acos": 0.0303,
            "ad_spend": 1.15,
            "clicks": 1,
            "cpc": 1.15,
            "query": "vitamin b12 zoom avit",
            "sales": 37.98
          },
          {
            "acos": 0.0126,
            "ad_spend": 0.48,
            "clicks": 1,
            "cpc": 0.48,
            "query": "b12 liquid",
            "sales": 37.98
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 13.71,
            "clicks": 14,
            "cpc": 0.98,
            "query": "organic chlorophyll liquid drops",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.87,
            "clicks": 9,
            "cpc": 0.99,
            "query": "organic chlorophyll",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.16,
            "clicks": 9,
            "cpc": 0.8,
            "query": "neurobion b12 complex",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 27,
          "non_converting": 269,
          "percent_converting": 0.0912,
          "total": 296
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 1743.33
        },
        "summary": {
          "percentage_of_total": 0.455,
          "total": 2308.78,
          "wasted": 565.45
        }
      },
      "campaigns": {
        "total_budget": 12300.0,
        "unique": 4
      },
      "clicks": {
        "click_through_rate": 0.0046,
        "cpc": 1.64,
        "total": 1407
      },
      "conversions": {
        "conversion_rate": 0.1279,
        "total": 180
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.5128,
          "roas": 1.9499,
          "total": 3399.39,
          "total_orders": 180.0
        },
        "summary": {
          "acos": 0.6792,
          "roas": 1.4724,
          "total": 3399.39,
          "total_orders": 180
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.4328,
            "ad_spend": 197.61,
            "clicks": 109,
            "cpc": 1.81,
            "query": "b complex liquid",
            "sales": 456.62
          },
          {
            "acos": 0.9039,
            "ad_spend": 264.52,
            "clicks": 155,
            "cpc": 1.71,
            "query": "liquid vitamin b complex",
            "sales": 292.65
          },
          {
            "acos": 0.4586,
            "ad_spend": 131.03,
            "clicks": 86,
            "cpc": 1.52,
            "query": "vitamin b complex",
            "sales": 285.73
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 51.42,
            "clicks": 24,
            "cpc": 2.14,
            "query": "vitamin d3",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 27.45,
            "clicks": 13,
            "cpc": 2.11,
            "query": "liquid vitamin d",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 19.25,
            "clicks": 15,
            "cpc": 1.28,
            "query": "best liquid chlorophyll",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 69,
          "non_converting": 128,
          "percent_converting": 0.3503,
          "total": 197
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 151.85
        },
        "summary": {
          "percentage_of_total": 0.1101,
          "total": 558.85,
          "wasted": 407.0
        }
      },
      "campaigns": {
        "total_budget": 12300.0,
        "unique": 4
      },
      "clicks": {
        "click_through_rate": 0.0172,
        "cpc": 1.54,
        "total": 362
      },
      "conversions": {
        "conversion_rate": 0.1243,
        "total": 45
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1975,
          "roas": 5.0642,
          "total": 769.0,
          "total_orders": 45.0
        },
        "summary": {
          "acos": 0.7267,
          "roas": 1.376,
          "total": 769.0,
          "total_orders": 45
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0445,
            "ad_spend": 4.76,
            "clicks": 2,
            "cpc": 2.38,
            "query": "zoomavit vitamin d3 drops",
            "sales": 106.92
          },
          {
            "acos": 0.1137,
            "ad_spend": 4.32,
            "clicks": 3,
            "cpc": 1.44,
            "query": "b12 complex drops",
            "sales": 37.98
          },
          {
            "acos": 0.6811,
            "ad_spend": 25.87,
            "clicks": 13,
            "cpc": 1.99,
            "query": "baby vitamin d drops",
            "sales": 37.98
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 10.26,
            "clicks": 6,
            "cpc": 1.71,
            "query": "vitamin d3 k2",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 4.53,
            "clicks": 3,
            "cpc": 1.51,
            "query": "mary ruths b complex",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 4.26,
            "clicks": 4,
            "cpc": 1.07,
            "query": "neurobion b12 complex",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 40,
          "non_converting": 241,
          "percent_converting": 0.1423,
          "total": 281
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "$",
    "date_from": "2022-03-20",
    "date_to": "2022-05-18",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-19T08:34:17.833500+00:00",
    "market": "US",
    "profile_ids": [
      2444913975934584
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 3346.270508754998
  },
  "research_types": {
    "ad_spend": 2460.27,
    "percentage_of_total": 0.4849
  },
  "sales": {
    "acos": 0.7253,
    "roas": 1.3787,
    "total": 6995.6,
    "total_orders": 369
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.6603,
        "ad_spend": 2135.81,
        "sales": 3234.85
      },
      "top_duplicate": [
        {
          "acos": 0.8636,
          "ad_groups": [
            "B-complex",
            "Broad",
            "Exact",
            "Exact2"
          ],
          "ad_spend": 269.13,
          "campaigns": [
            13867177930849,
            60265468305603,
            229938433426799
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT"
          ],
          "query": "liquid vitamin b complex",
          "sales": 311.62
        },
        {
          "acos": 0.4808,
          "ad_groups": [
            "B-complex",
            "Broad",
            "Exact",
            "Exact2"
          ],
          "ad_spend": 219.55,
          "campaigns": [
            13867177930849,
            60265468305603,
            229938433426799
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT"
          ],
          "query": "b complex liquid",
          "sales": 456.62
        },
        {
          "acos": 0.4775,
          "ad_groups": [
            "B-complex",
            "Exact2"
          ],
          "ad_spend": 181.76,
          "campaigns": [
            13867177930849,
            60265468305603
          ],
          "match_types": [
            "AUTO",
            "EXACT"
          ],
          "query": "vitamin b complex",
          "sales": 380.68
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 217,
      "non_converting": 1210,
      "total": 1427
    }
  }
}