Filter
User User( id="a7d7e868ca3042bd92e7047c33d1865c", external_auth_id="auth0|62764c577e7656006f88f896", name="John Timoney", email="joe@gnarlyjoe.com", onboarded="True", amazon_users=.... )
Created At 2022-05-07 10:51:13.293506
Params {"report_name": "PPC Audit", "profile_ids": "3552283363187328", "date_from": "2022-03-08", "country_code": "UK", "merchant_name": "TRADEMARK GNARLY JOE EST.MMXVII", "date_to": "2022-05-06", "merchant_type": "seller"}
Result
{
  "ad_groups": {
    "average_per_campaign": 727.0
  },
  "ad_spend": {
    "total": 3937.97,
    "wasted": 1149.16
  },
  "asins": {
    "converting": {
      "total": 38
    },
    "unique": {
      "total": 40
    }
  },
  "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": 52,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 52,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.0017,
      "percent_underspend": 0.9983,
      "total": 2090973.04,
      "total_underspend": 2087344.56
    },
    "top_daily_underspend": [
      {
        "date": "2022-03-25",
        "percent_spend": 0.0006194819231146089,
        "total": 40211.02,
        "total_ad_spend": 24.91,
        "total_underspend": 40186.11
      },
      {
        "date": "2022-03-09",
        "percent_spend": 0.0007229361503388872,
        "total": 40211.02,
        "total_ad_spend": 29.07,
        "total_underspend": 40181.95
      },
      {
        "date": "2022-04-02",
        "percent_spend": 0.000780134400967695,
        "total": 40211.02,
        "total_ad_spend": 31.37,
        "total_underspend": 40179.65
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 192
    }
  },
  "clicks": {
    "click_through_rate": 0.0193,
    "cpc": 0.91,
    "total": 4314
  },
  "conversions": {
    "conversion_rate": 0.1776,
    "total": 773
  },
  "impressions": {
    "total": 1742560
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 6.2,
      "total": 659
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 672.44
        },
        "summary": {
          "percentage_of_total": 0.1725,
          "total": 691.92,
          "wasted": 34.75
        }
      },
      "campaigns": {
        "total_budget": 347464.0,
        "unique": 17
      },
      "clicks": {
        "click_through_rate": 0.0117,
        "cpc": 1.13,
        "total": 611
      },
      "conversions": {
        "conversion_rate": 0.2042,
        "total": 127
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.4325,
          "roas": 2.3124,
          "total": 1554.95,
          "total_orders": 127.0
        },
        "summary": {
          "acos": 0.4556,
          "roas": 2.1947,
          "total": 1554.95,
          "total_orders": 127
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3134,
            "ad_spend": 132.95,
            "clicks": 139,
            "cpc": 0.96,
            "query": "b071ndkq2k",
            "sales": 424.19
          },
          {
            "acos": 0.0602,
            "ad_spend": 15.9,
            "clicks": 33,
            "cpc": 0.48,
            "query": "b079tygkjn",
            "sales": 264.04
          },
          {
            "acos": 0.5582,
            "ad_spend": 144.65,
            "clicks": 120,
            "cpc": 1.21,
            "query": "b07jl8qypw",
            "sales": 259.15
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 6.42,
            "clicks": 4,
            "cpc": 1.61,
            "query": "b08k3k25k1",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 4.59,
            "clicks": 4,
            "cpc": 1.15,
            "query": "b00j395xce",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 2.78,
            "clicks": 3,
            "cpc": 0.93,
            "query": "b0777phn2w",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 26,
          "non_converting": 23,
          "percent_converting": 0.5306,
          "total": 49
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 422.0
        },
        "summary": {
          "percentage_of_total": 0.2472,
          "total": 982.2,
          "wasted": 560.2
        }
      },
      "campaigns": {
        "total_budget": 341276.0,
        "unique": 16
      },
      "clicks": {
        "click_through_rate": 0.0235,
        "cpc": 0.65,
        "total": 1509
      },
      "conversions": {
        "conversion_rate": 0.1056,
        "total": 163
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2367,
          "roas": 4.2255,
          "total": 1834.16,
          "total_orders": 163.0
        },
        "summary": {
          "acos": 0.5477,
          "roas": 1.8258,
          "total": 1834.16,
          "total_orders": 163
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.301,
            "ad_spend": 61.79,
            "clicks": 75,
            "cpc": 0.82,
            "query": "beard conditioner",
            "sales": 205.29
          },
          {
            "acos": 0.5823,
            "ad_spend": 111.81,
            "clicks": 135,
            "cpc": 0.83,
            "query": "beard balm",
            "sales": 192.0
          },
          {
            "acos": 0.3501,
            "ad_spend": 28.77,
            "clicks": 34,
            "cpc": 0.85,
            "query": "beard care",
            "sales": 82.18
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 8.33,
            "clicks": 10,
            "cpc": 0.83,
            "query": "pre shave",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.65,
            "clicks": 9,
            "cpc": 0.85,
            "query": "beard grooming",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.45,
            "clicks": 8,
            "cpc": 0.93,
            "query": "hair balm",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 93,
          "non_converting": 693,
          "percent_converting": 0.1183,
          "total": 786
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 475.85
        },
        "summary": {
          "percentage_of_total": 0.1893,
          "total": 759.31,
          "wasted": 283.46
        }
      },
      "campaigns": {
        "total_budget": 870688.0,
        "unique": 11
      },
      "clicks": {
        "click_through_rate": 0.0322,
        "cpc": 1.04,
        "total": 712
      },
      "conversions": {
        "conversion_rate": 0.1994,
        "total": 145
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2579,
          "roas": 3.8772,
          "total": 1844.98,
          "total_orders": 145.0
        },
        "summary": {
          "acos": 0.4116,
          "roas": 2.4298,
          "total": 1844.98,
          "total_orders": 145
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.5684,
            "ad_spend": 176.15,
            "clicks": 133,
            "cpc": 1.32,
            "query": "beard moisturiser",
            "sales": 309.88
          },
          {
            "acos": 0.336,
            "ad_spend": 78.03,
            "clicks": 64,
            "cpc": 1.22,
            "query": "beard softener for men",
            "sales": 232.22
          },
          {
            "acos": 0.5672,
            "ad_spend": 74.28,
            "clicks": 40,
            "cpc": 1.86,
            "query": "beard wash for men",
            "sales": 130.95
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 14.27,
            "clicks": 11,
            "cpc": 1.3,
            "query": "beard conditioner softener for men",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.4,
            "clicks": 4,
            "cpc": 2.1,
            "query": "beard oil softener",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.65,
            "clicks": 6,
            "cpc": 1.28,
            "query": "face wash mens beard",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 63,
          "non_converting": 228,
          "percent_converting": 0.2165,
          "total": 291
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 339.82
        },
        "summary": {
          "percentage_of_total": 0.093,
          "total": 372.9,
          "wasted": 33.08
        }
      },
      "campaigns": {
        "total_budget": 878644.0,
        "unique": 28
      },
      "clicks": {
        "click_through_rate": 0.0084,
        "cpc": 0.8,
        "total": 456
      },
      "conversions": {
        "conversion_rate": 0.2069,
        "total": 96
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.321,
          "roas": 3.1149,
          "total": 1058.49,
          "total_orders": 96.0
        },
        "summary": {
          "acos": 0.3523,
          "roas": 2.8385,
          "total": 1058.49,
          "total_orders": 96
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.48,
            "ad_spend": 115.77,
            "clicks": 106,
            "cpc": 1.09,
            "query": "beard shampoo",
            "sales": 241.18
          },
          {
            "acos": 0.0662,
            "ad_spend": 11.86,
            "clicks": 22,
            "cpc": 0.54,
            "query": "gnarly joe",
            "sales": 179.05
          },
          {
            "acos": 0.4995,
            "ad_spend": 88.63,
            "clicks": 91,
            "cpc": 0.97,
            "query": "beard butter",
            "sales": 177.44
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 3.38,
            "clicks": 4,
            "cpc": 0.85,
            "query": "beard and face moisturiser for men",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 3.15,
            "clicks": 3,
            "cpc": 1.05,
            "query": "horace eye serum men",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 2.58,
            "clicks": 4,
            "cpc": 0.65,
            "query": "beard wax for men",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 20,
          "non_converting": 31,
          "percent_converting": 0.3922,
          "total": 51
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 740.07
        },
        "summary": {
          "percentage_of_total": 0.2579,
          "total": 1024.33,
          "wasted": 290.45
        }
      },
      "campaigns": {
        "total_budget": 769184.0,
        "unique": 23
      },
      "clicks": {
        "click_through_rate": 0.0391,
        "cpc": 1.14,
        "total": 902
      },
      "conversions": {
        "conversion_rate": 0.2391,
        "total": 219
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2803,
          "roas": 3.5671,
          "total": 2639.91,
          "total_orders": 219.0
        },
        "summary": {
          "acos": 0.3933,
          "roas": 2.5428,
          "total": 2639.91,
          "total_orders": 219
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.2727,
            "ad_spend": 87.01,
            "clicks": 69,
            "cpc": 1.26,
            "query": "beard cream",
            "sales": 319.04
          },
          {
            "acos": 0.0698,
            "ad_spend": 20.45,
            "clicks": 47,
            "cpc": 0.44,
            "query": "gnarly joe",
            "sales": 292.94
          },
          {
            "acos": 0.3875,
            "ad_spend": 112.91,
            "clicks": 71,
            "cpc": 1.59,
            "query": "beard moisturiser for men",
            "sales": 291.4
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 9.02,
            "clicks": 6,
            "cpc": 1.5,
            "query": "horace beard shampoo",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 6.45,
            "clicks": 7,
            "cpc": 0.92,
            "query": "mustache wax men",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 6.16,
            "clicks": 10,
            "cpc": 0.62,
            "query": "beard cream for men to make it soft",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 85,
          "non_converting": 221,
          "percent_converting": 0.2778,
          "total": 306
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-03-08",
    "date_to": "2022-05-06",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-07T10:53:25.642051+00:00",
    "market": "UK",
    "profile_ids": [
      3552283363187328
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 2794.094847241222
  },
  "research_types": {
    "ad_spend": 2937.64,
    "percentage_of_total": 0.7004
  },
  "sales": {
    "acos": 0.4294,
    "roas": 2.329,
    "total": 9171.53,
    "total_orders": 768
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.3475,
        "ad_spend": 1602.39,
        "sales": 4611.37
      },
      "top_duplicate": [
        {
          "acos": 0.6542,
          "ad_groups": [
            "Auto",
            "beard balm PHRASE",
            "BROAD",
            "Exact",
            "PHRASE",
            null
          ],
          "ad_spend": 179.15,
          "campaigns": [
            123292588751550,
            140219061170036,
            167189949302954,
            221470047480972
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT",
            "PHRASE",
            null
          ],
          "query": "beard balm",
          "sales": 273.84
        },
        {
          "acos": 0.3146,
          "ad_groups": [
            "Ad group 1",
            "ASINs",
            "Offense",
            "PAT",
            "WF-ZJ5N-HAVW MG 140619 NWASIN Mens Shampoo",
            null
          ],
          "ad_spend": 142.47,
          "campaigns": [
            58017042144,
            86271535763795,
            98139788411182,
            135831918905955,
            142744225988686,
            161972397368665,
            199677471926955
          ],
          "match_types": [
            "ASIN",
            "AUTO",
            null
          ],
          "query": "b071ndkq2k",
          "sales": 452.84
        },
        {
          "acos": 0.5454,
          "ad_groups": [
            "Auto",
            "BROAD",
            "Exact",
            "Phrase",
            "PHRASE",
            null
          ],
          "ad_spend": 128.65,
          "campaigns": [
            29169326309693,
            140219061170036,
            206969304788135,
            208512539102666,
            221470047480972
          ],
          "match_types": [
            "AUTO",
            "BROAD",
            "EXACT",
            "PHRASE",
            null
          ],
          "query": "beard butter",
          "sales": 235.9
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 259,
      "non_converting": 1118,
      "total": 1377
    }
  }
}