Filter
User User( id="9a9745d827ae43b590d4a490b2ea9eed", external_auth_id="google-oauth2|103991713203375260788", name="Bo Schuerman", email="bo@vetprocomplete.com", onboarded="True", amazon_users=.... )
Created At 2022-09-07 14:45:14.503313
Params {"brand_search_terms": [], "profile_ids": "2618522275674698", "country_code": "US", "merchant_name": "Dr. Joseph's VetPro Complete", "exclude_zero_spend_days": false, "merchant_type": "seller", "campaign_ids": [], "date_from": "2022-07-09", "wasted_spend_click_threshold": 5, "date_to": "2022-09-06", "report_name": "VetPro Audit "}
Result
{
  "ad_groups": {
    "average_per_campaign": 0.0
  },
  "ad_spend": {
    "total": 124903.14,
    "wasted": 5642.23
  },
  "asins": {
    "converting": {
      "total": 48
    },
    "unique": {
      "total": 9
    }
  },
  "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": 59,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 59,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.2599,
      "percent_underspend": 0.7401,
      "total": 480673.8,
      "total_underspend": 355770.66
    },
    "top_daily_underspend": [
      {
        "date": "2022-07-28",
        "percent_spend": 0.1785370244135403,
        "total": 9799.48,
        "total_ad_spend": 1749.57,
        "total_underspend": 8049.91
      },
      {
        "date": "2022-07-11",
        "percent_spend": 0.11857110321688435,
        "total": 8518.18,
        "total_ad_spend": 1010.01,
        "total_underspend": 7508.17
      },
      {
        "date": "2022-09-03",
        "percent_spend": 0.2620535145444822,
        "total": 9967.01,
        "total_ad_spend": 2611.89,
        "total_underspend": 7355.12
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 57
    }
  },
  "clicks": {
    "click_through_rate": 0.0063,
    "cpc": 6.26,
    "total": 19961
  },
  "conversions": {
    "conversion_rate": 0.1827,
    "total": 3646
  },
  "impressions": {
    "total": 10667507
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 81.4,
      "total": 1057
    }
  },
  "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": 2052.54
        },
        "summary": {
          "percentage_of_total": 0.0429,
          "total": 5361.37,
          "wasted": 842.98
        }
      },
      "campaigns": {
        "total_budget": 9225.1,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0042,
        "cpc": 4.61,
        "total": 1164
      },
      "conversions": {
        "conversion_rate": 0.0739,
        "total": 86
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.6515,
          "roas": 1.535,
          "total": 3150.6,
          "total_orders": 86.0
        },
        "summary": {
          "acos": 1.7017,
          "roas": 0.5876,
          "total": 3150.6,
          "total_orders": 86
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.9662,
            "ad_spend": 208.4,
            "clicks": 35,
            "cpc": 5.95,
            "query": "probiotics for dogs",
            "sales": 215.7
          },
          {
            "acos": 2.8313,
            "ad_spend": 466.45,
            "clicks": 91,
            "cpc": 5.13,
            "query": "dog",
            "sales": 164.75
          },
          {
            "acos": 2.4228,
            "ad_spend": 348.4,
            "clicks": 57,
            "cpc": 6.11,
            "query": "salmon oil for dogs",
            "sales": 143.8
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 107.34,
            "clicks": 16,
            "cpc": 6.71,
            "query": "dog treats",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 86.79,
            "clicks": 17,
            "cpc": 5.11,
            "query": "b089xvjhfk",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 69.55,
            "clicks": 12,
            "cpc": 5.8,
            "query": "fish oil for dogs",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 70,
          "non_converting": 500,
          "percent_converting": 0.1228,
          "total": 570
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 5.56
        },
        "summary": {
          "percentage_of_total": 0.0007,
          "total": 93.38,
          "wasted": 38.59
        }
      },
      "campaigns": {
        "total_budget": 198049.76,
        "unique": 6
      },
      "clicks": {
        "click_through_rate": 0.0552,
        "cpc": 4.67,
        "total": 20
      },
      "conversions": {
        "conversion_rate": 0.1,
        "total": 2
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.0752,
          "roas": 13.2914,
          "total": 73.9,
          "total_orders": 2.0
        },
        "summary": {
          "acos": 1.2636,
          "roas": 0.7914,
          "total": 73.9,
          "total_orders": 2
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1188,
            "ad_spend": 4.39,
            "clicks": 1,
            "cpc": 4.39,
            "query": "arthritis medicine for dogs",
            "sales": 36.95
          },
          {
            "acos": 0.0317,
            "ad_spend": 1.17,
            "clicks": 1,
            "cpc": 1.17,
            "query": "dr joseph vetpro complete",
            "sales": 36.95
          }
        ],
        "top_non_converting": [],
        "unique": {
          "converting": 2,
          "non_converting": 18,
          "percent_converting": 0.1,
          "total": 20
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 71.45
        },
        "summary": {
          "percentage_of_total": 0.002,
          "total": 252.47,
          "wasted": 145.56
        }
      },
      "campaigns": {
        "total_budget": 143715.45,
        "unique": 9
      },
      "clicks": {
        "click_through_rate": 0.0096,
        "cpc": 7.89,
        "total": 32
      },
      "conversions": {
        "conversion_rate": 0.2188,
        "total": 7
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.2957,
          "roas": 3.3821,
          "total": 241.65,
          "total_orders": 7.0
        },
        "summary": {
          "acos": 1.0448,
          "roas": 0.9571,
          "total": 241.65,
          "total_orders": 7
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0386,
            "ad_spend": 4.28,
            "clicks": 3,
            "cpc": 1.43,
            "query": "dr joseph vetpro complete hip and joint",
            "sales": 110.85
          },
          {
            "acos": 1.6168,
            "ad_spend": 59.74,
            "clicks": 3,
            "cpc": 19.91,
            "query": "joint support supplement for dogs",
            "sales": 36.95
          },
          {
            "acos": 0.1093,
            "ad_spend": 4.04,
            "clicks": 1,
            "cpc": 4.04,
            "query": "shark cartilage for dogs",
            "sales": 36.95
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 25.4,
            "clicks": 6,
            "cpc": 4.23,
            "query": "phycox max soft chews for dogs",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 5,
          "non_converting": 15,
          "percent_converting": 0.25,
          "total": 20
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 14.86
        },
        "summary": {
          "percentage_of_total": 0.0007,
          "total": 88.8,
          "wasted": 38.89
        }
      },
      "campaigns": {
        "total_budget": 137488.28,
        "unique": 7
      },
      "clicks": {
        "click_through_rate": 0.012,
        "cpc": 5.22,
        "total": 17
      },
      "conversions": {
        "conversion_rate": 0.1765,
        "total": 3
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1353,
          "roas": 7.3923,
          "total": 109.85,
          "total_orders": 3.0
        },
        "summary": {
          "acos": 0.8084,
          "roas": 1.237,
          "total": 109.85,
          "total_orders": 3
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1535,
            "ad_spend": 5.67,
            "clicks": 1,
            "cpc": 5.67,
            "query": "cbd joint and pain for dogs",
            "sales": 36.95
          },
          {
            "acos": 0.0882,
            "ad_spend": 3.26,
            "clicks": 1,
            "cpc": 3.26,
            "query": "vetpro",
            "sales": 36.95
          },
          {
            "acos": 0.165,
            "ad_spend": 5.93,
            "clicks": 1,
            "cpc": 5.93,
            "query": "vetpro complete hip and joint",
            "sales": 35.95
          }
        ],
        "top_non_converting": [],
        "unique": {
          "converting": 3,
          "non_converting": 13,
          "percent_converting": 0.1875,
          "total": 16
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "$",
    "date_from": "2022-07-09",
    "date_to": "2022-09-06",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-09-07T14:45:20.156891+00:00",
    "market": "US",
    "profile_ids": [
      2618522275674698
    ],
    "wasted_spend_click_threshold": 5
  },
  "missed_revenue": {
    "total": 5729.315597075548
  },
  "research_types": {
    "ad_spend": 5543.55,
    "percentage_of_total": 0.0444
  },
  "sales": {
    "acos": 0.9848,
    "roas": 1.0154,
    "total": 126830.95,
    "total_orders": 3646
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.0903,
        "ad_spend": 396.63,
        "sales": 4392.57
      },
      "top_duplicate": [
        {
          "acos": 0.0816,
          "ad_groups": [
            "Ad Group EXACT Match",
            "Ad Group PHRASE Match",
            null
          ],
          "ad_spend": 323.25,
          "campaigns": [
            119408678875918,
            122454319537747,
            133314185901398,
            141930643867340,
            158892358583136,
            172566870873283,
            255784061479846,
            265635164990645
          ],
          "match_types": [
            "EXACT",
            "PHRASE",
            null
          ],
          "query": "vetpro complete hip and joint",
          "sales": 3959.13
        },
        {
          "acos": 0.1281,
          "ad_groups": [
            "Ad Group PHRASE Match",
            null
          ],
          "ad_spend": 55.54,
          "campaigns": [
            119408678875918,
            122454319537747,
            141649536297786,
            141930643867340,
            172566870873283,
            252157405027697
          ],
          "match_types": [
            "AUTO",
            "PHRASE",
            null
          ],
          "query": "vetpro",
          "sales": 433.44
        },
        {
          "acos": null,
          "ad_groups": [
            "Ad Group EXACT Match",
            null
          ],
          "ad_spend": 17.84,
          "campaigns": [
            102045321539806,
            275482364862316
          ],
          "match_types": [
            "AUTO",
            "EXACT",
            null
          ],
          "query": "immune support for dogs",
          "sales": 0.0
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 1125,
      "non_converting": 3808,
      "total": 4933
    }
  }
}